…MySQL as if it were using SSD storage or to just use an optimized HDD storage configuration? After creating…mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…Created_tmp_disk_tablesblogpercona.commanual Created_tmp_filesblogpercona.commanual Created_tmp…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
… made on MySQL 5.6 config: optimizer_switch=’index_condition_pushdown=off’ optimizer_switch=’mrr=on’ optimizer_switch=’mrr_cost_based=off’ optimizer_switch=’batched…_buffer_size=4M & mrr_buffer_size=4M Created_tmp_disk_tables 0 0 0 0 0 0 Created_tmp_tables 1 1 1 1 1 1 Handler…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… the MySQL config: optimizer_switch=’index_condition_pushdown=off’ optimizer_switch=’mrr=on’ optimizer_switch=’mrr_sort_keys=on’ (only on MariaDB 5.5) optimizer….6 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_init…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one… post is aimed at a new optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…tables‘, ’102′ ‘Com_update’, ’15146253′ ‘Com_update_multi’, ’0′ ‘Connections’, ’263413′ ‘Created_tmp_disk_tables‘, ’0′ ‘Created_tmp_files’, ’4001′ ‘Created_tmp_tables…
Comment: Why MySQL could be slow with large tables ?
November 14, 2008 By 141 Comments
… need to optimize mysql server to manage a big tables (now about 78Mb, with increment of 1Mb/day) — I have used a table MyISAM… M Handler_read_rnd_next 4,483 M Created_tmp_disk_tables 5,270 Created_tmp_tables 5,274 Created_tmp_files 37 k Key_reads 4,226 Key… best performance & low disk usage? – may i remove old_passwords=1 & big-tables? — Web Server with Apache 2.2. Mysql ver. 5.0…
Comment: How much memory can MySQL use in the worst case?
February 19, 2009 By 17 Comments
… and/or rent. We are currently using MySQL and MyISAM tables and we keep running out of memory …runs) Created_tmp_disk_tables 9,208 Select_full_join 1,074(the application is using indexes to join the tables so … that are to blame here or could i optimize the config for the server some….maybe use …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…Created_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…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…Optimal WT, RA PhysiclDev Type State Errors Vendor Model Size ========== ==== ======= ====== ======= ============ =========== Hard Disk SAS Online 0/0/0 SEAGATE ST3600057SS 558.911 Hard Disk…created…mysql socket=/var/run/mysqld/mysqld.sock innodb_file_per_table…
