…I commented about this on my last webinar, but did not have time to analyze it in-depth. If you try to…the “will be disallowed in a future release” means. In MySQL 5….Duplicates: 0 Warnings: 0 We get no warnings and no errors in 5.6, …Indexes 2 By the way, if you want to get more familiar with this …
Post: How people are using MySQL... from 1 user to 100 million (upcoming conference talk)
June 11, 2013 By Leave a Comment
… popular, sooner or later you have to think about write scalability, and implement sharding ultimately. I will give a talk on this topic… makes sense to use one or an other, and common pitfalls we typically see in our consulting practice. Please let me know if you plan on attending – and also feel free to post questions in advance below.
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… has given me time to explore new tools using their environments. One tool that I am finding … related to failures due to constraints. One of the things that I like about ERD tools is that I … Thoughts While I find the Relationships tab the most useful component of SchemaSpy, I don’t want to leave …
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
…to recover the missing events with mysqlbinlog. Let’s say that we want to promote s1 as the new master. We need to… I instruct mysqlbinlog to start reading from there? Unfortunately, there is no…future post). Unfortunately, this will not work for every use case, and until this is fixed, it is good to…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
…I learned quite a lot about these technologies while looking at this, thanks to…to ZFS (30 mirrors + spares + OS partition mirror) and I limited the ARC size to 4GB. I don’t want to…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… available instructions. The only extra step I had to take was to extract the offsets for the … Quit for that to work, and no, my code-fu was not enough to understand why that …me here. – audit_record_objs : List of database objects (tables, according to the docs) for which you want events written to…
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.
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… benchmark. There was some discussion in the comments and I promised to follow up with more SSB tests at a later date. I also promised more low concurrency SSB tests when Peter blogged about… tests were done with no concurrency. The hardware for this test was provided by Adotomi. I will be blogging about raw performance of…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… manual describes very nicely how to switch to GTID-based replication, I won’t repeat it. Basically… replication to GTID replication. But if you are running a production system, you will probably want to…: mysql> show slave status\G [...] Slave_IO_Running: No Slave_SQL_Running: Yes [...] The error log…
Comment: ZFS on Linux and MySQL
June 8, 2013 By 17 Comments
… willing to pay for ZFS. ZFS LZ4 compression is the best thing since the invention of L2ARC and ZIL. All I am dreaming now is to have LZ4 compressed persistent L2ARC, which is coming… developer just quit, so I consider that pretty much dead project. The only thing I don’t like about OmniOS is that the…
