Overloading MySQL

Hi everyone,

My situation is this:

  1. I have one SWF file
  2. I have a multitude of PHP files
  3. I have one MySQL database
  4. The SWF communicates with the PHP files in order to retrieve data from the database
  5. On various occasions, only one person may access the database, and everyone else receives an error.
  6. When the error occurs, the PHP scripts can still be accessed via the browser window and they still work.

This problem is driving me crazy!

Is this a Flash based problem or something to do with the server? Has anyone else had similar problems involving Flash/PHP/MySQL?

I’d appreciate any help at this point.

Cheers,

Orisis84