----- Original Message ----- > From: "Reindl Harald" <h.rei...@thelounge.net> > > 95% of mysqld-installations have no problem with > innodb_file_per_table so DEFAULTS should not be for 5%
There is "no problem", and there is "better practice" - and if your system is I/O bound it makes sense to minimize on-disk fragmentation. However, given the need for file-per-table to benefit from compression, I admit that it might make sense to change the default now. Would you say compression should be enabled by default, too? If you're aiming at diskbound systems, I'd think that it might make sense, too. > it is a surprising behavior and defaults should minimize surprises Changing the default is a surprise, no? :-) Also, everything is a surprise if you don't read the fine manual. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql