Christopher Juckins

SysAdmin Tips, Tricks and other Software Tools

User Tools

Site Tools

Trace: • find_duplicate_files_in_linux • gimp_tricks
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 [2010/10/18 12:19] – juckinsmysql_time_date_tips [2024/11/27 21:38] (current) – juckins
Line 1: Line 1:
 +==== MySQL Tips ====
 +
 +__SELECT and JOIN__
 +
 +[[https://www.mysqltutorial.org/mysql-inner-join.aspx]]
 +
 +__Time/date__
 +
 [[http://www.richardlord.net/blog/dates-in-php-and-mysql]] [[http://www.richardlord.net/blog/dates-in-php-and-mysql]]
  
Line 8: Line 16:
  
 [[http://www.bennadel.com/blog/172-Ask-Ben-Selecting-Parts-of-a-Date-Time-Stamp-In-SQL.htm]] [[http://www.bennadel.com/blog/172-Ask-Ben-Selecting-Parts-of-a-Date-Time-Stamp-In-SQL.htm]]
 +
 +__Performance__
 +
 +[[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.1287418797.txt.gz · Last modified: 2010/10/18 12:19 by juckins