Archive for 'MySQL'

Using MySQL query logs to debug authentication issues

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 […]

Enabling MySQL query logging

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 […]

Using the rsyslog MySQL plug-in to send syslog data to a SQL database

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 […]

Display the default values of MySQL my.cnf settings

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 […]

Getting MySQL running on a CentOS Linux server

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 […]

Awesome MySQL performance blog

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!

« Older Entries