MySQL OPTIMIZE all tables?

You can use mysqlcheck to do this at the command line.

One database:

mysqlcheck -o <db_schema_name>

All databases:

mysqlcheck -o --all-databases

Related Posts:

  1. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  2. Unknown column in ‘field list’ error on MySQL Update query
  3. Unknown column in ‘field list’ error on MySQL Update query
  4. MySQL – Operand should contain 1 column(s)
  5. MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
  6. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  7. MySQL create table if not exists and insert record only if table was created
  8. How do I use properly CASE..WHEN in MySQL
  9. How can I do a FULL OUTER JOIN in MySQL?
  10. MySQL query String contains
  11. What’s the difference between VARCHAR and CHAR?
  12. Case statement in MySQL
  13. How to declare a variable in MySQL?
  14. MySQL Cannot Add Foreign Key Constraint
  15. How to split the name string in mysql?
  16. How do I import an SQL file using the command line in MySQL?
  17. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  18. mysql Foreign key constraint is incorrectly formed error
  19. MySQL: Invalid use of group function
  20. How can I return pivot table output in MySQL?
  21. Compare dates in MySQL
  22. MySQL “WITH” clause
  23. MySQL Multiple Joins in one query?
  24. Error Code: 2013. Lost connection to MySQL server during query
  25. MySQL syntax for Join Update
  26. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  27. how to drop partition without dropping data in MySQL?
  28. MySQL combine two columns into one column
  29. Simple way to calculate median with MySQL
  30. Error 1046 No database Selected, how to resolve?
  31. MySQL Error 1264: out of range value for column
  32. Remove duplicate rows in MySQL
  33. How to SUM and SUBTRACT using SQL?
  34. Cast from VARCHAR to INT – MySQL
  35. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  36. How do you force mysql LIKE to be case sensitive?
  37. MySQL – UPDATE multiple rows with different values in one query
  38. How to create a MySQL hierarchical recursive query?
  39. ERROR 1148: The used command is not allowed with this MySQL version
  40. Insert into a MySQL table or update if exists
  41. How to round down to nearest integer in MySQL?
  42. MySQL starts with searching issue
  43. Query to convert from datetime to date mysql
  44. Is it possible to GROUP BY multiple columns using MySQL?
  45. MySQL error: key specification without a key length
  46. Best way to test if a row exists in a MySQL table
  47. Check if MySQL table exists without using “select from” syntax?
  48. MySQL equivalent of DECODE function in Oracle
  49. mysql update column with value from another table
  50. The used SELECT statements have a different number of columns
  51. How to delete from multiple tables in MySQL?
  52. MySQL: Can’t create table (errno: 150)
  53. How to copy a row and insert in same table with a autoincrement field in MySQL?
  54. Join vs. sub-query
  55. Alternative to except in MySQL
  56. Equivalent of explode() to work with strings in MySQL
  57. ROW_NUMBER() in MySQ
  58. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  59. MySQL – Get row number on select
  60. MySQL error: Unknown column in ‘where clause’
  61. How to truncate the text returned for a column in a MySQL query
  62. Using union and order by clause in mysql
  63. MySQL LIKE IN()?
  64. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  65. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  66. Case in Select Statement
  67. How can I do an UPDATE statement with JOIN in SQL Server?
  68. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  69. How do I limit the number of rows returned by an Oracle query after ordering?
  70. Get day of week in SQL Server 2005/2008
  71. mysql Foreign key constraint is incorrectly formed error
  72. incorrect syntax error CREATE VIEW must be the only statement in the batch
  73. PLS-00103: Encountered the symbol when expecting one of the following:
  74. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  75. Postgresql tables exists, but getting “relation does not exist” when querying
  76. SQL Parentheses use in an OR clause
  77. What is the difference between LATERAL JOIN and a subquery in PostgreSQL?
  78. Repair all tables in one go
  79. Is there a Max function in SQL Server that takes two values like Math.Max in .NET?
  80. Temporary table in SQL server causing ‘ There is already an object named’ error
  81. Fatal error: Call to a member function query() on null
  82. Append table to an existing one: SQL Server
  83. How to order by column A and then by column B?
  84. SQL Server – An expression of non-boolean type specified in a context where a condition is expected, near ‘RETURN’
  85. Update query using Subquery in Sql Server
  86. register_post_status – show_in_admin_all_list & show_in_admin_status_list does not affect query
  87. How to get the list of WooCommerce product image of a certain category from database?
  88. How to execute mulitple statement SQL queries using $wpdb->query?
  89. Return number of items in a table with post id
  90. How do I find which articles are missing a featured image in The WordPress database?
  91. SQL query to set posts in bulk based on the post content
  92. How can i restore only Blogs from a SQL backup file?
  93. DB_HOST – is LOCALHOST speedy than domain name? [closed]
  94. JOIN and SUM different statement results (Mailster Database)
  95. Performing CRUD operations on front end in wordpress
  96. how to SELECT meta values that are not null?
  97. How to show result of sql query in a page?
  98. Conditional statement within WP SQL query
  99. Delete posts with word count less than x number of words
  100. Adding profile data to database

Leave a Comment