Percona's MySQL & InnoDB performance and scalability blog
… use the existing mysql data dir. But check http://www.percona.com/doc/percona-server/5.1/compatibility.html if you’re… 2) here is the list of compared features: http://www.percona.com/doc/percona-server/5.1/feature_comparison.html 3) we…
… temporary table to store an interim result set, and then use that to ultimately produce the result you want, that’s another… to be first, then look up matching rows in `title` by a secondary index. But the result was that it created a… it pays to test all different solutions, and measure the resulting performance! Q: Bill, back to the query where you were…
… has an exclusive copy of that source data. (see http://www.dbms2.com/2013/01/05/database-virtualization-data/) – Kyle Hailey
…, you could even be more zealous. Pretty interesting to speed up point in time recovery when you dataset is 700GB. If… and it is surprisingly cheap. In fact the best tpcc results I got were when using compression. I still have to… have an impact on performance with ZFS the impact is up front and the backups are almost free.
…, so we applied the technique described here, but the search results have gone from milliseconds to more than 43 seconds
… *no* truncation, as explained in the manual – http://dev.mysql.com/doc/refman/5.1/en/alter-table.html “For a…
… some caveats). Also, because of asynchronous replication, you can end up having inconsistent data on the nodes and encounter replication errors…
…_CHANGED_PAGES query started returning data to indicate an incomplete result set. Bug fixed #1185040. Fixed the upstream bug #69379 which…
The unstable result problem I met (e.g. 32G BP was faster than …
… different table (unrelated to the select query) also get hang up. If I do show processlist, the update queries show up with state =’Updating’ or some others with state =’query end’; …
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.