… to instead be sent to a message queue, or Gearman. Or in plain English: The same MySQL servers can achieve much more…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…the amazing MySQL manual, especially the option and variable … delayed_insert_timeoutblogpercona.commanual delayed_queue_sizeblogpercona.commanual Delayed_writesblogpercona.commanual ….commanual lc_messagesblogpercona.commanual lc_messages_dirblogpercona.commanual lc_time_namesblogpercona….
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…lot of the same components. Tagging, friends, queues, click tracking, search, paginated displays — we’…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…going; or just get on an instant messaging chat and tell the customer “here’…
Post: Recovering CREATE TABLE statement from .frm file
December 17, 2008 By 4 Comments
… the following MySQL creative error message: mysql> show tables; +—————-+ | Tables_in_test | +—————-+ | queue | | test_innodb | +—————-+ 2 rows in set (0.00 sec) mysql> show create… anyway. With MyISAM table MySQL comes with another creative error message if .frm is the only file which exists: mysql> show create table…
Post: Announce: Front End Performance Optimization
October 10, 2008 By 8 Comments
… availability as the whole, not just MySQL related issues. Indeed if you look at MySQL driven web site its properties will likely… here besides MySQL though quite typical you also would see external queue, message parsing, search systems etc being important components besides MySQL. MySQL is important…
Comment: Configuring MySQL For High Number of Connections per Second
January 8, 2012 By 17 Comments
… message there should be some error code: [root@localhost ~]# mysql -h 10.1.1.1 ERROR 2003 (HY000): Can’t connect to MySQL… have No route to host error. In case listen socket queue overflow you should be getting different error code instead of…
