… spend large portion of my life working on MySQL Performance Optimization and so MySQL Optimizer is quite important to me. For probably… optimizer behavior with new MySQL Version. Make Cost Model Adjustable MySQL Optimizer looks at query plan in terms of disk IOs/Seeks in…. In practice some people have their database 100% in RAM (even for Disk tables such MyISAM or Innodb) others keep database on…
Post: ALTER TABLE: Creating Index by Sort and Buffer Pool Size
June 27, 2012 By 4 Comments
… for test is rather old box with 8GB of RAM and 4*SATA disks in RAID10. I used 10mil row table which would look as following in terms of data and index size: mysql… was rather small – less than 10% though, which is because disks are not that bad with sequential IO, which is what…
Post: Impact of the number of idle connections in MySQL
December 17, 2010 By 21 Comments
… influence, because those idle threads are presents in internal MySQL list objects that need to be scanned and also…desktop is running Ubuntu 10.04, has 8GB of RAM and a Core i5 CPU (dual core with HT…commit=0, I ensured I was not benchmarking my disk. On the laptop, I ran the following script: #!/bin…
Post: MySQL 5.5-m2 scalability
February 28, 2010 By 17 Comments
…, and I have a predition that MySQL-5.5 will be announced as GA on MySQL UC 2010 in April. So let… our Dell R900 system ( 16 cores, 32GB of RAM, FusionIO + RAID10, but disk in this case does not matter). There is results…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
…speed storage system. I helped Violin Memory to optimize MySQL for customer workload and Violin memory and also had…to do IO to get their data from the disk. With Innodb results were quite poor – I got about…to repeat and test – just run Innodb from the RAM drive 
Next I tested MyISAM which is well …
Post: InnoDB benchmarks
January 3, 2007 By 15 Comments
… compiled from sources with options: ./configure –prefix=/usr/local/mysqltest/mysql- –with-innodb and next startup options were used: libexec/mysqld… cpu MHz : 1995.004 cache size : 4096 KB 16GB of RAM Disks do no matter, as I ran clear CPU-bound benchmarks…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… for write buffering efficiently. Q30: Question about using solid state disks for storing ib_log* files; I know that innodb writes… available RAM. I would guess that the number varied more, depending on the availability of RAM? On a dedicated server for Mysql you…, backup, cron, syslog, etc). But the ratio of RAM used for these non-mysql processes drops rapidly when you increase the amount…
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
… R900, with RAID 10 on 8 disks (2.5″ SAS disks, 15K RPMS) and 32GB of physical RAM, but restricted on kernel level… tried iiBench, which you can take there https://launchpad.net/mysql-patch/mytools What makes fractal indexes so interesting is the… application, it can be from simple apache logs put into mysql, application performance logs to more complex log like clicks, user…
Comment: Scaling to 256-way the Sun way
November 12, 2008 By 13 Comments
… and more disks than 10 15k (~2000 IOPs) to host 28 instances. A common high-performance commodity x86 server for MySQL uses 16GB or 32GB of RAM and 10 or more disks. By those standards, the Sun box would need 500GB to 1TB of RAM and 56…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 17 Comments
…400M rows, I would expect Inno starts hitting disk. Perhaps you could verify that by watching IOstat…. my prediction that at 400M rows and 55GB RAM, Inno would hit a memory wall. Given that…that Mark wrote http://bazaar.launchpad.net/~mdcallag/mysql-patch/mytools/annotate/head%3A/bench/ibench/iibench….
