In Progress

MySQL Database Administrator nedeed

MySQL optimizations nedeed, to resolve overloading server [url removed, login to view] will need to check the logs, and monitor the server to see any problem, and resolve it.

first this mysqltuner recommendations :

Reduce your overall MySQL memory footprint for system stability

Adjust your join queries to always utilize indexes

Temporary table size is already large - reduce result set size

Reduce your SELECT DISTINCT queries without LIMIT clauses

Variables to adjust:

*** MySQL's maximum memory usage is dangerously high ***

query_cache_size (> 128M)

join_buffer_size (> [url removed, login to view], or always use indexes with joins)

for this warnings:

Up for: 1d 0h 20m 53s

[!!] Maximum possible memory usage: [url removed, login to view] (95% of installed RAM)

!!] Joins performed without indexes: 3043

[!!] Temporary tables created on disk: 29% (501K on disk / 1M total)

[!!] Table cache hit rate: 11% (222 open / 2K opened)

it is also getting some errors, like

[ERROR] /usr/sbin/mysqld: Disk is full writing '/tmp/#[url removed, login to view]' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)

110310 12:27:05 [Warning] /usr/sbin/mysqld: Forcing close of thread 62940 user: '

From looking at the log at /var/log/messages I see that the server is running out of swap [url removed, login to view] it is just using little swap, but sometimes it goes out of swap.

and for some reason the server becomes unresponsive every day at the same hour .

The security of the server is also [url removed, login to view] day different ips try to login as root, or using ftp. i enabled cPHulk Brute Force Protection, but i think it needs more than that.

installing the CS Firewall was recommended by my host, Softlayer. [url removed, login to view]

Skills: Linux, MySQL

See more: joins performed without indexes, maximum possible memory usage, joins, expect, temporary tables created disk, writing result table, thread up, security administrator, mysql database server, mysql database free, maximum problem, free mysql server, brute force problems, nedeed, mysqltuner, mysqld forcing close thread, mysql free, free mysql, softlayer, server administrator, mysql error, mysql database administrator, linux firewall, it administrator, install database

About the Employer:
( 5 reviews ) baia, Romania

Project ID: #1256841

Awarded to:

nknk

Hi. That's my specialty. Please check PM.

$160 USD in 5 days
(172 Reviews)
7.0

21 freelancers are bidding on average $170 for this job

FandaR

Hello, I have over 8 years experience as a Linux admin. I can start now. Thank You

$250 USD in 1 day
(252 Reviews)
6.8
linuxfreak1985

Hi, this is linuxfreak and i am very interested to complete this project. please check your PM Box for further details

$200 USD in 1 day
(158 Reviews)
6.8
stels88

I can do this!

$250 USD in 1 day
(162 Reviews)
6.5
triamazikamno

13 years *nix experience, 7 years in high load web-hosting. I have a BSDA certificate.

$200 USD in 1 day
(55 Reviews)
6.3
t3nt3tion

I have checked your project details, and I`ve sent you a private message.

$250 USD in 1 day
(23 Reviews)
5.7
EugeneWHZ

Hello, I would like to help you with MySQL optimization and with securing your server. Please check PM for details.

$150 USD in 2 days
(53 Reviews)
5.7
jlfernandez

Hello, i´m a system administrator with 10+ years of experience. My knowledge is based in IP communications, Linux and Windows servers, Security and Virtual platforms. You have a PM.

$150 USD in 3 days
(8 Reviews)
5.0
freelancerbuzzo

Ready to start right now.

$250 USD in 5 days
(11 Reviews)
4.4
sobhnath

I am very interested to complete this project, please check your PM Box for further details

$225 USD in 2 days
(11 Reviews)
4.3
INNOSolution

I have over 10 years of experience as linux sysadmin. I've optimized many servers along the years, especially for magento/various cms.

$150 USD in 2 days
(15 Reviews)
4.1
tommanning1982

I have hands on experience in Linux and MySQL administration. Please check your PM. :)

$175 USD in 2 days
(7 Reviews)
3.8
Adnan853

Hello Sir, I am ready to start . Please see details in pmb and reply me for discussion. Thank You. Sincerely Adnan

$105 USD in 2 days
(2 Reviews)
3.2
chetanneo

Hi , Please check PM.

$150 USD in 3 days
(2 Reviews)
3.2
linusworld

Hi, Expert Mysql DBA and Linux admin, pl. check PM

$100 USD in 2 days
(1 Review)
1.0
vishu7

We are a Software Company with staff having over 100 Man years experience in IT Solutions ,Website Design and Web Applications in PHP/MySQL/WordPress with Linux / Windows Server.

$250 USD in 3 days
(0 Reviews)
0.0
hitgon

DBA Expert

$100 USD in 7 days
(0 Reviews)
0.0
krzysztofk

If you are looking for certified MySQL DBA, I'm willing to help. 4 years of experience. Please check your pm.

$200 USD in 2 days
(0 Reviews)
0.0
satyapalgarhwal

ready to work with u ....... Mysql DBA ..... Payment after complete work ...

$140 USD in 2 days
(0 Reviews)
1.8
markoljpetrovic

let's do it

$50 USD in 1 day
(1 Review)
0.0
server4sale

We are specialized in this. We have over 2000+ servers. We are starting to provide support services like this. We are also platinum reseller of softlayer as well. You can also try to get into [url removed, login to view] and see More

$75 USD in 1 day
(0 Reviews)
0.0