On Sat, 29 May 2004, Yannick Warnier wrote: > > > - 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
I had a related problem: ext2 was very slow to list a drectory with 14'000 files. When I switched to ReiserFS it was fine. Recently someone on this list compared the performance of different file systems using MySQL. You may want to check the archives. Thomas Spahni -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
