[nycbug-talk] Re: MySQL
Sun Aug 21 15:01:14 EDT 2005
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
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
More information about the talk