June 19, 2013

Post: Experiences with the McAfee MySQL Audit Plugin

…_record_objs : List of database objects (tables, according to the docs) for which you want events written to the log. – audit… plugin to work (plus one commented line for switching between file and socket for output): plugin-load=AUDIT=libaudit_plugin.so audit_offsets=6464, 6512, 4072, 4512, 104, 2584 audit_json_file=1 audit_json_socket_name=/tmp/audit.sock #audit_json…

Comment: How to calculate a good InnoDB log file size

It seems that in 5.5 the second log file is touched even if a rotation has not occurred, that ….mysql.com/doc/refman/5.5/en/innodb-performance-recovery.html “If you kept the size of your redo log files artificially low because recovery took a long time, you can consider increasing the file size.”

Comment: How to recover table structure from InnoDB dictionary

1) innodb_file_per_table is OFF by default, which means all tables …_parser tools. You can check the docs how to do it http://www.percona.com/docs/wiki/innodb-data-recovery-tool:mysql… find index_id for each table – http://www.percona.com/docs/wiki/innodb-data-recovery-tool:mysql-data-recovery:advanced_techniques…

Comment: Percona Server 5.5.30 with TokuDB for MySQL

I follow http://dev.mysql.com/doc/refman/5.5/en/binary-installation.html and seems to be fine, but when I try to run mysql command-line I found this: # bin/mysql bin/mysql: error while loading shared libraries: libtinfo.so.5: cannot open shared object file: No such file or directory What I miss?

Post: Getting MySQL Core file on Linux

… to do couple of changes to enable core files. First you need “core-file” option to my.cnf which will instruct MySQL…/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. Writing a core file… see Segmentation fault(core dumped) after Writing a core file. If core file was not written you will just have “Segmentation fault…

Post: Recovering CREATE TABLE statement from .frm file

… InnoDB data files but have forgotten to delete the corresponding .frm files of InnoDB tables, or you have moved .frm files to another… the engine doesn’t support. See http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting.html how you can… data dictionary so it allows MySQL to succeed displaying .frm file contents: mysql> create table test_innodb(i int) engine=innodb…

Post: Backing up binary log files with mysqlbinlog

… binary log data to local disks ( http://dev.mysql.com/doc/refman/5.6/en/mysqlbinlog-backup.html ). This can be…. By default if you do not supply the binary log file, mysqlbinlog deletes and overwrites them all that is undesired behaviour… $? trying to reconnect in $RESPAWN seconds.” sleep $RESPAWN done Configuration file: MBL=/opt/mysql5.6/usr/bin/mysqlbinlog MYSQLHOST=10.10…

Post: Future InnoDB File Formats

Looking into InnoDB docs I found list of names of future InnoDB file formats: Antelope, Barracuda, Cheetah, Dragon, Elk, Fox, Gazelle, Hornet…

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

… is that there are a lot of “new” InnoDB tablespace files in our database directory: -rw-rw—-. 1 mysql mysql 8632… index. I’m not entirely sure about the _STOPWORDS.ibd file just yet; I thought it might be somehow related to…_*_DOC_ID.ibd file (but none of the others), and if you drop a FT index, the its corresponding FTS_*_DOC_ID.ibd file

Post: XtraDB: The Top 10 enhancements

… one server to another, by backing up the .ibd file with Xtrabackup (see docs). IO scalability fixes – A lot of the internal… log files (innodb_log_file_size), which is worse for performance.  In a simple test, XtraDB recovered ten times faster (see docs… more aggressively as you approach the end of a log file (see docs). Insert Buffer control – The insert buffer is a great…