Daniël, thank you for your feedback. * How do you define large schemas, and what do you mean … schema and perhaps 10,000 tables per mysqld instance. SchemaSpy does take some time to execute but this is generally no… schema into Workbench so I can’t comment as to how well it scales at this volume of tables.
Post: Testing the Micron P320h
April 16, 2013 By 7 Comments
… threads we have maximum throughput with latency just over 3ms. How well does it perform with MySQL? Exact results vary, depending upon the…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… people think of). Callaghan’s Law But what does that all actually mean? Well, at the Percona Live conference a few weeks… WAN clusters? Callaghan’s law applies to WAN clusters as well. LANs usually have sub-millisecond RTTs. WANs usually have anywhere…: UPDATE achievements SET count = count + 1 where achievement = ‘killed_troll’; How many players might accomplish this achievement at the same time…
Post: What I'm looking forward to at Percona Live (MySQL Users Conference)
April 4, 2013 By 1 Comment
… MySQL space as well as how these technologies can be applied in practice. I learn what works and what does not. I learn… pretty “hardcore,” attracting many real MySQL practitioners as speakers as well as attendees who all share their deep technical insights, holding… I will give an Innodb and Performance Optimization Tutorial as well as talk about Goal-Driven Performance Optimization and Choosing storage…
Post: Why MySQL Performance at Low Concurrency is Important
March 27, 2013 By 8 Comments
…that offers the best response times (MySQL server does not use multiple threads to execute query …compared with this baseline to see how they are affected and how the system scales with increasing …or less, at least the system is performing well, pointing to rather low concurrency in the normal…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… yourself in the foot if you use it incorrectly. So how do you safely disconnect a replication slave? In short For… relay-log.info files as well as all the relay log files. This looks great, but does it ensure the replica is… status\G Empty set (0,00 sec) Very good! The command does work as expected without any additional tricks. As soon as…
Comment: Testing the Micron P320h
April 16, 2013 By 7 Comments
… SSD the newer file systems could be more appropriate. 2) How does P320h compare to Virident? You benchmarked Virident a while ago…/) and found it to be significantly faster than FusionIO as well.
Post: How well does your table fits in innodb buffer pool ?
December 9, 2010 By 12 Comments
Understanding how well your tables and indexes fit to buffer pool are often …, for example being washed away by other queries. MySQL Server does not provide any information of this type, Percona Server however… to see what is really getting warmed up first as well as how buffer pool is affected by batch jobs, alter tables…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… share our methodology with readers a little bit. This fits well with our philosophy of openness. It also shocks people sometimes… as Class::DBI, which does $dbh->ping before each and every query. Why is Ping useless? Well, it is intended to tell…. This is where you need to really know how to write queries and how EXPLAIN works. At Percona, we have peer training…
Post: How much overhead DRDB could cause ?
June 2, 2008 By 4 Comments
… when DRBD is used. The truth is – because how DRBD works it does not adds static overhead which could be told as… you really need to understand how DRBD works as well as how IO system is utilized to understand how much overhead you should expect… transaction commit, or could be more than 6 depending on how Filesystem does it job. Rates of 40-50 transactions per second…
