<div dir="ltr">Hi Daniel,<div><br></div><div>Thanks for the reply. I end up doing the following to solve the issue:<br></div><div><br></div><div>I've empty all cache tables (had a backup before that just in case that it doesn't work) and then I dropped both roundcube and kolab which use innodb structure.</div><div><br></div><div>After that I shutdown mysql and deleted the </div><div>ib_logfile0 and ib_logfile1 along with ibdata1.<br></div><div><br></div><div>Then I edit the my.cnf and added:</div><div><pre style="color:rgb(0,0,0)">innodb_file_per_table
innodb_flush_method=O_DIRECT
innodb_log_file_size=1G
innodb_buffer_pool_size=4G</pre><pre style="color:rgb(0,0,0)">and started again mysql.</pre><pre style="color:rgb(0,0,0)">Everything worked great and size is minimal now:</pre><pre style><font color="#000000">root@kolab1:/var/lib/mysql# ls -la
total 2117696
drwx------ 7 mysql mysql 4096 Mar 8 09:36 .
drwxr-xr-x 46 root root 4096 Mar 7 02:40 ..
-rw-r--r-- 1 root root 0 Feb 23 04:38 debian-5.5.flag
-rw-rw---- 1 mysql mysql 1073741824 Mar 8 13:44 ib_logfile0
-rw-rw---- 1 mysql mysql 1073741824 Mar 8 03:05 ib_logfile1
-rw-rw---- 1 mysql mysql 18874368 Mar 8 13:44 ibdata1
drwx------ 2 mysql mysql 4096 Mar 7 04:56 kolab
drwx------ 2 mysql root 4096 Feb 23 04:38 mysql
-rw------- 1 root root 6 Feb 23 04:38 mysql_upgrade_info
drwx------ 2 mysql mysql 4096 Feb 23 04:38 performance_schema
drwx------ 2 mysql mysql 4096 Mar 7 02:40 phpmyadmin
drwx------ 2 mysql mysql 4096 Mar 7 04:58 roundcube<br></font></pre><pre style="color:rgb(0,0,0)">Thanks</pre><pre style="color:rgb(0,0,0)"><span style="font-family:arial,sans-serif;color:rgb(34,34,34)">Stelios</span><br></pre></div><div class="gmail_extra">
<br><div class="gmail_quote">On 7 March 2015 at 12:19, Daniel Hoffend <span dir="ltr"><<a href="mailto:dh@dotlan.net" target="_blank">dh@dotlan.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">nope they have relations to kolab_folders<br>
<br>
it's safe to delete stuff from kolab_folders which then descenent to delete kolab_cache_*<br>
but the cache will fill up again at some point.<br>
<br>
or use the modcache script<br>
<br>
cd /usr/share/roundcubemail/<br>
plugins/libkolab/bin/modcache.<u></u>sh clear<br>
<br>
------ Originalnachricht ------<br>
Von: "Stelios A." <<a href="mailto:stelios.a@gmail.com" target="_blank">stelios.a@gmail.com</a>><br>
An: "<a href="mailto:users@lists.kolab.org" target="_blank">users@lists.kolab.org</a>" <<a href="mailto:users@lists.kolab.org" target="_blank">users@lists.kolab.org</a>><br>
Gesendet: 07.03.2015 08:53:46<br>
Betreff: kolab_cache_event contact & file huge<div class="HOEnZb"><div class="h5"><br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi all,<br>
<br>
I've got a huge ibdata1 file under mysql (32G)<br>
After checking the tables I've noticed that those that consume that disk space are:<br>
<br>
kolab_cache_event<br>
kolab_cache_contact<br>
kolab_cache_file<br>
kolab_cache_task<br>
<br>
Is it safe to empty them?<br>
<br>
Stelios</blockquote>
</div></div></blockquote></div><br></div></div>