June 19, 2013

Post: Percona XtraBackup 2.1.2 for MySQL available for download

… and Percona Software Repositories. This release fixes number of high-priority bugs since version 2.1 became GA. It’s advised…-info being ignored in such a case. Bug fixed #1180662. Low values for wait_timeout on the server could cause server… connections if the global wait_timeout value is set too low. Bug fixed #1180922. Other bug fixes: bug fixed #1177182. Release…

Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue

…-30.2 — New Features: Percona Server for MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov) Percona Server… by avoiding the malloc call in the read_view_create_low() in most cases. This significantly improves InnoDB scalability on read…

Post: Percona Server for MySQL 5.5.30-30.2 now available

… at Launchpad. New Features: Percona Server for MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov) Percona Server… by avoiding the malloc call in the read_view_create_low() in most cases. This significantly improves InnoDB scalability on read…

Post: Using MyISAM in production

… enough. Lock priorities. By default MySQL treats updates as higher priority operations. You can use SELECT HIGH_PRIORITY or UPDATE LOW_PRIORITY to adjust that or you can simply set low_priority_updates option…

Post: Ultimate MySQL variable and status reference list

…_tc_sizeblogpercona.commanual log_warningsblogpercona.commanual long_query_timeblogpercona.commanual low_priority_updatesblogpercona.commanual lower_case_file_systemblogpercona.commanual lower_case_table….commanual sql_log_offblogpercona.commanual sql_log_updateblogpercona.commanual sql_low_priority_updatesblogpercona.commanual sql_max_join_sizeblogpercona.commanual sql_modeblogpercona.commanual…

Comment: Linux IO Schedulers and MySQL

… is tough to use with database as there can be priority inversion due to lock held by the thread etc. What… great to see implemented is per request priorities so log flushes for example would get high priority while background dirty pages flush low priority.

Post: Knowing what pt-online-schema-change will do

…`) Not copying rows because this is a dry run. INSERT LOW_PRIORITY IGNORE INTO `test`.`_t_new` (`id`, `guest_language`, `guest_country…: Not copying rows because this is a dry run. INSERT LOW_PRIORITY IGNORE INTO `test`.`_t_new` (`id`, `guest_language`, `guest_country…

Post: SELECT LOCK IN SHARE MODE and FOR UPDATE

… on Innodb table but no updates. Supporting MySQL hints “HIGH_PRIORITY” and “LOW_PRIORITY” would probably be good start.

Post: MySQL Server Variables - SQL layer or Storage Engine specific.

… Cache also could use this feature. low_priority_updates If enabled selects will get higher priority than updates and waiting update will not…

Post: pt-online-schema-change and default values

…: Field ‘v’ doesn’t have a default value Query: INSERT LOW_PRIORITY IGNORE INTO `sbtest`.`_sbtest_new` (`id`, `k`, `c`, `pad`) SELECT…