Before InnoDB, indexes would get corrupted, updates meant table locks—not just row locks, and there was no support for transactions. Since the advent of InnoDB we’ve come a long way. Sites that don’t use InnoDB are missing out on performance and stability gains. As part of our Launch Check for new sites, we check the engineRead more about Convert MySQL Tables From MyISAM to InnoDB[…]
This guide is a companion to the Postfix, Dovecot, and MySQL installation guide. Because setting up a mail server is tricky, we’ve created this companion troubleshooting guide to help you work through and resolve any problems you might be experiencing. By the time you reach the end of this guide, you’ll know how to debug problems with your Postfix, Dovecot, and MySQL mail server.
The first section, Troubleshooting Checklist_, has a top-down approach to troubleshooting that will help you find specific errors for your mail server. The second section, Step-by-Step Configuration_, uses a bottom-up approach that shows you how to get a basic mail server functioning and then gradually add more features.
Hi ,, ?
Did you encounter this error after you upgrade your mysql from mysql 5.5 to mysql 5.6 in the vbulletin script ?
Error Number : 1406MySQL Error : Data too long for column
Follow with me the solution for this error 🙂
Hi guys 🙂
Do you experience the problem of the appearance of the size of databases 0M in the CPanel
The simple solution in only 3 steps!
f you’re trying to repair large MyISAM tables in MySQL, you can run into the following restriction, because of the limited size of the default Sort Buffer. root@east4serv # myisamchk -r table.MYI – recovering (with sort) MyISAM-table ‘table.MYI’ Data records: 335045 – Fixing index 1 Found block that points outside data file at 1509428340 FoundRead more about MySQL – myisamchk: error: myisam_sort_buffer_size is too small[…]