public marks

PUBLIC MARKS from camel with tags mysql & script

November 2008

Check Your Mysql Server Performance with MySQLTuner -- Debian Admin

by 1 other
MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability. Within seconds, it will display statistics about your MySQL installation and the areas where it can be improved. It’s key to remember that MySQLTuner is a script which can assist you with your server, but it is not the solution to a badly performing MySQL server. The best performance gains come from a thorough review of the queries sent to the server, and an evaluation of the MySQL server itself. A qualified developer in your application’s programming or scripting language should be able to work with a MySQL database administrator to find improvements for your server. Once the server and application are optimized well, you may need to consider hardware upgrades to the physical server itself. This is a really useful tool for helping to optimize MySQL performance.Understanding the various my.cnf variables and how they affect performance can seem really complicated but this tool takes some of the pain away and makes it easier to understand the effects of each variable.It is especially useful to be able to see the global memory usage, memory usage per thread and the maximum possible memory usage - that is really valuable information that is otherwise complex to calculate.

September 2008

Script To Check If MySQL Master Master Replication Is Working Correctly | HowtoForge - Linux Howtos and Tutorials

This short article explains how you can use a short script to check whether your MySQL master master replication is working as expected or not.

December 2007

Getting MySQL Status Values With mysqlreport | HowtoForge - Linux Howtos and Tutorials

mysqlreport is a Perl script that displays a well-formatted report of important MySQL status variables (taken from MySQL's SHOW STATUS; output) that can help you gain an understanding of what is happening under MySQL's hood. It can help diagnose problems.

June 2007

GuppY : nouvelle évolution du CMS sans base de données MySQL at

by 1 other
GuppY est un CMS (content management system) gratuit. Il permet de réaliser un site internet de manière très simple. Pour utiliser le script il suffit de placer le contenu de l’archive en ligne et cela fonctionne. Oubliez les mots de passes MySQL, les sauvegardes via phpMyAdmin. Le site gère tous les grands classiques du genre : news, articles, forum, faq, sondage, newsletter, gallerie photos, liens et depuis cette version quelque chose pour lequel je me suis battu longtemps : le blog… compatibilité avec tous les OS, tous les navigateurs, support des CSS pour les habillages et de plugins pour ajouter des fonctions non-standard.