Why are simple updates to wp_postmeta’s “_edit_lock” so slow?

the _edit_lock is generated each time you edit a post or page. it consist the timecode and the user. so WordPress is knowing who is currently editing it.

meta_id     post_id     meta_key    meta_value
9           5           _edit_lock  1388386997:1

if you manipulate it WordPress reacts somehow sensitive …I tried to fetch how many seconds somebody worked on a post. All the time it broke my database loading time.

As you said you running this on a large multisite. Don’t know how many users write posts there, but it definitely could break the RAM of the server if to many people edit a post at the same time.

A solution could be:
get rid of _edit_lock

How to disable the “Post Lock/Edit Lock”?

Normally WordPress should have the “_edit_lock” one per Post. Some databases have the problem generating them every time.

Like this guy
http://wordpress.org/support/topic/can-i-remove-_edit_lock-_edit_last-from-wp_postmeta

His solution was to delete them all.
To speed it up you can delete them all every night at 3 o’clock in phpMyAdmin with

DELETE FROM `yourdb`.`wp_postmeta` WHERE `wp_postmeta`.`meta_key` = '_edit_lock'

might be you find a cron job doing exactly that.

Related Posts:

  1. Inserting Hundreds of Thousands of Posts at Once
  2. Cannot add or update a child row: a foreign key constraint fails
  3. Cannot delete or update a parent row: a foreign key constraint fails
  4. ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
  5. Rename a column in MySQL
  6. Not unique table/alias
  7. Install mysql-python (Windows)
  8. #1055 – Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this is incompatible with sql_mode=only_full_group_by
  9. Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
  10. Select from multiple tables without a join?
  11. Disable ONLY_FULL_GROUP_BY
  12. MySQL WHERE IN ()
  13. SELECT list is not in GROUP BY clause and contains nonaggregated column …. incompatible with sql_mode=only_full_group_by
  14. Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
  15. difference between primary key and unique key
  16. How to export a mysql database using Command Prompt?
  17. mysqld_safe Directory ‘/var/run/mysqld’ for UNIX socket file don’t exists
  18. Order a MySQL table by two columns
  19. MySQL AS keyword
  20. Should I use the datetime or timestamp data type in MySQL?
  21. MySQL Error #1133 – Can’t find any matching row in the user table
  22. How can I prevent SQL injection in PHP?
  23. Best way to store an array in MySQL database?
  24. MySQL date formats – difficulty Inserting a date
  25. How to grant remote access permissions to mysql server for user?
  26. How to check if mysql database exists
  27. #1062 – Duplicate entry for key ‘PRIMARY’
  28. How can I convert a string to a float in mysql?
  29. Is there a Profiler equivalent for MySql?
  30. How to use greater than operator with date?
  31. Drop all databases in MySQL
  32. How to replace the domain name in a WordPress database?
  33. Use REGEXP in WP_Query meta_query key
  34. Mysqldump add drop table?
  35. Lack of composite indexes for meta tables
  36. How to disable `SQL_CALC_FOUND_ROWS` [duplicate]
  37. “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
  38. #1115 – Unknown character set: ‘utf8mb4’
  39. Group posts by meta_key
  40. WordPress Deadlock Error
  41. Triple meta_key on custom SELECT query
  42. How to do a MySQL dump from production site without using a search and replace script for local development?
  43. How to bulk edit canonical url’s in SQL?
  44. Concurrent / simultaneous MySQL connections
  45. How to check for empty and not a failure
  46. How many ‘wp_insert_post’ calls can be performed in one shot, in a very long ‘for’ loop?
  47. Keeping database within limits, please help!
  48. Best settings for MySQL to speed up site? [closed]
  49. HTML Entities in Post Title
  50. Insert post metadata for all posts in CPT at once if metadata no existent
  51. Can’t find my wordpress DB in phpmyadmin
  52. Deprecated: mysql_connect():
  53. Unique Post Meta Values
  54. $wpdb select all meta for each post
  55. Calculate average crossing post categories
  56. Replacing link URL ending strings via MySQL
  57. Many slow queries post_type = ‘attachment’;
  58. SQL command to convert all tags in lowercase?
  59. Problem with admin login after deployment
  60. Find out how many times the user has logged in
  61. Is it possible to create a WordPress table using array and loop?
  62. Can’t run database query
  63. WordPress doesn’t display accents after migration
  64. How to stop $wpdb from prepending database name
  65. Match tag names with form titles
  66. Error missing MySQL extension
  67. Getting Error Trying to Create Table
  68. Best approach for a custom database filling in WP custom post types
  69. Why doesn’t custom mysql query return results? Is syntax correct?
  70. Insert two row in wordpress database
  71. SQL statement using placeholder is not returning results
  72. How to Bulk find and replace MySQL for post image url
  73. Data is not constatntly loading from custom wordpress table
  74. Mysql Server keeps crashing
  75. Wpdb query with dynamic table name
  76. “BS_” rows in postmeta table
  77. How to add virtual column in wpdb get_result statement
  78. Regular XML-RPC timeouts
  79. update multiple rows in mysqli table base on two values
  80. How can I verify WordPress nonce from the following code?
  81. Query postmeta based on meta_value, return array of post_id
  82. How to write in MySQL more characters in user_nicename
  83. $wpdb->get_var not returning count
  84. Custom user query – orderby meta_key (that may not exist)
  85. How to get Attachments(image) with specific width\height ratio
  86. What is the cron doing?
  87. Apache Redirect based on WordPress permissions
  88. SQL error on restoring database
  89. MySQL database gives blank page (white screen of death)
  90. Datatabase error: Commands out of sync
  91. Copy wp_postmeta from one database to another
  92. retrieve wordpress post-meta using php not wordpress functions
  93. optimise SQL wordpress call
  94. why is $wpdb->update() causing a DB error from within wp_set_password()
  95. Global MySQL replacing of text patterns/matches
  96. If meta_key exists then don’t select this post?
  97. Initialization of table in database using ‘CREATE … IF NOT EXISTS’
  98. mysqldump throws: Unknown table ‘COLUMN_STATISTICS’ in information_schema (1109)
  99. How do I load a sql.gz file to my database? (importing)
  100. Batch Replace URLs in WordPress Database

Leave a Comment

techhipbettruvabetnorabahisbahis forumueduseduedusedusedueduedueduedusedu