238231 Tune Wordpress & Tune mySQL.

I gang Opslået Jul 14, 2008 Betalt ved levering
I gang Betalt ved levering

PLEASE READ CAREFULLY!

I need someone who is knowledgeable with (1.) Wordpress [url removed, login to view], (2.) PHP, and (3.) mySQL v5.0.51a.

PLEASE DO NOT RESPOND TO THIS PROJECT UNLESS YOU HAVE EXPERIENCE WITH WORDPRESS, PHP, AND MYSQL!

The scope of this project entails: (1.) tuning and tweaking a .PHP plugin for wordpress, (2.) tuning and tweaking the mySQL database for the wordpress site, and perhaps (3.) tuning and tweaking Wordpress itself.

Tuning and Tweaking a .PHP plugin for Wordpress

-----------------------------------------------

1. This Wordpress plugin in question is a modified and customized version of Feedwordpress. This plugin has been modified to integrate with the Revolution Pro Media template. This plugin is a RSS Syndication plugin. What I have this plugin doing is grabbing the RSS feeds from [url removed, login to view] and importing the content of Amazon's RSS feeds into blog posts into the appropriate shopping category. When the RSS feed from Amazon updates, this plugin either: (a.) updates existing content in the blog with content in the current [url removed, login to view] RSS feed, or (b.) adds new content to the blog in the appropriate category. Images are NOT stored in the database, however, the image URL on [url removed, login to view] is stored in the database.

** What I believe is happening with this plugin is that the entire database is searched before new content is added or updated. For each individual item to be updated/added, mySQL must search through 80,000+ existing posts before introducing/updating new content. This results in sluggish mySQL performance. As the Wordpress site grows, performance decreases. **

Therefore, the ** FIRST ** part of the project entails "Tuning and Tweaking my customized .PHP plugin for Wordpress."

SUGGESTION & CODING RECOMMENDATION: Rather than updating ALL rss feeds at once, perhaps there can be a cron job introduced to update each individual feed at different times.

Tuning and Tweaking the mySQL database for the Wordpress site

-------------------------------------------------------------

I assume that the existing database structure is inefficient. The present database structure is the result of a combination of (a.) Wordpress default settings, and (b.) Feedwordpress database structures.

** Therefore, the ** SECOND ** part of this project means that the existing database is to be examined for inefficiencies. More than likely, there will be queries that must be identified and rewritten for performance gains. **

To this end, I am making use of two programs -- (a.) Tuning-Primer and (b.) mysqlsla. Output from these tuning/performance programs will be attached; please examine the contents of these mySQL tuning programs to see if this project seems sensible to you.

Tuning and Tweaking Wordpress itself

------------------------------------

Perhaps the designers at Wordpress never intended their blogging software to have thousands of posts in a blog. However, given the scalability of both Wordpress and mySQL, it is hard to imagine that Wordpress itself is having a difficult time with 80,000+ blog entries. But perhaps I am wrong. (Perhaps the problem lies in searching the 80,000+ blog entries to find the particular ones that need updating.)

Output from the mysqlsla program MAY contain slow queries that reflect Wordpress itself, and not the plugin. Feel free to recommend to me software you need for proper mySQL query analysis.

Therefore, the ** THIRD ** part of this project ** MIGHT ** entail that you optimize Wordpress coding and Wordpress mySQL queries.

SLUGGISH BEHAVIOR & SERVER LOAD

-------------------------------

** When I attempt to write an article, the Wordpress admin interface appears to "Freeze," and the server load skyrockets to 4.00 to 7.00 while the page to write the article loads. It takes around 120 to 180 seconds for this page to finally load. **

MySQL Odd Jobs PHP WordPress

Projekt ID: #1984477

Om projektet

Remote projekt Aktiv Jul 11, 2012