Magento / Mysql / Dedivated Server Crashing

$30-250 USD

Selesai

Disiarkan

lebih dari 9 tahun yang lalu

$30-250 USD

Dibayar semasa penghantaran

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

ID Projek: 7109526

Tentang projek

3 cadangan

Projek jarak jauh

Aktif 9 tahun yang lalu

Ingin menjana wang?

Alamat e-mel

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda

Dapatkan bayaran untuk kerja anda

Tuliskan cadangan anda

Ianya percuma untuk mendaftar dan membida pekerjaan

Dianugerahkan kepada:

@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 dalam 7 hari

5.0

(18 ulasan)

5.0

3 pekerja bebas membida secara purata $147 USD untuk pekerjaan ini

@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 dalam 3 hari

4.9

(60 ulasan)

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 dalam 3 hari