Le sam 29/05/2004 à 15:28, Ryan Fox a écrit :
It depends on the table type, but I'll gear my answers toward myisam.
MySQL uses the os's filesystem calls to list directories. Slowdowns /
limits to the number of myisam databases will be caused by the
filesystem.
- how many databases can a MySQL server 3.23 (let's say on a good
pentium 3, 512MB RAM) handle? or where to find such info...
Depends on the platform/file system.
Unix RedHat (don't know version)
- how wrong is creating 20 databases (total 400 tables) when you know
you could create just one (total around 200 tables)?
For linux ext2, I'd rather have 20db 20table than 1db 200 table.
Neither approach practical limits tho.
Well... hopefully it doesn't.
- what does MySQL handle better? Databases or tables?
Depends on filesystem/table type. For myisam, databases. Each
database creates 1 directory entry, each table creates 3 file entries.
Ext2 / MyIsam, so I guess that makes 2800 directories with 60 files each
or something similar
- could a slowdown problem causing me to have a "show databases" query
answered in 42.50 seconds (more often being 0.02 sec) be bound to too
many databases?
That's it. :)
Ryan Fox
Thanks
4 messages in com.mysql.lists.mysqlRe: Lots of databases...how wrong is it?