Newest Industry

Evolving the Online Performance Experience

MySQL and PHP 5 woes

leave a comment »

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

Written by Stephen

January 2 2005 at 22:06

Posted in Uncategorized

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 274 other followers