Major back-end performance issue

  • Resolved Zade

    (@nothin7)


    5 months, 2 weeks ago

    Hello,

    All in One SEO v4.8.9 runs the following database query on every wp-admin page load:

    ALTER TABLE wp_actionscheduler_actions CHANGE COLUMN priority priority tinyint unsigned NOT NULL default '10'

    The caller is:

    ActionScheduler_Abstract_Schema->update_table()

    Running ALTER locks an entire table, even with InnoDB, which means other processes might have to wait. This slowness is exceptionally pronounced on sites where wp_actionscheduler_actions has grown to 10 GB or more (which is not uncommon). Using Query Monitor it’s easy to see that this one query takes far more time than any other query from any other plugin.

    Why does All in One SEO continue to try to change the data type of the priority column after it’s already been updated to tinyint unsigned? Can this be optimized so customers are able to use your plugin without slowing down their admin workflow?

    Thanks!

    The page I need help with: [log in to see the link]

Viewing 10 replies - 1 through 10 (of 10 total)
  • wpopt

    (@wpopt)

    5 months, 2 weeks ago

    Glad we’re not the only ones. Had a huge number of queued database queries on a site we manage following an update to this plugin, all ALTERs as OP mentioned, triggered by AIO SEO. Have reverted to the previous plugin version for now.

    Plugin Support MM Aurangajeb

    (@aurangajeb)

    5 months, 2 weeks ago

    Hi @nothin7 , @wpopt ,

    Thank you for reaching out and for sharing such detailed information about the performance issue you’re encountering. I completely understand how frustrating a slow admin dashboard can be and the impact it has on your workflow. Please accept our sincerest apologies for the inconvenience this has caused.

    We’re already actively investigating a database performance-related issue, particularly for our MariaDB users, and our Development team is working diligently to resolve this. I’ll be sure to provide you with an update as soon as we have more information.

    To help us narrow down the issue, could you please confirm if your site uses MariaDB? You can usually find this information under Tools > Site Health > Database section: https://a.supportally.com/i/tYSdEU

    Alternatively, you can contact us directly using our Basic Question form here (https://aioseo.com/contact) with your System Status Information, which you can download from the AIOSEO > Tools > System Status tab: https://a.supportally.com/i/wePhXg.

    Regardless of your database type, please be assured that we have an internal discussion open related to database performance, and I’ll keep you updated on our progress.

    Thank you for your patience as we work to resolve this for you.

    Thread Starter Zade

    (@nothin7)

    5 months, 2 weeks ago

    Yes, the site uses MariaDB.

    Plugin Support MM Aurangajeb

    (@aurangajeb)

    5 months, 2 weeks ago

    Thanks for the prompt response and information, @nothin7 !

    We’re actively investigating the MariaDB database performance issue and will provide an update as soon as more information is available.

    Thank you for your patience as we work to resolve this for you.

    wpopt

    (@wpopt)

    5 months, 2 weeks ago

    Also MariaDB here 🙂

    Torsten Landsiedel

    (@zodiac1978)

    5 months, 1 week ago

    I’m here to confirm the problem, my hoster is complaining to my client that it crashes the server, because of the plugin (since a week, which seems to be the 4.8.9 version). But against the claim above reverting 4.8.8 is not solving this issue.

    My client is also on MariaDB.

    Is there any way to stop this behavior? I can only work for some minutes in the backend until the server is crashing.

    Plugin Support MM Aurangajeb

    (@aurangajeb)

    5 months, 1 week ago

    Hi @nothin7 , @zodiac1978 , @wpopt

    I wanted to reach out and provide an update regarding the issue you encountered earlier.

    Our dedicated Development team has been actively working on finding a permanent solution for this issue.

    We’re currently collecting user feedback to ensure that the fix we’ve developed is effective, so I wanted to reach out to see if you’d be willing to test a beta version of All in One SEO for us.

    To access the beta version, please use the following link:

    https://a.supportally.com/f/eWl3UB

    We highly recommend taking a full backup of your site and database before installing the beta version.

    Here are the steps to install and test the beta version on your site:

    1. Download the ZIP file from the link above.
    2. Go to Plugins > Add New.
    3. Upload the beta version ZIP file downloaded in step 1.
    4. Click on Install Now.
    5. Click on Replace current with uploaded.
    6. Check if you’re still able to reproduce the issue when the beta version is activated.

    If you encounter any difficulties or have any questions during the testing process, please do not hesitate to reach out to us. We are here to assist you every step of the way.

    Tooni

    (@tooni)

    5 months ago

    Hi @nothin7 , @zodiac1978 , @wpopt,
    did someone of you test the above mentioned beta version? Can you tell something about the results?
    I do not intend to install the beta version, instead I’m waiting for the release of version 4.9.0.
    However I have some doubts if this will really solve the problems and therefore it would be nice to get a feeling about the behaviour of the beta version.
    Thank you and regards, Tooni

    Plugin Author arnaudbroes

    (@arnaudbroes)

    5 months ago

    Marking this as resolved for now since the update has gone out. Feel free to reopen this thread if the issue still persists.

    Thread Starter Zade

    (@nothin7)

    4 months, 3 weeks ago

    Thanks @aurangajeb ! I no longer see ALTER queries in wp-admin.

    Yes, @tooni , this appears to be resolved in version 4.9.0.

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

You must be logged in to reply to this topic.