```json
{
    "title": "MySQL and PHP 5 woes",
    "url": "https://performancezen.com/2005/01/02/mysql-and-php-5-woes/",
    "datePublished": "2005-01-02",
    "dateModified": "2005-01-02",
    "language": "en-US",
    "description": "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…",
    "author": "spierzchala",
    "publisher": "Performance Zen"
}
```

# MySQL and PHP 5 woes

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!>