Find Jobs
Hire Freelancers

MariaDB Locking -- Experienced PHP Programmer

$30-250 AUD

Closed
Posted over 5 years ago

$30-250 AUD

Paid on delivery
CMS: Vivvo CMS v4.7 Required Very Experienced PHP Programmer to Work on the Site Code. [!!] Temporary tables created on disk: 87% (93K on disk / 107K total) Explanation: queries are creating large temporary tables written to disk (800MB per query). Without memory (RAM) disk for mysql /tmp, site is completely unresponsive even with SSD disks. Too many concurrent queries causes /tmp full and mysql crash.
Project ID: 18008962

About the project

11 proposals
Remote project
Active 5 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
11 freelancers are bidding on average $185 AUD for this job
User Avatar
This is where I excel! Will require SSH access to your machine and might need to restart your server. On average task like this take 8 hours.
$277 AUD in 0 day
5.0 (116 reviews)
7.2
7.2
User Avatar
Dear Sir , Lets check for the slow quires and buffer size also check for the spaces . Also why its happen with the help of logs. Normally the quires are not optimized in this case BR, Mohsin
$200 AUD in 3 days
5.0 (11 reviews)
4.0
4.0
User Avatar
Hello ! There are some options to resolve a problem: 1) you need to modify queries so big temporary files will be not created. 2) you need to optimize queries to decrease size of temporary tables to minimum Probably you need to change of structure of tables and same connected things Anyway current way is incorrect. I have experience in big DB data queries. My current project have table with more than 170.000.000 records. Queries work quickly and don't depend on table size So i can have a look at to decide how it can be fixed Please ignore a milestone
$177 AUD in 10 days
5.0 (3 reviews)
3.6
3.6
User Avatar
Hi, I saw your project and i am good in PHP and its all CMS and Frameworks development including the Responsive Bootstrap Designing. I am working from last 5 Years within the same technology. Thanks..! Riya
$155 AUD in 3 days
5.0 (14 reviews)
3.3
3.3
User Avatar
hello, i am rupali birwa from bhopal . i m comfortable with your requirements . and i worked on html, css, jquery, java script, my sql, bootstrap. i work with my development team. we develop and design all most 25 projects . thank you rupali birwa
$155 AUD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Greenacre, Australia
5.0
8
Payment method verified
Member since May 13, 2016

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.