398 reputation
110
bio website
location
age
visits member for 2 years, 8 months
seen 5 hours ago

Jul
2
awarded  Curious
Apr
22
comment Why does dbDelta() not catch MysqlErrors?
Either way, sounds like a patch might be in order! :P
Apr
21
comment Why does dbDelta() not catch MysqlErrors?
Thanks for your answer! Unfortunately, the issue isn't related to errors showing or not showing. Rather, the issue is that Wordpress is not catching the related database error (regardless of whether or not it is displayed to the end user). Put succinctly, Wordpress is generating errors that appear in our error log that are not really true errors. They are (I assume), side-effects of a correctly functioning dbDelta() function. This causes our reporting systems to inaccurately conclude that there are issues with our production environment, since it is consistently generating errors.
Apr
21
asked Why does dbDelta() not catch MysqlErrors?
Apr
17
comment Detecting errors generated by $wpdb->get_results()
I suppose I could always do something nasty with intercepting the output buffer... :/
Apr
17
answered Detecting errors generated by $wpdb->get_results()
Apr
17
asked Detecting errors generated by $wpdb->get_results()
Mar
14
comment Why are simple updates to wp_postmeta's “_edit_lock” so slow?
(aka, perhaps, like you suggest, throwing more resources at the issue IS the source of the problem itself...)
Mar
14
comment Why are simple updates to wp_postmeta's “_edit_lock” so slow?
Hmm... Could be. That bug is a duplicate of bugs.mysql.com/bug.php?id=21074, which appears to be closed and included in version 5.1.23. We are running 5.1.73. :/ Regardless, it's still worth a shot - I suppose I can experiment with different cache/buffer sizes to see if there is an apparent connection. Either way, this issue certainly isn't grinding our system to a halt; it's more of a yellow flag. Perhaps the fact that this is coming up is due to our overabundance of resources and eagerness with slow query hunting and elimination... ? Still, something odd is definitely going on.
Mar
13
comment Why are simple updates to wp_postmeta's “_edit_lock” so slow?
It appears that we're still getting slow queries of this type... The strangest thing is that our server overall is relatively idle. We're on an 8-CPU VPS with a current load of 0.27 0.51 0.66 and a consistent InnoDB cache hit rate of 100%. I think most of us would agree that this is likely not an issue with the actual SQL generated by Wordpress, but rather, the underlying architecture and how it translates to the database (MySQL). There seems to be something strange going on here that is deeper than just SQL query optimization and such...
Mar
13
comment Why are simple updates to wp_postmeta's “_edit_lock” so slow?
@fischi: That query seems to take from 45-50ms, at least in the testing I just did a few moments ago. However, it's possible that it would occasionally take a very long time (e.g. up to 84 seconds, as shown in the mysqlsla output included in the question). I'll run a new round of slow query analysis to see if any of my recent changes to our configuration have affected the queries.
Feb
24
comment Why are simple updates to wp_postmeta's “_edit_lock” so slow?
Thanks for your question, adrian7! There are 33k rows matching your query. I'm not familiar with WP's usage of the '_edit_lock' meta key. Is this abnormal?
Feb
21
asked Why are simple updates to wp_postmeta's “_edit_lock” so slow?
Feb
12
comment Is there a more efficient admin search function/plugin?
Thanks for your input, @SeamusLeahy! Do these search applications (and their related plugins) work for the admin area? I'm mainly concerned with speeding up the admin area's search functionality.
Feb
12
asked Is there a more efficient admin search function/plugin?
Feb
7
answered quicktags “link” button doesn't work, but all other buttons do
Feb
7
comment quicktags “link” button doesn't work, but all other buttons do
Hi, Andrew! Did you ever figure this out? I'm having the exact same problem?
Jan
23
answered Why are double-periods (“..”) invalid in a Wordpress image filename?
Jan
23
awarded  Commentator
Jan
23
comment Why are double-periods (“..”) invalid in a Wordpress image filename?
The question still remains, though - Why does Wordpress allow us to upload files with filenames of this format if it will refuse to serve them up later? Perhaps it's simply a defect?