…MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as … which would be rather handy is UDF or stored procedure to “normalize” query by removing comments and replacing…most frequent slow query types or queries which load server the most. The other handly feature would…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql… both the queries which cause the greatest load on the server (in aggregate) and which…, or apps that have a lot of stored procedures, which are more difficult to analyze because…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…load your backups onto. In addition, you can binlog rollforward 24 hours of binlogs as a good test. Store…s. It does not handle views/triggers/procedures etc. Run with –no-schemas, instead …transfer files that are partially transferred Compress the files after successful transfer Amazon S3 for MySQL …
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…Load procedure: Infobright: the loader that comes with ICE version is very limited and I had to transform files to quote each field. After that load statement is: mysql -S /tmp/mysql-ib.sock -e “LOAD… Q8 (1year range) traditional transactional oriented stored engine took 30min to get result….
