MySQL: Specified key was too long; max key length is 767 bytes
I just ran into this issue while setting up a new client server with MySQL 5.6, well, Percona 5.6 in my case.
It looks like one has to explicitly allow long prefixes in 5.6. Something that was never needed in 5.5 or earlier version of MySQL.
In any case, adding:
innodb_large_prefix = on
to the my.cfn file solved it.
Hope it helps someone else out there 🙂
MySQL: Failed to open the relay log
If you happen to see the message "Failed to open the relay log..." in your MySQL error log file (sometimes it is good to look into it once in a while) then you either have your replication setup incorrectly or you forgot to remove the salve information in the master.…
MySQL replication - Query caused different errors on master and slave
MySQL replication works quite reliable most of the time. But from time to time, especially if you change network, servers or the master has gone away the slave will get in a "weird" state. Today, I've encountered the following error message on one of the slaves; Query caused different errors…
Fix for running MySQL 5.5.8 under MacOS X 10.6.5 (Snow Leopard)
Oracle recently released the latest MySQL 5.5.x versions. Despite of having tones of fixes and supposedly running much faster and (finally) making InnoDB the default storage engine, it is always good to keep up to date with latest releases. But, as in the past, MaxOS X users always have to…
Removing line breaks and tabs in a MySQL column
Sometimes it happens that you have unwanted tabs, line breaks, paragraphs, etc. in a table column. With the following code snippet you can clean the value of the column quickly: [sql]update mytable set mycolumn = REPLACE(REPLACE(REPLACE(mycolumn, 't', ''), 'r', ''), 'n', '')[/sql]
Why Coldfusion / CFML has its place and is worth to learn it
I actually never indulge in conversations why one programming language is better then another, because what is right to you, does not automatically mean, it is right for someone else. So, for me ColdFusion, or as we call the language itself - CFML, works very well. Nevertheless, in this post…
What you should look for in your customer service software
Being able to offer your customers help whenever they need it is vital to ensuring your customer service is the best that it can be. For many companies, building an outstanding customer support network involves a lot of manual work, often with support tickets being left behind, or not prioritized…
