…innodb_write_io_threads = 16 innodb_read_io_threads = 16 join_buffer_size=1M max_allowed_packet=1M max_connections=3000 max_heap_table…tables skip_locking sort_buffer_size=64K table_cache=2048 thread_cache_size=16 thread_concurrency=16 thread_stack=196K tmp_table…already and recommendation to fit at …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…_assign_to_keycacheblogpercona…innodb_thread_sleep_delayblogpercona.commanual Innodb_truncated_status_writesblogpercona.commanual innodb_use_native_aioblogpercona.commanual innodb_use_sys_mallocblogpercona.commanual innodb_versionblogpercona.commanual innodb_write….commanual tmp_table_sizeblogpercona….
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…tmp_disk_tables‘, ’0′ ‘Created_tmp_files’, ’4001′ ‘Created_tmp_tables‘, ’669137′ ‘Delayed_errors’, ’0′ ‘Delayed_insert_threads’, ’0′ ‘Delayed_writes‘, …innodb_table_locks=0 innodb_buffer_pool_size=1800M # USE ALL MEMORY AVAILABLE #innodb_log_buffer_size=8M # Lowered from 32M according to MySQL innodb…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…table_cache=20M # open-files-limit=20000 table_cache = 3072 open_files_limit = 9216 tmp_table…to 25 % of buffer pool size innodb_log_file_size = 1000M #innodb_log_buffer_size = 32M #innodb_flush_log_at_trx_commit = 1 #innodb…_size = 256M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer =…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…write something instructional to the client about it. Preparing to report findings I should mention here a bit about how I write the report to…to other things; for example, when I’m examining the status values for Created_tmp_tables and Created_disk_tmp_tables… to convert MyISAM tables to InnoDB. (But…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
… will not write into slow log any queries executed by the slave’s SQL thread. This patch allows you to change that… Tmp_table: Yes Disk_tmp_table: No # Filesort: Yes Disk_filesort: No Merge_passes: 0 # InnoDB_IO_r_ops: 19 InnoDB_IO_r_bytes: 311296 InnoDB_IO…: No Full_join: No Tmp_table: No Disk_tmp_table: No # Filesort: No Disk_filesort: No Merge_passes: 0 # No InnoDB statistics available for this…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…_30/tmp | /mnt/data/sandboxes/msb_5_6_10/tmp | | TABLE_OPEN_CACHE | 400 | 2000 | | INNODB_VERSION | 5.5.30 | 1.2.10 | | INNODB_BUFFER…_MAX_THREAD_INSTANCES | 1000 | 224 | | SOCKET | /tmp/mysql_sandbox5530.sock | /tmp/mysql_sandbox5610.sock | | INNODB_FILE_PER_TABLE | OFF | ON | | SYNC_MASTER_INFO | 0… from 5MB to approximately 50MB which is a good change, though I think default could have been made even larger. Write intensive…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… to estimated (or benchmarked) system performance to provide our estimates. If we’re running Innodb with MySQL we can use Innodb_data_reads , Innodb_data_writes, Innodb…, 99% no # Full scan 0% yes, 99% no # Tmp table 1% yes, 98% no # Tmp table on 1% yes, 98% no In this case… 0 # Tmp tables 0 0 0 0 0 0 0 0 # Tmp disk tbl 0 0 0 0 0 0 0 0 # Tmp tbl…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… innodb-status-file innodb-strict-mode innodb-thread-concurrency=0 innodb-thread-concurrency-timer-based innodb-thread-sleep-delay=0 innodb-use-sys-stats-table innodb-write-…=32 thread-stack=256K tmp-table-size=64M transaction-isolation=READ-COMMITTED user=mysql wait-timeout=86400 To be continued You…
Post: Neat tricks for the MySQL command-line pager
June 23, 2008 By 13 Comments
…write your own script and push the output through it. You can’t specify arguments to the script, but since you can write…tmp/lock_waits PAGER set to ‘/tmp/lock_waits’ mysql> show innodb status\G ——- TRX HAS BEEN WAITING 50 SEC FOR THIS LOCK TO… rows 2 +- Table scan rows 1022 +- Table table film …
