… general_logblogpercona.commanual general_log_fileblogpercona.commanual group_concat_max_lenblogpercona.commanual Handler_commitblogpercona.commanual Handler… server_idblogpercona.commanual shared_memoryblogpercona.commanual shared_memory_base_nameblogpercona.commanual show_slave_auth_infoblogpercona…
Post: Testing MySQL column stores
August 16, 2010 By 15 Comments
…. ICE supports almost all of the MySQL aggregation functions. Notably, GROUP_CONCAT is not supported, which is something I hope they rectify… that was higher than it should have been, and several GROUP BY queries returned unexpected results as well. I did not… on a 16GB box, one query did not have enough memory to complete on InfiniDB. Overall, I would say that ICE…
Post: Researching your MySQL table sizes
March 17, 2008 By 26 Comments
…concat(round(sum(table_rows)/1000000,2),’M') rows, concat(round(sum(data_length)/(1024*1024*1024),2),’G') data, concat…data_length),2) idxfrac FROM information_schema.TABLES GROUP BY table_schema ORDER BY sum(data_…66M | 6.01G | 0.00G | 6.01G | 0.00 | | MEMORY | 14 | 0.00M | 0.00G | 0.00G | 0.00G…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
… tests concurrently because Sysbench should run completely in memory and use a lot of CPU resources but… pool contents. mysql [localhost] {msandbox} (information_schema) > select concat_ws(‘.’, t.schema, t.name, i.name) as… p using(index_id) where t.schema=’test’ group by i.index_id \G INDEX_NAME DATA…
