Why is connecting to MySQL server so slow?

by

Well it could be a DNS problem. You can disable DNS host name lookups by starting mysqld with the --skip-name-resolve option in the configuration file.

Read here for more details: http://dev.mysql.com/doc/refman/5.0/en/host-cache.html

More Related Contents:

  1. MyISAM versus InnoDB [closed]
  2. How can i optimize MySQL’s ORDER BY RAND() function?
  3. MYSQL OR vs IN performance
  4. Why does MYSQL higher LIMIT offset slow the query down?
  5. How to Perform an UPSERT so that I can use both new and old values in update part
  6. Is there a REAL performance difference between INT and VARCHAR primary keys?
  7. MySQL: Fastest way to count number of rows
  8. Why is MySQL InnoDB insert so slow?
  9. MySQL vs MongoDB 1000 reads
  10. MySQL stored procedures use them or not to use them
  11. UUID performance in MySQL?
  12. MySQL “IN” operator performance on (large?) number of values
  13. How can I speed up a MySQL query with a large offset in the LIMIT clause?
  14. Optimal MySQL settings for queries that deliver large amounts of data?
  15. What is better in MYSQL count(*) or count(1)?
  16. DOs and DONTs for Indexes [closed]
  17. MySql views performance [closed]
  18. MySQL performance: multiple tables vs. index on single table and partitions
  19. MySQL view performance
  20. “SELECT COUNT(*)” is slow, even with where clause
  21. Higher cardinality column first in an index when involving a range?
  22. Does Order of Fields of Multi-Column Index in MySQL Matter
  23. MySQL load data infile – acceleration?
  24. sql group by versus distinct
  25. is php sort better than mysql “order by”?
  26. How can “set timestamp” be a slow query?
  27. Would it help to add index to BIGINT column in MySQL?
  28. ALTER TABLE ADD COLUMN takes a long time
  29. Mysql performance on 6 million row table
  30. Composite Primary Key performance drawback in MySQL

Leave a Comment