GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Avoid Flash cache while using LOAD DATA LOCAL INFILE

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Avoid Flash cache while using LOAD DATA LOCAL INFILE

    Hi,

    I'm trying to avoid trashing my flash cache SSD whie loading data to the db.
    Is there something like /* sql_no_fcache */

    for the Mysql loader?

    Thanks,
    Daniel.

  • #2
    Hi Daniel,

    There is /*sql_no_fcache*/ in Percona Server 5.5. You can get more information here,

    http://www.percona.com/doc/percona-server/5.5/management/sql _no_fcache.html

    Regards,
    Niljoshi

    Comment

    Working...
    X