… to listen on this socket and process the audit records as you wish. Performance-wise, I did basic tests on the VM…, 2584 audit_json_file=1 audit_json_socket_name=/tmp/audit.sock #audit_json_socket=1 audit_json_log_file=/var/lib/mysql/audit.log audit_record_cmds=connect,Quit Notice the audit…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…=/var/db/mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql.sock consult…. The changes Percona’s performance audits typically suggest can be really significant, and can completely change the performance profile and workload of a…
Post: Tools to use for MySQL Performance Review
May 31, 2008 By 3 Comments
There are some tools we commonly use doing performance review and optimization and we often ask each other where … be public instead. So now you can find our favorite MySQL Performance Review Tools on the site. This is just list of… on Open Source tools which are helpful for “in time” performance audit – for example you see no graphing software in this list…
Post: Auditing login attempts in MySQL
December 28, 2012 By 4 Comments
… a recurrent question made by our MySQL Support customers: How can I audit the login attempts in MySQL? Logging all the attempts or…. Unfortunately there are not too many audit capabilities in MySQL Community so the first option to audit MySQL‘s authentication process is to get… is that it will log everything so it can cause performance degradation and you will have to deal with very large…
Post: Percona is hiring performance experts
February 13, 2009 By 2 Comments
…-level, senior experts in LAMP/Open-Source performance and scalability. Most of our work involves MySQL (at least peripherally, usually centrally) but… component that you might expect to see at the Percona Performance Conference) we’d like to talk with you. What’s… all remote DBA, nor is it all urgent troubleshooting or performance audits; it’s everything you can imagine, and it’s never…
Post: Impact of logging on MySQL’s performance
February 10, 2009 By 8 Comments
… immediately a question arises how much logging impacts on performance. When we do performance audit often we log every query to find not… take more than a second to execute; logging every query; MySQL was run with default settings except following: [mysqld] user=root… than a second without worry about performance impact in case of CPU-bound workload. The performance impact is negligibly small in IO…
Post: How Can Percona MySQL Server Development Services Help ?
January 28, 2013 By 3 Comments
…or the HandlerSocket interface. If you have some custom authentication, auditing, or storage engine needs, we can help. It also …the most performance from your MySQL server via our Percona MySQL Consulting, Percona MySQL Support, and Percona MySQL Remote DBA services. With our MySQL Server …
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
We were doing MySQL Performance evaluation on TPC-H queries for the client and they … publish results which are very interesting. This is obviously not audited TPC-H run, and it can’t be because we… and may be MySQL 6.0 performance will improve. Though considering a lot of talks about optimizer improvements in MySQL 6.0 I…
Post: Write contentions on the query cache
September 5, 2012 By 5 Comments
While doing a performance audit for a customer a few weeks ago, I tried to …. This query was run very frequently and had very unstable performance: during the time data was collected, response time varied from… 160ms). Of course, I wanted to know more about how MySQL executes this query. So I used commands you’re probably…
Post: Election night
November 5, 2008 By Leave a Comment
… array of services enabling them to face the challenge: “Comprehensive MySQL Performance Audit“- to help you find the bottlenecks, to assist with architecture… Time Hire for MySQL“- to keep an eye on your system during whole period of event and to perform fast and proffesional…
