12

How do I view MySQL slow log?

view full story
linux-howto

http://serverfault.com – # ls error.log mysql-slow.log.1.gz mysql-slow.log.3.gz mysql-slow.log.5.gz mysql-slow.log mysql-slow.log.2.gz mysql-slow.log.4.gz mysql-slow.log.6.gz This is what I see. How do I view them? Why are there so many files anywyay? What if I want to read them all as one file? # ls -lh total 36K -rw-rw---- 1 mysql adm 6.5K 2012-02-12 21:59 error.log -rw-r----- 1 mysql adm 174 2012-02-19 06:25 mysql-slow.log -rw-r----- 1 mysql adm 154 2012-02-18 06:25 mysql-slow.log.1.gz -rw-r----- 1 mysql adm 154 2012-02-17 06:25 mysql-slow.log.2.gz -rw-r----- 1 mysql adm 154 2012-02-16 06:25 mysq (HowTos)