MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: Correctly setting mysql options for a huge DB with intense trafic
Posted by: Rick James
Date: November 22, 2010 12:02AM

Connections -- probably ok

Key_buffer -- fine.

QC -- OFF is good; one fewer thing to possibly cause hangs.

162 rows deleted / sec. Are you inserting stuff, only to delete it quickly? I wonder if some change to the logic could decrease this.

61K/sec rows read -- sounds quite high. Let's look at the slowlog to see which statements are the biggies. Note how Handler_read_rnd_next is about the same? (I suspect there is a reason.)

What is MaxClients on Apache? (Often people set it "too high".)

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


Subject
Views
Written By
Posted
Correctly setting mysql options for a huge DB with intense trafic
4869
Toni Shocker
November 19, 2010 05:12PM
Re: Correctly setting mysql options for a huge DB with intense trafic
1508
Brian Parris
November 19, 2010 05:57PM
Re: Correctly setting mysql options for a huge DB with intense trafic
1398
Toni Shocker
November 19, 2010 11:42PM
Re: Correctly setting mysql options for a huge DB with intense trafic
2023
Brian Parris
November 20, 2010 12:21AM
Re: Correctly setting mysql options for a huge DB with intense trafic
1517
Toni Shocker
November 20, 2010 01:28AM
Re: Correctly setting mysql options for a huge DB with intense trafic
1325
Brian Parris
November 20, 2010 09:08AM
Re: Correctly setting mysql options for a huge DB with intense trafic
1441
Rick James
November 20, 2010 10:19PM
Re: Correctly setting mysql options for a huge DB with intense trafic
1334
Toni Shocker
November 21, 2010 08:55PM
Re: Correctly setting mysql options for a huge DB with intense trafic
1181
Rick James
November 22, 2010 12:02AM
Re: Correctly setting mysql options for a huge DB with intense trafic
1217
Toni Shocker
November 22, 2010 04:49PM
Re: Correctly setting mysql options for a huge DB with intense trafic
1283
Shawn Taylor
November 22, 2010 07:07PM
Re: Correctly setting mysql options for a huge DB with intense trafic
1267
Brian Parris
November 22, 2010 09:19PM
Re: Correctly setting mysql options for a huge DB with intense trafic
1389
Shawn Taylor
November 23, 2010 07:52AM
Re: Correctly setting mysql options for a huge DB with intense trafic
1128
Toni Shocker
November 24, 2010 09:25AM
Re: Correctly setting mysql options for a huge DB with intense trafic
1390
Shawn Taylor
November 24, 2010 07:13PM
Re: Correctly setting mysql options for a huge DB with intense trafic
1241
Toni Shocker
November 25, 2010 10:24AM
Re: Correctly setting mysql options for a huge DB with intense trafic
1081
Shawn Taylor
November 25, 2010 12:17PM
Re: Correctly setting mysql options for a huge DB with intense trafic
1221
Rick James
November 25, 2010 02:54PM
Re: Correctly setting mysql options for a huge DB with intense trafic
1095
Toni Shocker
November 26, 2010 10:16AM
Re: Correctly setting mysql options for a huge DB with intense trafic
1367
Shawn Taylor
November 26, 2010 12:22PM
Re: Correctly setting mysql options for a huge DB with intense trafic
1194
Toni Shocker
November 26, 2010 02:24PM
Re: Correctly setting mysql options for a huge DB with intense trafic
1245
Rick James
November 26, 2010 03:09PM
Re: Correctly setting mysql options for a huge DB with intense trafic
1117
Toni Shocker
November 26, 2010 03:31PM
Re: Correctly setting mysql options for a huge DB with intense trafic
1143
Rick James
November 26, 2010 05:27PM
Re: Correctly setting mysql options for a huge DB with intense trafic
1291
Toni Shocker
November 27, 2010 07:13AM
Re: Correctly setting mysql options for a huge DB with intense trafic
1446
Rick James
November 27, 2010 01:14PM
Re: Correctly setting mysql options for a huge DB with intense trafic
1397
Toni Shocker
November 27, 2010 01:47PM
Re: Correctly setting mysql options for a huge DB with intense trafic
1190
Shawn Taylor
November 27, 2010 03:19PM
Re: Correctly setting mysql options for a huge DB with intense trafic
1208
Toni Shocker
November 27, 2010 03:21PM
Re: Correctly setting mysql options for a huge DB with intense trafic
1288
Shawn Taylor
November 27, 2010 04:28PM
Re: Correctly setting mysql options for a huge DB with intense trafic
1279
Toni Shocker
November 28, 2010 08:31AM
Re: Correctly setting mysql options for a huge DB with intense trafic
1371
Rick James
November 27, 2010 09:00PM
Re: Correctly setting mysql options for a huge DB with intense trafic
1244
Toni Shocker
November 28, 2010 08:56PM
Re: Correctly setting mysql options for a huge DB with intense trafic
1228
Rick James
November 28, 2010 10:35PM
Re: Correctly setting mysql options for a huge DB with intense trafic
1206
Toni Shocker
December 01, 2010 05:05AM


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.