Percona's MySQL & InnoDB performance and scalability blog
…detailed guide on tuning innodb buffer pool innodb_log_file_size – This depends on… transactions. innodb_thread_concurrency=8 Even with current Innodb Scalability Fixes having limited concurrency…row level replication. There are bunch of other options you may want to tune but lets focus only on Innodb…
… ROWS_READ columns of TABLE_STATISTICS and INDEX_STATISTICS were not properly updated when a query involved index lookups on an InnoDB… even on an empty InnoDB table could take a long time due to excessive locking when innodb_dict_size_limit was non-zero. Locking…
….commanual Innodb_row_lock_timeblogpercona.commanual Innodb_row_lock_time_avgblogpercona.commanual Innodb_row_lock_time_maxblogpercona.commanual Innodb_row_lock_waitsblogpercona.commanual Innodb_rows_deletedblogpercona.commanual Innodb_rows_insertedblogpercona.commanual Innodb_rows_readblogpercona…
…limitation with the InnoDB…innodb_ft_min_token_size to 1, dropped/rebuilt the InnoDB…
…128 MyISAM / InnoDB: libexec/mysqld –no-defaults –user=root –key-buffer-size=1500M –innodb-buffer-pool-size=1500M –innodb-log-file-size=100M –innodb-thread-concurrency=8… %d LIMIT 50 READ_FTS Query: SELECT min(dob) FROM $tableName The hardest query performs a scan of all million rows. InnoDB is…
… you have to specify compressed block size, this is the size to which you expect each page …Innodb is being blamed for a lot of “Gotches” while many of them come from MySQL limits at the time when Innodb… target at least MySQL 5.1 with row level replication readily available. Speaking about community…
…delete from dir_test_innodb LIMIT 200000; Query OK, 200000 rows affected (8.65 sec) mysql> optimize table dir_test_innodb; +———————-+———-+———-+———-+ | Table | Op | … to the default InnoDB settings for MySQL 5.6, and that was to change innodb_ft_min_token_size from the …
…. Index Condition Pushdown Traditional B-Tree index lookups have some limitations in cases such as range scans, where index parts after…
…row examined + 1 ticket per row updated DELETE: 1 ticket per row examined + 1 ticket per row deleted ALTER: (2 * rows…enter InnoDB is limited by innodb_…innodb_log_buffer_size = 8M innodb_log_files_in_group=2 innodb_log_file_size=1900M innodb_thread_concurrency=16 innodb_flush_method = O_DIRECT innodb…
… use reasonable global buffers, such as innodb_buffer_size, key_buffer_size etc, you have reasonable amount…_heap_table_size variable which allows you to limit size of MEMORY tables (the limit applies both to…: MEMORY NAME: #sql516_1c42_1 TABLE_ROWS: 2 AVG_ROW_LENGTH: 257 DATA_LENGTH: 126984 INDEX_…
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.