MySQL (Database)
Module Files
Live configuration files and boilerplates used by current SlickStack installation that may be altered by LittleBizzy or Ubuntu for better performance.
Related Links
Links and resources related to the above module that may help users understand its functionality, or how it interacts with other LEMP stack modules.
- https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html
- https://stackoverflow.com/questions/9192027/invalid-default-value-for-create-date-timestamp-field/29503517#29503517
- https://gabi.dev/2016/03/03/group-by-are-you-sure-you-know-it/
- https://stackoverflow.com/questions/28606483/how-to-allow-empty-string-for-integer-in-mysql
- https://stackoverflow.com/questions/43589048/mysql-need-to-allow-0000-00-00-000000-dates
- https://stackoverflow.com/questions/36374335/error-in-mysql-when-setting-default-value-for-date-or-datetime
- https://www.sitepoint.com/optimize-mysql-indexes-slow-queries-configuration/
- https://dzone.com/articles/how-to-optimize-mysql-queries-for-speed-and-perfor
- https://stackoverflow.com/questions/2317650/setting-global-sql-mode-in-mysql
- https://www.reddit.com/r/mysql/comments/owye5g/whats_the_status_of_mysql_8190/
- https://blog.kernl.us/2019/10/wordpress-database-performance-showdown-mysql-vs-mariadb-vs-percona/
- https://www.percona.com/resources/webinars/mariadb-103-vs-mysql-80
- https://hackr.io/blog/mariadb-vs-mysql
- https://www.cloudways.com/blog/mysql-vs-mariadb/
Last updated: Jan 31, 2022