On Thu, 29 Jul 2010 12:46:12 -0500, Dan McGee <[email protected]> wrote: > Well MyISAM is shit if you care about data integrity or foreign keys > or constraints, so yes it is slower on InnoDB but it shouldn't be 100x > slower.
It's now about 120 times slower... ;-) But I guess it's not innodb's fault anyway. I don't see any high cpu load and we have enough ram. So i/o seems to slow. Maybe due to xen? > Without knowing how you're doing this I can't be of much help and I > can't get to a real machine until later tonight. I just did a mysqldump and I am now running "mysql fluxbb < fluxbb.sql". So nothing special. The dump is about 850 MByte. -- Pierre Schmitz, https://users.archlinux.de/~pierre
