…on main platforms (Linux, Solaris, Windows) rw-locks have a …threads Quadxeon with enabled concurrent-insert Quadxeon –skip-concurrent-insert Sun V40z with enabled concurrent-insert Sun V40z –skip-concurrent… disabling concurrent-insert with –skip-concurrent-insert can improve MyISAM performance. …
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…size = 100M read_rnd_buffer_size = 100M myisam_sort_buffer_size = 100M max_length…thread_cache = 40 max_connections=500 query_cache_size = 2000M # Try number of CPU’s*2 for thread_concurrency thread_concurrency… this option without enabling named pipes on Windows # (via the “enable-named-pipe” option)…
Post: MySQL optimizer: ANALYZE TABLE and Waiting for table flush
February 27, 2013 By 3 Comments
…to trigger this problem we need: – Lot of concurrency – A long running query – Run an ANALYZE …On the other hand, if the table is MyISAM there will be no rollback process so…, ALTER, RENAME, OPTIMIZE or REPAIR can cause threads to wait on “Waiting for tables”, “Waiting … of load or a maintenance window…
