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
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
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/Product.aspx?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/en/optimization.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..
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
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.
I have always liked this subject believe it or not.... my best friend works at a company supporting clustering software for large storage arrays..... good luck
you should really look at these... i'm sure you could easily mess with this in a sandbox situation and figure out how to optimize your queries etc.. http://dev.mysql.com/doc/refman/5.0/en/using-explain.html
If u looking for advanced knowledge check this: http://www.mysqlperformanceblog.com/ http://www.percona.com/ http://www.amazon.com/High-Performance-MySQL-Optimization-Replication/dp/0596101716