June 18, 2013

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

MySQL server. Let’s take a recent 5.1 bzr version (pre-5.1.61) and a single test, innodb_plugin.innodbfile_write (os0file.c:2172) ==9090==    by 0x6B35B5E: fil_io (fil0fil.c:4432) ==9090==    by 0x6B67EDA: log_group

Post: Percona Server 5.5.16-22.0

in 5.1 it is –innodb-blocking-lru-restore), which is OFF by default. When set to ON, restoring from the LRU dump filevariable innodb_expand_fast_index_creation has been introduced for enabling or disabling this feature. #858945 (Alexey Kopytov). Bugs Fixed InnoDB

Post: Percona Xtrabackup 1.6.2 released!

… should only be used with innodb-file-per-table set in the server, the variable is checked by xtrabackup … When creating an InnoDB with its own tablespace after taking a full backup, if the log files have been… development Release notes Documentation Developer Discussion group General Discussion group

Post: Percona Server 5.1.53-12.4

MySQLInnoDB system files when a dedicated file to contain the doublewrite buffer is specified. (Yasufumi Kinoyasu) Added system variablelog_slow_verbosity=innodbin Percona Server. For general questions, use our Percona Discussions Group, and for development questions our Percona Development Group

Post: Percona Server 5.1.58-12.9

file also (size, name, access time, etc.), but for the transaction logvariables for my.cnf have been kept for compatibility and warnings will be printed for the deprecated options (innodbin MySQL (Alexey Kopytov). Uninitialized values in the Slow Query Loggroup

Page: Tools

MySQL Report is a tool which would look at status variables same as mysqladmin extended but will grouplog. It reads bunch of different logMySQL and is helpful even if you do not use Innodb tables. Very nice to watch what happens to server infile is cached in