Thread: Can MySQL handle very high traffic?

It depends upon the type of queries, server hardware and available RAM, and mysql optimization.

I use mysql on dedicated servers with over 2k concurrent connections. The server specs need to be pretty good to handle that kind of connections.

mysql is very powerful and with proper setup can handle a great deal of traffic.

remember a few things.
Its best to make a table long then it is wide.

Example you have a database named DB1

in DB1 you have 2 tables
1st is users
2nd is ip_tracking

in users you have
id, user, pass, email

in ip_tracking you have
id, userid, ip

stead of 1 table having
id, user, pass, email, ip

stead of making a table with multiple sections
id, user, pass, email, ip, status, medal1, medal2, medal3, medal4, medal5, medal6

You see how much wider that is and all data takes longer to load as there is more and more information.
Break it up into separate tables, and make the list not as wide and associate the data by key id number or associating each table somehow.


Next make sure you have proper indexs setup for each table. Key items that will be used for identifying how you will pull information.

TJ