Sponsorised links
04 July 2008
01 July 2008
Nexen.net : portail PHP et MySQL - Trouver les index MySQL inutiles
by damdec
La requête utilise la base information_schema (MySQL 5.0 et supérieur), pour repérer les index dont la cardinalité est inférieure à 30% : c'est le niveau à partir duquel MySQL va décider que l'index est utile, et en dessous de ce niveau, MySQL décidera d'ignorer l'index et de tout analyser. Cela revient à décider de tout ranger quand le désordre est tellement grand que corriger les erreurs sera beaucoup plus long encore.
Sponsorised links
27 June 2008
24 June 2008
23 June 2008
Nexen.net : portail PHP et MySQL - Sortie de TPLN Php Template v2.9
by damdec
H2Lsoft, Société de services en logiciel libre, annonce la sortie de son moteur de template PHP estampillé 2.9.
Nexen.net : portail PHP et MySQL - L'art de la jointure : join-FU
by damdec
L'inénarrable Jay Pipes publie ses conférences sur le Join-Fu, l'art de maîtriser les jointures. Les deux conférences, données en Avril dernier à MySQL UC, sont toutes les deux très complètes, et pratiques. Jay suggère ne plus raisonner en boucle mais en ensembles, de réaliser des partitions verticales. C'est très long, mais vous y apprendrez sûrement comment améliorer vos requêtes SQL.
20 June 2008
PHP Performance Series: Maximizing Your MySQL Database - Mike Willbanks : getting into the mind of a php developer.
by damdec
In the first article of the PHP Performance Series, I focused on PHP Caching Techniques. This time I want to talk about maximizing your database. This article will deal mostly with MySQL, however, you should be able to note many of the different aspects even if you do not directly utilize MySQL.
19 June 2008
16 June 2008
How To Set Up A Load-Balanced MySQL Cluster With MySQL 5.1 | HowtoForge - Linux Howtos and Tutorials
by camel
This tutorial is based on Falko Timme's tutorial for MySQL Cluster 5.0. It shows how to configure a MySQL 5.1 cluster with five nodes: 1 x management, 2 x storage nodes and 2 x balancer nodes. This cluster is load-balanced by an Ultra Monkey package which provides heartbeat (for checking if the other node is still alive) and ldirectord (to split up the requests to the nodes of the MySQL cluster).
In this document I use Debian Etch 4.0 for all nodes. Therefore the setup might differ a bit for other distributions. The two data nodes were x64 to use all of the 8GB RAM. Servers were compiled from source so you should be able to make it running on any platform. The MySQL version I use in this setup is 5.1.24-rc. It's a release candidate, but I wanted to use 5.1 to take advantage of Memory-Disk Based tables.
Beginning with MySQL 5.1.6, it is possible to store the non-indexed columns of NDB tables on disk, rather than in RAM as with previous versions of MySQL Cluster.
14 June 2008
08 June 2008
06 June 2008
Tools | MySQL Performance Blog
by ddelangle
& 2 others
This page contains links to various tools we found helpful to use in practice.
Some tools are written by us, others by third parties, yet another ones may be shipped with your operating system you just need to find they are there.
Tools | MySQL Performance Blog
by kasi77
& 2 others
This page contains links to various tools we found helpful to use in practice.
Some tools are written by us, others by third parties, yet another ones may be shipped with your operating system you just need to find they are there.
04 June 2008
02 June 2008
29 May 2008
28 May 2008
26 May 2008
Benchmark d'un serveur MySQL - Tux-planet
by damdec
& 1 other
Voici une petite astuce qui permet de faire un benchmark très rapide sur un serveur MySQL, afin de vérifier ses performances.
23 May 2008
Nexen.net : portail PHP et MySQL - FireWall pour PHP et MySQL
by damdec
Tout le monde connaît les firewall, qui surveillent le contenu du trafic réseau, et imposent des limites à ce qui est possible de faire. Le même concept a été porté en PHP et MySQL.
