I gang

Database optimisation

My database is causing excess load on a shared server, to the extent that the hosting company has disabled access to it.

I need someone to go through the database, and perhaps the plugins being used, in order the load be reduced and the site restored.

Some examples given as to what might be needed are:

Resolving this situation may be as simple as modifying the code to to use mysql_connect instead of mysql_pconnect, closing connections sooner, adding additional indexes to your database, optimizing the queries used, or something equally easy.

Excessive MySQL activity is caused by (a) a long-running process that locks a table, causing other queries to back up, (b) a query that is not optimized ][example: select all from ... and involving a large or complex query], (c) huge table copies/maintenance during peak hours.

Additionally, adding indexes to your table(s) may improve performance. If you're not sure what you're doing, it's best not to modify any table; caution is recommended. There are various articles ([url removed, login to view]). It may be best to Google for something like [Your Software Name] MySQL indexes for suggestions.

Færdigheder: Database Administration, MySQL, SQL, WordPress

Se mere: wordpress mysql database developer, software developer company wordpress, peak 10, performance optimisation, optimisation php, database performance , simple access order database, php mysql load table, hours access database, wordpress mysql query, mysql optimizing , query performance, access database process, mysql server performance, database optimisation, improve performance, software company name suggestions, queries wordpress, performance wordpress, mysql queries optimisation, google disabled, google disabled use, php table maintenance, php mysql database maintenance, mysql closing connections

Om arbejdsgiveren:
( 19 bedømmelser ) London, United Kingdom

Projekt-ID: #6050141

Tildelt til:

cath1ynn

Hi there I have some experience with the problems that you mentioned in your description. Can you tell me what hosting company you use and whether you are able to access the cPanel or administration panel? I will al Mere

$222 USD in 3 dage
(0 bedømmelser)
0.0

30 freelancere byder i gennemsnit $197 for dette job

epark

Dear Sir, We have 7 years experience on Wordpress, HTML, CSS, JavaScript, PHP, MySQL, etc. We have gone through all of the requirements for your project. Very familiar with theme customization (Genesis, Thesis, Elegan Mere

$257 USD in 5 dage
(178 bedømmelser)
7.1
webedeveloper

Hi, Websalvia Solutions has many years of experience of developing database driven websites and applications. Our Services includes not limited o Template, Logo, Banner, ecommerce, Social Media Marketing. We are sp Mere

$250 USD in 7 dage
(36 bedømmelser)
6.4
bistanil98

Need more detail,can we discuss this,to know more detail. We have a team of professionals,they have more than 11 year of experience,so we can manage this work and will give you quality solution.

$200 USD in 10 dage
(15 bedømmelser)
6.6
mascotindia123

Hey Friend, Myself having has 10 + years experience of web site development. Expert in Custom programming in php / Mysql / Jquery / Wordpress/ Joomla / OSC / OpenCart/ Magento. Ready to start the work imme Mere

$230 USD in 8 dage
(40 bedømmelser)
5.6
pixelbypixelsl

UK based developer - mySQL expert, I can debug your scripts to review what is causing the most damage and optimise where possible. Happy to discuss your project further.

$555 USD in 5 dage
(9 bedømmelser)
5.4
rmmarconi

I'm a experienced System and Network administrator with more than 10 years of experience with Debian, Slackware, FreeBSD, OpenBSD, Solaris and others Linux and Unix flavors. Now I'm a System Administrator for the Brazi Mere

$155 USD in 3 dage
(11 bedømmelser)
5.4
shreeyait

Hello Sir, We have checked your job detail and as per that we are able to do your job and we have very good experience in Word Press, Joomla, Joomla component, Modules, PHP, HTML,Magento etc . As well knowledge on Mere

$200 USD in 6 dage
(22 bedømmelser)
5.2
smshafiqulislam

Hi, First of all thanks of such job posting. I am oracle certified developer and dba with more than 6 years of experience. Presently holding DBA positions in a multinational corporate as well as 2 offsite companies o Mere

$166 USD in 3 dage
(22 bedømmelser)
5.1
tuxmin

Hi there ,We have analyzed your requirement and now we would like to go for detailed discussion with you so that project delivery will be more clear and faster.So Instead of giving few general idea about your project Mere

$257 USD in 10 dage
(9 bedømmelser)
5.1
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 !! Mere

$252 USD in 3 dage
(21 bedømmelser)
5.0
titanium009

http://www.aeron7.com/portfolio/websites/ Have a look at the above link to ensure my creativity and expertise. I am well versed with database optimization . I think it is caused by lot of spam comments and unused pl Mere

$200 USD in 3 dage
(48 bedømmelser)
4.8
acronymsolutions

Hi, I have gone through your requirements and attachment as well.I am a DBA at CMM5 Level company since August 2010.I am working on MySql,SQL ,Oracle database, I can do your job confidently. I am very much Interested t Mere

$200 USD in 5 dage
(16 bedømmelser)
4.5
rajeshverma88

Hello Sir! I have completed a number of projects that are relevant to the skills required in this job posting. Please take a look on my recent completed project- Ecommece Sites are-- http://www.wayfair.com/ Mere

$150 USD in 3 dage
(31 bedømmelser)
4.5
GandalfTheGrey

I am an experienced Linux and database administrator. I can authenticate myself so you could be sure that I will do no harm to your server / services nor abuse your data. Also, I am ready to sign NDA if needed. I ca Mere

$250 USD in 3 dage
(8 bedømmelser)
4.4
santosoftvw

Dear Customer, I am Oracle Certfied Professional. I have experience in database optimisation. I can do your job. Thank you.

$88 USD in 3 dage
(10 bedømmelser)
4.2
ipistis

we are having very good experience in data optimization and WordPress plugins we will have to do code analysis bcoz this will be the main reason to increase usages of the mySQL memory.

$210 USD in 3 dage
(23 bedømmelser)
4.1
mohidkhan

Hi, I am professional Programmer & designer of Front end & Back end, I am working with challenge and hope to improve future plan with good network every client. If you want to get more faster job services with save ti Mere

$155 USD in 3 dage
(6 bedømmelser)
3.9
suy99

A proposal has not yet been provided

$155 USD in 3 dage
(11 bedømmelser)
3.8
oneiricindia

Hello, I have gone through your project’s initial requirements with the help of the job posting you have placed. And I think I have requisite experience and expertise to complete your project successfully. I am very Mere

$206 USD in 8 dage
(11 bedømmelser)
3.5
anshulikabansal

Hello Sir, I will help you out in Database Optimization so that it will reduce the load on DB engine. Please open a PM to discuss it. Thanks & Regards.

$100 USD in 2 dage
(5 bedømmelser)
2.2