Sorry for the ambiguity. I'm testing the useful of adding indexes to one table for one type of query.
When I execute the same query for the second time it executes faster beacuse it's using the cache (the key_cache or the query cache if it is enabled). Is it possible to empty the key_cache (and also the query cache) without shutdown the mysql server? Iago Sineiro. -----Mensaje original----- De: Nils Valentin [mailto:[EMAIL PROTECTED] Enviado el: lunes, 09 de junio de 2003 12:48 Para: Iago Sineiro; MySql Mail List Asunto: Re: How to empty the cache? Hi Iago, I am unsure if I understand your question correctly, MySQL has a t least 5 different chaches (to name only the most important ones). key_cache table_cache thread_cache hostname_cache evt. disc cache (memory) or do you mean buffer variables ? sort_buffer record_buffer join_buffer_size myisam_sort_buffer net_buffer_length tmp_table_size I guess if you lookup any of the variables above you will quickly sort out the ones which applies to your question and the ones that don't. Sorry, but with the information given I am unable to be more precise. Best regards Nils Valentin Tokyo/Japan 2003年 6月 9日 月曜日 19:30、Iago Sineiro さんは書きました: > Hi. > > I'm doing some testings and I want to know how to empty the cache in mysql > (versions 3.23 and 4.0) between the differents tests. > > Iago Sineiro -- ================================================ Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp ================================================ ---Publicidad-------------------------------------------------------- nete a los miles de sin pareja en Meetic... ڡte vas a enamorar! http://www.iespana.es/_reloc/email.meetic -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
