…=16 innodb-recovery-stats innodb-recovery-update-relay-log innodb-replication-delay=# innodb-rollback-on-timeout innodb-rollback-segments=16 innodb-stats-auto-update=0 innodb-stats-on-metadata=0 innodb-stats…=256 innodb-stats-update-need-lock=0 innodb-status-file innodb-strict-mode innodb-thread-concurrency=0 innodb-thread-concurrency-timer-based innodb-thread-sleep-delay=0 innodb-use-sys-stats-table innodb…
Post: Percona Server 5.1.49-rel12.0
September 15, 2010 By 6 Comments
…_commit. (Yasufumi Kinoshita) innodb_fast_index_creation – Allows disabling of fast index creation. (Yasufumi Kinoshita) innodb_use_sys_stats_table – If ON, the table‘s statistics are stored statically in the internal table SYS_STATS. The table is populated with the ANALYZE TABLE command. (Yasufumi…
Post: Percona Server 5.1.49-rel11.3
September 10, 2010 By 1 Comment
… introduced: innodb_use_sys_stats_table. If ON, the table‘s statistics are stored statically in the internal table SYS_STATS. The table is populated with the ANALYZE TABLE command. A new session variable was introduced: innodb_flush_log_at…
Post: Percona Server 5.1.50-rel11.4
September 27, 2010 By 1 Comment
… on MySQL 5.1.50. Fixed bugs innodb_use_sys_stats_table – The SYS_STATS table is now used only for non-temporary tables. The binary packages are available on…
Post: How well does your table fits in innodb buffer pool ?
December 9, 2010 By 11 Comments
…innodb_sys_tables ON table_id = innodb_sys_tables.id JOIN innodb_index_stats ON innodb_index_stats.table_name = innodb_sys_tables.name AND innodb_sys_indexes.name = innodb_index_stats.index_name AND innodb_index_stats.table_schema = innodb_sys_tables…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…innodb_table_locksblogpercona.commanual innodb_thread_concurrencyblogpercona.commanual innodb_thread_sleep_delayblogpercona.commanual Innodb_truncated_status_writesblogpercona.commanual innodb_use_native_aioblogpercona.commanual innodb_use_sys_mallocblogpercona.commanual innodb…
Comment: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
…innodb_support_xa ON innodb_sync_spin_loops 30 innodb_table_locks ON innodb_thread_concurrency 0 innodb_thread_sleep_delay 10000 innodb_use_sys_malloc ON innodb…
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
… however there is still significant amount of reads (the stats were flushed between query runs) which does not make…temporary table. Do not forget about it especially if running only Innodb tables so you may think there is no use for…buff cache si so bi bo in cs us sy id wa st 0 4 116 60064 9084 …
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…) ==9090== by 0x74E4DF: get_schema_tables_result(JOIN*, enum_schema_table_state) (sql_show.cc:6238) ==…similar issues (other InnoDB stat counters), show non-issues or my analysis errors (like the log_sys->lsn “race”…I had my way, I’d use atomic access primitives in InnoDB for the benign and minor…
Post: Beware the Innodb Table Monitor
November 29, 2011 By 2 Comments
…Tables‘ were waiting for the dict_sys->mutex, which is required for opening tables in Innodb. It would be better for the Table Monitor if: Table stats…
