Christopher Juckins

SysAdmin Tips, Tricks and other Software Tools

User Tools

Site Tools

Trace:
mysql_time_date_tips

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
mysql_time_date_tips [2020/05/16 15:57] – juckinsmysql_time_date_tips [2024/11/27 21:38] (current) – juckins
Line 20: Line 20:
  
 [[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
  
mysql_time_date_tips.1589659032.txt.gz · Last modified: by juckins