Find Jobs
Hire Freelancers

Build a website

$30-250 USD

Cerrado
Publicado hace más de 9 años

$30-250 USD

Pagado a la entrega
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/[login to view URL] or similar file path). A useful program to review the logs one page at a time is "less" –for example: less /var/log/mysql/[login to view URL] 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: [login to view URL] 3) Optimizing MySQL with mysqltuner. On your server there is a file: /etc/mysql/[login to view URL] 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.
ID del proyecto: 6643709

Información sobre el proyecto

7 propuestas
Proyecto remoto
Activo hace 9 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
7 freelancers están ofertando un promedio de $119 USD por este trabajo
Avatar del usuario
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 en 3 días
5,0 (15 comentarios)
4,8
4,8
Avatar del usuario
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 en 1 día
5,0 (11 comentarios)
3,8
3,8
Avatar del usuario
Hello, We can do this task. Please feel free to ask if you have any questions. Looking forward to your response. Thanks
$155 USD en 1 día
5,0 (1 comentario)
1,5
1,5
Avatar del usuario
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 daemon configuration issue. For memory issue it's easy to fix it using swap but your server could become slow. I can provide you data backup if you need upsize to a new one. In case of database corruption, the process is to backup database files and try a recovery. Best regards
$77 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$55 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 server and the database. However we cannot be 100% your site will be back in a day or two because we haven't had a good look at the hardware and software you have. We have hosting facilities and technical expertise to provide or recommend a good solution. regards, Freddy..
$244 USD en 2 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED KINGDOM
United Kingdom
0,0
0
Miembro desde oct 26, 2014

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.