… 5h run. After 3h the disk is full, and InnoDB …id`. However it will interesting how both InnoDB and TokuDB performs…lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb …_len = 4 #default_table_type = InnoDB thread_stack = 192K tmp_table_size = 64M server-…
Post: How to find MySQL queries worth optimizing ?
September 11, 2012 By 6 Comments
… Rows_read: 0 # Bytes_sent: 213 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0 # InnoDB_trx_id: …tables but because the access type to the tables is “const” MySQL does not count it as access to two tables… no” answer but rather helps to understand how much optimization is possible. For example …
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0 # InnoDB_trx_id: F00 # QC_Hit: No Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk…table. Another thing to note is the last line in the output the # MISC part, it tells you how… tables involved and the query execution plan used by MySQL. …
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…delete one of MySQL‘s log or data files from disk. The database …jobs to delete old files in /tmp can do the same thing. …table-checksum tool from Percona Toolkit can generate table checksums, and the pmp-check-pt-table… been restarted recently. It is surprising how often a server crashes, perhaps even…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… desc LIMIT 20; In-memory workload Now let’s see how effective is MRR when the workload fits entirely in memory… MySQL 5.6 w/ read_rnd_bufer_size=4M MariaDB 5.5 MariaDB 5.5 w/ mrr_buffer_size=4M Created_tmp_disk_tables 1 1 1 1 1 Created_tmp_tables 1 1 1 1 1 Handler_mrr…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… to see how much benefit can we get from a proper IO alignment on a 4-disk RAID1+…: [mysqld] datadir=/data/mysql socket=/var/run/mysqld/mysqld.sock innodb_file_per_table = true innodb_data_file_path … = 16M max_heap_table_size = 64M thread_cache_size = 32 query_cache_size = 0 tmp_table_size = 64M key_…
Post: When Does InnoDB Update Table Statistics? (And When It Can Bite)
October 6, 2011 By 7 Comments
…table or manually running ANALYZE TABLE on it? The 2 instances below are documented from the MySQL…Tmp_tables: 1 Tmp_disk_tables: 0 Tmp_table_sizes: 0 SET timestamp=1316767697; show table status from `db1`; As you can see db1 has about 294 tables…
Post: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 22, 2012 By 33 Comments
…table: sysbench –test=oltp –oltp-table-size=20000000 –mysql-table-engine=innodb –mysql-socket=/tmp/mysql_sandbox5524.sock –mysql-db=test –oltp-table…disks. The version of MySQL used for benchmarking pre 5.5.23 DROP TABLE implementation is MySQL 5.5.15, the version of MySQL…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…. How to get CPU consumption per query ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat… 0 0 0 0 0 # Tmp tables 21.36k 0 2 0.01 0 0.11 0 # Tmp disk tbl 21.21k 0 2 0.01 0 0.11 0 # Tmp tbl size 554.04M 0… 0 # Tmp tables 0 0 0 0 0 0 0 0 # Tmp disk tbl 0 0 0 0 0 0 0 0 # Tmp tbl size…
