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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
