June 19, 2013

Post: MySQL 5.6: Improvements in the Nutshell

MySQL University in Raleigh,NC, Tuesday 29th of January I have created the outline of improvements available in MySQLDELETE queries – - JSON output with more information – Optimizer Tracing – Deadlock Logging – GET DIAGNOSTICS Operational Improvements – Separate Tablespaces for Innodb Undo

Post: SHOW INNODB STATUS walk through

MySQL Performance. To start with basics SHOW INNODB STATUS is commandIn MySQL 5 number of Innodb performance counters were exported and now available in…`parent` (`id`) ON DELETE CASCADE Trying to add in child table, in index `par_ind…is number of unpurged transactions in undo space. It is increased …