Find Jobs
Hire Freelancers

SQL Database Settings & Optimization

$10-150 USD

Closed
Posted over 9 years ago

$10-150 USD

Paid on delivery
I run a game server on a dedicated host. The server used to run fine on a previous host until we were forced to move to another hosting company due to DDOS attacks. The game server has been running for about 3 weeks now and it is having problems with stability which I believe stem from the SQL Databases. On the previous host it would run perfect but now it lag spikes sometimes and causes the login /char server to disconnect from the map server. I optimized the database using MySQL tools and the problem got a bit better but it still persists during peak hours. According to [login to view URL] I need to re-adjust some settings on the [login to view URL], well I have tried to do so through SSH and Webmin and it shows that the setting is modified but when I run the tuner again in a few days I get the same out put...not sure if this is causing the lag and disconnections...and I am not sure if I am modifying the right file, but I should be..it's the only one.. This is the output the [login to view URL] shows: [login to view URL] Running MySQL on Ubuntu.. Need someone to check if the lag is from the mysql database also to check if I modified the settings properly and If i did, why the mysqltuner output says I haven't.. More info if you need it message me ENGLISH OR SPANISH - IS A MUST No over priced bids please...
Project ID: 6475729

About the project

8 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
8 freelancers are bidding on average $118 USD for this job
User Avatar
Hello, I'm a Network and System Administrator. If provided root ssh access and mysql root password, I can investigate and fine tune your existing configuration. This will include but not limited to apache, mysql and tcp configuration. Please see my feedback to evaluate my previous works, and shoot me your reply if you want to talk about this further. Regards, Aroel
$155 USD in 0 day
5.0 (159 reviews)
6.4
6.4
User Avatar
Hi, i can help you. .
$150 USD in 1 day
4.8 (73 reviews)
6.3
6.3
User Avatar
I have ran multiple high availability MySQL instance across multiple Linux platforms, however, the truly unique aspect about the way I work is I will ensure that you are happy with the results before the job is over. I have worked as a System Administrator and Systems Support Sr. Specialist solving problems of performance with various techniques on all different types of systems. I enjoy and can vouch for the work that I do. If you would like a copy of my resume as well and/or my business partner for verification I can provide both at your request. Thank you for your time!
$138 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$88 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Have total of 20 years of experience, Including 14 years as Oracle DBA. Proficient in ITIL processes and service Delivery. Have managed remotely 1200 Oracle Instances for different customers(45) which had a size ranging from 50 GB to 12 TB. Done migration project from Ms SQL to Oracle for a telecom company in Afghanistan. Also can support Ms SQL database environments.
$144 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
As a SQL developer i have good experience of performance tunning.
$111 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Margate, United States
5.0
11
Payment method verified
Member since Nov 23, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.