Jump to content

Mysql performance

GAURAV SHARMA_MT's Photo
Posted Oct 24 2012 05:10 AM
8573 Views

I would like to ask you about following parameters which should be low or high for best performance:
please tell me
1) Thread cache size --- should be low or high for best mysql performance
2) thread cache hit rate -- should be low or high for best mysql performance
3) thread created --- should be low or high for best mysql performance
4) table lock --- should be low or high for best mysql performance
5) table lock wait --- should be low or high for best mysql performance
6) Maximum open file --- should be low or high for best mysql performance
7) total row returned --- should be low or high for best mysql performance
8) total row returned via index --- should be low or high for best mysql performance
9) table open --- should be low or high for best mysql performance
10) table cache --- should be low or high for best mysql performance
11) Average row per query -- should be low or high for best mysql performance
12) No. of byte received --- should be low or high for best mysql performance
13) No. of Byte sent --- should be low or high for best mysql performance
14) connection used -- should be low or high for best mysql performance
15) query in cache --- should be low or high for best mysql performance
16) query cache hit --- should be low or high for best mysql performance
17) query cache hit ratio -- should be low or high for best mysql performance


I request you to kindly provide me solution as soon as possible.
I am waiting your response.

Tags:
1 Subscribe


5 Replies

0
  macnlos's Photo
Posted Oct 25 2012 11:30 AM

Let me point out that I'm not a DBA nor am I what you would call extremely proficient with Mysql. I do have to manage a couple of small DBs and what has been most helpful is using phpMyAdmin. From the home page you can view your Mysql Runtime Processes and you will find a list at the bottom of most of the settings. The tool will tell you the values, the purpose and suggest if you need to change something to.
=========================
Sent to you from my
iPad, iPhone, BlackBerry,
Laptop, Desktop, or
Kitchen Toaster
0
  darrensmith1's Photo
Posted Apr 20 2013 03:14 AM

I am explaining you one by one.

1) Thread cache size --- low
2) thread cache hit rate -- low
3) thread created --- low
4) table lock --- donot understand what you mean by that
5) table lock wait --- donot understand what you mean by that
6) Maximum open file ---donot understand what you mean by that
7) total row returned --- depend on the query you cannot low if it return too many
8) total row returned via index --- depend on the query you cannot low if it return too many
9) table open --- question not clear
10) table cache --- question not clear
11) Average row per query -- depend on the query you cannot low if it return too many
14) connection used -- are you talking about connection string here
15) query in cache --- depend on the query you cannot low if it return too many
16) query cache hit --- depend on the query you cannot low if it return too many
actually some are simply depends on your query which you want to pass and want to fetch the result.Are you want to want to know about these for software or website development. I think you might be want to reduce the chances of crash of the database.Am i right?Hope that helps you.
0
  minecraft free's Photo
Posted Nov 13 2013 07:31 PM

Thanks darrensmith1 for the advice. But to get free minecraft gift codes, check it out. Free minecraft gift codes
0
  kokim89's Photo
Posted Feb 11 2014 03:43 AM

Thanks darrensmith1 your question is helping us...i want share something if you want know about price handphone cek below Daftar harga HP and harga oppo N1
0
  jack101's Photo
Posted Mar 19 2014 03:13 AM

Education is definitely a sticky subject. However, is still among the leading topics of our time. High PR backlinks