The Joomla! Forum ™

Download

Demo


Board index » Joomla! Older Version Support » Joomla! 1.5 » Administration 1.5

Forum rules


Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.



Post new topic Reply to topic  Page 1 of 1
  [ 5 posts ] 
  Print view Previous topic | Next topic 
Author Message
asemili
 Post subject: Mysql crashing?
PostPosted: Sat May 12, 2012 10:12 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Sat May 12, 2012 1:43 pm
Posts: 3
I'm running Joomla 1.5 on an Ubuntu 12.04 EC2 Micro instance. Mysql is sometimes crashing / stopping and I found this in the /var/log/syslog

Code:
May 12 10:43:01 ip-10-202-18-193 kernel: [46106.736962] Out of memory: Kill process 707 (mysqld) score 131 or sacrifice child
May 12 10:43:01 ip-10-202-18-193 kernel: [46106.736980] Killed process 707 (mysqld) total-vm:889284kB, anon-rss:79356kB, file-rss:40kB
May 12 10:43:01 ip-10-202-18-193 kernel: [46106.950933] init: mysql main process (707) killed by KILL signal
May 12 10:43:01 ip-10-202-18-193 kernel: [46106.965710] init: mysql main process ended, respawning
May 12 10:43:02 ip-10-202-18-193 kernel: [46107.718122] type=1400 audit(1336819382.674:14): apparmor="STATUS" operation="profile_replace" name="/usr/sbin/mysqld" pid=7602 comm="apparmor_parser"
May 12 10:43:03 ip-10-202-18-193 kernel: [46108.361188] init: mysql main process (7606) terminated with status 1
May 12 10:43:03 ip-10-202-18-193 kernel: [46108.361224] init: mysql main process ended, respawning
May 12 10:43:04 ip-10-202-18-193 kernel: [46109.129996] init: mysql post-start process (7607) terminated with status 1
May 12 10:43:04 ip-10-202-18-193 kernel: [46109.147300] type=1400 audit(1336819384.102:15): apparmor="STATUS" operation="profile_replace" name="/usr/sbin/mysqld" pid=7630 comm="apparmor_parser"
May 12 10:43:04 ip-10-202-18-193 kernel: [46109.244960] init: mysql main process (7634) terminated with status 1
May 12 10:43:04 ip-10-202-18-193 kernel: [46109.244996] init: mysql respawning too fast, stopped


I googled and it looks like something unrelated to Joomla, maybe a bug with mysql, ubuntu or apparmor with 12.04 but I wanted to see if anyone here has seen this?

-Asemili
Top
 Profile  
 
RussW
 Post subject: Re: Mysql crashing?
PostPosted: Sat May 12, 2012 11:24 pm 
User avatar
Joomla! Exemplar
Joomla! Exemplar

Joined: Sun Oct 22, 2006 4:42 am
Posts: 9352
Location: Sunshine Coast, Queensland, Australia
the message sort of says it all;
Quote:
Out of memory: Kill process 707 (mysqld) score 131 or sacrifice child


You need to configure MySQL correctly for the amount of memory you have available.

_________________
Joomla! on the fabulous Sunshine Coast...
hotmango, web & print http://www.hotmango.me/
Network SMARTS, Systems Engineering http://www.networksmarts.com.au/
Top
 Profile  
 
asemili
 Post subject: Re: Mysql crashing?
PostPosted: Sun May 13, 2012 1:08 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Sat May 12, 2012 1:43 pm
Posts: 3
Ok thanks for the reply, I'm fairly new to mysql server-side configs but I'm not new to configuring servers. Is there any other tips or suggestions or things I can google to learn how to properly configure mysql for the amount of memory I have?
Top
 Profile  
 
RussW
 Post subject: Re: Mysql crashing?
PostPosted: Sun May 13, 2012 7:51 am 
User avatar
Joomla! Exemplar
Joomla! Exemplar

Joined: Sun Oct 22, 2006 4:42 am
Posts: 9352
Location: Sunshine Coast, Queensland, Australia
the MySQL site, basic mysql keyword googling to suit your problem.

_________________
Joomla! on the fabulous Sunshine Coast...
hotmango, web & print http://www.hotmango.me/
Network SMARTS, Systems Engineering http://www.networksmarts.com.au/
Top
 Profile  
 
asemili
 Post subject: Re: Mysql crashing?
PostPosted: Sun May 13, 2012 1:33 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Sat May 12, 2012 1:43 pm
Posts: 3
Thanks. I was able to post to another forum and the suggestion was that I need to tune my InnoDB performance and adjust my innodb_buffer_pool_size properly. I am taking the corrective actions.

I also believe I solved the problem for now by simply running sudo service webmin stop and sudo service proftpd stop which after doing that my server hasn't crashed in the timeframe it had been crashing in, but I still will tune my InnoDB performance properly.

I have googled "ubuntu mysql innodb_buffer_pool_size" and found some results which appear helpful.
Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  Page 1 of 1
  [ 5 posts ] 


Board index » Joomla! Older Version Support » Joomla! 1.5 » Administration 1.5

Who is online

Users browsing this forum: No registered users and 38 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group