On Thu, 9 Dec 2004 12:34:36 -0800
"Dathan Pattishall" <[EMAIL PROTECTED]> wrote:
> This is a very broad question, I sometimes do this myself. But to answer
I know, but where must i begin ...
> the question to the best of my ability I have to ask a few.
>
>
> Are you using RAID? If so what RAID level?
no raid
>
> What are you're my.cnf settings?
standaard execpt for the bind address
>
> What type of Indexes are you using?
On the larged table that has only 2 fields there are primary indexes on both
fields. And each table has its ons primary index, and some other "normal"
indexes.
>
> What does vmstat and iostat say?
NIDS-console distfiles # free
total used free shared buffers cached
Mem: 507508 497872 9636 0 2232 399024
-/+ buffers/cache: 96616 410892
Swap: 506036 62384 443652
procs -----------memory---------- ---swap-- -----io---- --system-- ----cpu----
r b swpd free buff cache si so bi bo in cs us sy id wa
0 2 62384 5044 2380 401636 1 1 251 18 7 522 15 6 79 0
1 0 62384 4412 2392 402296 0 0 4511 13 1272 1859 17 5 79 0
0 2 62384 4504 1840 402744 0 0 4556 72 1325 1977 16 8 76 0
2 0 62412 4960 1808 401408 0 0 3959 0 1170 1866 35 13 52 0
>
> What Filesystem are you using?
ext3
>
> What are some typical queires for a given schema?
I have no idee thats the whole problem, its a propretaire product.
>
>
> Typically for most orginizations mysql dedicated on the box below is
> wicked fast, even when not optimized because of system cache etc. But if
> your running out of diskspace then that's a problem in itself.
I got a lot of disk space left.
>
> -----Original Message-----
> From: Patrick Marquetecken [mailto:[EMAIL PROTECTED]
> Sent: Thursday, December 09, 2004 7:49 AM
> To: [EMAIL PROTECTED]
> Subject: MYSQL is getting slow
>
> Hi,
>
> I have 3 snort sensors logging to a central mySQL database after two
> weeks the size of the database is about 3.3GB and the machine is getting
> slow, as i'm not used to be working with mySQL is my question how far
> can i go before the machine stop responding ?
>
> HP Pentium4 - 2.2mhz - 512 mb, 99% used and no swap, HD of 40GB.
>
> TIA
> Patrick
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
