Percona's MySQL & InnoDB performance and scalability blog
…most situations, any possible advantages to using MyISAM are far outweighed by the potential disadvantages and the strengths of InnoDB. However, up until MySQL…least some of the diagnostic output isn’t working quite right. Intuitively, I would expect some changes in total_word_count…
… rare count. But for the most part they are designed to …You would be surprised how many people use this type of…Using this application I can then compare using MySQL to using MySQL + Memcached, and then to…to use a database. Heresy I know! But for many of us we already accept storing data ( at least…
…to use a bigger example than “digits” because this is too small for you to…mysql> select count(*) from ex1; +———-+ | count(*) | +———-+ | 73027220 | +———-+ 1 row in set (0.00 sec) mysql…
…to use as it is implemented now – you have to specify compressed block size, this is the size to which you expect each page to…to for data and for various indexes. How… way to count …least MySQL 5.1 with row level replication readily available. Speaking about community items the following were most…
…how search is implemented is counting number of results matched. FaceBook does not give you exact count…least some search options would work great on wider scale. Using advanced search seems to be the only way to restrict search to…
…MySQL. In the best case, we want to know everything about the system’s activity: we want to know how many things happened, how…to right along the arrow, we can count the system’s “busy time” as the time during which at least…how to tie it all together quickly to…
…to simply use the INFORMATION_SCHEMA.INNODB_SYS_INDEXES table, which exists in Percona Server 5.1, but doesn’t appear in MySQL…to be the most…least you can re-add it later. However, it’s not the greatest thing to…
…how many Variables did MySQL get over years – it is pushing 400 these days even if we do not count…not need to set nearly all of them in most cases,…least can be solved manually. The next natural step I would like to see taken is having MySQL to…it silly for example MySQL would use the same sort_buffer…
…mostly unique “c” column. mysql> explain select count…to avoid OS writes OS Write cache is not as efficient as I would hope, at least…MySQL will implement support of dynamic rows for MEMORY tables some time in the future and so we will be able to use…
…to count the data dictionary. This can take many gigabytes on servers with a lot of tables. We’re trying to…uses memory to execute; so do temporary tables. The following query creates at least…mysql…to use a monitoring tool to watch the actual memory usage over time and see how…
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.