Web Developer with mySQL skills

We need a Web Developer with mySQL knowledge to configure our adult personals website. [url removed, login to view]

We are using the following:

Sweet Date Theme(ThemeForest) Powered by Buddy Press

We had 2,000,000 profiles installed by a third party which resulted in extremely slow performance.

Below is the advise from our Server support:

Your word-press media library is loading very slow due to problems with the database used for your wordpress installation. Your site databases size is 16GB. You need to check that with your site developer as its an issue with database itself and not something with the server.

You will need to optimize your database queries from your web developer. I checked this and when you try search any profile on your site, your databases queries are taking so long time to search that in databases and due to that you are getting this issues. I will suggest you please contact your web developer and ask them to check this. You may also want to check with a mySQL developer.

| 21 | maxxxper_wp58 | localhost | maxxxper_wp58 | Query | 103 | Copying to tmp table | SELECT DISTINCT wp_bp_xprofile_data.user_

id FROM wp_bp_xprofile_data JOIN wp_usermeta um ON um.user_ |

| 43 | root | localhost | | Query | 0 | | show processlist

root@sh39 [/home/maxxxpersonals/www]# du -sch /var/lib/mysql/maxxxper_wp58/

16G /var/lib/mysql/maxxxper_wp58/

16G total

root@sh39 [/home/maxxxpersonals/www]#


Please give us an estimate and time frame.

Taidot: Tietokantaohjelmointi, MySQL, WordPress

Näytä lisää: www web developer com, www web developer, wordpress word developer, wordpress web developer support, word press support, wordpress mysql database developer, wordpress developer support, wordpress developer profile, word press developer profile, wordpress com developer, web developer wordpress theme, web developer search, web developer profile website, web developer profiles, web developer in need, web developer for word press, web developer for wordpress, web developer for site, web developer database problems, web developer contact

Tietoa työnantajasta:
( 0 arvostelua ) Morgan City, United States

Projektin tunnus: #8125948

Myönnetty käyttäjälle:


Hi, I'm an expert at WordPress and optimizations. One of the WordPress websites I work with (it uses BuddyPress as well) handles over 3 million visitors a month. It initially had a horrible DB design of around 1.5 GB b Lisää

$250 USD 4 päivässä
(15 Arvostelua)

7 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


this is no easy job like change code and it will work. wherever this query goes those part has to be changed and it has to work correctly for those and it has to be handled with temp tables and we need to make it routi Lisää

$944 USD 7 päivässä
(193 arvostelua)

Hello There, Greetings!! I have read your job details of Web Developer with mySQL skills. I have excellent experience in Web development with more than 5 years of experience. Skills: PHP, HTML, CSS, Mysql, Lisää

$309 USD 3 päivässä
(41 arvostelua)

hello sir, we have gone through your project description and Ready to start right way! we are a team having 5+ years experience in wordpress development. We assure to you that will deliver to you a quality work with Lisää

$200 USD 7 päivässä
(7 arvostelua)

hi your issue is related to the heavy data without indeximg. your data cn be indexed ad will result in better [login to view URL] lrt me know if you are interested I can do it for you.

$222 USD 7 päivässä
(2 arvostelua)

Hi, I’m dedicated professional Web and Desktop Programmer & Developer and also Team leader for my company. I have been working with challenge and hope to improve future plan with good network every client. If any clie Lisää

$111 USD 5 päivässä
(0 arvostelua)

WebDesignOnly PHP Programmer - Graphic Design Artist - MySQL Programmer I am a talented AJAX Developer and ASP Developer ready to be outsourced by your organization. I have worked as a AJAX Developer and ASP Dev Lisää

$155 USD 3 päivässä
(0 arvostelua)

I go through the requirement and found it suites my profile better as per my past experience and knowledge.

$250 USD 3 päivässä
(0 arvostelua)