mysql

We've been having some issues with our hosting. Some of you might have been seeing red error messages instead of content from time to time. This is due to issues at our host, CIHost.

We're on a shared server. Whenever someone else on our server uploads one or more very large files, the /tmp partition fills up. This means that other file uploads will fail, but far more importantly, MySQL will fail doing even the simplest of SELECT statements with an 'error 28'. Unfortunately, this seems to happen quite often. Looking through the logs of the site, I have traced back 4 incidents:

Neo

Is that...

Cypher

The Website? Yeah.

Neo

Do you always look at it encoded?

Cypher

Well you have to. The MySQL databse works for Drupal. But there's way too much information to decode the website. You get used to it. I...I don't even see the code. All I see is blonde, brunette, red-head.

I'm having some fun converting the Drupal user database to and from the IVRPA member database. The IVRPA member database is kept up to date in Filemaker Pro. It's a rather simple affair; a single table with lots of columns (values) and rows (members). The Drupal user database on the other hand is a bit more complex and relational.