Help With a Large WordPress Based MySQL Database on Shared Hosting

Ditto Otto –

Q: “What is your suggestion on running a large database?”

A: Don’t do it on shared hosting.

Shared hosts have CPU limits, so any queries run on a database that large will be slow or time out. Shared hosts also have database size limits, so your database with 500K posts may be too large to upload and run.

You need at very least a VPS, and one that gives you root access so you can configure MySQL for loads and large databases with tools like http://mysqltuner.com/

Related Posts:

  1. What is the difference between an ORM and an ODM?
  2. Rename a table in MySQL
  3. How should I tackle –secure-file-priv in MySQL?
  4. Checking if Database Table exists
  5. How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
  6. Is it possible to define two databases for one installation?
  7. Has parent field in the table wp_term_taxonomy has term_id or term_taxonomy_id
  8. Connect forms in WP to external database
  9. Hook into $wpdb
  10. Syncing local content with development / staging sites
  11. Export WP database for import using WP-CLI on Vagrant Box
  12. Is it wise to delete post revisions and autosaves from database?
  13. Improve or optimize a very slow query
  14. What is the advantage of separating wp_users and wp_usermeta table?
  15. “MySQL server has gone away” since update to 3.8
  16. WordPress page title repeated in SOME pages
  17. Why is $wpdb->get_results failing on certain tables but not others (which have data)?
  18. Usage of Direct Database Call Without Caching Error
  19. How to correctly add a table to the WordPress MySQL database
  20. MySQL Syntax Error upon restoring database from backup [closed]
  21. Help running a MySQL query to update all wp_#_options tables in a Multisite install
  22. Merge two databases: OLD SITE -> NEW SITE
  23. Is it safe to convert tables from MyISAM to InnoDB?
  24. Backup another database with BackUpWordPress plugin [closed]
  25. Easiest Way to Authenticate WP Users Using an External DB?
  26. Use one WordPress database with multiple instances of one site
  27. Who is responsible for data sanitization in WordPress development?
  28. How do I properly update the WordPress database password?
  29. How to check if a core update, like 4.9.8 → 5.0, involves a database update (migration)?
  30. $wpdb->insert is not working
  31. WordPress Install and Database on separate hosting?
  32. Moving a site from a temporary domain to the live domain [duplicate]
  33. How do I find out the full path of a page’s template?
  34. I need to get an array from the wordpress database
  35. Moving minor updates between local and live sites – just database?
  36. what is the best way to store user created data?
  37. WP get stuck with a query on MySQL when the site is resumed
  38. Using GROUP CONCAT in my-sql query with wp_usermeta table
  39. “The link you followed has expired” & “Error while saving” messages when adding new post
  40. input data and output table [closed]
  41. How to move the WordPress site Layout from test site to Production site?
  42. Your PHP installation appears to be missing the MySQL extension which is required by WordPress
  43. Retrieve data from the database to table such as comments in the admin control panel
  44. Need to store custom user information (many-many relationsips), preferably not as user meta
  45. charset problem with new custom table
  46. WordPress and user security
  47. How to share plugin created database tables between two WordPress sites
  48. How to connect to a remote database in WordPress?
  49. Migrating from PDO using SQLite to clean new install using MySQL
  50. Change WordPress URL in sql file via Terminal
  51. $wpdb->insert Giving duplicates
  52. Which data is written and stored in the database when read-only (non-posting, non-commenting) users visit the site?
  53. Where is phpMyAdmin inside WordPress?
  54. What can I do when an outside party hacks into my weblog and changes my display name?
  55. How to properly check if a table exists in WordPress Database using Show Tables Query
  56. How to delete database without using any plugin?
  57. Cannot restore wordpress database from sql dump [closed]
  58. WooCommerce: remove sample & dummy data
  59. Is database deleted on clicking “reinstall” button in WordPress updates?
  60. Fill custom select field with pages/post titles
  61. Is my way to change WordPress server is correct?
  62. Recovering the table wp_usermeta from users
  63. WordPress database products structure
  64. I cannot find the difference between these wp_capabilities values in wp_usermeta
  65. Files on Localhost, Database on Server
  66. Remote database -> massive response time increase?
  67. Custom Post Type not showing anything added by code anymore?
  68. How do I have a user upload a blog post and then retrieve that to display in a card on the site?
  69. Delete user with only subscriber role
  70. WordPress keeps redirecting to localhost
  71. get value from ‘terms’ table
  72. How to rename custom table name programatically in wordpress?
  73. How to edit custom table data in frontend
  74. pre_get_posts causings DB error when using ( ‘posts_per_page’, -1)?
  75. generate PDF from member information
  76. mysqli_query(): MySQL server has gone away for Curl Request
  77. Help posting values to DB on submit using $wpdb->query
  78. WP website showing blank page after moving from subdomain to main domain
  79. create a table using user meta custom data
  80. wpdb query to insert images in to post/page gallery
  81. Creating a database in my plugin not working
  82. How to create index (sql) to a meta_key?
  83. WPCLI search and replace in a particlar site dir effect another site-dir
  84. get_user_meta and umeta_id
  85. $wpdb not working
  86. Database error after importing WordPress
  87. Send data to database after redirect (and popping out of iframe)
  88. Simple email input store in database
  89. Pulling values from a sepcific row in table
  90. import (migration) user database to wp-users
  91. Create hundreds of users with just ID in phpMyAdmin
  92. What is best for saving lot of extra detail of user?
  93. Insert Extra fields added in the front end registration form to DB
  94. $wpdb->insert not working for last select option
  95. How to create a table [closed]
  96. Upload wordpress from localhost to 000webhost
  97. wp-config was suddenly updated
  98. Weird WP -Cli Error Connection Refused
  99. Order of search results based off of a backend custom field and also in alpha order
  100. How to find fresh (last modified) and sql backup?