very slow loading write and edit admin pages

Have you tried disabling automatic pinging of URLs you type into posts? It’s in Options > Writing.

yes, pingbacks and trackbacks are disabled.

He means the services listed in “Update Services”. Options:Writing.

Delete those and test again.

I have the same problem. I’ve disabled pings and trackbacks nor do I ping any services. I’ve tried removing all my plugins, but that doesn’t seem to have any effect. The front end of my page doesn’t have any problem loading, it’s just the write, edit, and manage functions of the admin area.

I’ve tried the same – and found that optimizing the MySQL database helped a little.

Follow the instuctions here:
https://weblogtoolscollection.com/archives/2005/04/06/optimize-your-database/

Well,
I’ve been at this for several days now. As I wrote yesterday, I’ve optimized the MySQL database, and it helped a little. But it’s still not doing the trick. The WHOLE blog is loading extremely slowly.

I’m running WP2.0… / MySQL 3.23.55 / Mac / Safari / Firefox – but it’s slow on both MS and Mac.

Safari sometimes gives me this error:

Safari can’t open the page “https://sonofagun.dk/blog/”. The error was: “lost network connection” (NSURLErrorDomain:-1005) Please choose Report Bug to Apple from the Safari menu, note the error number, and describe what you did before you saw this message.

1. I’ve disabled both pings and trackbacks
2. I’ve optimized the database
3. I’ve deactivated plugins

– So what’s left to do?

I had the same problem, with the page load taking more than a minute.
I tracked this down to the server attempting to look up hostnames in DNS releated to content aggregation etc. My DNS settings on my server were incorrect. (I had just setup the server.) Fixing DNS solved the problem for me. Make sure that you can resolve hostnames on your server. Regards.

Great. Cheers.

How do I fix DNS? And how do I resolve hostnames?
I’m pretty stupid when it comes to MySQL and PHP.

Anyway, I checked the dns.

This is the result:
https://www.dnsreport.com/tools/dnsreport.ch?domain=sonofagun.dk

My domain is located at an external host (not my own server) – can I do anything to fix the DNS-problems myself?

Pingbacks and trackbacks are disabled…

I have the same problem… and it started apparently spontaneously – no changes were made to WP. (2.0.9)

I’ve read every post on this subject and tried every solution, from checking DNS, killing all “ping” services, disabling plugins, disabling live preview, optimizing MySQL database…

…and my machine STILL locks up whenever I enter the “write” tab of the admin section for several minutes.

i have exactly the same problem. i’m not sure when it started and i did not upgrade everytime a new version came out. i am, however, pretty sure that it began with or after 2.0. i remember that i got a “500 Internal Error” occasionally while posting a new entry, so i updated to the next version of WP and it seemed to be fixed…for now. but after a while i noticed that it took longer and longer to open the “write” page and to edit entries. last summer it took 20 seconds, but these days i have to wait around 1-2 minutes, whichmakes me think that the problem is increasing while the database becomes bigger. just for the record: my DB has about 35MB and consists of roughly 700 entries, which is not *that* huge.

at first i started to blame my host, but then i started playing around with a local webserver (xampp). i did two instllations, one on my laptop and one on my desktop pc:

1) xampp with a new, clean WP 2.1.2. installation.
2) xampp with WP 2.1.2. installation AND my old database.

now guess what. the sql/apache settings are the same on both, and while the new installation works like charm, the one with my old database shows EXACTLY the same symptoms as mentioned above.

i did a bit of research, and this is what i found out: whenever i try to open the “write new entry” page or try to edit an older entry, my HD space decreases by 300-400 MB and the CPU usage goes up by 10-15% (due to the server writing a .temp file – but why?)
in the phpmyadmin panel, the following process appears to be the problem:

Command: Query
Status: Sorting for group
SQL Query:
SELECT meta_key
FROM wp_postmeta
GROUP BY meta_key
ORDER BY meta_id DESC
LIMIT 30

sometimes the text edit window appears, incl. the modules on the right side, but the page still takes another 2-3 minutes to build the upload/trackback/user defined modules.

i’m not an sql expert and i don’t know how i can optimize the database, but i guess that it’s the database itself that is causing the problem, since the symptoms on two different servers are the same, while a new WP installation works perfectly.

if anyone has an idea, please let me know.

[and yes, i tried all the mentioned fixes – plugins, pingbacks etc..]

Hi

I had the same problem. Deleting the services listed in “Update Services” (Options/Writing) just now worked for me.

Thanks

out of curiosity i ran a search on the process mentioned above (group by meta_key etc..).

i found the function in the admin-functions.php and deleted the part referring to the meta fields – now guess what – write/edit pages load as fast as they are supposed to!

however, i get an error (undefined function…) and therefore i can’t edit/write entries, but it appears to be the function that is slowing down the database.

i will take a closer look, but my PHP skills are lousy so i’m not sure exactly which part of the sourcecode to delete in order to deactivate the whole thing…