Posted on in System Administration
I use Pingdom's free service to monitor slaptijack.com. Apparently,
late Friday night, oom-killer decided that the server needed more memory and
took out the MySQL server. To make matters worse, I missed the alarm from Pingdom,
and slaptijack.com was down for pretty much all of Saturday. The fact …
Posted on in System Administration
Naturally, I ran into this problem in the middle of the night when the client was asleep and I had no access to the Magento administrative interface. The short story is that after running a re-index of the site, the home page began returning a 404 error status. A bit …
Posted on in System Administration
I have a fairly lightly loaded MySQL server with a few tables that are updated every five minutes. Other than these updates, there are very few queries run against the database. The data is queried just a few times per month. Ever so often, one of the more complicated queries …
Posted on in System Administration
Posted on in System Administration
I use snmptrapd to catch SNMP traps and then put them into a MySQL database using a pretty generic trap handler. This gives me the opportunity to generate such useful information as:
> SELECT HOUR(time) AS "hour", COUNT(*) AS "bounces" FROM snmptraps
WHERE hostname = 'XXX' AND time > '2011-07-25'
AND trap_oid …Posted on in Software
In a small environment, there's very little reason to rely on DNS resolution inside MySQL. You can disable it by adding skip-name-resolve to your my.cnf or by using the --skip-name-resolve command line argument.
Remember that if you disable DNS lookups, you will need to set permissions using IP addresses …
Posted on in Programming
This will just be a short reminder. If you're planning to create multiple-column indexes in MySQL, remember that the order of the columns matters. As the MySQL documentation points out, any "leftmost prefix of the index can be used." This means that the index can be used for any number …
Posted on in System Administration
If you're using a non-standard MySQL data directory on your Red Hat Enterprise Linux (RHEL) server, you may have seen an error like /usr/libexec/mysqld: Can't change dir to '/mysql_data/' (Errcode: 13). The key to fixing this problem is to ensure the new MySQL data directory has the proper …
Posted on in Software
In a test lab, we ran into a situation where the connection between our Cisco Access Registrar (AAA) server and MySQL server was timing out. This forced the server to reconnect and resulted in the following errors:
name/radius/1 Error Server 0 ODBC client (DataSource 'my_odbc', Connection 8): SQLExecute …Posted on in System Administration
We ran across the following error on a MySQL slave server recent:
mysql> SHOW SLAVE STATUS \G
<snip>
Last_Error: Query caused different errors on master and slave. Error on master: 'Deadlock found when trying to get lock; try restarting transaction' (1213), Error on slave: 'no error' (0). Default database: '<database_name …
