June 20, 2013

Post: Ultimate MySQL variable and status reference list

…_lostblogpercona.commanual Performance_schema_rwlock_classes_lostblogpercona.commanual Performance_schema_rwlock_instances_lostblogpercona.commanual Performance_schema_table_handles_lostblogpercona.commanual Performance_schema_table_instances_lostblogpercona.commanual Performance_schema_thread…

Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit

…processor might perform the … might be lost, with…TABLE_LIST*, Item*) (sql_show.cc:5522) ==9090==    by 0x74E4DF: get_schema_tables_result(JOIN*, enum_schema_tablehandle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:269) ==9090==    by 0x63A3E3: execute_sqlcom_select(THD*, TABLE

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

perform point in time recovery. Store your binlogs offsite for disaster recovery scenarios. Run pt-table… was lost. e.g. there is one primary schema and that schema was dropped…schema‘s. It does not handle views/triggers/procedures etc. Run with –no-schemas, instead use mysqldump for the schemas