Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By r00tk1ll on
Recently my installation of Drupal which has been running perfect started going very slow, I takes about 2 minutes to render 1 page most of the time. Also some of the time it just goes to a white screen and spits out this error:
"
Warning: MySQL server has gone away query: SELECT * FROM system WHERE type = 'theme' in /html/includes/database.mysql.inc on line 172
Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', 'Lost connection to MySQL server during query\nquery: SELECT data, created, headers, expire FROM cache_menu WHERE cid = '1:en' in /html/includes/database.mysql.inc on line 172.', 2, '', 'http://www.mysite.com/admin', 'http://www.mysite.com/node/3/edit', 'server-ip', 1234567891) in /html/includes/database.mysql.inc on line 172
"
There are about 20 line saying this...
Now I didn't have caching enabled to start or css aggregation, tried to enable them both and no improvement. Also, I looked in my database and I had a huge watchdog file (50MB), It was full of watchdog errors related to my coding modifications to ubercart. I deleted all of them and then used phpmyadmin to repair & optimize the database, still no improvement.
I am on a hosted server (goDaddy) who told me there were no connection or speed issues between the web server and the database server. I then completely deleted the database, recreated it, and imported my old sql backup into it. Still the same issue, going super slow and sometimes getting this error. I am not behind any firewall and from what I can tell all the communication is between the 2 godaddy servers.
If anyone has any idea what could be going on please let me know, because I cant even work in this environment.
Thanks,
r00tk1ll
Comments
=-=
use the devel.module to help you debug what is going on.
how many modules ?
how many querries ?
so on so forth.
There are quite a few handbook pages and forum threads about fine tuning your MySQL server for Drupal, though being on a shared host your options are very limited.
Ok got it installed and
Ok got it installed and whats funny is when I initially opened up my site admin it worked fine, then a couple of seconds later it just started going slow again. I will play with the devel module and let you know if I find anything, I will post back later.
I get it every so often too.
I get it every so often too. It times out and errors. The admin loads slower than teh rest. So about every 5 or 6th time it goes to timeout. Cant find databse.
It hasnt done it to me except the admin area.
=-=
The admin area of Drupal uses 1000 or more querries therefore timing out there makes sense on a crowded database server.