… values for Created_tmp_tables and Created_disk_tmp_tables, I‘ll paste in mysql> show global variables like… an indication that it’s time to convert MyISAM tables to InnoDB. (But then again, it might … know a lot about the I/O subsystem. And by now I know that I should concentrate in certain areas — …
Comment: MySQL Partitioning - can save you or kill you
June 28, 2012 By 45 Comments
… is possible in some applications. XtraDB shines over MyISAM and InnoDB. TokuDB may shine even with lots… data — appending to the .MYD file: essentially 0 disk hits per row inserted Inserting into 4 indexes –… (1) DELETE via DROP PARTITION, and (2) no I/O thrashing during the inserts. He may well be…
Comment: Slow DROP TABLE
June 17, 2009 By 21 Comments
… data and indexes), 16 – 20 GB in a few hundred MyISAM tables (out of 24 GB RAM on the machine). It… we’d like to spill to disk. It’s okay if these are somewhat slow. I/O contention is not an issues since…, we definitely do need on disk, since our ram is mostly dedicated to caching the db / indexes). I‘d go spelunking, but…
Comment: Evaluating IO subsystem performance for MySQL Needs
March 5, 2008 By 23 Comments
…works pretty well for workloads like this. Honestly I‘m surprised by the claim cache on …device, to the RAID controller or to the disk drive ? Buffered or Unbuffered. If you have …MyISAM you’re risking journaling file system corruption. File system cache is removed from equation because of use of O…
Post: A recovery trivia or how to recover from a lost ibdata1 file
June 3, 2011 By 8 Comments
…. I decided, also for portability, to do “alter table tablename engine=MyISAM;” Script all that In order to get a decent disk space and good internet connectivity, I fired up an… 00 00 00 00 00 00 00 13 00 00 |O…G………..| In the above example, the table space id is…
Post: Linux schedulers in tpcc like benchmark
January 30, 2009 By 19 Comments
…see noop / deadline can utilize disks much better. For reference I used tpcc scripts from …disk), and used next XtraDB params: [mysqld] #mysqld options in alphabetical order user=root default_table_type=MYISAM…innodb_thread_concurrency=0 innodb_flush_method = O_DIRECT innodb_write_io_threads=4 innodb…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
…FreeBSD, Solaris you need to set innodb_flush_method=O_DIRECT. On other Operating Systems you may be… what is in memory and what is on disk, for example when Innodb tries to avoid holding…S I only described Innodb Buffer Pool selection for dedicated Innodb system. If you have fair amount of MyISAM, …
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
…re using – DRBD does not work with MyISAM (check required) so you need to … when development has too much autonomy. I must note in this aspect however … and care about performance you use O_DIRECT with Innodb which makes it … though not eliminate because you get some disks which you can’t really use …
