<div class="gmail_quote">On Wed, Feb 11, 2009 at 8:30 AM, Armin Medosch <span dir="ltr"><<a href="mailto:armin@easynet.co.uk">armin@easynet.co.uk</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi<br>
<br>
sorry for previous message which went out by mistake.<br>
<br>
I am using drupal 5.14 on a virtual machine with 512M Ram allocated<br>
(ubuntu server configuration). First the database and now apache toppled<br>
over, as it looks, because the system went out of memory.</blockquote><div><br>You say a virtual machine, and yet later on you say your host does not want you to install PhpMyAdmin... Which means you do not seem to have complete control over the administration of your server.<br>
<br>So I would ask your hosting to update the lamp stack, first of all.<br><br>Secondly, you have one instance of the watchdog table being corrupted, which happens. And a single instance of the Apache server crashing...<br>
<br>Keep monitoring after everything is updated.<br><br>Victor <br> </div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
However, I think 512 should be decent enough, I havent that awful lot of<br>
additional modules installed and there is not such heavy traffick on the<br>
site. When the database fell over it generated an error message about<br>
duplicate entry in watchdog, so I repaired that. everything seemed fine<br>
for a couple of days, then last night apache said goodbye.<br>
<br>
What can I do to prevent that? is there a way to clean the database in a<br>
way that goes beyond repairing tables (I am not very advanced in command<br>
line mysql but my host does not want phpmyadmin to be installed)<br>
is there a way from stopping mysql growing and growing? Subsequent<br>
mysqldumps result in ever growing files, in no proportion to the amount<br>
of new content.<br>
<br>
Glad for any pointers to step by step howtos or any other advice<br>
cheers<br>
armin<br>
<font color="#888888"><br>
<br>
--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br>
</font></blockquote></div><br>