…] /usr/libexec/mysqld: Shutdown complete 120502 11:50:41 mysqld ended 120502 11:51:16 mysqld started 120502 11:51:16…: ready for connections. Version: ’5.0.95′ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 Source distribution Also, I don’t see how MySQL could be using any other conf file other than /etc…
Comment: What to tune in MySQL Server after installation
April 28, 2012 By 116 Comments
… at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156) at com.mysql.jdbc.MysqlIO.(MysqlIO.java:276) at com.mysql.jdbc.Connection.createNewIO….java:105) at java.awt.EventDispatchThread.run(EventDispatchThread.java:90) ** END NESTED EXCEPTION **
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… a Debian Squeeze system where I have to edit: /etc/mysql/my.cnf Also make sure that innodb_buffer_pool_size… log files later (or even do not move them). The end result was: I could only use mysqldump to import all…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… have created which temporary tables (both in memory and not): mysql> select * from information_schema.global_temporary_tables \G *************************** 1. row… I would say these are rather rare in MySQL. Most suspected memory leaks end up being some run away resource usage, though… and fixed. This is where your MySQL Support contract can be handy. Conclusion Understanding where MySQL can allocate memory can help us…
Post: Early Bird Pricing Ends Today for Percona Live MySQL Conference & Expo
March 12, 2012 By Leave a Comment
Early Bird Pricing for the Percona Live MySQL Conference and Expo ends today, March 12th. Hotel room rates at the Hyatt Regency…, Eucalyptus Systems, Percona, and more. This is the “must attend” MySQL event of the year. Already planning to attend? The calls…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
…, which in the end causes “field list” operation to be blocked too, which among other tools used by mysql client, so you… query blocks any READ queries to execute on the table. mysql> show processlist; +——-+——+———–+———-+————+——+——————————+——————————+———–+—————+———–+ | Id | User | Host | db | Command | Time | State | Info…
Post: Best kept MySQLDump Secret
March 23, 2012 By 11 Comments
… visible. In the end we will get new structure in the dump but no data. Here is example: SESSION1: mysql> show tables… | +——————–+ | A | | B | | C | +——————–+ 3 rows in set (0.00 sec) mysql> select count(*) from A; +———-+ | count(*) | +———-+ | 2359296 | +———-+ 1 row in set…
Post: Announcing Percona XtraBackup 1.9.1
February 27, 2012 By 9 Comments
…. If provisioning a slave, this means your new slave will end up with a warmed up buffer pool to mimic that…
Comment: Percona Toolkit 2.1 with New Online Schema Change Tool
April 22, 2012 By 9 Comments
…) with a Percona type version of MySQL – ie one of Percona’s “improved” versions of MySQL (that is what Percona does, isn…, thanks for your help and information. I just made the MySQL, apache2 and php updates available to Debian Squeeze avalable on…) with the last two or three minor updates since the end of last year; shortly after Oracle took it over. Can…
Comment: Introducing new type of benchmark
February 25, 2012 By 16 Comments
… definitely find this useful. Benchmarks are written to provide the end user with a perspective of how a piece of software… extent SQL Server handle better. JOIN has long been something MySQL has done badly, people have been ragging on about it… board? With the increasing emergence of drop-in replacements for MySQL like Percona and MariaDB which are either tweaking or flat…
