…to be enabled in slave server and the performance impact should be taken in account. Anyway, … and set it on the slave. MySQL keeps two global variables with GTID numbers on it: gtid…changing GTID_PURGED manually but we can’t change it with SET because is a read only variable. The only way to change…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…changed, starting MySQL 5.5.3. Let’s see how this works now. Metadata Locking behavior starting MySQL… table open operation was performed and hence no wait…> show status like ‘Open%tables’; +—————+——-+ | Variable_name | Value | +—————+——-+ | Open_tables | 30 | | Opened_…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
… happening concurrently. It is very typical to hear complains about MySQL interactive performance – serving simple standard web traffic is drastically impacted when… also look into changing how buffer pool is split into young and old sublists via innodb_old_blocks_pct variable though we…
Post: Percona Server 5.5.10 (Release Candidate)
April 4, 2011 By 4 Comments
…variable innodb_enable_unsafe_group_commit was deleted. The existing MySQL variable innodb_support_xa can be used instead. (Yasufumi Kinoshita) Old system variable…performance. (Oleg Tsarev) Bug #727704 – When using the Expand Table Import feature, importing .ibd files created on MySQL…
Post: Time for Zero Administration effort at MySQL ?
January 8, 2012 By 4 Comments
… Optimizing MySQL Configuration talk for Percona Live in Washington,DC I noticed how many Variables did MySQL get over years – it is… have matching SHOW VARIABLES value, and settings done by changing tables rather than command line options (like much of Performance Schema configuration). Innodb…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
… the reset. A speculative processor might perform the read first, which could leave …system_variables and LOCK_system_variables_hash. Deadlock is possible when one connection issues SHOW VARIABLES …changes that might make the issues not-so-minor. Additionally, I’d consider backporting and using MySQL…
Post: MySQL Users Conference Presentation Proposals
October 24, 2007 By 12 Comments
…approach to MySQL variable tuning. Instead of giving you theoretical guesses on what would be right variable values we’ll perform benchmarks…Performance We’re looking at performance at Open Source Transactional Storage engine MySQL – Innodb, Falcon, SolidDB, PBXT and analyzing how things have changed…
Post: Is MySQL 5.6 slower than MySQL 5.5?
February 18, 2013 By 23 Comments
…. Granted I have not tuned MySQL 5.6 for best performance going with defaults outside of few variables MySQL Sandbox sets explicitly but yet this is likely course of action for many MySQL users out there, also was not change…
Post: Introducing the pmp-check-mysql-status Nagios Plugin
March 29, 2012 By 2 Comments
…of status counters and variables. This is the pmp-check-mysql-status plugin, which can perform computations on status variables. By default, I recommend…variable or another counter Add, subtract, multiply, and divide counters or variables Transform a ratio into a percentage Compute the rate of change…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
… little changes done to the core of original implementation which appeared in MySQL …MySQL Query Cache so it once again is appealing to improve performance for MySQL Applications ? Make it Lockless Can we re-implement MySQL… get query_cache_ttl as session variable, which is very helpful for …
