…by retrying benchmarks on various combinations of hardware and dataset sizes… following chart shows a results…root port=3306 innodb_status_file=0…mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-selects=1 –oltp-simple-ranges=0 –oltp-sum-ranges=0 –oltp-order…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
…for MySQL. I actually had more material than I covered (by …all nodes and global ordering is established, but apply…size of the transactions, which translates into number of unique key lookups into the certification index, which is a hash table…) since the last SHOW GLOBAL STATUS that flow control is …
Post: ALTER TABLE: Creating Index by Sort and Buffer Pool Size
June 27, 2012 By 4 Comments
… RAID10. I used 10mil row table which would look as following in terms of data and index size: mysql> show table status like “sbtest” \G *************************** 1… order can become very slow when index does not fit to memory any more. Creating Index by sort is great Creating index by…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… by …order‘; /*!40101 SET character_set_client = @saved_cs_client */; CREATE TABLE…mysql> use ontime1; Database changed mysql> show table status…size=512K sql-mode=STRICT_TRANS_TABLES symbolic-links table-definition-cache=16384 table-open-cache=128 thread-cache-size=32 thread-stack=256K tmp-table-size…
Post: How fast can you sort data with MySQL ?
August 18, 2007 By 26 Comments
I took the same table as I used for MySQL Group by Performance Tests to see how much MySQL can sort 1.000.000… buffer sizes. set sort_buffer_size=1000000; mysql> select * from gt order by i desc limit 10; 10 rows in set (0.70 sec) mysql> show status like…) set sort_buffer_size=10000000; mysql> select * from gt order by i desc limit 10; 10 rows in set (1.34 sec) mysql> show status like “sort…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
… size 8 by…by 0x74A32E: show_status_array(THD*, char const*, st_mysql_show_var*, enum_var_type, system_status_var*, char const*, st_table*, bool, Item*) (sql_show…by 0x6A7D72: mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
… how it happens in practice. mysql> show global status like “key%”; +————————+———+ | Variable_name | Value | +————————+———+…mysql> set tmp_table_size=1000000000; Query OK, 0 rows affected (0.00 sec) mysql> select count(*) cnt,c from gt group by c order by…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…status | OK | +——–+———-+———-+——————————————————————-+ 2 rows in set (2 min 57.65 sec) mysql> SHOW TABLE STATUS…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…tables involved and the query execution plan used by MySQL…Tables # SHOW TABLE STATUS FROM `wp_blog_one ` LIKE ‘wp_terms’\G # SHOW CREATE TABLE `wp_blog_one `.`wp_terms`\G # SHOW TABLE STATUS…ORDER BY…
Comment: Finding out largest tables on MySQL Server
October 6, 2008 By 27 Comments
…size | idxfrac | +———————————————-+——–+——-+——-+————+———+ | database.table | 15.00M | 2.08G | 0.00G | 2.08G | 0.00 | +———————————————-+——–+——-+——-+————+———+ mysql> show table status…
