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.

Evner: Database Administration, MySQL, SQL, WordPress

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

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

Projekt ID: #6050141

Tildelt til:


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 Flere

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

30 freelancers are bidding on average $197 for this job


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 Flere

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

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 Flere

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

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)

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 Flere

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

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)

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 Flere

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

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 Flere

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

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 Flere

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

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 [url removed, login to view] Instead of giving few general idea about your project Flere

$257 USD in 10 dage
(9 bedømmelser)

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 !! Flere

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

[url removed, login to view] 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 Flere

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

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 Flere

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

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-- [url removed, login to view] Flere

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

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 Flere

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

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)

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)

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 Flere

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

A proposal has not yet been provided

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

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 Flere

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

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)