June 19, 2013

Post: Call for papers: Percona Live London

… step up and volunteer to present your unique insights into MySQL and MySQL-related technologies either as a keynote, tutorial or breakout… sponsors. This is the showcase event for Europe’s growing MySQL community of developers, business managers, technology evangelists, DBAs and entrepreneurs… the benefits of sponsorship. Questions? Let me know in the comments section. I look forward to hearing from you!

Post: Implementing SchemaSpy in your MySQL environment

…Percona Server 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1:5610/schemaspy …02/05/schemaspy.meta.xsd”> <comments> Main Production Database. Percona, Michael Coburn comments>

comments=”Parent table”>

Post: Experiences with the McAfee MySQL Audit Plugin

… share my experience in this post. Auditing user activity in MySQL  has traditionally been challenging. Most data can be obtained from… why that is the case. Maybe someone more knowledgeable in MySQL internals can enlighten me here. – audit_record_objs : List of… my config file for the plugin to work (plus one commented line for switching between file and socket for output): plugin…

Post: The small improvements of MySQL 5.6: Duplicate Index Detection

…unnoticed by most (not all) DBAs. Duplicate Index Detection I commented about this on my last webinar, but did not have…warning (0.56 sec) Records: 0 Duplicates: 0 Warnings: 1 mysql> SHOW WARNINGS\G *************************** 1. row *************************** Level: Note Code: 1831 Message: …

Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency

… Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using… performance of the benchmark.  There was some discussion in the comments and I promised to follow up with more SSB tests… [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb…

Comment: How to calculate a good InnoDB log file size

Scratch my previous comment, this is seemingly not repeatable today: (despite the fact that …/lib/mysql/ib_logfile* -rw-rw—- 1 mysql mysql 536870912 May 22 13:33 /var/lib/mysql/ib_logfile0 -rw-rw—- 1 mysql mysql 536870912 May 22 12:55 /var/lib/mysql/ib…

Comment: Derived Tables and Views Performance

i would appreciate your comments on this script: taken from: http://phptechnicalgroups.blogspot.co.il/2013/05/simple-mysql-and-php-prodcuts… 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: Percona Live MySQL Conference 2013 wrap-up

comments such as this from Tom Krouper or this from John Goulah or this from Jeremy Tinley or this from SF MySQL…, tutorial, and breakout session speakers who presented insights into MySQL and MySQL-related technologies in over 110 sessions across four days. Special… particularly enjoyed the Percona Live MySQL Conference keynote presentations this year. I heard very positive comments on the sponsor sessions including the…

Post: 10 years of MySQL User Conferences

… available for MySQL. Facebook mentions they have over 1,800 MySQL Servers. MySQL Enterprise provides Monthly Rapid Updates [MRU] while Community MySQL versions updated… moments do you have from you attending MySQL Conference over last 10 years. Please leave comment and share your experiences! Thank you…

Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL

Galera/Percona XtraDB Cluster (PXC) for MySQL is a hot thing right now and some users jump …’d like to hear your thoughts and experience on the comments :)