Hi Torsten,
I think these parameter are most important:
key_buffer = 16M
join_buffer_size= 32M
innodb_buffer_pool_size = 256M
innodb_log_buffer_size = 32M
innodb_log_file_size= 128M
The last 2 affects the recovery time and write speed. Higher values provides
better
Hi Gilmar,
i'm playing around with this buffers since some months without finding a
good solution, can you give me a hint about yours??
We have 4GB RAM at the DB Server.
Thanks Torsten
2007/1/28, Gilmar Santos Jr [EMAIL PROTECTED]:
Dirk Pape escreveu:
[...]
If the latter, does anybody
Hello,
does anybody have the same performance degration on 3.6.3
SelfService/index.html or do I have to dig into our special configuration??
If the latter, does anybody have a hint where to dig into?
Dirk.
--Am 23. Januar 2007 08:39:38 +0100 schrieb Dirk Pape
[EMAIL PROTECTED]:
Hello,
I
On Sat, Jan 27, 2007 at 09:29:17AM +0100, Dirk Pape wrote:
Hello,
does anybody have the same performance degration on 3.6.3
SelfService/index.html or do I have to dig into our special configuration??
If the latter, does anybody have a hint where to dig into?
I haven't seen it. It
Hi Jesse,
--Am 27. Januar 2007 03:36:24 -0500 schrieb Jesse Vincent
[EMAIL PROTECTED]:
I haven't seen it. It _does_ look like htat query is qgetting built
wrong. I wonder if changing the search to be Watcher = rather than what
it is now would make it all better.
you are right. Switching
On 1/28/07, Dirk Pape [EMAIL PROTECTED] wrote:
Hi Jesse,
--Am 27. Januar 2007 03:36:24 -0500 schrieb Jesse Vincent
[EMAIL PROTECTED]:
I haven't seen it. It _does_ look like htat query is qgetting built
wrong. I wonder if changing the search to be Watcher = rather than what
it is now would
Hello,
--Am 27. Januar 2007 22:18:04 +0100 schrieb Dirk Pape
[EMAIL PROTECTED]:
you are right. Switching to Watcher instead of ( Requestor, Cc, AdminCc )
helps.
thanks Jesse for help and Ruslan for explaination.
Here is the simple patch.
Dirk.
performance_of_selfservice.patch
Dirk Pape escreveu:
[...]
If the latter, does anybody have a hint where to dig into?
Try to increase innodb_buffer_pool_size in my.cnf. See [1], [2] and
[3]. Tunning some parameters like join_buffer_size,
innodb_buffer_pool_size and some others gave me a huge performance
improvement. Take care