Title: Database issues
Last modified: September 27, 2022

---

# Database issues

 *  Resolved [firex20](https://wordpress.org/support/users/firex20/)
 * (@firex20)
 * [3 years, 8 months ago](https://wordpress.org/support/topic/database-issues-24/)
 * Do you have any advise on how to improve the simple query speed and bulk data
   import speed. Currently using MySQL 8.0 I follewed the suggestion you made but
   still getting low speeds.

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

 *  Thread Starter [firex20](https://wordpress.org/support/users/firex20/)
 * (@firex20)
 * [3 years, 8 months ago](https://wordpress.org/support/topic/database-issues-24/#post-16049031)
 * [https://ibb.co/Xsj8jGz](https://ibb.co/Xsj8jGz)
 *  Plugin Author [Anton Aleksandrov](https://wordpress.org/support/users/antonaleksandrov/)
 * (@antonaleksandrov)
 * [3 years, 7 months ago](https://wordpress.org/support/topic/database-issues-24/#post-16082428)
 * Can you please run test and send me URL of the results? Feel free to contact 
   me by email info at wpbenchmark dot io. 😉
 *  Thread Starter [firex20](https://wordpress.org/support/users/firex20/)
 * (@firex20)
 * [3 years, 7 months ago](https://wordpress.org/support/topic/database-issues-24/#post-16084957)
 * Sending you an email
 * [https://report.wpbenchmark.io/nNXyfLV30u/](https://report.wpbenchmark.io/nNXyfLV30u/)
 * Here is the link just in case.
 *  Thread Starter [firex20](https://wordpress.org/support/users/firex20/)
 * (@firex20)
 * [3 years, 7 months ago](https://wordpress.org/support/topic/database-issues-24/#post-16085114)
 * [https://report.wpbenchmark.io/MT2nViKXVS/](https://report.wpbenchmark.io/MT2nViKXVS/)
 * I tried the email address seems to not be working.
 *  Thread Starter [firex20](https://wordpress.org/support/users/firex20/)
 * (@firex20)
 * [3 years, 7 months ago](https://wordpress.org/support/topic/database-issues-24/#post-16092833)
 * Hi Anton,
 * Haven’t heard back from you yet any advise?
 * Kind Regards
 *  Plugin Author [Anton Aleksandrov](https://wordpress.org/support/users/antonaleksandrov/)
 * (@antonaleksandrov)
 * [3 years, 7 months ago](https://wordpress.org/support/topic/database-issues-24/#post-16144467)
 * Here is a solution (posting here, so others can benefit from it).
 * If you are running MySQL8 on slow disks (e.g. SATA) and benchmarks are failing,
   most likely you need to add these configuration options to your MySQL config (/
   etc/my.cnf)
 *     ```
       # default 100M
       innodb_redo_log_capacity=512M
       # default 16M
       innodb_log_buffer_size=512M
       # default 8kb
       innodb_log_write_ahead_size=128K
       # binlog is enabled by default
       disable_log_bin
       ```
   
 * The biggest impact you will feel after adding “disable_log_bin”. Other options
   help a lot.
 * Important: the “innodb_redo_log_capacity” setting is only available from MySQL
   8.0.30
 * As always for performance – suggest setting :
    `innodb_flush_log_at_trx_commit
   = 2`
    -  This reply was modified 3 years, 7 months ago by [Anton Aleksandrov](https://wordpress.org/support/users/antonaleksandrov/).

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

The topic ‘Database issues’ is closed to new replies.

 * ![](https://ps.w.org/wpbenchmark/assets/icon-256x256.gif?rev=2669206)
 * [Hosting Benchmark tool](https://wordpress.org/plugins/wpbenchmark/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wpbenchmark/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wpbenchmark/)
 * [Active Topics](https://wordpress.org/support/plugin/wpbenchmark/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wpbenchmark/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wpbenchmark/reviews/)

 * 6 replies
 * 2 participants
 * Last reply from: [Anton Aleksandrov](https://wordpress.org/support/users/antonaleksandrov/)
 * Last activity: [3 years, 7 months ago](https://wordpress.org/support/topic/database-issues-24/#post-16144467)
 * Status: resolved