Jump to content

SHOW DATABASES is slow


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 post
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 post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...