Jump to content

SHOW DATABASES is slow


Err
 Share

Recommended Posts

SHOW databases

The above query is slow on shared MySQL hosts. Is there any way I can use a different method that would be faster in general?

Link to comment
Share on other sites

  • 3 weeks later...
SHOW databases

The above query is slow on shared MySQL hosts. Is there any way I can use a different method that would be faster in general?

if you want to show all the databases present in your mysql-server you need the query "show databases", if in your server the no. of database are large then it wil definitely take time to execute the query.if you want show few databases of your choice you can use LIKE clause..e.g. " show databases like '<search key word>%' " i.e. show databases like '<user>%' , the above query will show all the databases starting with user
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...