… Server 5.5.30 and check how these servers will handle such OLTP workloads in the CPU and IO-bound cases…_per_table innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_io_capacity = 5000 sync_binlog=0 max_connections=5000 table_open_cache=5000 table-definition-cache=1000 query_cache_size=0 query_cache_type=0 performance_schema=0 #56only…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…max_rwlock_classesblogpercona.commanual performance_schema_max_rwlock_instancesblogpercona.commanual performance_schema_max_table_handlesblogpercona.commanual performance_schema_max_table_instancesblogpercona.commanual performance_schema_max_thread_classesblogpercona.commanual performance_schema_max…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… | OFF | | PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_SIZE | 10 | 5 | | PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_LONG_SIZE | 10000 | 100 | | PERFORMANCE_SCHEMA_MAX_RWLOCK_INSTANCES | 1000000 | 1724 | | PERFORMANCE_SCHEMA_MAX_TABLE_HANDLES | 100000 | 2223…/dpe0 | /mnt/data/sandboxes/msb_5_6_10/data/dpe0 | | PERFORMANCE_SCHEMA_MAX_TABLE_INSTANCES | 50000 | 445 | | SYNC_RELAY_LOG_INFO | 0 | 10000 | | SLAVE…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… are likely to be very different. The schema and queries are described here Used hardware …=1G –falcon_max_record_memory=2GB –falcon_page_cache_size=1500M –max-connections=1500 –table-cache=512 –… cannot handle LIMIT properly and that is why we see bad performance. We hope the performance of …
Post: Announcing Percona Server for MySQL version 5.5.29-30.0
February 26, 2013 By Leave a Comment
…performance even with the increased number of client connections. New user statements have been introduced for handling…made to improve InnoDB DROP TABLE performance were not adjusted …#1105709 (Laurynas Biveinis). INFORMATION_SCHEMA plugin name innodb_… option to innodb_max_changed_pages. Bug fixed …
