Question

MySQL crashing now and then. Can u help me with log?

Posted August 31, 2014 2.5k views

Hello, I’m facing some MySQL crashes. I’m on a Ubuntu 12.04.5 LTS X64 (The most basic droplet) and using “SELECT VERSION();” I got MySQL version 5.5.38-0ubuntu0.12.04.1

I have Zpanel installed, because for now I don’t have that many customers to use something as good as Cpanel. I have 3 sites on that server, my newest.

I don’t know what’s causing this crashes and maybe you guys could help out seeing the log. Can you? Please?

Log file: http://vulcanus.com.br/MySQL.txt

Add a comment
jntslvdrt
By:
jntslvdrt
Add a comment
1 comment
  • nineinchnails August 31, 2014
    Reply Report

    My best advice would be to separate all your sites in different droplets and different droplets to host databases as well, instead of jamming everything in the same space.

    At the end of the day, you pay the same and have a more tidy work.

    If you read the first lines in the log it says InnoDB engine is not supported. Perhaps some table is created to use InnoDB.

    To show installed MySQL Engines:
    SHOW ENGINES;

    To show how a particular table is created:
    use my_database;
    SHOW CREATE TABLE my_table;

    Regards.

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

1 answer
jntslvdrt August 31, 2014

Fuc* me! That’s why I do need to learn more about MySQL I don’t figured out nothing you said about it.

I’m planning to put each service (email, DB’s, Apache) into separated droplets as you advice. But actually I’m on Zpanel and this system is almost abandoned in favor of Sentora. So I can’t get support by now to split up these services into different droplets using Zpanel (Now Sentora). I’ll wait for official Sentora release.

I did resize my 512MB to 1GB (10$ bucks plan). But I still experiencing some crashes. I’m doing stress tests with http://loadimpact.com/ and my droplet crashes about 20 simultaneous visitors. It seems that Apache is taking as much as RAM as MySQL.
For now I’ll add swap into my 1GB droplet and see if it helps at all.

Reply Report
Submit an Answer

Looking for something else?

Ask a new question Search for more help