Magento / Mysql / Dedivated Server Crashing

$30-250 USD

Terminado

Publicado

hace alrededor de 9 años

$30-250 USD

Pagado a la entrega

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 del proyecto: 7109526

Información sobre el proyecto

3 propuestas

Proyecto remoto

Activo hace 9 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

Adjudicado a:

@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 en 7 días

5,0

(18 comentarios)

5,0

3 freelancers están ofertando un promedio de $147 USD por este trabajo

@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 en 3 días

4,9

(60 comentarios)

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 en 3 días