Doesn’t MySQL 5.6 log queries in its performance schema? Something called Statement digest? If that is not what you are looking for, you can use Karlsson’s audit plugin http://karlssonondatabases.blogspot.co.uk/2010/03/more-fun-with-mysql-audit-plugin-api.html This may…
Post: Is VoltDB really as scalable as they claim?
February 28, 2011 By 3 Comments
… plans to provide services for VoltDB. We’re focused on MySQL software and services. I am not a VoltDB expert. I… servers, and VoltDB should provide even higher performance on faster machines. I did not audit or repeat Tim’s benchmarks in the… 8 percent) to avoid unphysical parameters as a result of performing a regression against the full dataset. These are rather standard…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
… production. Even the official manual page for MySQL Proxy 0.8.2 still says: “MySQL Proxy is currently an Alpha release and… depends how you store $_SESSION. I have audited sites that stored $_SESSION in the MySQL database for persistence, but when we measured… going to be a high performance cost? A: Connecting to a MySQL database isn’t a great performance cost, compared to the queries…
Post: PROCEDURE ANALYSE
March 23, 2009 By 9 Comments
… done by bunch of SQL queries while really MySQL has a native feature to perform this task – PROCEDURE ANALYSE Here is sample…’) NOT NULL Here is how this table was originally defined: mysql> desc node; +———-+——————+——+—–+———+—————-+ | Field | Type | Null | Key | Default | Extra | +———-+——————+——+—–+———+—————-+ | nid | int… do an ALTER TABLE it provides very helpful information for performing schema audit.
Comment: Announcing PAM authentication plugin for MySQL (early access release)
December 5, 2011 By 9 Comments
Alleluia! Between the audit plug-in interface, and your PAM authentication plug-in (hopefully … set with frustrated envy, and enjoy the rocking performance and flexibility of the MySQL platform. [Please no flaming – PostgreSQL rocks in its…
Comment: White Paper: Preventing MySQL Emergencies
February 7, 2011 By 7 Comments
….5, 3.6): openark kit’s oak-prepare-shutdown will perform both actions: reducing the dirty pages percent until no improvement…. check configuration before shutdown (3.8): mycheckpoint (monitoring tool for MySQL) records all status variables, as well as all server variables… openark kit’s oak-security-audit. Basically, the tool provides you with a report and recommendations on your MySQL‘s security flaws.
