I'm really not sure if this is a server load issue or if the add_post api query is just that un-optimized but I am running into a lot of problems with all of our blogs (125+ WP blogs of varying amounts of traffic, spread across three servers in a cluster with a separate db server) and it's sort of driving me nuts. We're running into a LOT of these kinds of errors (virtually anytime a post is published/edited)
INSERT INTO wp2_postmeta (post_id,meta_key,meta_value) VALUES ('1349','_pingme','1')
Is there a recommendation anyone can give me before I take this to the hackers list? I admit, I'm not as tuned into these kinds of discussions as I once was so if the conversation has come up, here or on the mailing lists, please feel free to provide a link.
PS: For what it's worth, the database has been optimized and we have high concurrent connections but way below what we should. Also, the mysql cache appears to be working fine. My guess is the WP API function needs work but open to advice.