Error during test – skipping failed benchmark…

Hello,
It feels, that your hosting has some limitations for number of MySQL requests.
– I will take a look – and make a link to results in next version.
meanwhile you can try free wordpress account on my server.

Thanks Anton.

After submitting this, I took a look at my stats and it looked like I was hitting the max number of processes allowed by my hosting (TMD). I would run it again to check for you if I was hitting a SQL limit as well, but unfortunately the testing eventually ended up crashing the site (because of the process limit) so I am very reticent to try again!

Any ideas on what could be done to get those tests to work? Or a way to run the tests but skip the database test portion?

Any updates to this? I’m experiencing the same issue when testing a new managed MySQL 8 instance (in comparison to a self-hosted MariaDB 10 instance).

The MariaDB instance has no issues with the benchmark tests, but the MySQL 8 managed instance fails during "Importing large amount of data to database".

Any thoughts @antonaleksandrov?

• This reply was modified 1 year ago by Jonah.

Looking into this a bit more, I can see that the errors occurs when initializing the tables to be used for the data import. AUTO_INCREMENT is managed a little different between MariaDB and MySQL and requires INDEX to be set together with PRIMARY KEY.

I will experiment a bit later to see if the plugin code can be adjusted to support also MySQL 8.

@jonaho did you have any luck getting this to work for you? I’d love to see what your solution was if so!

@evanderkloot, no I didn’t find the time. I decided to go with sysbench and other CLI tools instead. Sorry!

Sorry guys… I forgot about this forum and was missing notifications.. I am quite sure, that I run benchmarks on MySQL8 without issues.. but I will doublecheck syntax for that.