Thanks for the suggestion. I don’t see anything suspicious in the /var/log/…: 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: Load management Techniques for MySQL
May 11, 2012 By 3 Comments
… right place to suggest somenting , but i will, i have one question about select sorted results from a big mysql tabble, myISAM…
Comment: PHP Sessions - Files vs Database Based
April 10, 2012 By 38 Comments
With suggested mysql backed memcached as session handler, there still exists problem with … previous changes. The problem is not actually with memcached or mysql, but on using the $_SESSION that can be operated only…
Post: Give feedback on a pt-online-schema-change update
March 14, 2012 By 2 Comments
… on it, please write to the mailing list with your suggestions. Thanks!
Comment: Too many connections? No problem!
March 15, 2012 By 28 Comments
… have my website develop in PHP with MYSQL, these are MYSQL values: datadir=/data/mysql socket=/data/mysql/mysql.sock max_connections = 600 wait_timeout…_logs_days = 5 max_binlog_size = 100M [client] socket=/data/mysql/mysql.sock When I start the database service that starts smoothly… the security aspect and not an attack, will have any suggestions or ideas of what might be causing thereby increase the…
Comment: Innodb Performance Optimization Basics
March 28, 2012 By 70 Comments
… with slow query output. The tables are in InnoDB with MySQL 5 and RHEL 5. Its a 32 bit machine with… = ibdata1:10M:autoextend innodb_log_group_home_dir = /usr/local/mysql/data innodb_buffer_pool_size = 2000M innodb_additional_mem_pool… min 54.29 sec) Please help to improve performance and suggest if any config changes are to be made. Thanks
Comment: Solving INFORMATION_SCHEMA slowness
April 20, 2012 By 16 Comments
… suggest adding an option to the tool (and this might apply to the rest of the percona tools that use the MySQL…
Comment: Online MySQL Configuration Wizard from Percona
March 15, 2012 By 23 Comments
Great idea indeed! I’ve got a few suggestions. When you choose the “This server will be a replica”, … like the idea of putting socket and pid files in mysql data directory. My usual choice for them is /var/run…
Comment: INSERT INTO ... SELECT Performance with Innodb tables.
March 7, 2012 By 21 Comments
I am using AWS MySQL RDS, InnoDB engine. Our requirement is to insert data in … can improve the performance? We can use OUTFILE method as suggested by Peter because of permission. What is the best way…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
… problems. To avoid this problem as much as possible, I suggest the following: Alert only on things that reliably indicate a… impossible to find the right threshold for all situations. This suggestion is a consequence of the previous two, but it’s… see a pretty extensive list of suggestions for what to monitor in MySQL. Those are only suggestions; any given deployment might want to…
