MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: MySQL server configuration for a 8 cpu+20gb RAM server
Posted by: Ahamed kabeer
Date: July 26, 2010 11:26PM

Hi,

Thanks for your kind suggestions.

I have identified some slow queries and optimized them. My application is some what faster than previous. Now I am trying to optimize LIKE '%abc%' kind of queries.

I noticed one thing in MySQL Administrator tool, If more than 16 queries are running, only 16 queries are seems to be running faster, remaining queries(even simple queries) are seems to be slow. Is it because my server is having 16 CPUs or some other reason? Please advice

Number of CPUs : 16
innodb_thread_concurrency = 32


Thanks in Advance.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
MySQL server configuration for a 8 cpu+20gb RAM server
15841
josé renato milanez
May 13, 2010 10:17AM
Re: MySQL server configuration for a 8 cpu+20gb RAM server
4198
Rick James
May 14, 2010 06:40PM
Re: MySQL server configuration for a 8 cpu+20gb RAM server
3307
josé renato milanez
May 15, 2010 06:15AM
Re: MySQL server configuration for a 8 cpu+20gb RAM server
3276
Rick James
May 15, 2010 07:35AM
Re: MySQL server configuration for a 8 cpu+20gb RAM server
2918
josé renato milanez
May 15, 2010 11:34AM
Re: MySQL server configuration for a 8 cpu+20gb RAM server
3232
Rick James
May 15, 2010 01:06PM
Re: MySQL server configuration for a 8 cpu+20gb RAM server
2445
josé renato milanez
August 11, 2010 05:06AM
Re: MySQL server configuration for a 8 cpu+20gb RAM server
2468
Rick James
August 11, 2010 08:28AM
Re: MySQL server configuration for a 8 cpu+20gb RAM server
3621
ivo welch
June 01, 2010 03:06PM
Re: MySQL server configuration for a 8 cpu+20gb RAM server
2834
Rick James
June 01, 2010 07:48PM
Re: MySQL server configuration for a 8 cpu+20gb RAM server
2467
ivo welch
June 02, 2010 06:24AM
Re: MySQL server configuration for a 8 cpu+20gb RAM server
1829
Mayur P Vegad
July 07, 2010 08:54AM
Re: MySQL server configuration for a 8 cpu+20gb RAM server
5391
Ahamed kabeer
July 23, 2010 05:40AM
Re: MySQL server configuration for a 8 cpu+20gb RAM server
2042
Rick James
July 25, 2010 11:26PM
Re: MySQL server configuration for a 8 cpu+20gb RAM server
1953
Ahamed kabeer
July 26, 2010 12:28AM
Re: MySQL server configuration for a 8 cpu+20gb RAM server
1681
Rick James
July 26, 2010 10:53PM
Re: MySQL server configuration for a 8 cpu+20gb RAM server
1914
Ahamed kabeer
July 26, 2010 11:26PM
Re: MySQL server configuration for a 8 cpu+20gb RAM server
2220
Rick James
July 27, 2010 09:06AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.