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

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • AScherff
    Senior Member
    • Jun 2008
    • 141
    • 5.7.0

    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
  • captainslater
    Senior Member
    • Jun 2006
    • 1716

    #2
    Have you tried optimizing your phrases table?
    To infinity and beyond!
    Deutschsprachige vBulletin News & Tipps
    captainslater
    - Eine vBulletin Cloud-Site

    Comment

    • AScherff
      Senior Member
      • Jun 2008
      • 141
      • 5.7.0

      #3
      Yes, Status is "OK"

      Comment

      • captainslater
        Senior Member
        • Jun 2006
        • 1716

        #4
        You can increase the value for timeout in your MySQL configuration.
        To infinity and beyond!
        Deutschsprachige vBulletin News & Tipps
        captainslater
        - Eine vBulletin Cloud-Site

        Comment

        • AScherff
          Senior Member
          • Jun 2008
          • 141
          • 5.7.0

          #5
          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...

          Comment

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