sslug-teknik team mailing list archive

[Robert Larsen <robert@xxxxxxxxxxxxxxxxx>]

Martin Møller Skarbiniks Pedersen wrote:
> 2010/4/9 Martin Berg <martin@xxxxxxx>:
> 
>>> 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,
> 
> root@quadcore:~# free | head -2
>              total       used       free     shared    buffers     cached
> Mem:       4057788    4020616      37172          0     394020    2110732
> 
> root@quadcore:~# sync ; echo 3 > /proc/sys/vm/drop_caches
> 
> root@quadcore:~# free | head -2
> 
>              total       used       free     shared    buffers     cached
> Mem:       4057788    1518816    2538972          0        432     119264
> 
> 

robert-desktop:~ $ /etc/init.d/mysql restart; sync ; echo 3 > /proc/sys/vm/drop_caches ; time mysql -u root -pblar gamelog -e "select count(*) from game_log_ng where match(log) against('+nano' in boolean mode)"
 * Stopping MySQL database server mysqld                                                                                                                                                         [ OK ]
 * Starting MySQL database server mysqld                                                                                                                                                         [ OK ]
 * Checking for corrupt, not cleanly closed and upgrade needing tables.
+----------+
| count(*) |
+----------+
|  5127025 |
+----------+

real	0m44.251s
user	0m0.004s
sys	0m0.000s
robert-desktop:~ $ /etc/init.d/mysql restart; sync ; echo 3 > /proc/sys/vm/drop_caches ; time mysql -u root -pblar gamelog -e "select count(*) from game_log_ng where log like '%nano%'" * Stopping MySQL database server mysqld                                                                                                                                                         [ OK ]
 * Starting MySQL database server mysqld                                                                                                                                                         [ OK ]
 * Checking for corrupt, not cleanly closed and upgrade needing tables.
+----------+
| count(*) |
+----------+
|  5127025 |
+----------+

real	0m14.047s
user	0m0.004s
sys	0m0.004s
robert-desktop:~ $



Der er stadig stor forskel på index og ikke-index...og jeg fatter stadig intet :-)

Attachment: signature.asc
Description: OpenPGP digital signature