…_pages = 0 innodb_write_io_threads=8 innodb_read_io_threads=8 innodb_io_capacity=500 max_connections=3000 query_cache_size=0 skip-name-resolve table_cache=10000 [mysql] socket=/tmp/mysql.sock (post edited by Fred Linhoss)
Post: Review of MySQL 5.6 Defaults Changes
October 8, 2012 By 10 Comments
…) would be better than trying to be overly smart. host_cache_size = 128 + 1 for each of the first 500 max_connections… value 0 which would mean limit disabled. Very few users actually need DOS prevention this variable strives to provide as MySQL is… even more would be good default. query_cache_size = 1M Query cache remains off by default but default size is raised to 1M which is probably…
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
…_size=512M innodb_log_files_in_group=2 innodb_flush_log_at_trx_commit=2 innodb_flush_method=O_DIRECT query_cache_size=0 query_cache_type=0 MySQL 5.6.5 Configuration innodb_file_per_table=1 innodb_file_format=barracuda innodb_log_file_size=512M…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…cache=16384 table-open-cache=128 thread-cache-size=32 thread-stack=256K tmp-table-size=64M transaction-isolation=READ-COMMITTED user=mysql…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…size = 2M sort_buffer_size = 32k thread_cache = 16 query_cache_size = 0M thread_concurrency = 8 max_heap_table_size=200M log-output = FILE log-slow-queries=/tmp/mysql…for a little bit lless of performance. innodb_thread_concurrency = 0 Good! So Innodb performed best in this workload without …
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
… can query temporary tables too: mysql> …cache 512619219 (509995888 + 2623331) File system 294352 (82672 + 211680) Lock system 318875832 (318747272 + 128560) Recovery system 0 (0 + 0) Threads 425080 (406936 + 18144) Dictionary memory allocated 2623331 Buffer pool size 7864319 Buffer pool size…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
…) mysql> ALTER TABLE `child` ADD PRIMARY KEY (`id`,`parent_id`); — 0 Tickets Used Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> INSERT…=500 innodb_max_dirty_pages_pct=90 max_connections=3000 query_cache_size=0 skip-name-resolve table_cache=10000
Comment: MySQL random freezes could be the query cache
March 29, 2009 By 23 Comments
… = /usr/mysql/logs/mysql-bin.log binlog-do-db=tp server-id=1 wait_timeout = 15 key_buffer = 16M key_buffer_size = 32M max_allowed_packet = 16M thread_stack = 128K thread_cache_size = 64 query_cache_limit = 0 #query_cache_size = 64M query_cache_size = 0 query_cache_type = 0 join_buffer_size = 512K log_slow_queries = /usr/mysql/logs/mysql…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… query in the right way. But vanilla MySQL … queries‘ execution plan (which includes things like whether Query cache…0 0 0 0 0 0 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 0 0 0 0 0 0 0 0 # Query size 0 21.63k 71 71 71 71 0 71 # InnoDB: # IO r bytes 0 0 0 0 0 0 0 0…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 17 Comments
…_file_per_table = 1 ## Disabling query cache query_cache_size = 0 query_cache_type = 0 You can see that the buffer pool is sized at 55G and I am using… performance. Other then that, I have also disabled query cache to avoid contention caused by query cache on write heavy workload. OK, so that was all about the configuration of the EC2 instance and MySQL. Now…
