[Van Jr]

Found the problem.

One of the email addresses in the Send alert mails to field ha two @ signs. The mail address was formated incorrectly like so: username@@somedomian.com

[Van Jr]

I found why:

See: http://dev.mysql.com/doc/refman/5.5/en/log-destinations.html

MySQL wrote:

By default, the log tables use the CSV storage engine that writes data in comma-separated values format. For users who have access to the .CSV files that contain log table data, the files are easy to import into other programs such as spreadsheets that can process CSV input.

The log tables can be altered to use the MyISAM storage engine. You cannot use ALTER TABLE to alter a log table that is in use. The log must be disabled first. No engines other than CSV or MyISAM are legal for the log tables.

To disable logging so that you can alter (or drop) a log table, you can use the following strategy. The example uses the general query log; the procedure for the slow query log is similar but uses the slow_log table and slow_query_log system variable.

There are NO indexes on the log tables. So, I altered mysql.slow_log to be MyISAM and created index START_TIME_IDX on START_TIME.

That helped some.

[Author]

Posts