101 Tips to MySQL Tuning and Optimization

MySQL is a powerful open-source database.  With more and more database driven applications, people have been pushing MySQL to its limits.  Here are 101 tips for tuning and optimizing your MySQL install.  Some tips are specific to the environment they are installed on, but the concepts are universal.   I have …

What is Data Integrity? Learn How to Ensure Database Data Integrity via Checks, Tests, & Best Practices

Data integrity is a fundamental component of information security. In its broadest use, “data integrity” refers to the accuracy and consistency of data stored in a database, data warehouse, data mart or other construct. The term – Data Integrity – can be used to describe a state, a process or …

ERROR: Too many failed login attempts. Please try again” in wordpress admin login page

This error comes from a wordpress limit_login plugin. Due to load balancing and DDoS protection the majority of our IPs are behind loadbalancers, as a result limit login plugin always sees the IP of the load balancer as the IP of requester. To fix this problem follow this steps: Login …

Install Oracle 11gR2 Database Server on CentOS 5.7 Final

Environment : CentOS 5.7 Final I think we must upgrade kernel and dependency package first yum install kernel kernel-devel yum install compat-libstdc++-33.x86_64 binutils compat-libstdc++ elfutils-libelf elfutils-libelf-devel glibc glibc-common glibc-devel glibc-headers gcc gcc-c++ libaio-devel libaio libgcc libstdc++ libstdc++ make sysstat unixODBC unixODBC-devel

How To Change IP Address Without reboot On Solaris

Usually after you change IP address with edit somes files on Solaris, reboot is recommended. But actually you do not need reboot system same like linux – Redhat, CentOS, Fedora, etc – just enter command line On Linux root@WS01~]# service network restart On solaris, #>svcadm restart network or #>svcadm restart …

How to Install dbase extension in php5

My Environment : OS : CentOS 5.7 Final Web Server : httpd-2.2.3-53 PHP : php53-5.3.3-1.el5_6.1 Programming Language : gcc Download package from php.net Download package dbase-5 from php.net [root@compare] # wget http://pecl.php.net/get/dbase-5.0.1.tgz Extract package [root@compare] # tar -zxvf dbase-5.0.1.tgz Prepare the build environment for a PHP extension and compile [root@compare] …

How to Reset Root Password MySQL

Shutdown MySQL service # service mysqld stop Start MySQL Service in safe mode # mysqld_safe –skip-grant-tables Login as root #mysql -u root update root password mysql> use mysql; mysql> UPDATE user SET Password = PASSWORD (‘New Password’) WHERE User=’root’; mysql> FLUSH PRIVILEGES; mysql> quit; Restart service MYSQL as normally # …