June 19, 2013

Post: Modeling MySQL Capacity by Measuring Resource Consumptions

…at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /…consumed by the process. Collecting these at regular …can get the value from User Statistics *************************** 1. row *************************** USER:…RECEIVED: 21847267 BYTES_SENT: 336986112 BINLOG_BYTES_WRITTEN: 0 ROWS_…

Comment: Slow Query Log analyzes tools

… query log in my production server, and collected some data. I let it run for 60… Recompile the same version of mysql, with this patch applied (we compile mysql from source ourselves anyway, so …if(s/^\s+([0-9]+) ((Query)|(Quit)|(Connect)|(Statistics)|(Binlog Dump Log))//) { # If we enter this loop, …