PUBLIC   marks

PUBLIC MARKS with tag mysql

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

Shift

by marco (via)
The Shift project was started in May 2008 as a fork of the apparently defunct CocoaMySQL project. Whouhou !

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.

PUBLIC TAGS related to tag mysql

no tag

Sponsorised links