mysql

How to Recover MySQL Innodb ?

webadmin's picture
Coding

Unfortunately some times you need to recover MySQL data from ibdata1. It’s many reasons why your getting corrupted Innodb files that cannot automatically be restored of the mysqld daemon.

Mass Change Prefix Tables MySQL with single Script PHP

webadmin's picture
Coding

When we worked on maintenance mode in Database MySQL on Drupal sites, sometime we need to change Our Prefix Tables at new database server, this is a simple trick if you don't want to change one by one table name :)

This is simple script PHP to use it.

Drupal Tools, tips and links on optimizing mySQL

webadmin's picture
Drupal

Here are some basic, but high impact ways to optimize MySQL for Drupal (there are much more sophisticated and expensive ways to speed up your database of course):

Drupal Tuning MySQL query_cache

webadmin's picture
Drupal
Drupal Mysql Logo Image

An appropriate amount of "query_cache" is believed to improve MySQL performance at the expense of available memory. "Appropriate" will vary widely with usage and "performance" on a live site can be elusive. On Ubuntu, the defaults are modest but "work".

Drupal High Performance Tuning Apache and MySQL

webadmin's picture
Drupal

I've been working on the performance of my Drupal site and thought I'd share my results to date in case they might help someone else. My baseline performance using out-of-the-box settings was around 28 requests per second, and the end result is a rate of 68 requests per second.