Phymyadmin Import slowly
in my vps phpmyadmin database import takes too much time like 9 or 10 minutes to import 7 MB Data. i checked all the settings of php.ini upload limit and tweak settings also. Not found any issues. but still import SQL file through phpmyadmin is a slowly process. please help me to fix it.
-
Hey there! When there is an issue with the database I always like to check this command on the system:
mysqladmin proc status
to see if there is any obvious slowness with MySQL itself. Do you see anything odd there, such as too many opens or slowness? A basic "top" would also show if there is any I/O wait on the system that could be contributing to slowness on the machine.
0 -
mysqladmin proc status
+------+-----------------+-----------+----+---------+--------+------------------------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+-----------------+-----------+----+---------+--------+------------------------+------------------+
| 5 | event_scheduler | localhost | | Daemon | 161078 | Waiting on empty queue | |
| 4547 | root | localhost | | Query | 0 | init | show processlist |
+------+-----------------+-----------+----+---------+--------+------------------------+------------------+
Uptime: 161116 Threads: 2 Questions: 328817 Slow queries: 34 Opens: 16323 Flush tables: 3 Open tables: 389 Queries per second avg: 2.0400 -
# mysqladmin proc status
+------+------------------+-----------+--------------------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+------------------+-----------+--------------------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+
| 5 | event_scheduler | localhost | | Daemon | 161287 | Waiting on empty queue | |
| 4601 | cpses_map1jlsyj4 | localhost | martfero_hmtesting | Query | 1 | creating table | -- ----------------------------------------------------------
-- Table structure for table `module |
| 4602 | cpses_map1jlsyj4 | localhost | | Sleep | 31 | | |
| 4606 | root | localhost | | Query | 0 | init | show processlist |
+------+------------------+-----------+--------------------+---------+--------+------------------------+------------------------------------------------------------------------------------------------------+
Uptime: 161325 Threads: 4 Questions: 331316 Slow queries: 34 Opens: 16492 Flush tables: 3 Open tables: 400 Queries per second avg: 2.0530 -
That all looks great, and the server isn't busy at all.
Did "top" show anything odd in the %wait column?
0
Please sign in to leave a comment.
Comments
4 comments