MySQL and PHP 5 woes

Discovered some things tonight.

  1. 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
  2. ‘url’ is a reserved word in PHP 5 using the MySQL 4.1.x MySQL clients
  3. 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!>

Leave a Reply

Your email address will not be published. Required fields are marked *