Hi,
We are importing a 600MB database into My SQL version 5.0.77 on Red Hat 5.5.
It's taking 11 hours to import this data.
We tried it with My SQL 5.1 as well with the same results.
The OS is sitting on a blade server with 12GM RAM + 8GB Swap and 2.83MHZ Dual Core Proc.
I am a UNIX Admin, but our DBA's aren't able to shed any light on this.
We tried on Ubuntu 10.04 running on a desktop and it took 163 minutes to complete! This was using My SQL 5.1.
The rpm's look like this;
mysql-5.0.77-4.el5_4.2
php-mysql-5.2.6-1.el5.remi
mysql-server-5.0.77-4.el5_4.2
So, why is it taking so long to complete?
Cheers,