June 19, 2013

Post: Announcing Percona Server 5.5.28-29.2

… flag –debug has been added to the build script, that will create a build with the debug…running server. This information can be useful when doing the Expand Table Import. Support for Fake …UPDATE. In some cases this could cause infinite loop. Bug fixed #917942 (Mark Callaghan, Laurynas Biveinis). …

Comment: Apache PHP MySQL and Runaway Scripts

Ven, Do you see it for ALL scripts which are shown here ? You should see an error for first script (which runs in tight loop and so consumes a lot of CPU time) but others should not be killed.

Post: MySQL Backup tools used by Percona Remote DBA for MySQL

… fix here. Details on how we dump schemas: loop through each DB write out ALTER DATABASE DEFAULT … factor on restore time when done inline. When do we typically use mydumper restores: Restoring a single …files with gpg prior to upload via a separate script use_https = True, especially if your data is …

Post: SHOW INNODB STATUS walk through

… for interval you want to have, if you’re writing scripts to look at SHOW INNODB STATUS it is much better…. innodb_sync_spin_loops can be used to ballance between wasting CPU time running spin locks and doing unneeded context switches. The… of system operations – flushing dirty pages, checkpointing, purging, flusing logs, doing insert buffer merge. Values for “state” field are rather self…