I need a PHP Expert

BassTrackerBoats

BassTrackerBoats

Super Moderator
Staff member
Moderator
Executive VIP
Jr. VIP
Joined
Mar 10, 2010
Messages
40,122
Reaction score
97,455
We are looking for someone who can performance tune our DB, as the DB
grows our performance degrades.

We need someone who can

1- Analyze our schema for potential improvements - solutions for
troublesome queries etc.
2- Suggest hardware spec for our system and MySQL config optimizations
3- Possibly implement clustering

This is for a legit expert not for someone who thinks they can do it... I want a pro and am willing to to a fair rate to one that is a pro.

Shoot me an email with your qualifications please - [email protected]
 
Advertise on BHW
Your thread title and your post requirement have no connection whatsoever ;). You will have better responses if you change your title to "I need a MYSQL DB expert". Just a thought :)
 
essares1 said:
Your thread title and your post requirement have no connection whatsoever ;). You will have better responses if you change your title to "I need a MYSQL DB expert". Just a thought :)
Click to expand...
PHP experts should have thorough understanding of MySQL
 
essares1 said:
Your thread title and your post requirement have no connection whatsoever ;). You will have better responses if you change your title to "I need a MYSQL DB expert". Just a thought :)
Click to expand...

cbnoob said:
PHP experts should have thorough understanding of MySQL
Click to expand...

Both of you guys know tons more than I do... my partner is the technician and asked me to post this... I am sure that I could have put a better title up but when we were talking I though he said PHP expert but then again I'm not even remotely technical.

I appreciate the input from both of you so that others that read this will get a better understanding of what we need.
 
cbnoob said:
PHP experts should have thorough understanding of MySQL
Click to expand...

"understanding" doesn't cut it for him. He obviously needs a pro. He is not technical so he put up the wrong title. I know many PHP "experts" that don't have a clue of database optimization. And many DB experts are not PHP experts. If an actual mysql pro sees the thread title, he may pass it assuming he needed a PHP expert, which is why I suggested a more apt title may bring in more relevant views.

Anyways good luck with your search BTB
 
One solution would be to check out a non-relational database like CouchDB. It's fairly easy to deploy and use. One of my tasks at my former job was to move the current MS SQL DB to a CouchDB solution(even though my cup of tea is C#). With it you can simplify the SQL queries using lists and views and you can really improve the query execution time. Just a thought.
 
Hi, I don't know how to optimize db queries, but if you to optimize the website and not only the db, I can analyze your website's performance and tell you what needs to be done.
I can obtain up to 98/100 on page speed score for a simple website (of course it depends on its complexity).
Just send a PM if you are interested :)
 
scraper1 said:
One solution would be to check out a non-relational database like CouchDB. It's fairly easy to deploy and use. One of my tasks at my former job was to move the current MS SQL DB to a CouchDB solution(even though my cup of tea is C#). With it you can simplify the SQL queries using lists and views and you can really improve the query execution time. Just a thought.
Click to expand...

In the above, I understood the word "solution", the rest was Latvian to me.

My business partner handles the technical end and has a day job which is why we thought it best for me to post the request for help.

I do appreciate the input and will pass the above to him.
 
Greg, I had similar problems with my mysql databases for the phone stuff and there are 2 things you basically have to remember with mysql

1) on a live production table set no indexes!!! All reports should be run on a copy of the production database.

2) make the primary key autogenerated and not some number you plugin.

Let Kevin know he should understand what I am saying. Mysql is fast but can be finicky. Also tell him to remove any spoorious columns. on your main working tables only collect essential data.
 
Last edited:
scraper1 said:
One solution would be to check out a non-relational database like CouchDB. It's fairly easy to deploy and use. One of my tasks at my former job was to move the current MS SQL DB to a CouchDB solution(even though my cup of tea is C#). With it you can simplify the SQL queries using lists and views and you can really improve the query execution time. Just a thought.
Click to expand...

Yeah I would recommend non-relational database, although I would use MongoDB instead of CouchDB.

(Craigslist, sourceforge, bit.ly and a lot of others all use Mongo ;)).

Also, in regards to MYSQL, go to the page below and try running the "MySQL Performance Tuning Primer Script" script. It's a basic optimizer but it will alert you if you should change any settings.
(Make sure the server has been running for a while before running the script).

Code: 
http://www.day32.com/MySQL/
 
non relational databases are good depending on what you want to do. I am pretty sure wordpress can't use them yet and if you dont know how to use them then there is a bit of a learning curve and also be preapred to have some HUGE tables
 
Advertise on BHW
You must log in or register to reply here.
Sign up now!

Main Menu

Home Main Forum List Black Hat SEO White Hat SEO BHW Newbie Guide Blogging Black Hat Tools Social Networking Downloads

Marketplace

Content / Copywriting Hosting Images, Logos & Videos Proxies For Sale SEO - Link building SEO - Packages Social Media Social Media - Panels Web Design Misc

Making Money

Affiliate Programs Hire a Freelancer Making Money Pay Per Click Site Flipping

BlackHatWorld

BHW Merch Forum Suggestions & Feedback Introductions Lounge Dispute Resolution

Other

Domain Name Forum IM Journeys Web Hosting Newsletter
Back
Top