29 Jul
2010
29 Jul
'10
6 p.m.
On Thu, 29 Jul 2010 12:46:12 -0500, Dan McGee <dpmcgee@gmail.com> 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