Mysql status update is a script which provides status update by email or SMS whenever mysql is restarted, huge fluctuation in numbers difference about queries and slow queries. Thought of sharing.
Please follow link to get more details on it.
Wednesday, February 10, 2010
Found a great and fantastic tool which monitors full processlist of mysql query running on server. No logs required to get the details. You can use it to log to any way you want it and can see what all queries have been executed on server for fine tuning your application. Written is perl, Its [...]
Tuesday, February 9, 2010
Cool piece of perl script that monitors usage/resource consumption of Mysql on Linux machine.Written in perl and can be modified to get details of almost any running program.Liked a lot as it helps me to get resource consumption of many programs.
Please follow link to get more detail on it.
Monday, February 1, 2010
Apache log has various formats, out of which common and combined are mostly used ones. Bash script that is provided below parses apache common/combined logs and displays information out of its stats. In the resulting output, the “User Agent” part can be extended further to display many other information like Browsers, OS and so on.
Any [...]
Thursday, January 28, 2010
Script to create username and password from a text files. Assuming you have 100 users and password in file separated by comma, you can use below script to create the usernames and assign the password to those users. Please check the username and password argument and do not supply any existing user else it will [...]
Wednesday, January 20, 2010
Want to monitor your logs in real time and generate action based on matching pattern, you can use swatch. It produces desired result with negligible load on the server and alerts admin based on pattern it is asked to look for in logs. Monitors any kind of logs.
Please follow link to get more details on [...]
Friday, January 15, 2010
Found a great tool which generates server report and sends it via mail. Reports can also be kept in folders and displayed on web page as index is also defined as a calender wise for reports generated. Many features support.
Please follow link to get more details on it.
Monday, January 11, 2010
Below script can be made to run every 5 min in cron to find current top running process.
It will find below stuffs for running process on a particular machine at the time the script is run.
ServernameProcess NameProcess PIDCurrent CPU Usage By PIDNo Of Opened File By PIDResident Memory Size Of PIDCurrent Memory Consumption By PIDProcess [...]
Tuesday, December 29, 2009
Below script will parse Apache config and will grab only the VirtualHost section from config file. Script can be extended to parse any directives in apache config file.
#!/bin/bashmyifs=$IFSIFS=$(echo -en “\n”)scan_file=`sed -n ‘/^<VirtualHost*/,/<\/VirtualHost>/p’ /etc/httpd/conf/httpd.conf | grep -v “#” | sed ’s/^[ \t]*//;s/[ \t]*$//’ | sed ’s/<//g’ | sed ’s/>//g’ | sed ’s/:/ /g’ | sed ’s/\/V/V/g’` [...]
Monday, December 28, 2009
There is an interesting article about the PHP Pagination and easy to integrate. As a developer you’ll soon find a need to paginate data when displaying contents from the database, and rather than use JavaScript which could require all the data to be loaded into the page on load, we can use PHP to ensure [...]
© 2010 Solution Expert Online Blogs. Powered by Wordpress.
Saturday, February 13, 2010
0 Comments