mysql

Slime101 · 8 Jun 2006 at 22:12

Can mysql handle multiple queries running on a multi-table 50,000 record database or will it all fall over due to the ammount of records?

Noxis · 8 Jun 2006 at 22:31

Slime101 said:
Can mysql handle multiple queries running on a multi-table 50,000 record database or will it all fall over due to the ammount of records?

It can handle it just fine.... depending on the hardware you slap it on of course. Mysql database are much much much bigger than that in the big corp world. Should see some of ours

Would be much easier to admin them if it wasnt for them pesky users :mad:

Beansprout · 8 Jun 2006 at 22:39

50,000 is peanuts but it depends on the number of users, too

Noxis · 8 Jun 2006 at 22:41

Beansprout said:
50,000 is peanuts but it depends on the number of users, too

Indexing 4tw.

Beansprout · 8 Jun 2006 at 22:43

Noxis said:
Indexing 4tw.

memcached for the ultimate win

Slime101 · 8 Jun 2006 at 22:59

50,000 records, 50,000 potential users, but not all at the same time- pobably no more than several hundred at a time.

I realise 50K is amll in DB terms, but big corps use MSSQL and alternatives usually over than mysql...or so i thought.

Beansprout · 8 Jun 2006 at 23:02

That's a couple of orders of magnitude off big corp stuff, though

MySQL is a very competent database. It's not what corporate stuff with complex requirements would run on - for that you have MSSQL, Oracle etc, since MySQL lacks lots of features of ""proper"" databases (well, v5 has taken some big steps from what I've read) - but for the majority of uses it's a very competent tool

Adz · 9 Jun 2006 at 00:16

Agreed. 50,000 records is nothing. I personally ran a 1,000,000 record table on a Dual Xeon 2.8 and I believe Berserker runs something even larger on lower spec hardware.

Obviously if you're receiving masses of traffic and the database is poorly designed, performance will be poor but with a decent structure, decent hardware and well designed code, it should be a breeze

.

Craig321 · 9 Jun 2006 at 02:06

Slime101 said:
Can mysql handle multiple queries running on a multi-table 50,000 record database or will it all fall over due to the ammount of records?

http://game-monitor.com/

Check out the number of database entries on that, and I'm sure other people have even more.

92,000 not that many, but almost double 50,000 and it's handling perfectly

Noxis · 9 Jun 2006 at 08:53

Slime101 said:
50,000 records, 50,000 potential users, but not all at the same time- pobably no more than several hundred at a time.

I realise 50K is amll in DB terms, but big corps use MSSQL and alternatives usually over than mysql...or so i thought.

I think some of the biggest around use MySQL, I know that places such as lastminute.com where they have to store all those flight details do.