Forgot to mention...
OS is not swapping... The load on MySQL server is the same...
Usually my system has ~100 selects/sec and 0.2 inserts/sec.
And I found that during inserts MySQL uses 100% of CPU,
before it used ~5-10% CPU maximum...
I understand that it's difficult to say what is going wrong
show statusHi all,
I am running MySQL version 4.0.14-standard-log on Suse Linux 2.4.20 i686.
All tables in my db are InnoDB tables.
Today morning I've got troubles with perfomance...
Generally all queries are slower in 4-5 times than usually.
Also I see that number of deadlocks is in 10-15 times