…McAfee MySQL Audit Plugin and would like to share my experience in this post. Auditing user activity in MySQL …is undocumented on the wiki at the time of writing, and is a list of users for…cmd”:”Connect”,”query”:”Connect”} {“msg-type”:”activity”,”date“:”1369155747373″,”thread-id”:”6439″,”query-id”:”…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
…in the comments and I promised to follow up with more SSB tests at a later date…time periods or different regions. The flights represent the type of investigations and drill-downs that are common in OLAP analysis. Each query in… basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin …
Comment: How to calculate a good InnoDB log file size
May 21, 2013 By 38 Comments
…/lib/mysql/ib_logfile* && date && mysql -BNe’show engine innodb status\G’ | grep sequence && sleep 60 && date && mysql…in modern versions of InnoDB: https://blogs.oracle.com/mysqlinnodb/entry/innodb_recovery_is_now_faster And from the manual: http://dev.mysql… recovery took a long time, you can …
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
…. MySQL 4.0.12 was just released as its first GA release in the MySQL 4.0 series, and for the first and only time in a MySQL version you could buy MySQL in a box with… perhaps the time of the brightest hopes for MySQL to date at the time, and everyone had a “lets change the world” mentality. MySQL 4.1…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… critical operation, and its tries and wait time between tries for …date or are known bad versions. For example, there are two versions of the DBD::mysql Perl module that have problems. And…and pt-mysql-summary have built-in MySQL options No more “pt-stalk — -h db1 -u me”. pt-stalk 2.2 and pt-mysql…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… feedback mechanism, unlike anything you find in standard async MySQL replication. It is my belief that … in the cluster might have applying cluster transactions. Therefore, it keeps reads more up to date …message (to pause) and then Flow control is in a pause state 100% of the time. We can …
Post: Percona XtraDB Cluster for MySQL and encrypted Galera replication
May 3, 2013 By 2 Comments
…certificate with a very long expiration time. If you use the default expiration…date has past. Note also that we currently need to use the same cert and…mysql]# service mysql start [root@node3 mysql]# service mysql start There should be no need for SST in this case: each node was shutdown cleanly, and…
Post: Testing the Micron P320h
April 16, 2013 By 7 Comments
… equally impressive; the next two graphs show 95th and 99th-percentile response time, but there really isn’t much difference … a standard TPCC-MySQL test to the original FusionIO and the Intel i910 with assorted buffer pool sizes: And in this graph … the fastest one that I have personally seen to date…
Post: Auditing login attempts in MySQL
December 28, 2012 By 4 Comments
… get the number of connections and failed connections made by a particular user but not the date and time of those attempts. Besides that information we can get other statistics that can be very useful if MySQL is… We don’t have too many audit capabilities in MySQL Community so logging all events and then filter them with custom-made scripts…
Post: How to debug long-running transactions in MySQL
March 8, 2011 By 6 Comments
… long time without committing, and has modified data, then other transactions could block and fail… into a query log, and examine the log. In MySQL 5.1 and newer with the …and port ${port} > /root/tcpdumps/`date +%s`-tcpdump & mysql -e ‘show innodb status\Gshow full processlist’ > /root/tcpdumps/`date…
