Explore photos on a Map

Lire la suite...

Traduction de Prepared Statements and Query Cache (avant que l'original n'ai plus d'un an !!!)

Les requêtes préparées peuvent maintenant travailler avec le cache de requêtes.

Voyez plutôt:

 
  Enter password: *******
  Welcome to the MySQL monitor.  Commands END with ; or \g.
  Your MySQL connection id is 3
  Server version: 5.1.17-beta-community-nt-debug MySQL Community Server (GPL)
 	
 Type 'help;' or '\h' for HELP. Type '\c' to clear the buffer.
 
 
 mysql> SHOW global variables like '%query_cache%';
 +------------------------------+---------+
 | Variable_name                | Value   |
 +------------------------------+---------+
 | have_query_cache             | YES     |
 | query_cache_limit            | 1048576 |
 | query_cache_min_res_unit     | 4096    |
 | query_cache_size             | 8388608 |
 | query_cache_type             | ON      |
 | query_cache_wlock_invalidate | OFF     |
 +------------------------------+---------+
 6 rows in SET (0.02 sec)
 
 
 mysql> SHOW global status like '%qc%';
 +-------------------------+---------+
 | Variable_name           | Value   |
 +-------------------------+---------+
 | Qcache_free_blocks      | 1       |
 | Qcache_free_memory      | 8379648 |
 | Qcache_hits             | 0       |
 | Qcache_inserts          | 0       |
 | Qcache_lowmem_prunes    | 0       |
 | Qcache_not_cached       | 0       |
 | Qcache_queries_in_cache | 0       |
 | Qcache_total_blocks     | 1       |
 +-------------------------+---------+
 8 rows in SET (0.00 sec)
 	
 mysql> prepare tst FROM \"select broker_last_name from broker where office_location_id > 1\";
 Query OK, 0 rows affected (0.03 sec)
 Statement prepared
 	
 mysql> execute tst;
 +------------------+
 | broker_last_name |
 +------------------+
 | MCMILLIAN        |
 | MONSOUR          |
 | FRAZIER          |
 | HIGHT            |
 | KAELIN           |
 | MCMANUS          |
 | PERKINS          |
 | SANDERS          |
 | SCHWARTZ         |
 | SCHULTZ          |
 | JACKSON          |
 | FORD             |
 | CARRIER          |
 | BONNER           |
 | BOYCE            |
 | LEE              |
 | BRADY            |
 | HARBSMEIR        |
 +------------------+
 18 rows in set (0.00 sec)
 	
 mysql> execute tst;
 +------------------+
 | broker_last_name |
 +------------------+
 | MCMILLIAN        |
 | MONSOUR          |
 | FRAZIER          |
 | HIGHT            |
 | KAELIN           |
 | MCMANUS          |
 | PERKINS          |
 | SANDERS          |
 | SCHWARTZ         |
 | SCHULTZ          |
 | JACKSON          |
 | FORD             |
 | CARRIER          |
 | BONNER           |
 | BOYCE            |
 | LEE              |
 | BRADY            |
 | HARBSMEIR        |
 +------------------+
 18 rows in set (0.00 sec)
 	
 mysql> show global status like '%qc%';
 +-------------------------+---------+
 | Variable_name           | Value   |
 +-------------------------+---------+
 | Qcache_free_blocks      | 1       |
 | Qcache_free_memory      | 8378112 |
 | Qcache_hits             | 1       |
 | Qcache_inserts          | 1       |
 | Qcache_lowmem_prunes    | 0       |
 | Qcache_not_cached       | 0       |
 | Qcache_queries_in_cache | 1       |
 | Qcache_total_blocks     | 4       |
 +-------------------------+---------+
 8 rows in set (0.00 sec) 

Bien cool! Vérifiez quand même le manuel pour les restrictions

Kris Buytaert annonce la 3ème rencontre du groupe d'utilisateusr Belges de MySql !

Elle aura lieu le 15 février, juste le jour où je commence chez Skynet. Je ne sais donc pas encore si j'aurais la possibilité de m'y rendre.

En tout cas ca se passe près de Leuven.

Geert nous parlera de son déplacement à Orlando