This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm whether you accept or reject these cookies being set.

A cookie will be stored in your browser regardless of choice to prevent you being asked this question again. You will be able to change your cookie settings at any time using the link in the footer.

Using Droplet 512MB MySQL is Crashing very often
#1
[Solved] Using Droplet 512MB MySQL is Crashing very often
Any idea to avoid this situations with my control panel server.
 
I only have 4 website including one Wordpress site and 3 domains.

I want to improve the performance to increase the amount of sites y the server.

thanks a lot! Huh
Kreotuweb ---- Web solution in cuba.--- Web development & Web Design -- Hosting

[Image: K2w-logo.jpg]
Reply
Thanks given by:
#2
[Solved] RE: Using Droplet 512MB MySQL is Crashing very often
You need to review the logs to find out exactly why MySQL is shutting down.
(/var/logs/, /var/sentora/logs/)
You may also want to look into upgrading to at least 1gb ram also.
-TGates - Head of Support

SEARCH the Forums or read the DOCUMENTATION before posting!
Modules Maintained: 13 - Module Installs: 108k+

Find my support or modules helpful? Donate HERE
Get your domains using my affiliate link:
GoDaddy - Domains
Reply
Thanks given by:
#3
[Solved] RE: Using Droplet 512MB MySQL is Crashing very often
(05-06-2017, 03:43 AM)TGates Wrote: You need to review the logs to find out exactly why MySQL is shutting down.
(/var/logs/, /var/sentora/logs/)
You may also want to look into upgrading to at least 1gb ram also.

Thanks your help

that was what I find in var/log/mysql/error.log

170502  7:38:13 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
170502  7:38:13 [Note] Plugin 'FEDERATED' is disabled.
170502  7:38:13 InnoDB: The InnoDB memory heap is disabled
170502  7:38:13 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170502  7:38:13 InnoDB: Compressed tables use zlib 1.2.8
170502  7:38:13 InnoDB: Using Linux native AIO
170502  7:38:13 InnoDB: Initializing buffer pool, size = 32.0M
170502  7:38:13 InnoDB: Completed initialization of buffer pool
170502  7:38:13 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
170502  7:38:13  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
170502  7:38:13  InnoDB: Waiting for the background threads to start
170502  7:38:14 InnoDB: 5.5.54 started; log sequence number 577003798
170502  7:38:14 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
170502  7:38:14 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
170502  7:38:14 [Note] Server socket created on IP: '127.0.0.1'.
170502  7:38:14 [Note] Event Scheduler: Loaded 0 events
170502  7:38:14 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.54-0ubuntu0.14.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)

Can you help me to interpretate the log to find the specific problem.

In this moment I can not affor a droplet with 1GB RAM. For that reason I setup the swap space to see if it improve the server funtioning.

Thanks!
Kreotuweb ---- Web solution in cuba.--- Web development & Web Design -- Hosting

[Image: K2w-logo.jpg]
Reply
Thanks given by:
#4
[Solved] RE: Using Droplet 512MB MySQL is Crashing very often
Confused
Well, that is just the startup log and shows no errors of the shut down. We need the portion of the log right before and including the error/shut down information.
-TGates - Head of Support

SEARCH the Forums or read the DOCUMENTATION before posting!
Modules Maintained: 13 - Module Installs: 108k+

Find my support or modules helpful? Donate HERE
Get your domains using my affiliate link:
GoDaddy - Domains
Reply
Thanks given by:
#5
[Solved] RE: Using Droplet 512MB MySQL is Crashing very often
(05-06-2017, 04:53 AM)TGates Wrote: Confused
Well, that is just the startup log and shows no errors of the shut down. We need the portion of the log right before and including the error/shut down information.

for the moment is solved adding a swap space.
see the link how to add swap on Ubuntu 14.04
Kreotuweb ---- Web solution in cuba.--- Web development & Web Design -- Hosting

[Image: K2w-logo.jpg]
Reply
Thanks given by:


Possibly Related Threads...
Thread Author Replies Views Last Post
Increase MYsql file size Upload testing 17 754 11-21-2017, 06:22 AM
Last Post: TGates
MySQL Users Error salim24info 2 156 11-17-2017, 03:39 AM
Last Post: TGates
Does using old versions of PHP/MySQl affect app performance? divij 1 271 08-04-2017, 11:54 PM
Last Post: Me.B

Forum Jump:


Users browsing this thread: 1 Guest(s)