It may not be easy to simply switch from regular MySQL replication to using replication using GTIDs 1. Temporary tables – CREATE and DROP…. Updates involving non-transactional storage engines – It is not possible to mix non-transactional tables (such as MYISAM) with innodb tables…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
June 10, 2013 By 8 Comments
Comment: ZFS on Linux and MySQL
June 7, 2013 By 17 Comments
… compression. If I use SSD for L2ARC, I’ll need to do the same for xfs… I am redoing my tpcc test with primarycache=metadata, if giving more arc to metadata make sense, I should already see a difference right… an easy move for a MySQL dba to steal 20GB memory from the Innodb buffer pool to give it to the filesystem. I took…
Comment: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
Miguel: Filters can be combined, but there’s no way (that I know) to achieve what you want with this plugin. You could add mysql.user to the audit_record_objs variable, for example, but not indicate a specific user for which you want to audit changes.
Comment: Derived Tables and Views Performance
May 21, 2013 By 16 Comments
…, PRIMARY KEY (`id`)) —————————————————————————————————— $mysql=mysql_connect(’127.0.0.1′,’root’,”); mysql_select_db(‘test’,$mysql); function display_menu($parent, $level) { $result = mysql_query(“SELECT a…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
…_old Make sure that the files are owned by mysql: chown mysql:mysql /var/lib/mysql/orig_old/* For each table, run: ALTER TABLE… comparison, and allow remote users to compare on a live system without needed to grant access to another “backup” server. As noted by one of…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… in use for my Percona Server 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1… whether you need to provide a hint or not. Running SchemaSpy (with Foreign Keys) When you run schemaSpy without a metadata file… can then be accessed by a web server. Also note that since I created the mysql.properties file in the same directory…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… to analyze it in-depth. If you try to do something like this in MySQL 5.5, you will succeed without errors or warnings: mysql…: 0 Duplicates: 0 Warnings: 0 $ mysqlindexcheck –server=user:pass@localhost test.test # Source on localhost: … connected. $ pt-duplicate-key-checker –tables test…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
…/lib/mysql/audit.log audit_record_cmds=connect,Quit Notice the audit_offsets that I mentioned had to be extracted due to this Percona Server…-maint”,”host”:”localhost”,”cmd”:”Connect“,”query”:”Connect“} In conclusion, the plugin API seems to be opening new possibilities of extending MySQL‘s behavior in…
Post: How people are using MySQL... from 1 user to 100 million (upcoming conference talk)
June 11, 2013 By Leave a Comment
MySQL can be deployed in several ways, and that means… or development systems, many people are using a single server with some backups configured, and then simply take the … application gets really popular, sooner or later you have to think about write scalability, and implement sharding ultimately. I…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… Server for MySQL version 5.6.11-60.3[/caption] Percona is glad to announce the first Release Candidate release of Percona Server 5… Software Repositories). Based on MySQL 5.6.11, including all the bug fixes in it, Percona Server 5.6.11-60.3… fixed #1177780, bug fixed #1154954. Release notes for Percona Server for MySQL 5.6.11-60.3 are available in our online…
