[nycbug-talk] Re: MySQL

[Bob Ippolito]

On Aug 21, 2005, at 8:55 AM, Francisco Reyes wrote:

> On Sun, 21 Aug 2005, Bob Ippolito wrote:
>
>
>> Try adding a column with a MD5 hash of the email address, and an  
>> index that covers the hash instead.
>>
>
> The queries are coming from Postfix, not sure we can change how  
> postfix does it queries.
>
>
>> Also, normalizing things helps considerably.  Normalized data  
>> takes up less space, which means less I/O bottleneck.
>>
>
> Again, our use is primarily with Postfix. Nothing fancy. We do use  
> it for some apps, but the utilization problems are with the Postfix  
> usage.

It might be trying to do too much concurrency, which would explain  
this kinda problem.  See if postfix has any facility to do MySQL  
connection pooling, and take a look at how many connections you have  
with mytop.

-bob