June 19, 2013

Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL

…, and USER_STATISTICS) led to the maximum counter values being limited to 32-bit signed integers. Fixed so that these values… the log system mutex for the log reads needlessly, potentially limiting performance on write-intensive workloads. Bug fixed #1171699. Missing path… Ubuntu 13.04. Bug fixed #1186690. Under very rare circumstances, deleting a zero-size bitmap file at the right moment would…

Post: Percona Server 5.6.11-60.3 first Release Candidate now available

… levels of concurrency. Bug fixed #1185686. Under very rare circumstances, deleting a zero-size bitmap file at the right moment would… the log system mutex for the log reads needlessly, potentially limiting performance on write-intensive workloads. Bug fixed #1171699. Incorrect schema…, and USER_STATISTICS) led to the maximum counter values being limited to 32-bit signed integers. Fixed so that these values…

Post: Limiting InnoDB Data Dictionary

… it there http://mysqlperformanceblog.com/files/patches/innodb_dict_size_limit_standalone.patch. Currently patch is on testing stage, but later… be included into our releases. To limit memory we introduce new variable innodb_dict_size_limit (in bytes). Some internals: There is… by data dictionary may exceed innodb_dict_size_limit, as we can’t delete any table entry from it. To finalize this…

Comment: Thoughts on MySQL Replication

… hanling bulk DELETES by using DELETELIMIT 1000 and executing it in the loop until no more loops can be deleted. If delete is using…

Post: Performance impact of complex queries

… too much resources for too long time. If you delete things do DELETELIMIT 1000 and insert sleep 10; in between. By spreading…

Comment: Using MyISAM in production

… are in sync) Concurrency delete by chopping update statements is good approach. For example I quite frequently used DELETELIMIT 100; in the…

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

…_ft_config; +—————————+———+ | KEY | VALUE | +—————————+———+ | optimize_checkpoint_limit | 180 | | synced_doc_id | 1028261 | | last_optimized_word | | | deleted_doc_count | 0 | | total_word_count… | +—————————+———+ 10 rows in set (0.00 sec) mysql> delete from dir_test_innodb LIMIT 200000; Query OK, 200000 rows affected (8.65…

Post: Performance Schema tables stats

…by_table order by COUNT_STAR DESC LIMIT 5; +————-+————+ | OBJECT_NAME | COUNT_STAR | +————-+————+ | sbtest97 | 1854084 | | sbtest66 | 1837665… COUNT_DELETE: 0 SUM_TIMER_DELETE: 0 MIN_TIMER_DELETE: 0 AVG_TIMER_DELETE: 0 MAX_TIMER_DELETE: 0 *************************** 3….

Post: A quest for the full InnoDB status

… transactions or a large deadlock dump may easily exhaust the limit. MySQL in such situation truncates the output so it fits… transaction list, but fortunately there are some alternatives to the limited MySQL command output. First one is that you can have… all the files that were deleted. garfield ~ # cd /proc/11886/fd garfield fd # ls -l | grep deleted lrwx—— 1 root root 64…

Post: Ultimate MySQL variable and status reference list

…_viewblogpercona.commanual Com_dealloc_sqlblogpercona.commanual Com_deleteblogpercona.commanual Com_delete_multiblogpercona.commanual Com_doblogpercona.commanual Com_drop_dbblogpercona.commanual Com…