MySQL limitation and capacity

Anon

does any one out there know the capacity of MySQL, even if it's a rough figure.
Also do any of youse know the types of limitation with MySQL????

Anon

I've ran databases >8GB, and 1,000 simultaneous connections... Not sure what type of limitations your looking for, but that's what I've done successfully.

Anon

1000 simultaneous? are you sure? what kind of monster machine was that?

seriously, what do you think how many connections can handle mysql if we have enough ram and cpu power? in your example, how much time [seconds] was needed to finish the request to the database for 1 client?

Anon

It's a dual Intel 800Mhz machine with 1GB of RAM. Queries on a smaller database are running are 1-2 seconds average, about 3-5 seconds heavily loaded.. We are running into some problems around 1,000 connections to the database, but I'm not sure if those are OS related or not yet... Going to dig into it deeper.

matjaz wrote:

1000 simultaneous? are you sure? what kind of monster machine was that?

Anon

Look at the sample config files, there are samples for BIG servers

[deleted]

1000 is just about the limit for MySQL (according to the manual)
If you had on 1GB of RAM just for connections, you'd get about 1MByte per connection. On my low-spec machine mysql already takes 2.5Mbyte per connection.
Subtract the memory that the OS uses, and the cache that MySQL needs to get any sort of speed, and 1GByte total memory leaves precious little memory for the connections. Swap-city here we come. I think 3-5 seconds is a little optimistic, or the queries are fenominally simple.

Databases of 8GByte are also on the very edge of what MySQL can handle.
MySQL is filebased, so the max size of a table is the max filesize of your filesystem.

The mysql manual is full of info about the limits of MySQL.

PS: some limits are more important than others. For example, the lack of referencial integrity can be a showstopper before you even begin.