June 18, 2013

Post: How Percona does a MySQL Performance Audit

…_64 x86_64 GNU/Linux [percona@db1 ~]$ cat /etc/*release Red Hat Enterprise Linux Server release 5.2 (…/mysql/mysql.sock consult 28852 26909 0 19:08 pts/2 00:00:00 grep mysqld In this case,…ignore. The above process may look like a static recipe that you can just mechanically execute, and in some cases

Post: How to obtain the "LES" (Last Executed Statement) from an Optimized Core Dump?

….25a-rel27.1-285.Linux.x86_64/bin/mysqld ./core.3200 [...] …Last Executed Statement - in our RQG case for example, we could…mysql_execute_command frame: (gdb) frame 21 #21 0x00000000005a30af in mysql…, 3135          lex->duplicates, 3136          lex->ignore))) 3137       { 3138  res= handle_select(…

Post: Announcing Percona XtraBackup 2.0.4

… wasn’t working correctly. Bug fixed #887803 (Alexey Kopytov). In case safe-slave-backup-timeout was reached when using the safe…-log when filesystem didn’t support Linux AIO. Bug fixed #1065561 (Alexey Kopytov). XtraBackup binary would ignore innodb_use_native_aio when…

Comment: Database problems in MySQL/PHP Applications

linux with 16gigs or ram. Here is our my.cnf # sammple MySQLignore-db=dummyData #binlog-ignore-db=edmunds #binlog-ignore-db=evox #binlog-ignore-db=jato #binlog-ignore-db=kbb binlog-ignore-db=mysql binlog-ignore-db=test #binlog-ignore…2) Set the variables below. However, in case you choose this method…