Search code examples
phpmysqldatabaseperformancedatabase-performance

MYSQL PHP Application performance with single database

I am designing an "high" traffic application which realies mainly on PHP and MySQL database queries.

I am designing the database tables so they can hold 100'000 rows, each page loading queries the db for user data.

I can experience slow performances or database errors when there are say 1000 users connected ?

Asking because i cannot find specification on the real performance limits of mysql databases.

Thanks

Solution

  • If the userdata remains unchanged due loading another page, you could think about storing those information in a session. Also, you should analyze how the read/write ratio in your database/ on specific tables is. MyIsam and InnoDB are very different when it comes to locking. Many connections can slow down your server, try to cache connections.

    Take a look at http://php.net/manual/en/pdo.connections.php