Find Jobs
Hire Freelancers

Optimize my.cnf settings on linux sever

£10-20 GBP

Lukket
Slået op over 7 år siden

£10-20 GBP

Betales ved levering
I run a website for my customers where it gets extremely busy during peak hours. top command shows mysql at 300%. This is because we have a lot of simultaneous entries being made on the database - approx 1000 entries per min during peak hours. At this point server goes down and my customers start facing problems and inconvenience. I need someone to look at the below config and advice what needs changing. Server Info CPU GenuineIntel, Intel(R) Xeon(R)CPU E3-1270 v3 @ 3.50GHz Version Plesk v12.0.18_build1200140606.15 os_CentOS 6 16GB RAM This is my current configuration [mysqld] bind-address=[login to view URL] datadir=/var/lib/mysql socket=/var/lib/mysql/[login to view URL] user=mysql symbolic-links=0 local-infile=0 max_connections = 600 max_user_connections=1000 key_buffer_size = 512M myisam_sort_buffer_size = 512M read_buffer_size = 1M table_open_cache = 5000 thread_cache_size = 384 wait_timeout = 300 connect_timeout = 300 tmp_table_size = 768M max_heap_table_size = 256M max_allowed_packet = 64M net_buffer_length = 16384 max_connect_errors = 150 concurrent_insert = 2 read_rnd_buffer_size = 786432 bulk_insert_buffer_size = 8M query_cache_limit = 4M query_cache_size = 256M query_cache_type = 1 query_prealloc_size = 262144 query_alloc_block_size = 65535 transaction_alloc_block_size = 8192 transaction_prealloc_size = 4096 max_write_lock_count = 8 slow_query_log log-error external-locking=FALSE open_files_limit=50000 innodb_buffer_pool_size=8G [mysqld_safe] log-error=/var/log/[login to view URL] pid-file=/var/run/mysqld/[login to view URL] [mysqldump] quick max_allowed_packet = 64M [isamchk] key_buffer = 384M sort_buffer = 384M read_buffer = 256M write_buffer = 256M [myisamchk] key_buffer = 384M sort_buffer = 384M read_buffer = 256M
Projekt-ID: 11900503

Om projektet

29 forslag
Projekt på afstand
Aktiv 7 år siden

Leder du efter muligheder for at tjene penge?

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme
Bliv betalt for dit arbejde
Oprids dit forslag
Det er gratis at skrive sig op og byde på jobs
29 freelancere byder i gennemsnit £33 GBP på dette job
Brug Avatar.
Hi, I will do optimization,will do memcache,install nginx for balance load. In server optimization will do this: Unused services packages removal Apache server optimization perform module for apache mysql optimization Apache,mysql,kernel version to stable version whm/cpanel server to stable version Disk Space optimization Inode Disk space optimization memcache module for mysql Install nginx: 1. Configure Ngnix for caching 2. Install Ngnix Server on any Linux VPS or Windows 3. Integrate it with Apache to get best of both Apache & Ngnix. 4. Create Multiple Server Blocks(Virtual Hosts) 5. Setup HTTPS 6. Rewrite ht access 7. reverse proxy server Thank you
£88 GBP på 1 dag
4,9 (343 anmeldelser)
6,9
6,9
Brug Avatar.
Do you have root access to your server?. I'm looking forwards to your response. Thank you.
£30 GBP på 1 dag
5,0 (167 anmeldelser)
6,4
6,4
Brug Avatar.
A proposal has not yet been provided
£113 GBP på 1 dag
4,9 (110 anmeldelser)
6,5
6,5
Brug Avatar.
Yes, let's clarify the requirement and let me know if you Would like to check our portfolio. Here to hope you soon. Best regards Moumita
£72 GBP på 2 dage
4,9 (74 anmeldelser)
6,4
6,4
Brug Avatar.
Dear Employer, Convert the query_cache_type to 2. This setting will cache the queries on demand. Do not cache every query. cache the queries that are only required repeatedly.
£18 GBP på 1 dag
5,0 (131 anmeldelser)
5,3
5,3
Brug Avatar.
Hello, I have extensive experience with MySQL and server optimisation. Looking at your current MySQL conf file, it is not obvious if you are running innodb or myisam table formats in your MySQL instance, if you would like to contact me with some additional information, we can look at some options and optimisations to get your server running at peak performance. Other than MySQL performance tuning, application layer caching could also be of benefit in some circumstances. We can chat about that further as well. Thank you.
£88 GBP på 1 dag
5,0 (16 anmeldelser)
5,5
5,5
Brug Avatar.
Hi CPU peak you observing related to misusing\missing indexes i database. I can find and fix that issue(issues) in fast and efficient manner including production server. See my porject history for references. All the best Alexei
£23 GBP på 3 dage
4,9 (55 anmeldelser)
5,4
5,4
Brug Avatar.
i am mysql dba having more then 10 yrs of experience,,.............................................................................................................
£18 GBP på 1 dag
4,9 (44 anmeldelser)
5,1
5,1
Brug Avatar.
The MySQL servers stats are the most important thing to check and then according to them modify my.cnf. There is an excellent script that when run shows what to modify and in most cases this will do the trick. I will provide the URL if you hire me. Best regards, Tomislav Crnicki Croatia/EU
£35 GBP på 1 dag
5,0 (12 anmeldelser)
4,5
4,5
Brug Avatar.
Hello, We can help you out with this. problem. We are very sure that its a task of 1-2 days max, as you have described some problems in the post itself. This time when I m bidding on this job, it has already nearly 25 bids, but I am damn sure that we can do this task, so this shows how sure we are to help you out with this problem. Just give us the website, issues, and we will do the work before the job is assigned and you can pay once the work is done. we hare nearly 7 years, of exp, in working with codeigniter, so its not a big deal, we have our clients world wide, whom we sell the Vehicle Tracking system which accepts data for around 5000 devices. which sends data to server at every 1 minute, 24/7, so for every second we are having lots of data coming into the server and we have all the VPS servers running linux CentOS 6/7. So consider our bid also, I know its late in bidding for the right job. but the confidence matters. Regards, Kunal SilverLInes.
£18 GBP på 1 dag
5,0 (4 anmeldelser)
2,6
2,6
Brug Avatar.
hi.. have you run mysqltuner application ? it will help us to give best value to mysql server performance.
£20 GBP på 1 dag
5,0 (6 anmeldelser)
2,6
2,6
Brug Avatar.
Hello! I`m Slava and can help you to solve this loading issue. I have rich experience with similar projects. I can start right now and don`t need much time for this work If you have any questions feel free to contact me Best wishes, Slava
£17 GBP på 1 dag
5,0 (2 anmeldelser)
1,4
1,4
Brug Avatar.
Hello, I am expert Ubuntu 16.04 LTS Xenial Xerus. I can start your project now to complete on time on delivery. Just give me money when u r happy :) Thanks, Sagar
£40 GBP på 0 dag
0,0 (1 bedømmelse)
0,0
0,0
Brug Avatar.
Hello My name is Guillermo, What I can do for you will be 1. Tune configuration 2. Provide server audit
£23 GBP på 1 dag
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
You should also take a look on your kernel settings
£18 GBP på 1 dag
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
A proposal has not yet been provided
£13 GBP på 1 dag
0,0 (0 anmeldelser)
0,0
0,0

Om klienten

Flag for UNITED KINGDOM
Fareham, United Kingdom
5,0
19
Betalingsmetode verificeret
Medlem siden jan. 29, 2015

Klientverificering

Tak! Vi har sendt dig en e-mail med et link, så du kan modtage din kredit.
Noget gik galt, da vi forsøgte at sende din mail. Prøv venligst igen.
Registrerede brugere Oprettede jobs i alt
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Indlæser forhåndsvisning
Geolokalisering er tilladt.
Din session er udløbet, og du er blevet logget ud. Log venligst ind igen.