TheFilmGod Posted January 9, 2008 Share Posted January 9, 2008 How can I optimize mysql? I want really good performance with many concurrrent connections. Any ideas? I know about using indexes... anything else? Quote Link to comment Share on other sites More sharing options...
teng84 Posted January 9, 2008 Share Posted January 9, 2008 this sql not php Quote Link to comment Share on other sites More sharing options...
TheFilmGod Posted January 9, 2008 Author Share Posted January 9, 2008 Yes and no. This board is called "PHP and Mysql". (just look up) I realize that sql has a lot to do with optimization but there are many things that php affects sql... that affects .... performance ... that results me in posting this question .... Quote Link to comment Share on other sites More sharing options...
teng84 Posted January 9, 2008 Share Posted January 9, 2008 How can I optimize mysql? and that is your question!! Quote Link to comment Share on other sites More sharing options...
awpti Posted January 9, 2008 Share Posted January 9, 2008 Notice the forum: PHP Freaks Forums > PHP and MySQL > PHP Help > See that MySQL part? In any case.. Read the mySQL documentation. Look up tutorials on MySQL Performance tuning. Quote Link to comment Share on other sites More sharing options...
teng84 Posted January 9, 2008 Share Posted January 9, 2008 Notice the forum: PHP Freaks Forums > PHP and MySQL > PHP Help > See that MySQL part? In any case.. Read the mySQL documentation. Look up tutorials on MySQL Performance tuning. does it mean i can post this thread in freelance section because that also has mysl ?? any way sorry for being rude.. i just find this thread as wrong post again sorry ! Quote Link to comment Share on other sites More sharing options...
fenway Posted January 9, 2008 Share Posted January 9, 2008 How can I optimize mysql? I want really good performance with many concurrrent connections. Any ideas? I know about using indexes... anything else? What do you want to optimize? Quote Link to comment Share on other sites More sharing options...
jaymc Posted January 9, 2008 Share Posted January 9, 2008 Do you have access to mysql.conf Is it your server? Optimizing should start at that level Once mysql is making the most of its home (hardware) we can start to look on query and database normalisation I would only go this far if you are studying this or have a reason to optimize, mysql / computers are so fast even a terrible query will be completed before you can blink Quote Link to comment Share on other sites More sharing options...
TheFilmGod Posted January 9, 2008 Author Share Posted January 9, 2008 good post ^. - But if you have over 1,000 concurrent connections to mysql and about 1000 queries a second, even the best queries can create a bottleneck with soo many connections at the same time... Quote Link to comment Share on other sites More sharing options...
fenway Posted January 9, 2008 Share Posted January 9, 2008 Do you have access to mysql.conf Is it your server? Optimizing should start at that level Once mysql is making the most of its home (hardware) we can start to look on query and database normalisation I would only go this far if you are studying this or have a reason to optimize, mysql / computers are so fast even a terrible query will be completed before you can blink DB normalization should always be at the top of the list. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.