…to check for. VARIABLE=${VARIABLE:-Threads_connected} You need to change the threshold to 15, and the variable to…MySQL video/screencast blog site. Another interesting topic is how to examine a system that appears to…
Post: Getting MySQL Core file on Linux
August 26, 2011 By 1 Comment
…as if MySQL crashes accessing the wrong memory area, you will even see some stack trace, probably …. Now as I explained how you can get core files from MySQL I should say they …to connect as “gdb -p `pidof mysqld`” select “continue” and let MySQL run. If it crashes you will have process ready to…
Post: MySQL for Hosting Providers - how do they manage ?
November 28, 2008 By 15 Comments
…how do they manage to keep things up given MySQL gives you so little ways to really restrict how…, order=0, oomkilladj=0 Call Trace: [] out_of_memory+0x8e/0x2f5 [] __alloc_…to happen ? Not really – you do not even need to be able to select from the table. Any user with permission to connect to MySQL…
Post: On Good Instrumentation
May 31, 2010 By 1 Comment
… it took to generate HTML page we want to understand how much time …MySQL Query Log. What is important is however to be able to connect the data from these logs – glue them together. The easy way to…mySQL the simple way to do it is to put it in the comments for queries you execute. Optional Tracing…
Post: MySQL Prepared Statements
August 2, 2006 By 19 Comments
… way to pass list of values to IN Harder tracing. Logs were now fixed to include …connection or multiple connections. Do not forget to close prepared statements – Many memory leaks reported in MySQL Server turned out to… at Com_stmt_execute to Com_stmt_prepare ratio to see how many times each …
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
…CONNECTION IDENTIFIER Each slow log entry now contains a connection identifier, so you can trace all the queries coming from a single connection…the InnoDB usage statistics. MySQL currently allows you to see many per-session statistics…you can see how much time (in seconds) it took InnoDB to actually …
