… factor of ten (it will be 100 disk seeks to answer a random query, assuming you can get each index query… hits the memory wall at about 100M rows, which matches my prediction that at 400M rows and 55GB RAM, Inno would…
Comment: Testing Fusion-io ioDrive - now with driver 3.1
May 18, 2012 By 2 Comments
Thanks for posting the benchmarks. They are very informative. One question: when you configure MySQL, what portion of it resides on…
Comment: Learning about MySQL Table Fragmentation
May 18, 2012 By 19 Comments
I have innodb tables in my production database and i have set files_per_table variable. …
Comment: Benchmarking single-row insert performance on Amazon EC2
May 17, 2012 By 11 Comments
Justin, I would be doing another benchmark and use ‘innodb_ibuf_accel_rate’ together with tuning other IO related parameters that I can tune to good affect, and I will post my results.
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
May 16, 2012 By 93 Comments
On my boxs with MySQL 5.5 (Ubuntu Server 12.04 LTS) … this in his the last version on gitub. But in my MySQL – installation a “SHOW SLAVE STATUS” will ALWAYS produce a…
Comment: Why MySQL could be slow with large tables ?
May 15, 2012 By 139 Comments
i have 90GB db, my selects are pretty slow with tables over 500,000 rows. guess i will have to partition as i used up the maximum 40 indexes and its not speeding things up. i think max rows per table should be 50-100k rows
Comment: Choosing proper innodb_log_file_size
May 15, 2012 By 12 Comments
… user’s VM doing heavy activity on the disk. Also, my DB has also slowed down other user’s apps. IMO…
Comment: SHOW INNODB STATUS walk through
May 15, 2012 By 40 Comments
Hello Peter, I have trouble getting the monitores working – i created the …
Comment: Announcement of Percona XtraDB Cluster 5.5.20 GA release
May 9, 2012 By 10 Comments
…/percona-xtradb-cluster and we are doing our best to answer on questions about XtraDB Cluster in our mailgroup http://groups.google…
Comment: Multi Column indexes vs Index Merge
May 10, 2012 By 30 Comments
HI Peter I had a question regarding index merge (intersect). Below are two explains that I … was using a single index. I would greatly appreciate your answer. First explain —————– explain SELECT LinksTbl2.id, LinksTbl2.title, LinksTbl2.url…
