Which way to count a number of rows should be faster in MySQL? SELECT COUNT(1) FROM TABLE_NAME When you COUNT(1) it takes in count column indexes, so it will be the best result. Mysql engine actually stores row count, it doesn’t count all rows each time you try to count all rows. here is the […]
Install Apache, Mysql , PhP Web Server # yum install httpd mod_ssl #/etc/init.d/httpd start # yum install mysql mysql-server # chkconfig –levels 235 mysqld on # /etc/init.d/mysqld start configure mysql Set the MySQL service to start on boot chkconfig –levels 235 mysqld on Start the MySQL service service mysqld start Log into MySQL mysql -u root Set the […]
This happened when my cacti crashed after a power failure. Repair a table inside database This will repair host table in cacti databse # mysqlcheck -r cacti host -u root -p The following checks, optimizes and repairs all the corrupted table in cacti database. # mysqlcheck -u root -p –auto-repair -c -o cacti Check […]
mysql> create database ajay; Query OK, 1 row affected (0.00 sec) CREATE USER ‘newuser’@’localhost’ IDENTIFIED BY ‘password’; GRANT ALL PRIVILEGES ON * . * TO ‘newuser’@’localhost’; FLUSH PRIVILEGES;
This tutorial describes how to set up MySQL master-master replication. We need to replicate MySQL servers to achieve high-availability (HA). In my case I need two masters that are synchronized with each other so that if one of them drops down, other could take over and no data is lost. Similarly when the […]
