https://ndchost.com/wiki/ Mon, 13 Apr 2026 10:41:15 +0000 FeedCreator 1.8 https://ndchost.com/wiki/_media/wiki/logo.png https://ndchost.com/wiki/ https://ndchost.com/wiki/mysql/illegal-mix-collations?rev=1317835662&do=diff MySQL Database Error :: Illegal mix of collations The error “Illegal mix of collations” in MySQL has to do with the collation type for the database being set differently than MySQL. This likely occurred because you created the databases on a system that had a different collation type. The collocation defaults to UTF, and should be acceptable in most cases. Collation for a database can be changed with the anonymous@undisclosed.example.com (Anonymous) Wed, 05 Oct 2011 17:27:42 +0000 https://ndchost.com/wiki/mysql/index?rev=1265669878&do=diff MySQL mysql index anonymous@undisclosed.example.com (Anonymous) Mon, 08 Feb 2010 22:57:58 +0000 https://ndchost.com/wiki/mysql/optimize-tables-script?rev=1333387060&do=diff Optimizing Fragmented Tables If there are random insertions into or deletions from the indexes of a table, the indexes may become fragmented. Fragmentation means that the physical ordering of the index pages on the disk is not close to the index ordering of the records on the pages, or that there are many unused pages in the 64-page blocks that were allocated to the index. anonymous@undisclosed.example.com (Anonymous) Mon, 02 Apr 2012 17:17:40 +0000 https://ndchost.com/wiki/mysql/tune-up-and-optimize-mysql-configuration?rev=1466184810&do=diff How to Tune Up and Optimize your MySQL Configuration A default installation of MySQL is set up using all of the default settings. However for systems with larger or smaller amounts of resources, the MySQL configuration can be changed to speed up database queries. anonymous@undisclosed.example.com (Anonymous) Fri, 17 Jun 2016 17:33:30 +0000