…MySQL DBA and would be an excellent choice for anyone either just getting started in MySQL, or who has been doing DBA work…in less time. Cookbook for Creating INDEXes — All about Indexing…in on how the query optimizer does what it does, why it does it, and how to make it work…
Post: Percona Live MySQL Conference and Expo 2013 – News from the Committee – Tutorial Selection Complete
December 3, 2012 By 1 Comment
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
…for i in 1 10 100 1000 10000; do ./benchmark.php $i 10000000; mysql -e’drop database test1′; mysql -e…does not work very well. Note: As I checked later contrary to my expectation this filesystem was created without dir_index…again for 10000 tables. I can’t explain why it is a bit worse for 1000 tables…
Post: Reasons for run-away main Innodb Tablespace
June 10, 2010 By 2 Comments
… to be inserted in the index tree and undo …following can be helpful: mysql> select * from innodb_rseg; +———+———-+———-+———+————+———–+ | rseg_…keep up. This however does not work in all cases. If …why Master and Slave may get so much different table space size in…
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… but it also might work. Regarding if you use… your data however it does not always bring good performance….not have all these problems with loosing data etc. Read more in my Why MySQL…Not using Join. This is typical error. On other hand in MySQL… do not expect it soon. Use Indexes This item was not in …
Post: Distro Packages, Pre-built Binaries or Compile Your Own MySQL
September 4, 2012 By 7 Comments
…MySQL server from pre-built binaries does not prevent you from installing other MySQL packages on the server for other dependencies i.e. mysql…MySQL‘s default behavior i.e. disabling and totally disallowing use of query cache or increasing maximum total number of indexes…
Post: MySQL net_write_timeout vs wait_timeout and protocol notes
July 8, 2007 By 1 Comment
…back in multiple pieces and if you’re using mysql_use_result you can do any work …large data sets and large buffers. While indexing Sphinx performs sorts and flushes buffers …MySQL protocol which does not allow client to talk to the server until full result set is fetched. This is also the reason why…
Post: To UUID or not to UUID ?
March 13, 2007 By 28 Comments
…in MySQL…in memory case or data on disk case with auto_increment having advantage when UUID larger BTREE does not fit in…in time physically local in BTREE index. This is actually the reason why UUID can do much better than SHA1 as Kevin proposes in…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…to work in. …in touch with what the lead consultant does…in our book, High Performance MySQL 2nd Edition (it’s not in… paste in mysql> show global variables like ‘%table_size%’; …why I save this part of the analysis for last. You cannot consider any one of these factors (schema, queries, indexing) in…
Post: Multi Column indexes vs Index Merge
September 19, 2009 By 31 Comments
…not want it to run, however I do not know of the hint in MySQL which would allow forcing using index merge when MySQL does not…indexes are required for index merge to work and combined indexes can’t be used for such queries. P.S The tests were done in MySQL…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…work required to make it work well such as having IO and uncompression happening in…the indexes – does it uses…in MySQL 5.1 It also should be possible to start unlocking rows if they do not…why large stripes are better and why battery backed up cache is so important. I also usually speak about these in…
