Hi Alexander,
Alexander Hahn [mailto:[EMAIL PROTECTED] wrote:
Subject: loadercli performance loss when upgrading from 7.3 to 7.4
we are experiencing severe performance losses when using loadercli/repmcli scripts ( DATALOAD TABLE ... ) since we upgraded to 7.4.3.25.
How much does the performance decrease? Any figures? What command do you run?
The LOG_MODE is set to off. Is there perchance a parameter, whose default value has changed and that could influence the loading performance?
The only parameter I could think of is the kernel parameter CACHE_SIZE. What's the value for this?
Regards, Steffen
Hi Steffen,
it takes c. 5x as long to load a given table. This is only true for the larger tables ( > 800 MB ). In addition, we note that around 5x as many kernel processes are running.
CACHE_SIZE is set to 60.000, in our version 7.3 databases, the DATA_CACHE was 40.000.
Regards, Alex
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
