…how…to run: sysbench –test=insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb –oltp_auto_inc=on –max…table_type = InnoDB thread_stack = 192K tmp_table…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…cron jobs to delete old files in /tmp can …all trying to open or close tables can indicate …. It is surprising how often a server crashes…mysql-status plugin to alert when the server’s Uptime variable is too small. The server is approaching max_connections. Overflowing the max_connections setting…
Post: TMP_TABLE_SIZE and MAX_HEAP_TABLE_SIZE
January 19, 2007 By 17 Comments
… fact setting tmp_table_size is not enough as MySQL also looks at max_heap_table_size variable and uses lower value as a limit to for… to fix but why real behavior was not documented in the manual at least ? But what surprises me the most is how…@ted.mysql.internal +6 -0 BUG #4291 fix: new configuration option “disk-tmp-table-size” introduced to set maximum expected on-disk temporary table size and…
Post: Using any general purpose computer as a special purpose SIMD computer
May 16, 2011 By 5 Comments
…mysql> select min(id),max(id) from words; +———+———+ | min(id) | max(id) | +———+———+ | 1 | 3088896 | +———+———+ 1 row in set (0.00 sec) How to factor numbers create table…
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
…disk MyISAM temporary table. What i decided to do is to see how much overhead do on disk temporary tables cause compared to MEMORY tables. To have things… For 1M rows we have mysql> set max_heap_table_size=1000000000; Query OK, 0 rows affected (0.00 sec) mysql> set tmp_table_size=1000000000; Query OK…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…Tables MEMORY tables can take memory. There are implicit MEMORY tables which are allocated for query execution, which size can be controlled by tmp_table…to see how much memory is being used by current MEMORY tables: mysql> select sum(data_length+index_length) from information_schema.tables…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
…how to get it. Most distributed engines work with rows. They break the queries up into the lowest level sets…right now only MySQL storage nodes are supported. Amdahl’s law applies to the distributed …_tmp_74082863` GROUP BY 1 –POST EXEC: DROP TABLE IF EXISTS `aggregation_tmp#74082863` ; Edit *MIN/MAX…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…to 19:03:39 # Attribute total min max…to gather more data about the underlying tables involved and the query execution plan used by MySQL…tmp table size needed per query is 270.35k, which is not much considering the fact that tmp_tbl_size variable is set to…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…max_heap_table_size=200M log-output = FILE log-slow-queries=/tmp/mysql-slow.log long_query_time = 1 innodb_data_home_dir = /data/mysql…set. Are any explicit MEMORY tables use in the benchmarks ? As otherwise you also need to boost tmp_table_size to deal with implicit memory tables…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…tmp_tables and Created_disk_tmp_tables, I’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+ | max_heap_table_size | 268435456 | | tmp_table…
