Re: mysql query cache [johnrembo @ 2009-04-23 14:27:45]

Tema: Re: mysql query cache
Autorius: johnrembo
Data: 2009-04-23 14:27:45
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=windows-1257" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18702">
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT size=2 face=Arial>na taip, pavyzdys mano nevykes (It refers to tables 
in the mysql or INFORMATION_SCHEMA system database. ), bet tai nekeicia reikalo 
esmes:</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT>&nbsp;</DIV>
<DIV><FONT size=2 face="Courier New">mysql&gt; SELECT sale_begin FROM nv_peb 
where id=2;<BR>+------------+<BR>| sale_begin |<BR>+------------+<BR>| 
2009-04-01 |<BR>+------------+<BR>1 row in set (0.00 sec)</FONT></DIV>
<DIV><FONT size=2 face="Courier New"><BR>mysql&gt; show global status like 
'%qcache%';<BR>+-------------------------+----------+<BR>| 
Variable_name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 
Value&nbsp;&nbsp;&nbsp; |<BR>+-------------------------+----------+<BR>| 
Qcache_free_blocks&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 
1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR>| 
Qcache_free_memory&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 16768384 |<BR>| 
Qcache_hits&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
| 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR>| 
Qcache_inserts&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 
0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR>| 
Qcache_lowmem_prunes&nbsp;&nbsp;&nbsp; | 
0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR>| 
Qcache_not_cached&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 
49&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR>| Qcache_queries_in_cache | 
0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR>| 
Qcache_total_blocks&nbsp;&nbsp;&nbsp;&nbsp; | 
1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
|<BR>+-------------------------+----------+<BR>8 rows in set (0.02 
sec)</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT>&nbsp;</DIV>
<DIV><FONT size=2 face=Arial>"Laimis" &lt;</FONT><A 
href="mailto:wiela@centras.lt"><FONT size=2 
face=Arial>wiela@centras.lt</FONT></A><FONT size=2 face=Arial>&gt; wrote in 
message </FONT><A href="news:gspdua$dea$1@trimpas.omnitel.net"><FONT size=2 
face=Arial>news:gspdua$dea$1@trimpas.omnitel.net</FONT></A><FONT size=2 
face=Arial>...</FONT></DIV><FONT size=2 face=Arial>&gt; johnrembo 
ra:<BR>&gt;&gt; na jo....ideja, vienok, nepasiteisino :\<BR>&gt; <BR>&gt; 
dmiai skaitei?:<BR>&gt; </FONT><A 
href="http://dev.mysql.com/doc/refman/5.1/en/query-cache-operation.html"><FONT 
size=2 
face=Arial>http://dev.mysql.com/doc/refman/5.1/en/query-cache-operation..html</FONT></A></BODY></HTML>