… logs after in X days. long_query_time = 2 thread_cache_size = 100 max_connections = 400 table_cache = 20000 open_files_limit = 40000… = 20M tmp_table_size = 100M max_heap_table_size = 100M query_cache_size = 100M default_table_type = MYISAM log_long_format # Innodb… = 1 innodb_file_per_table = 1 innodb_data_home_dir = /db2/innodb innodb_log_group_home_dir = /db-logs/ibdlogs innodb…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
… logs after in X days. long_query_time = 2 thread_cache_size = 100 max_connections = 400 table_cache = 20000 open_files_limit = 40000… = 20M tmp_table_size = 100M max_heap_table_size = 100M query_cache_size = 100M default_table_type = MYISAM log_long_format # Innodb… = 1 innodb_file_per_table = 1 innodb_data_home_dir = /db2/innodb innodb_log_group_home_dir = /db-logs/ibdlogs innodb…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… about Prepared Statements in MySQL 4.1 which came without query cache support but even worse not all of statements could be… run (and still can’t) most of your Oracle/DB2/MS SQL Queries on MySQL because subqueries optimizer weakness. I’m saying… inconsistent it stays where for very long time. For example Query Cache support for Prepared Statements is only fixed in MySQL 5…
