Memcached & MySQL

memcached (pronunciation: mem-cash-dee.) is a general-purpose distributed memory caching system that was originally developed by Danga Interactive for LiveJournal, but is now used by many other sites. It is often used to speed up dynamic database-driven websites by caching data and objects in memory to reduce the number of times an external data source (such [...]

Read Full Post »

How to recover root password in MySQL?

As Linux system root user stop the database process: /etc/init.d/mysql stop
(or: service mysql stop)
Start MySQL in safe mode and skip the use of the “grant tables”: /usr/bin/mysqld_safe –user=mysql –socket=/var/lib/mysql/mysql.sock –pid-file=/var/run/mysqld/mysqld.pid –datadir=/var/lib/mysql –skip-grant-tables –skip-networking & [...]

Read Full Post »

MySQL Optimization Tips

(for more database related articles)
MYSQL Optimization Tips
The MySQL database server performance depends on the number of factors. The Optimized Query is one of the factors for the MySQL robust performance.
The MySQL performance depends on the below factors.

Hardware (RAM, DISK, CPU etc)
Operating System (i.e. Linux OS will give the more [...]

Read Full Post »

Pros and Cons of MySQL Table Types

Please visit http://sqldbpool.blogspot.com/
(for more database related articles)
Of all the positive things that MySQL brings to the table, probably the most overlooked is multiple table types. This facet of the application is overlooked as a feature and more importantly is overlooked at design time.
MySQL has six distinct table types.

MyISAM
MERGE
ISAM
HEAP
InnoDB [...]

Read Full Post »

MySQL Question and Answers

How do you start and stop MySQL on Windows? – net start MySQL, net stop MySQL
How do you start MySQL on Linux? – /etc/init.d/mysql start
Explain the difference between mysql and mysqli interfaces in PHP? – mysqli is the object-oriented version of mysql [...]

Read Full Post »

How do I reclaim Space from the INNODB (Ibdata) file?

This is the major issue with the Innodb engine, the bulk delete/truncate operation will deleted the data but it is not reclaiming the space from the Innodb file. There are some techniques to reclaim the space but please make sure you must have the extra space on your servers.
1. Alter Database Set Engine = Innodb
2. [...]

Read Full Post »