I have seen that when executing a mysql query the cpu usage becomes 100 % and it takes a long time to execute the query. I have executed the same query thorugh phpmyadmin and that time also it took a long time to execute also mysql consumes 100 % cpu . I have done some [...]
Archive for December, 2009
Posted in 
Mysql database replication
December 2nd, 2009 
Aneesh Install mysql server on both server and client machine
Settings in Server
Editi My.conf
log-bin = mysql-bin
server-id = 1
binlog-do-db=DBNAME1
binlog-do-db=DBNAME2
# Backing up Master Database
mysqldump -u root -p –routines –add-drop-table –master-data –databases DBNAME1 DBNAME2 > master.sql
musql -uroot -p
CREATE USER ‘repluser’@’%’ IDENTIFIED BY ‘password’;
GRANT PROCESS , SUPER , REPLICATION SLAVE , REPLICATION CLIENT ON * . * TO ‘repluser’@’%’ IDENTIFIED BY [...]
Find PID of a PHP script
December 2nd, 2009 Aneesh I have been trying to find the PID of a php site which is hosted in my apache web server. I did not know that it was very easy until in found the built in php function getmypid(). To find the process ID (PID) of a PHP script use the following code in your php [...]
