background preloader

Mysql

Facebook Twitter

Travaux   2doc. 2doc. DbNinja - Une alternative sérieuse à phpMyAdmin pour MySQL. Top 10 MySQL GUI Tools. Many third parties create rich applications to facilitate database management, database development and database administration.

Top 10 MySQL GUI Tools

Here are ten outstanding graphical interfaces for MySQL. Most relational databases, with the notable exception of MS Access, are comprised of two distinct components: the back-end, where the data is warehoused, and the front-end, a user interface for communicating with the data component. This type of design is quite clever, as it parallels the two-tier programming model that separates the data layer from the user interface and allows the makers of the database software focus on their product's strongest suit: data storage and management. It also opens the door for third parties to create rich applications to interact with various databases. Such products include Embarcadero Rapid SQL and Oracle SQL Developer. Cracker un mot de passe MySQL. Five simple ways to tune your LAMP application. Introduction Major web properties like Wikipedia, Facebook, and Yahoo!

Five simple ways to tune your LAMP application

Use the LAMP architecture to serve millions of requests a day, while web application software like Wordpress, Joomla, Drupal, and SugarCRM use this architecture to enable organizations to deploy web-based applications easily. The strength of the architecture lies in its simplicity. While stacks like .NET and Java™ technology may use massive hardware, expensive software stacks, and complex performance tuning, the LAMP stack can run on commodity hardware, using open source software stacks.

Because the software stack is a loose set of components rather than a monolithic stack, tuning for performance can be a challenge since each component needs to be analyzed and tuned. However, there are several simple performance tasks that can have a huge impact on the performance of websites of any size. Back to top Use an opcode cache.

Nordbeastie. Méthodes de suppression des index inutiles « dbnewz. Les vacances étant terminées, nous allons boucler notre tour de vue des index inutiles en voyant quels outils vont nous aider à découvrir les index qui peuvent être supprimés.

Méthodes de suppression des index inutiles « dbnewz

Le dernier article présentait en effet des indications qui fonctionnent généralement bien mais qui ont l’inconvénient de demander beaucoup de travail manuel et de laisser de côté tout un pan d’index qui peuvent être inutiles : ceux qui ne sont pas en doublon ni redondants, qui n’ont pas une cardinalité faible mais qui ne sont tout simplement pas utilisés par l’application. Idée générale Si vous avez bien lu l’article précédent, vous avez probablement remarqué que la principale difficulté est qu’il n’existe quasiment jamais de règle absolue permettant de savoir à coup sûr qu’un index est inutile (exception notable : les index en doublon repérés par mk-duplicate-key-checker et qui peuvent être supprimés dans 99% des cas sans problème).

101 Tips to MySQL Tuning and Optimization at Monitor.Us Free Monitoring. MySQL is a powerful open-source database.

101 Tips to MySQL Tuning and Optimization at Monitor.Us Free Monitoring

With more and more database driven applications, people have been pushing MySQL to its limits. Here are 101 tips for tuning and optimizing your MySQL install. Some tips are specific to the environment they are installed on, but the concepts are universal. I have divided them up into several categories to help you with getting the most out of MySQL: MEET-UP SkySQL 20 avril - AL'X COMMUNICATION. 7.9.3 How MySQL Uses Threads for Client Connections. MySQL Partitioning: A Flow Chart  Recovering Innodb table Corruption. Assume you’re running MySQL with Innodb tables and you’ve got crappy hardware, driver bug, kernel bug, unlucky power failure or some rare MySQL bug and some pages in Innodb tablespace got corrupted.

Recovering Innodb table Corruption

In such cases Innodb will typically print something like this: InnoDB: Database page corruption on disk or a failed InnoDB: file read of page 7. And crash with assertion failure. So what can you do to recover such a table ? Ways to repair MYSQL Databases. 8.7 Utiliser mysqlcheck pour l'entretien et la réparation. Tunning MySQL InnoDB performance. Tunning MySQL InnoDB storage engine is not an easy task.

Tunning MySQL InnoDB performance

It’s more like a game where you set mini goals and then try to find the right value and achieve them. Playing with the InnoDB variables is an art where you have to check your performance results each time you change a configuration parameter. The start point of this game is your MySQL my.cnf file. The optimal configuration depends on your hardware and on the type of workload you are running. MySQL show status - show open database connections. By Alvin Alexander.

MySQL show status - show open database connections

Mémo - MySql, PHP, RvDevsign. Installer et configurer MySQL sur Debian. Bien qu'il décrive une procédure relativement commune, ce manuel vous permettra d'installer rapidement un Mysql disposant d'une sécurité minimum sur Debian 4.0 Etch ou 5.0 Lenny.

Installer et configurer MySQL sur Debian

Cet article a été testé sur les distributions suivantes : Debian 4.0 EtchDebian 5.0 LennyDebian 6.0 Squeeze Cet article nécessite que vous soyez identifié en tant que super utilisateur root. Virtual IP Addresses and Their Discontents for Database Availability. Virtual IP addresses or VIPs are commonly used to enable database high availability.

Virtual IP Addresses and Their Discontents for Database Availability

A standard failover design uses an active/passive DBMS server pair connected by replication and watched by a cluster manager. The active database listens on a virtual IP address; applications use it for database connections instead of the normal host IP address. Should the active database fail, the cluster manager promotes the passive database server and shifts the floating IP address to the newly promoted host.

Application connections break and then reconnect to the VIP again, which points them to the new database. Virtual IP addresses are enticing because they are completely transparent to applications--no changes to database API behavior, no changes to connection strings, etc. Passer de MySQL à MariaDB. Mise à jour 16/10/2011: Dans la première version j’utilisais l’ancienne version stable de MariaDB (5.1), suite au commentaire de Guillaume je l’ai mis à jour pour utiliser la version 5.2.

Passer de MySQL à MariaDB

Depuis quelques temps, Oracle ne se sent plus pisser: Ils rachètent Sun, ils ferment les sources des logiciels qu’ils possèdent, ils font des procès pour gagner des thunes,… Ils ont tué OpenOffice. Tips, Suggestions, and Findings: How to Log User Connections in MySQL. There is nothing that MySQL 5.1 explicitly performs to log user connections, but there is a combination of MySQL commands that can log user connections without having to turn on the general query log. I repeat: you do not have to turn the general query log on to make this work! Would you like to find out what that is?

Ingredients init-connect See it coming together? Alrighty, here's the recipe... SPAM - ClissXXI. De ClissXXI. [modifier] Principes et problèmes du SPAM Le mail circule via Internet via le protocole protocole SMTP et en se basant sur IP et DNS. Le problème: il n'y a aucune identification, et envoyer du courriel est pour ainsi dire gratuit, par conséquent toute boîte au lettre peut être remplie de spam par n'importe qui, sans la contrainte de coût du courrier postal. Depuis plusieurs années, à mesure que ce phénomène gagne en puissance, diverses solutions ont été mises en oeuvre.

Shinguz's Blog (en): MySQL Cluster - Cluster circular replication with 2 replication channels. 10 things in MySQL (that won't work as expected). (I just discovered cracked.com) #10. Searching for a NULL 2.FROM a 3.WHERE a.column = NULL In SQL, a NULL is never equal to anything, even another NULL. MyTAP. 30 questions sur MySQL – Réponses de la partie 1 « dbnewz. Et voici comme promis les réponses de la 1ère partie du quiz. Dans la mesure du possible, j’ai ajouté quelques petits commentaires pour expliquer le pourquoi du comment. 1- b : Toutes les ressources doivent etre étanches entre les instances.