…memory…max-time=7200 –max-requests=0 –percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…Rows_sent: 1 Rows_examined: 655360 Rows_affected: 0 Rows_read: 655361 # Bytes_sent: 68 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table…tables created in memory…in memory. What it says though is that, if this query would run on a cold MySQL…max avg 95% stddev median # ============ === ======= ======= =======…
Post: How fast can MySQL Process Data
April 9, 2008 By 3 Comments
… MySQL process (filter) data using it current architecture ? I decided to test the most simple case – what if we take the in memory table… Rows: 5000000 Avg_row_length: 129 Data_length: 685609952 Max_data_length: 948528873 Index_length: 0 Data_free: 0 Auto_increment: NULL Create_time…
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
…memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql…rows from the table in the new one until we finally touch the row which crashes MySQL. In this case we can expect this is the row…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…created which temporary tables (both in memory and not): mysql> select * from information_schema.global_temporary_tables \G *************************** 1. row *************************** SESSION_ID: 7234 TABLE_SCHEMA: test TABLE…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially the option and variable reference table…max_tmp_tablesblogpercona.commanual Max_used_connectionsblogpercona.commanual max_user_connectionsblogpercona.commanual max_write_lock_countblogpercona.commanual memlockblogpercona.commanual min_examined_row…
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
…queries MySQL needs to create temporary tables, which can be created in memory, using MEMORY storage engine or can be created on disk as MYISAM tables. …MEMORY tables for the same queries: mysql> set global key_buffer_size=8000000; Query OK, 0 rows affected (0.03 sec) mysql> set global max_heap_table…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…rows‘, ’1344092495′ ‘Sort_scan’, ’935242′ ‘Table_locks_immediate’, ’895966639′ ‘Table_locks_waited’, ’20096′ ‘Threads_cached’, ’0′ ‘Threads_connected’, ’260′ ‘Threads_created…in_d, 96252k in…mysql innodb_log_arch_dir=/var/log/mysql innodb_table_locks=0 innodb_buffer_pool_size=1800M # USE ALL MEMORY…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
…in the table: mysql> select count(*), count(distinct UniqueCarrier) from dim_flightG *************************** 1. row *************************** count(*): 58625 count(distinct UniqueCarrier): 29 1 row in…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…max_connections is just 150 and there are less than 200 tables in this system. innodb_stats_on_metadata is disabled by default in MySQL…max_allowed_packet is 4MB instead of 1MB now allowing MySQL to handle larger queries. Makes sense as amount of memory…
