Solution Expert Online Blogs

S3 Non Empty Bucket Deletion

ravi.ranjan — Fri, 27 Aug 2010 06:39:37 +0000

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

ravi.ranjan — Thu, 19 Aug 2010 11:59:21 +0000

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 -p -e “insert into 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

ravi.ranjan — Tue, 06 Jul 2010 10:20:45 +0000

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

admin — Thu, 01 Jul 2010 12:37:58 +0000

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

ravi.ranjan — Thu, 17 Jun 2010 14:08:14 +0000

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

Please follow link to get more details on it.

Linux Inventory Script

ravi.ranjan — Tue, 15 Jun 2010 14:35:37 +0000

Want to have hardware and software inventory of your Linux machines viewable on browser, you can use cfg2html.

Fantastic tool which collects and generates details of your system information in to beautiful web page, which can be opened by any browser.

It can generate output in text format also.

Please follow link to get to know more details about it.

Mysql Performance Graphing

ravi.ranjan — Wed, 02 Jun 2010 13:48:03 +0000

Cool piece of work for graphing mysql performance using mycheckpoint. Tried it and its really good as its database driven, you can customize and generate your own kind of report. It also has features of alerting system.

Try it, its really good and displays lot of stuffs on browser as well as text.

Mysql Useful Tools

ravi.ranjan — Tue, 01 Jun 2010 14:28:41 +0000

Want to monitor, process logs and many other, try this link which has many other tools on its site.

Tried it and found really good to process the logs and can help in automating many mysql activity stuffs.

MySQL DATE FORMAT AND PHP DATE TOOL

ravi.ranjan — Mon, 31 May 2010 15:29:43 +0000

Found an interesting link that displays the code to be used in coding for mysql and php. Just select the date and the format to be used and your code statement is ready.

Please follow link to check.

zabbix configure: error: Not found libcurl library

ravi.ranjan — Fri, 28 May 2010 14:41:50 +0000

I was trying to install zabbix monitoring tool and was getting libcurl library not found error. I checked all the way and found curl and libcurl installed.

Finally ,found the library that was missing was not libcurl but libidn-devel library which provides -lcurl option to zabbix for installation.

Sharing this as it might help many.

To get all details about Zabbix.