… thing you need to consider is string comparison in MySQL is case insensitive by default …length is rather short for such hack as BIGINT itself is 8 bytes and the difference in the index length with all overhead is… Order by” described in presentation. Q: what is the impact on indexing to use wider …

…mysql> select sum(data_length+index_length) from information_schema.tables where engine=’memory’; +——————————-+ | sum(data_length+index_length) | +——————————-+ | 126984 | +——————————-+ 1 row in…

…in RAID10. I used 10mil row table which would look as following in terms of data and index size: mysql…_length: 224 Data_length: 2247098368 Max_data_length: 0 Index_length:…is because disks are not that bad with sequential IO, which is what file merge process uses. This is important illustration as in…

… to the amazing MySQL manual, especially the option and variable reference table…look for content in the Percona documentation or forums. So I present to you what is now my…_threadsblogpercona.commanual max_join_sizeblogpercona.commanual max_length_for_sort_datablogpercona.commanual max_prepared_stmt…

…MySQL configuration, we quite …). There are many examples of this. What about join_buffer_size? I …is allocated to cache rows from each table in a join when the join can’t use an index. This is… table_count) 14185 { … snip … 14268 cache->length=length+blobs*sizeof(char*); 14269 cache->blobs=blobs…