Registered: Feb 2003
Posts: 715

hello,

I am seeking a MySql guru with help in "tuning" the current MySql database design/configuration I currently have for a web based application.

I am a programmer but am new to MySql and need make sure my design is optimal.

Please PM me for further details.

thanks
fan27

Registered: Aug 2011
Posts: 3513

---

Quote from fan27:

hello,

I am seeking a MySql guru with help in "tuning" the current MySql database design/configuration I currently have for a web based application.

I am a programmer but am new to MySql and need make sure my design is optimal.

Please PM me for further details.

thanks
fan27

---

Registered: Feb 2003
Posts: 715

I am not a DBA but know enough to be dangerous

Looking for guidance on table structure and configuring the database settings. On my own I have been able to greatly improve performance but want to get someone's time who is a MySql expert to see if there are better approaches or simple things I may be missing.

thanks
fan27

Registered: Aug 2011
Posts: 3513

i'm on the same level as you are... but my first thoughts are... whats the hardware your using.. your only as good as your hardware can be... I suggest raiding SSD's with SATA 3 connections like for example these drives

http://www.newegg.com/Product/Produ...Item=20-227-707

.. now most likely your not on your own box... your using a hosting environment.. shop hosting environments.. get a dedicated box if you have to.. hardware means alot... Co locate your own server.. theres a bunch of options there.. but definitly consider it heaavy on your budget to optimize..

read this..
http://dev.mysql.com/doc/refman/5.0...timization.html

my experience.. even if you pay slash or get free advice from a DBA your at a big advantage if you know what you need already... kind of like going to the mechanic and just throwing your hands up.. instead of saying.. hay how much for a water pump mine is blown.. you get the point..

have the problem with DB's is they are on shared resources.. and you can't control as much as you need to... you want to be the sole allocater of your resources.. forget shared hosting.. i can go on..and on.. but next would be optimizing your queries.... if you index a query that you use all the time..and just reference the index quiery.. its super fast.. its already got the map ... mapping to commonly used queries..

i've read a few books on this.. but its been a while.. i don't have much practical expereience.. but like everything else.. i learn it so i know what i want and i can shop it..

Registered: Aug 2011
Posts: 3513

theres a guy on here called oracle wizard.. i would guess he knows a bit.. but then again he seemed to be looking for investors for his fund.. he might not be interested in helping anypne

Registered: Feb 2003
Posts: 715

thanks for the info cdcaveman. Our plan is to lease a dedicated box. Right now our dev environment is a shared box but my goal is to get the database optimized then get a dedicated box when we go live with our project.

Advantage Futures

Futures Brokerage & Clearing

AMP Global Clearing

Futures and FX Trading

Bright Trading

Professional Equities Trading

CTS

Futures Trading Software

DaytradingBias.com

Professional Trading Analytics

ECHOtrade

Professional Trading Firm

eSignal

Trading Software Provider

FXCM

Forex Trading Services

Global Futures

Futures, Options & FX Trading

Interactive Brokers

Pro Gateway to World Markets

JC Trading Group

Direct Access Trading

MB Trading

Direct Access Trading

MultiCharts

Trading Software Provider

NinjaTrader

Trading Software Provider

OANDA

Currency Trading

optionshouse

Option Trading & Education

Rithmic

Futures Trade Execution Platform

SpeedTrader

Direct Access Trading

SpreadProfessor

Spread Trading Instruction

thinkorswim by TD Ameritrade

Direct Access Trading

TradersStudio

System Building & Backtesting

Trading Technologies

Trading Software Provider

Trend Following

Trading Systems Provider