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’);” [...]
Tuesday, July 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.
Thursday, July 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 [...]
Wednesday, June 2, 2010
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.
Tuesday, June 1, 2010
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.
Monday, May 31, 2010
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.
Thursday, February 18, 2010
Mysql administration can be made easy using tools. Found an interesting link that provide almost complete list of tools to administer Mysql. Thought of sharing it as it might help many. Please follow link to know more detials on it.
Saturday, February 13, 2010
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.
© 2010 Solution Expert Online Blogs. Powered by Wordpress.
Thursday, August 19, 2010
0 Comments