…my.cnf to those server is currently running with. The problem however this only works well if settings are set in my.cnf…variables for SESSION variables, yet for some GLOBAL variables…
Post: How Percona diagnoses MySQL server stalls
March 3, 2011 By 6 Comments
… thing to check for. VARIABLE=${VARIABLE:-Threads_connected} You need to change the threshold to 15, and the variable to Threads_running. Check… the script can log into MySQL (if necessary, put a password into .my.cnf, or in the MYSQLOPTIONS variable). Now you can simply start running bin/stalk in a screen session. It shouldn…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 116 Comments
… all of these are global variables. These variables depend on hardware and mix of storage engines, while per session variables are typically workload specific… leave per session variable tuning to second step after I can analyze workload. P.S Note MySQL distribution contains bunch of sample my.cnf files…
Post: How is join_buffer_size allocated?
July 5, 2010 By 9 Comments
…MySQL configuration, we quite often want … about join_buffer_size? I saw a my.cnf with a 128M join_buffer_size the…size=max(thd->variables.join_buff_size, cache->length); 14272 if (!(cache->buff=(uchar*) my_malloc(size…run the server out of memory: set session join_buffer_size = 1 << 30; # 1GB select *…
