Solution Expert Online Blogs

S3 Non Empty Bucket Deletion

Got struck in deleting Amazon S3 non empty bucket with huge files / logs in it and found its a tedious process using browser. Try a command line ruby tool S3sync that makes your job easier. It not only deletes the bucket but can also do a lot of s3 jobs easier.

Please follow link to get more details on it.

Useful Mysql Commands

1. Stop Mysql anonymous login without password:

a) mysql -uroot -p

b) use mysql;

c) delete from user where user = ‘ ‘ ;

d) FLUSH PRIVILEGES;

2. Insert data in to mysql database from command line ( prompt ) without entering in to mysql prompt:

mysql -u<user> -p<pass> <dbname> -e “insert into <tablename> values(‘value1′,’valuen’);”

3. Changing mysql user password from mysql prompt

a) mysql -u root -p

b) use mysql;

c) update user set password=PASSWORD(“NEWPASSWORD”) where User=’username’;

d) FLUSH PRIVILEGES;

4. Parsing Slow logs

mk-query-digest –review h=localhost,D=slowdb,u=myadmin,p=password,t=query_review mysqld-slow.log

This will create tables also.

mk-query-digest –review h=localhost,D=slowdb,u=myadmin,p=password,t=query_review mysqld-slow.log –create-review-table

5. Deadlock logger

mk-deadlock-logger –source u=myadmin,p=password,h=localhost –dest D=dead_db,t=locks

Will keep updating further as progress continues via comments.

MySql Statistics Aggregator

You can use Statpack to generate stats of mysql show global status and store in file for later analysis. Its a python script that collects performance snapshot of mysql server.

You will need to install mysql-python module to get this script working.

Please follow link to know more about it.

Mysql Performance Monitoring

Monitor Mysql server statistics using mysql-monitoring. Its a perl script that queries mysql server for statistics every 60 secs. Licensed under GPL v3.

Once rrd files have been generated, you can use ddraw tool to generate graphs out of it.

Please follow link to get to know more about it.

Ddraw a tool to generate graphs from rrd database.

Some screenshot:

Inventory Management

Found an interesting link which provides inventory of linux and windows, thought of sharing it.

Please follow link to get more details on it.