WooCommerce with thousands of products – site is very slow – optimize db queries? [closed]

This is really a server question and not particularly WordPress.

You’re running into a MySQL server speed bottleneck at 1and1. Sorry, but they’re well known as a slow shared host, and for that reason I doubt their VPSs are any better.

Caching and a CDN will only do so much for you. You need more horsepowwer in the form of a better and faster MySQL server, and if you’re already paying for a VPS, move to a better VPS host, like Media Temple.

Once there, with root access, you can use a utility such as http://mysqltuner.com to log and analyze the performance of the MySQL server and adjust server memory and database query cache parameters in the configuration file my.cnf. You will also be able to adjust apache – in httpd.conf – to handle high loads.

There is little sense in trying to optimize the database queries made by Woo Commerce or WordPress; any changes made will need to be made again after updates.

Related Posts:

  1. WordPress database scalability from the code perspective
  2. WordPress for a very large website
  3. How to solve slow WordPress site caused by attachment_metadata
  4. Changing BIGINT to INT
  5. Database slowdown after update to 3.4.1
  6. Which is more efficient? Using usermeta, or creating a new MySQL table?
  7. Improve performance by removing unnecessary database queries
  8. How to prevent/delay MySQL connections when an object cache is used?
  9. Mysql Queries per Visit – Crazy High
  10. Slow queries constantly getting stuck on WordPress database of ~100,000 posts
  11. How can I perform high-level database merging for WordPress within continues delivery?
  12. A MySQL DB within a MySQL DB
  13. How do I query wp_options for expired transient pairs with MySQL commands?
  14. Switching Databases in LocalHost
  15. WordPress Backend HA (Automatic failover)
  16. Create table from array with prepare
  17. Automatic switch to backup database on fail
  18. Migrating to WordPress Recipe Plugin and Some SQL Issues
  19. Is there a way to recover the table wp_term_relationships?
  20. Trouble Migrating all data blog from WordPress.com to WordPress.org
  21. Unable to set a default serialized array using dbdelta()
  22. fastest replacement DB
  23. Multiple instance of data in plugin custom database table on plugin activation
  24. Does auto_load to ‘no’ in wp_options improve performance
  25. WordPress running SQL query to update database from form
  26. How to fix database error duplicate entry
  27. Migrating from PDO using SQLite to clean new install using MySQL
  28. Migration: Copying database content to a different server
  29. Call to undefined function get_user_meta() – trying to access data in MySQL from custom fields
  30. Better ads plugin has 500.000 entries in wp_postmeta
  31. Duplicated site isn’t recognized as a site
  32. How to combine multiple wp_insert_post into one in order to gain better performance
  33. How do I convert a MySQL database from utf8mb4 to utf8 encoding?
  34. after wordpress update to 3.5+ i get many errors in plugin wpdb::prepare()
  35. Query multiple tables at once?
  36. Have working sql query… trying to adjust it to use $wpdb
  37. Error establishing a database connection,
  38. Changing root password in PHPMyAdmin for WordPress Database when going live
  39. How to properly check if a table exists in WordPress Database using Show Tables Query
  40. Can’t update WordFence Options, clear data manually
  41. Changing between Local Host DB to Production DB and in reverse
  42. creating new field on mysql
  43. dbDelta not adding additional columns in plugin database update
  44. Remove empty rows from the database
  45. Custom WordPress Table wpdb
  46. Why this query is not showing any result on wordpresss home page?
  47. Best practice to limit results in get_row()?
  48. How and where is wordpress adding mySQL content to database?
  49. Plugin has added weird data in wp_options, set to autoload
  50. Always get creating a new table with foreign key
  51. How to do database for download stats?
  52. Why does changing Database Table Prefixes result in loss of content?
  53. Trouble running $wpdb->query() with last_insert_id
  54. how to encyrpt DB_PASSWORD in wp-config
  55. DB Query not working in Plugin
  56. SQL query to set posts in bulk based on the post content
  57. Query Column of Specific ID from Database Table
  58. External wpdb connections in different plugins on single page
  59. How can I detect right db type?
  60. How to create more than one new wpdb object?
  61. Optimizing function that automatically creates internal links based on post title string
  62. Moving WordPress site to new domain – database import [duplicate]
  63. How to connect and insert data in database of wordpress?
  64. Buddypress avatar image in database [closed]
  65. Changing order of db results when encoding to JSON
  66. Files on Localhost, Database on Server
  67. WordPress plugin: efficient way to store large data
  68. $wpdb->get_var – What value is returned when zero records are found?
  69. Remote database -> massive response time increase?
  70. WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version [closed]
  71. Installing local to live WP into subdirectory
  72. Second ezSQL initialization for MSSQL
  73. Fetch a single row from a custom table for to a given ID
  74. Database create or redirect
  75. Integrating Custom Database with WordPress
  76. Getting “Error Establishing a Database Connection” on localhost in new Mac OSX Lion environment
  77. How to display results from a data table with an encrypted user id?
  78. Cloning blog to localhost via WAMP
  79. Only allow user to access a link once a year, based on their joining date
  80. add_action for publish_post doesn’t work
  81. Counting post and changing roles in mysql database. Query not code
  82. MSQL database wp_postmeta has meta key tve_revision
  83. Is there anyway to split posts to different databases?
  84. How to escape percentage sign(%) in sql query with $wpdb->prepare?
  85. What database state changes happen after a post is manually “updated” with no changes?
  86. Link multiple user databases together?
  87. DB prefix not updating
  88. Cant create table on plugin activation
  89. Recovery – Restore Database after moving folder location locally
  90. Replacing javascript link in WordPress database without getting mysql syntax errors
  91. Performing CRUD operations on front end in wordpress
  92. I wanted to Know that how can I give ingore to 0000-00-00 in my config file
  93. I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
  94. Set a cron job to delete a specific database table table every midnight
  95. How to edit custom table data in frontend
  96. Job and Employee Performance Tracking with Product Safety
  97. local wordpress broke after changing URL
  98. “BS_” rows in postmeta table
  99. What structure and database storage method should I use for temporary storage that may be written concurrently?
  100. how to access 2nd Mysqli Database from different server for wordpress

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)