Snort mailing list archives
ACID/MySQL multiple database performance question
From: "Crow, Owen" <Owen_Crow () bmc com>
Date: Wed, 8 Jan 2003 09:50:39 -0600
This probably has a simple answer that I've missed somewhere, but I can't find it. I have a MySQL server with two Snort database. One's schema 105 for 1.8.x sensors, one's 106 for 1.9.x sensors. I have a separate install of ACID for each database. On the newer database with < 5K events, clicking back and forth between pages takes about a second ("Home" to Today's unique alerts and vice versa). On the older database with >800k events, clicking back and forth between those two pages takes almost 3 minutes (176s at last count). If I start a query on the old, slow database then a query on the new, fast database, they both take about 3 minutes. To me it seems pretty obvious that the second query is waiting for the first to finish, but I would have thought that MySQL would have more parallelism than that. Am I just being naive or did I miss some setup in MySQL? Looking at top on the server during the query, there is just one process taking up 100% CPU. I've attached a listing of my server variables in case there's anything obvious I'm missing there. Thanks, Owen Crow Systems Programmer (Unix) BMC Software, Inc. <<mysql.txt>>
Attachment:
mysql.txt
Description:
Current thread:
- ACID/MySQL multiple database performance question Crow, Owen (Jan 08)