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.
Thu, Aug 19, 2010
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.
Tue, Jul 6, 2010
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.
Thu, Jul 1, 2010
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:
Thu, Jun 17, 2010
Found an interesting link which provides inventory of linux and windows, thought of sharing it.
Please follow link to get more details on it.
Fri, Aug 27, 2010
0 Comments