public marks

PUBLIC MARKS with tags mysql & admin





MySQL :: Download MySQL Workbench

by nicolargo
Administrer vos BD avec MySQL Workbench. Disponible sus licence GPL sous Linux, Mac et Windows...



Check Your Mysql Server Performance with MySQLTuner -- Debian Admin

by camel & 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.

Typical automated MySQL maintenance jobs

by dzc
Quelques tâches récurrentes, typiques avec MySQL Une bonne installation MySQL vient avec sa propre politique d'entretien : ces tâches qui ne doivent pas être exécutées trop souvent, mais permettent de gagner en performances et stabilité si elles sont régulièrement réalisées. Les quelles? Sauvegarde, nettoyage des logs binaires, optimisation des tables, vidange du cache de requêtes, rotation des logs binaires.


Outils d’administration, de gestion, et de supervision pour MySQL

by camel & 5 others
Je vais présenter dans ce billet 4 outils graphiques, vous permettant de gérer et de monitorer vos instances MySQL

Quelques astuces mysqldump

by dzc
mysqldump est un utilitaire mysql qui extrait des données d'une table, et produit des requêtes SQL. Cette dernière peut être stockée pour sauvegarde, ou bien renvoyée directement dans un client MySQL, pour être exécutée.


GPLHost:>_ Web hosting open source (GPL) control panel

by camel & 3 others
Domain Technologie Control (DTC) is a GPL control panel for hosting. Using a web GUI for admin and accounting all hosting services, DTC can delegate the task of creating subdomains, email, and FTP accounts to users for the domain names they own. DTC manages a MySQL database containing all the hosting information. It has support for many programs (bind 8 and 9 and compatibles, MySQL, Apache 1.3, php4, qmail, postfix 2, courier, dovecot, proftpd, webalizer, mod-log-sql, etc.) through config files and/or MySQL plugins (when the service is non-critical). It can also generate backup scripts, calculation scripts, and config files using a single system UID/GID and monitor all traffic accounting per user and per service. Since version 0.12, DTC is fully skinable and translated into several languages (Chinese, English, Spanish, French, Dutch, German, Italian, Russian, Hungarian, Romanian and Polish).

MySQL Performance Blog » Using LVM for MySQL Backup and Replication Setup

by dzc & 1 other (via)
"Pour sauvegarder des bases MySQL, une technique simple est d'exporter directement les fichiers MySQL . Il faut alors un système capable de faire des sauvegardes atomiques. La copie binaire de fichiers est extrêmement rapide et permet parfois de faire de la sauvegarde à chaud." (actu. Nexen)



PUBLIC TAGS related to tag mysql

***** +   [en] +   admin +   administration +   ajax +   apache +   application +   backup +   client +   cluster +   configuration +   control +   database +   db +   dba +   debian +   ftp +   gpl +   gui +   hosting +   lamp +   linux +   logiciel libre +   optimize +   performance +   php +   phpmyadmin +   plugin +   postfix +   programming +   replace +   sauvegarde +   script +   search +   server +   serveur +   sgbd +   sgdb +   smp +   springnet +   springnet blogmarks +   sql +   sysad +   tools +   web +   wordpress +  

Active users

last mark : 09/01/2014 08:27

last mark : 17/02/2013 21:41

last mark : 09/11/2011 19:42

last mark : 14/04/2010 20:57

last mark : 09/11/2008 16:35

last mark : 28/01/2008 01:14

last mark : 22/11/2006 13:08

last mark : 22/12/2005 06:16

last mark : 18/11/2005 05:43

last mark : 01/01/1970 01:00