Discovered some things tonight.
- When you upgrade a local MySQL database on a system with PHP 5, you have to recompile PHP or else you get some sort of weird libmysqlclient error
- ‘url’ is a reserved word in PHP 5 using the MySQL 4.1.x MySQL clients
- Running two InnoDB Databases on the same machine == bad.
My Apache log database is now running on the Web server itself, while the GrabPERF Database is on a stand-alone machine. That should prevent some of the locking problems that I was seeing at log insertion time.
Oh, and my log flushing script was not being run. I was calling the wrong filename in the crontab. <DOH!>