Regarding Performance and Tuning in MySQL

praveenppandey · #1 (**permalink**) 10-13-04, 08:55

Hello Members

1.Can anybody provide me information that how to optimized the MySQL database queries.

2.How to tune the database.

3.How to check the performance of database

Regards
Praveen Kumar Pandey

Offshore Outsourcing Service Provider

r937 · #2 (**permalink**) 10-13-04, 09:47

here's a great tutorial: 7 MySQL Optimization

RBARAER · #3 (**permalink**) 10-13-04, 09:47

Hello,

Well, you seem a little too direct and not precise enough in your questions to me. Do not be offended, but how would you react if my answer had just been :

Quote:

1. RTFM
2. Google
3. Come back here

This being said, I suggest you first have a look at the MySQL Manual about Optimization. You can then try to google for something like "MySQL performance tuning", and finally come back here with precise questions, you will then have a better understanding of what you want to talk about.

Best Regards,

RBARAER

praveenppandey · #4 (**permalink**) 10-14-04, 04:45

Hello RBARAER

It seems that you are very convincing person, you are right in your perspective and to some extent I was right in my domain, well Thanks for such a witty reply, I love these type of answer, and yes don't be get overwhelmed.

Regards
Praveen Kumar Pandey

CoVisible Solutions Inc. - Offshore Outsourcing

Quote:

Originally Posted by RBARAER

Hello,

Well, you seem a little too direct and not precise enough in your questions to me. Do not be offended, but how would you react if my answer had just been :

This being said, I suggest you first have a look at the MySQL Manual about Optimization. You can then try to google for something like "MySQL performance tuning", and finally come back here with precise questions, you will then have a better understanding of what you want to talk about.

Best Regards,

RBARAER

Internet Services

Web Development

Digital Marketing

Consumer Tech