Differences

This shows you the differences between two versions of the page.

--- mysql_time_date_tips [2020/05/16 15:56] – juckins
+++ mysql_time_date_tips [2024/11/27 21:38] (current) – juckins
@@ Line 19: / Line 19: @@
 __Performance__
-[[https://tableplus.com/blog/2018/11/error-1040-too-many-connection-increase-max-connections-mysql.html Max connections]]
+[[https://tableplus.com/blog/2018/11/error-1040-too-many-connection-increase-max-connections-mysql.html|Max connections]]
+__Checking for errors in all tables/databases__
+  * In phpMyAdmin, select database and then check the table you want to investigate.  In the dropdown box "With Selected", choose the Check / Repair option, etc.
+Alternately:
+  mysqlcheck -c -u root -p --all-databases
+__Repair a database__
+  mysqlcheck -r DATABASE_NAME -u root -p
+__Checking Size of Indexes__
+https://releem.com/blog/check-mysql-database-table-size