Announcement

Collapse
No announcement yet.

Database error in Table cache e.g. when editing phrases Error 1205

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • AScherff
    replied
    i did - wit a huge of other tuning:

    max_allowed_packet = 256M
    max_connections=200
    table_open_cache=256
    max_delayed_threads=20
    max_tmp_tables=32
    query_cache_type=1
    query_cache_size=4M
    thread_cache_size=4
    innodb_use_native_aio=0
    open_files_limit=10000
    innodb_lock_wait_timeout=120

    now it seems gone...

    Leave a comment:


  • Dominic
    replied
    You can increase the value for timeout in your MySQL configuration.

    Leave a comment:


  • AScherff
    replied
    Yes, Status is "OK"

    Leave a comment:


  • Dominic
    replied
    Have you tried optimizing your phrases table?

    Leave a comment:


  • Database error in Table cache e.g. when editing phrases Error 1205

    If i translate phrases and save, some times i get database errors in table "cache" with error No. 1205 "Lock wait timeout exceeded; try restarting transaction".

    Some idea? MySQL Configuration or what?

    Thanks
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X