Build a website

Closed Posted Oct 26, 2014 Paid on delivery
Closed Paid on delivery

My website has gone down with an "error establishing database connection". The people who host the site have said I need to try something in the command line. Which I don't have the skills to do.

The email from then said ...

The most common reason why MySQL is not running is that it stopped or failed to start as a result of not enough memory.

This can usually be seen by attempting to start the mysql server ("service mysql start" on Ubuntu and some other systems) and then reviewing the mysql error log (usually in /var/log/mysql/[url removed, login to view] or similar file path).

A useful program to review the logs one page at a time is "less" –for example:

less /var/log/mysql/[url removed, login to view]

If you see memory issues such as "mmap can't allocate" then you can be sure that you are having memory issues.

Potential solutions are:

1) upsize to a larger server. We recommend at least a 1GB droplet for any server utilizing a MySQL database.

2) Enable swap space, which functions in the same way as RAM, except it's slower since it's using disk space to simulate RAM. Your system uses this only in the case where you run out of RAM, and it'll likely result in slower responses from your site, but if you add enough swap (generally twice as much as the amount of RAM you have is a safe bet) it should prevent MySQL from crashing and causing your site to go down. You can find a guide relevant to your Linux distribution here: [url removed, login to view]

3) Optimizing MySQL with mysqltuner. On your server there is a file: /etc/mysql/[url removed, login to view] that sets the basic configuration settings of your MySQL service. It controls how much RAM MySQL will try to use, and in what way. The MySQLtuner utility takes a look at certain log files and other information regarding how your MySQL server is functioning and gives you a diagnosis on how efficiently it is performing. At the bottom will be a list of configuration changes you can make to your config file. The longer your server has been running before using MySQLtuner, the more accurate the information it gives you will be.

-------

In short I need help getting it back up today.

Graphic Design HTML PHP Website Design

Project ID: #6643709

About the project

7 proposals Remote project Active Dec 2, 2014

7 freelancers are bidding on average $119 for this job

SoulVagrant

Hello, I manage servers at DigitalOcean and Amazon Web Services using cPanel. I can upsize your server and create a swap memory file. Please, contact me fore more details. Best regards

$100 USD in 3 days
(15 Reviews)
4.8
optimizmo

Hello, do you still experience problems with your MySQL server? If so, I can offer my assistance in getting your server alive. If interested, feel free to contact me. Regards, Alexander

$100 USD in 1 day
(11 Reviews)
3.8
nesawebcreations

Hello, We can do this task. Please feel free to ask if you have any questions. Looking forward to your response. Thanks

$155 USD in 1 day
(1 Review)
1.5
Mdano

Hello, I manage linux servers since years. I know mysql and can easily help you for troubleshooting it. First thing is to find out why mysql don't start anymore. It could be a memory issue, data corruption or daemo More

$77 USD in 1 day
(0 Reviews)
0.0
dagmie2

I will help you solve the problem for certain. even you could do it if u wanted to but it appears u didnt want to take risk.

$100 USD in 3 days
(0 Reviews)
0.0
javaidurrehman

A proposal has not yet been provided

$55 USD in 1 day
(0 Reviews)
0.0
probsolv33

Hi, It looks like your website has become too big for the resources you have, if you have ssh access we can check quickly where the resources are being used, we would then optimise and allocate resources to your serve More

$244 USD in 2 days
(0 Reviews)
0.0