…_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_max_dirty_pages_pct = 50 innodb_io_capacity = 800 innodb_read…_write_io_threads = 4 innodb_file_per_table = 1 ## Disabling query cache query_cache_size = 0 query_cache_type = 0 You can see that… every partition would hold 100 million rows. Table Structure The table structure of the table with no secondary indexes is as follows: CREATE…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… done Check for Table Cache Related Allocations There are cases when MySQL will allocate a lot of memory for table cache, especially if you… down. What you might see instead is flushing tables regularly or reducing table cache reduces memory consumption to be withing the reason. Connection… are also explicit MEMORY tables you can create both as permanent and temporary. There is a max_heap_table_size variable which allows…
Comment: Too many connections? No problem!
March 15, 2012 By 28 Comments
… MYSQL values: datadir=/data/mysql socket=/data/mysql/mysql.sock max_connections = 600 wait_timeout = 60 interactive_timeout=1800 skip-name… log-queries-not-using-indexes query_cache_type=1 query_cache_size=32M thread_cache_size=30 table_cache=4096 join_buffer_size=6M key… = 1 log-bin=/data/mysql/drbd expire_logs_days = 5 max_binlog_size = 100M [client] socket=/data/mysql/mysql.sock When…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
… max_connections = 2500 max_connect_errors = 10 table_cache = 2048 max_allowed_packet = 16M binlog_cache_size = 16M max_heap_table_size = 64M thread_cache_size = 32 query_cache_size = 0 tmp_table…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
…-8K per table though complex tables can require larger sizes, so this is mainly the problem for smaller servers. Table Cache Merge Tables – Table Cache is allocated… it intensionally – most of the limits, such as max_heap_table_size or max_prepared_stmt_count are designed to protect from typical…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…-COMMITTED max_allowed_packet = 1M max_connections=300 max_connect_errors=100 table_cache = 6000 read_rnd_buffer_size = 2M sort_buffer_size = 32k thread_cache = 16 query_cache_size…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…’ ‘Sort_rows’, ’1344092495′ ‘Sort_scan’, ’935242′ ‘Table_locks_immediate’, ’895966639′ ‘Table_locks_waited’, ’20096′ ‘Threads_cached‘, ’0′ ‘Threads_connected’, ’260′ ‘Threads_created’, ’124272…-queries=/var/log/mysql/slow-queries.log max_connections=650 open_files_limit=6144 max_connect_errors=10000 interactive_timeout=3600 wait… used. sort_buffer_size=2M query_cache_size=10M # Might be increased thread_cache_size=40 table_cache=512 # Default 64 was used before…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 12 Comments
…_buffer_size = 2000M max_allowed_packet = 32M # table_cache=20M # open-files-limit=20000 table_cache = 3072 open_files_limit = 9216 tmp_table_size=1000M sort… are using BDB tables #bdb_cache_size = 384M #bdb_max_lock = 100000 # Uncomment the following if you are using InnoDB tables #innodb_data_home…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 139 Comments
…_cache_limit=1M query_cache_size=32M query_cache_type=1 max_connections=1500 interactive_timeout=25 wait_timeout=10 connect_timeout=5 thread_cache_size=60 key_buffer=750M join_buffer=10M max_heap_table_size=50M tmp_table_size=64M max_allowed_packet=16M table_cache=1800 record_buffer=10M sort_buffer_size=24M read_buffer_size=9M max…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
… thread_cache_size = 100 max_connections = 400 table_cache = 20000 open_files_limit = 40000 max_binlog_size = 500M max_allowed_packet = 20M tmp_table_size = 100M max_heap_table_size = 100M query_cache…
