[an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] (none) [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] (none) [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive]
 
[an error occurred while processing this directive] [an error occurred while processing this directive]
Skåne Sjælland Linux User Group - http://www.sslug.dk Home   Subscribe   Mail Archive   Forum   Calendar   Search
MhonArc Date: [Date Prev] [Date Index] [Date Next]   Thread: [Date Prev] [Thread Index] [Date Next]   MhonArc
 

Re: [TEKNIK] MySQL fulltext search



Martin Møller Skarbiniks Pedersen wrote:
> 2010/4/9 Martin Berg <sslug@sslug>:
> 
>>> Tjah. Man kan flush ikke-dirty objecter fra cachen vha.
>>> echo 3 > /proc/sys/vm/drop_caches
>>>
>>> Mvh
>>> Martin
>>>
>>>
>> Tak - den kendte jeg ikke
>>
> 
> Husk forresten også sync før, så du har færre dirty objects.
> Et eksempel, hvor jeg sletter ca. 2GB fra hukommelsen.
> Kig på cached tallet,
> 
> sslug@sslug:~# free | head -2
>              total       used       free     shared    buffers     cached
> Mem:       4057788    4020616      37172          0     394020    2110732
> 
> sslug@sslug:~# sync ; echo 3 > /proc/sys/vm/drop_caches
> 
> sslug@sslug:~# free | head -2
> 
>              total       used       free     shared    buffers     cached
> Mem:       4057788    1518816    2538972          0        432     119264
> 
> 

robert-desktop:~ $ sync ; echo 3 > /proc/sys/vm/drop_caches ; time mysql -u root gamelog -e "select count(*) from game_log_ng where match(log) against('+nano' in boolean mode)"
+----------+
| count(*) |
+----------+
|  5127025 |
+----------+

real	0m41.384s
user	0m0.012s
sys	0m0.012s
robert-desktop:~ $ sync ; echo 3 > /proc/sys/vm/drop_caches ; time mysql -u root gamelog -e "select count(*) from game_log_ng where log like '%nano%'"
+----------+
| count(*) |
+----------+
|  5127025 |
+----------+

real	0m10.882s
user	0m0.004s
sys	0m0.000s
robert-desktop:~ $

Det ser stadig ud til at index er en hel del langsommere :-(


 
Home   Subscribe   Mail Archive   Index   Calendar   Search

 
 
Questions about the web-pages to <www_admin>. Last modified 2010-05-01, 02:01 CEST [an error occurred while processing this directive]
This page is maintained by [an error occurred while processing this directive]MHonArc [an error occurred while processing this directive] # [an error occurred while processing this directive] *