I recently installed LogAnalyzer, and after the install completed I noticed that nothing was being displayed in the web interface. I figured I fat fingered something, but needed a way to verify this. Luckily for me I was using MySQL, so I enabled MySQL query logging and low and behold I proved my hypothesis: 120212 […]
Archive for 'MySQL'
I recently installed the LogAnalyzer graphical syslog analysis tool. After the install completed I went to the “Show Events” page and noticed that no data was being displayed. I wanted to see which queries were being sent by LogAnalyzer to my MySQL database instance, so I enabled query logging by adding the following two statements […]
I have been experimenting with ways to better manage the logs my servers generate. Depending on who you ask, folks will recommend sending your logs to a remote syslog server that writes the logs to disk, some may recommend sending it to a log analysis tool similar to splunk, and others would recommend feeding it […]
MySQL is configured through the my.cnf configuration file, which typically resides in /etc. There are dozens of configuration settings that can be added to this file, and you can view the full list by running mysqld with the “–help” and “–verbose” options: $ /usr/libexec/mysqld –help –verbose | grep -i ^relay relay-log slave-relay-bin.index relay-log-index slave-relay-bin relay-log-info-file […]
I started playing with MySQL back in the 4.X days, but never invested a lot of my time since my day job required me to support Oracle databases. I’m trying to branch out more now, and recently picked up a copy of MySQL, MySQL High Availability and PHP And MySQL. There are a slew of […]
I came across Neelakanth Nadgir’s blog while doing some research, and his performance analysis tools (cmdtruss and inniostat) are pretty sweet. If you are looking to learn more about MySQL performance, you should take a look at High Performance MySQL and the Sun engineering blogs. There is some awesome stuff out there!