Linux & Windows Tips, Tutorials, , Ideas

Convert MySQL Tables From MyISAM to InnoDB

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[…]

Share Button

Troubleshooting Problems with Postfix, Dovecot, and MySQL

 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.

Read more about Troubleshooting Problems with Postfix, Dovecot, and MySQL

Share Button

FIX MySQL Error : Data too long for column – vbulletin

mysql

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 : 1406
MySQL Error : Data too long for column

Follow with me the solution for this error 🙂

Read more about FIX MySQL Error : Data too long for column – vbulletin

Share Button

Mysql Databases showing 0MB in Cpanel

Hi guys 🙂 mysql

Do you experience the problem of the appearance of the size of databases 0M in the CPanel

The simple solution in only 3 steps!

 

Read more about Mysql Databases showing 0MB in Cpanel

Share Button

MySQL – myisamchk: error: myisam_sort_buffer_size is too small

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. [email protected] # 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[…]

Share Button