Magento / Mysql / Dedivated Server Crashing

$30-250 USD

Ukończony

Opublikowano

ponad 9 lat temu

$30-250 USD

Płatne przy odbiorze

We have a current Magento installation and apparently the InnoDB buffer pool / data size is set to the following: 118.0M/1.5G. This is a major recommendation from our web host to change. Here are all of the changes we must make: General recommendations: Run OPTIMIZE TABLE to defragment tables for better performance MySQL started within last 24 hours - recommendations may be inaccurate Enable the slow query log to troubleshoot bad queries Adjust your join queries to always utilize indexes When making adjustments, make tmp_table_size/max_heap_table_size equal Reduce your SELECT DISTINCT queries without LIMIT clauses Variables to adjust: join_buffer_size (> 128.0K, or always use indexes with joins) tmp_table_size (> 64M) max_heap_table_size (> 64M) innodb_buffer_pool_size (>= 1G) If you are familiar with this exact scenario, please bid. We need this project completed right away as the site is live and the server keeps crashing. Only bid if you can do this work right away. Thank you

Magento

MySQL

Identyfikator projektu: 7109526

Informację o projekcie

3 ofert

Zdalny projekt

Aktywny 9 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Adres e-mail

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe

Otrzymuj wynagrodzenie za swoją pracę

Przedstaw swoją propozycję

Rejestracja i składanie ofert jest bezpłatne

Przyznano:

@twhiting9275

Hi there, I have a good bit of experience with MySQL, load and the like. It's entirely possible that your server is not crashing directly due to MySQL, but something else entirely, and I'd love to take a bit and help you figure this out. Understandably, my bid is probably going to take longer than you desire, however, this is just the time allocated to find and fix the problem. In most cases, the time for something like this is < 24 hours, and I can get this done easily enough. If you have any concerns, please do feel free to view my profile, you'll see a 5 star rating and 100% completion (sans a few stragglers that were paid outside of FL). I look forward to hearing from you and working with you on this project

$194 USD w 7 dni

5,0

(18 opinii)

5,0

3 freelancerzy składają oferty o średniej wysokości $147 USD dla tej pracy

@VnBestSolutions

Dear Sir. We claim to get it done perfectly for you EXACTLY in the way you want it - Kindly give we a chance and we will prove myself - Ready to prove our words, let's get it done right away and I mean RIGHT AWAY !! Looking forward to hear from you soon - GOD Bless You.

$147 USD w 3 dni

4,9

(60 opinii)

5,7

@dreamdata

Hello, i am writing this comment after 30 minutes of my Bid , i was wait to your message for me to start work instantly ( cause of your project was urgent ) but did not hear you, time here is very late and i need sleep, but about your project , dont worry this is my skill , please check my feedback i had the same issues ( mysql and webservice optimization projects ) , if would like when i wake up ( your night in US ) i will sort your issue straight away if hear you, thank you so much regards,

$100 USD w 3 dni