… happens in the foreground to instead be sent to a message queue, or Gearman. Or in plain English: The same MySQL…
Post: Recovering CREATE TABLE statement from .frm file
December 17, 2008 By 4 Comments
… will see the following MySQL creative error message: mysql> show tables; +—————-+ | Tables_in_test | +—————-+ | queue | | test_innodb | +—————-+ 2 rows in set (0… much rather see MySQL to report some more reasonable error message, something like Storage Engine could not open table or something…
Comment: Configuring MySQL For High Number of Connections per Second
January 8, 2012 By 17 Comments
…. The main negative with long queue is the request can spend long time in the queue and at certain point it just… with very high queue times. It is also a good practice to measure connection times. BTW what error message did you get…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…threadsblogpercona.commanual delayed_insert_timeoutblogpercona.commanual delayed_queue_sizeblogpercona.commanual Delayed_writesblogpercona.commanual des_…query_costblogpercona.commanual lc_messagesblogpercona.commanual lc_messages_dirblogpercona.commanual lc_time_namesblogpercona.commanual …
Comment: Configuring MySQL For High Number of Connections per Second
January 8, 2012 By 17 Comments
…, Yes, most likely. When you have Can’t connect error message there should be some error code: [root@localhost ~]# mysql -h… have No route to host error. In case listen socket queue overflow you should be getting different error code instead of…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… applications have a lot of the same components. Tagging, friends, queues, click tracking, search, paginated displays — we’ve seen these and… direction I’m going; or just get on an instant messaging chat and tell the customer “here’s the top thing…
Post: Announce: Front End Performance Optimization
October 10, 2008 By 8 Comments
… besides MySQL though quite typical you also would see external queue, message parsing, search systems etc being important components besides MySQL. MySQL…
