… can find which connections does this process have. Here you can see it has couple of memcached connections. Few MySQL connections (to the same host, which if usually bad idea) and connection to some external web… libmysql or memcache.so, which means it is not MySQL or memcache connections leaving last candidate as the only choice. I also could…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
… table, or the database itself. Likewise, if a system administrator leaves a temporary file in the database directory and then you… error appropriately. The pmp-check-mysql-status plugin can be configured to alert when Threads_connected approaches max_connections too closely, which can…
Post: Percona XtraBackup 1.6.4
December 19, 2011 By 9 Comments
… a large wait_timeout for the MySQL connection, innobackupex will regularly poll the server, keeping the connection alive while the backup is taking… named stdout and stderr to the current working directory and leave them behind. With this bug fixed, innobackupex will use temporary…. Bug Fixed: #687544 (Valentine Gostev) When a password for the MySQL connection was given to innobackupex with the –passwordoption, innobackupex would log…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
… not need much introduction, especially to the MySQL server developers. The Valgrind Memcheck tool, …might perform the read first, which could leave a waiting thread hanging indefinitely. Our …is possible when one connection issues SHOW VARIABLES or equivalent while another connection is just starting…
Post: Talking MySQL to Sphinx
April 19, 2009 By 4 Comments
… sp]# mysql –host 127.0.0.1 –port 3307 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is… tests I used the table from the forum search engine, leaving just bunch of ids in it, removing everything else: CREATE… | 2735703 | 139448919 | 2735703 | +————+——–+———-+———–+———+ 10 rows in set (32.47 sec) MySQL mysql> select max(forum_id) as m,author_id as a…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 116 Comments
… with couple hundreds tables (remember each connection needs its own entry) if you have many connections or many tables increase it larger… Thread creation/destructions can be expensive, which happen at each connect/disconnect. I normally set this value to at least 16…. I normally leave per session variable tuning to second step after I can analyze workload. P.S Note MySQL distribution contains bunch…
Post: MySQL net_write_timeout vs wait_timeout and protocol notes
July 8, 2007 By 1 Comment
… that. MySQL uses a lot of different timeout variables at different stages. For example when connection is just being established connect_timeout is… and leaving server with partial query received. Result set however comes back in multiple pieces and if you’re using mysql_use… I know of. You can’t use something like mysql_ping because connection is in the stage of getting the data. You…
Comment: Finding your MySQL High-Availability solution – The questions
October 17, 2009 By 36 Comments
…types of failures: * mysql becomes unavailable (best case) * mysql connection are unresponsive connection happen very slowly * mysql connection are unresponsive connection hangs indefinitely when … can count on anything failing in the worst case leaving you with huge downtimes and restore times. I …
Post: Percona testing: Quick test clusters with kewpie!
January 13, 2012 By Leave a Comment
….py exiting and leaving servers running… Now for some play: $ mysql -uroot –protocol=tcp –port=9317 test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
… IO alignment, not different MySQL configurations, I didn’t try out different MySQL versions or settings. … 200 port = 3306 back_log = 50 max_connections = 2500 max_connect_errors = 10 table_cache = 2048 max_allowed_…If you have some numbers to share, please leave a comment. Next, I plan to look…
