…much overhead do on disk temporary tables cause compared to MEMORY tables. To have things comparable I used medium size table…tables can be 10-100 times faster than disk based MyISAM tables Hopefully MySQL will implement support of dynamic rows for MEMORY tables some time…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…management: processor : 7 vendor_id : GenuineIntel cpu family : 6 model : 15 model name … ways to get this information, too. The last three commands are…an indication that it’s time to convert MyISAM tables to InnoDB. (But then …how much time we’re spending, and shortcut effort if it’s not useful, …
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…how much … 24xIntel(R) Xeon(R) CPU X5650 @ 2.67GHz Caches …myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover skip-grant-tables Amount of rows used…table, used proper file system alignment. Benchmark results I had a hard time…no difference too. Write-…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
… No Spinlocks Falcon does not use Spinlocks. It has its… spinlocks wasting CPU time on single CPU boxes without much of the …too frequently if I keep them close. Manual does not say much… how much performance it will give. As “SHOW TABLE STATUS”…certainly can be applied for MyISAM and Innodb. I remember…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…too late to write about stuff happened at Users Conference but I’m just starting find bits of time…MyISAM tables). Are there any plans to be able to build indexes in parallel by running sorts in different threads – using…
Post: Just do the math!
July 6, 2009 By 4 Comments
…queries and drill down as much as you like. …any more with response times for individual queries …table can be kept in memory or it spills over to the disk as MyISAM table…modeling is you can use worse case scenario or … then going from CPU bound to IO bound…problems with the model (too bad) or problems …
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 15 Comments
…execution – either row level locks for Innodb or table locks for MyISAM and any DDL statements. If you happen … the query) it is not able to use the CPU or the Disks on the slaves as efficient …trust Seconds_Behind_Master too much, even though it is close to the true most of the time there are …
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
…workloads. Well this may be too much of the wish but at… fair amount of issues with MyISAM and generally on MySQL level… there are summary tables and other tricks we use when such need…well, being able to use only one CPU effectively on single …stays where for very long time. For example Query Cache …
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
…it can’t be because we used MyISAM tables which are not ACID complaint….MySQL 6.0 time divided by MySQL 5.1 time so if it… Server. Of course this is much more powerful system but still…use only half of system CPU resources for query processing was not too bad, however with 16,32,64 cores it is just too…
Post: MySQL Storage Engines - PBXT
May 14, 2007 By 6 Comments
…not get too far yet, too busy. So today it is time for… as with MyISAM, and you might need to repair tables. This …use two phase commit for transactions spawning multiple databases – this might not even add too much overhead as XA already used…anyway. We also checked for CPU bound workload – with disk …
