| Webtraffic Exchange
How to change primary key values in MySQL?
To change values of existing integer field (`table` is the table name, and "id" is the column name), you may use the following update SQL command:
Read More +Data & Databases
Databases
| Webtraffic Exchange
How to change MySQL user and root password?
We have been using the DirectAdmin control panel for a number of years, and each time we set up a server it is necessary to change the root password. By default, Direct Admin creates a MySql superuser called "da_admin" w...
Read More +
| Webtraffic Exchange
[SOLVED] ERROR 1206 (HY000): The total number of locks exceeds the lock table size
We have a customized Openbravo POS v2.2 running with a dozen workstations operating 24x7 a year around. The size of the database has grown to 10GB, and the performance started to degrade so we decided to archive old data...
Read More +
| Webtraffic Exchange
[SOLVED] MySQL Crash with Fatal error: cannot allocate memory for the buffer pool
We have a dozen websites mostly running WordPress, and one Drupal website on Digital Ocean with a 1GB instance. The server was running flawlessly for 6 months, and then MySQL starts to crash every few days unexpectedly w...
Read More +