wp_aal_request_cache Waiting for table level lock

  • nicolas75001

    (@nicolas75001)


    6 years, 5 months ago

    Hello,

    My website is oftenly going down because of several “OPTIMIZE TABLE wp_aal_request_cache” tasks in mysql where the state is “Waiting for table level lock ‘ or ‘Waiting for table metadata lock’. I have to kill these processes before the website comes back live.
    I have changed wp_aal_request_cache to innoDB but the issue is still there.

    Any solution?

    Thanks

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author miunosoft

    (@miunosoft)

    6 years, 5 months ago

    Hi,

    I’m not familiar with the error.

    I’d like to know the followings. You can find those by going to Dashboard -> Amazon Auto Links -> Help -> About.

    – MySQL AUTOCOMMIT setting ( About -> Server Information -> [MySQL] -> autocommit )
    – MySQL Strict Mode setting ( About -> Server Information -> [MySQL] -> sql_mode )
    – MySQL interactive_timeout setting ( About -> Server Information -> [MySQL] -> interactive_timeout )
    – MySQL wait_timeout setting ( About -> Server Information -> [MySQL] -> wait_timeout )
    – MySQL Version ( About -> Server Information -> [MySQL] -> Version )
    – PHP Version ( About -> Server Information -> [PHP] -> Version )
    – WordPress Version ( About -> Server Information -> [WordPress] -> Version )
    – WordPress Multi-site ( About -> Server Information -> [WordPress] -> Multi-site )

    Thanks.

    • This reply was modified 6 years, 5 months ago by miunosoft. Reason: Added required information
    Thread Starter nicolas75001

    (@nicolas75001)

    6 years, 5 months ago

    Hi,

    Strangely the Server information field in the about page is totally empty. All other fields have data. why’s that?

    Thanks

    Plugin Author miunosoft

    (@miunosoft)

    6 years, 5 months ago

    I don’t know.

    You can try this plugin Server Information (https://ww.wp.xz.cn/plugins/server-information/).

    If it does not show anything, it could be that your host blocks some PHP functions. Though, you should find the information I asked in some other ways. Some of them can be found via Dashboard -> Tools -> Site Health -> Info.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘wp_aal_request_cache Waiting for table level lock’ is closed to new replies.