开发者

Creating database is slow under Mysql

开发者 https://www.devze.com 2023-02-22 21:40 出处:网络
I\'m trying to create database by using: create database test; It seems so simple but when I hit enter, it only waits. No error message, just nothing. There is an another database working for a liv

I'm trying to create database by using:

create database test;

It seems so simple but when I hit enter, it only waits. No error message, just nothing. There is an another database working for a live application, so I can not restart 开发者_如何学Cthe mysql service. Mysql must be alive all the time. Is there anything I can do about this situation? What is the reason?

Output:

root@delta-dbs1:/# mysql -u mysql -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 124011
Server version: 5.1.30-ndb-6.3.20-cluster-gpl MySQL Cluster Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database test_wips;

and nothing comes after it. It only hangs. And response to ping is also good. There is no problem with network, because my applications are getting data beatifully from the other databases which were created before. My problem is, i cant create or drop any database.

Thanks in advance.


Probably the other application is slowing down your server with a query. You need to take a look at the slow query log to check which one.


Please, print console output for

$ mysql -u username --password=HIDDEN_PASSWORD --port=330X --host=HOSTNAME
mysql> create database `test`; 
mysql> 

Maybe your software or network stucks? How do you know that it is exactly MySQL's problem?

You also can try diagnose your network problems using this commands:

$ traceroute HOST
$ ping HOST
0

精彩评论

暂无评论...
验证码 换一张
取 消