“mysqlreport makes a friendly report of important MySQL status values. mysqlreport transforms the values from SHOW STATUS into an easy-to-read report that provides an in-depth understanding of how well MySQL is running. mysqlreport is a better alternative (and practically the only alternative) to manually interpreting SHOW STATUS.” Installation: root@server [~downloads]# wget hackmysql.com/scripts/mysqlreport root@server [~downloads]#chmod 755 [...]
Archive for the ‘OPTIMIZATION’ Category
script to show mysql status values
Posted in Mysql, OPTIMIZATION, SCRIPT on October 4, 2009 | Leave a Comment »
iframe attacks
Posted in OPTIMIZATION, SECURITY on September 11, 2009 | Leave a Comment »
How are the iframe attacks done? =============================== Client side PC infected with virus. Virus gets FTP username/password from the FTP clients. Using the username/password, the virus downloads the index files, add iframe code and re-uploads it. The iframe code points to the same virus. So, anyone accessing this website gets infected with the same virus, [...]
Identifying slow MySQL queries
Posted in Mysql, OPTIMIZATION, SECURITY on January 7, 2009 | Leave a Comment »
MySQL can sometimes create big problems on a server when you have users abusing it. This article will teach you how to correctly identify the queries that are creating a problem for your server. MySQL can log those queries that are taking longer then X seconds but this future is not turned on by default. [...]
Install MySQL Performance Tuning Script
Posted in Mysql, OPTIMIZATION, SECURITY on January 7, 2009 | Leave a Comment »
Tuning the performance of MySQL can be a really hard job to do. There are many thinks to consider and no two servers are identical so there is no universal solution. Tuning Primer is a script that will help you tune your mysql installation by providing very healthy recommendations based on past mysql records. For [...]
Apache tuning and optimization Linux-cPanel server
Posted in Apache, OPTIMIZATION, SECURITY on January 7, 2009 | Leave a Comment »
This article will teach you all the tricks to make your webserver (apache) run faster. First login to your server as root using ssh. All the important configuration options are stored by Apache in a config file called httpd.conf that is located at /usr/local/apache/conf/httpd.conf We will start by opening this file in your favorite text [...]
