Bug #13639 memory leak during server's long time running
Submitted: 30 Sep 2005 8:40 Modified: 30 Oct 2005 10:30
Reporter: ming lu Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.10 OS:Linux (redhat9.0)
Assigned to: CPU Architecture:Any

[30 Sep 2005 8:40] ming lu
We did a test that like the TPC-W test against to the server. During the test, we use the performance monitor of the Linux OS to watch the used quantity of the physical memory. The quantity is increasing during the all process. It decrease 50% until we kill the service of the mysql, but it didn't revert to the initial quantity. So it should be occur a memory leak error.

How to repeat:
1.setup the environment like the tpc-w test. Produce 800eb 10000item's data by the ./ant gendb.
2.execute the following scripts (note: the path should be modified)
mysql -Dtpcw -uroot -p123456
SELECT * FROM address    INTO OUTFILE 'E:\\lxh\\databak\\10000-800\\tt1';
SELECT * FROM author     INTO OUTFILE 'E:\\lxh\\databak\\10000-800\\tt2';
SELECT * FROM cc_xacts   INTO OUTFILE 'E:\\lxh\\databak\\10000-800\\tt3';
SELECT * FROM country    INTO OUTFILE 'E:\\lxh\\databak\\10000-800\\tt4';
SELECT * FROM customer   INTO OUTFILE 'E:\\lxh\\databak\\10000-800\\tt5';
SELECT * FROM item       INTO OUTFILE 'E:\\lxh\\databak\\10000-800\\tt6';
SELECT * FROM orders     INTO OUTFILE 'E:\\lxh\\databak\\10000-800\\tt7';
SELECT * FROM order_line INTO OUTFILE 'E:\\lxh\\databak\\10000-800\\tt8';
3.Do the database restore by the following statements
mysql -Dtpcw -uroot -p123456
truncate table address;
truncate table author;
truncate table cc_xacts;
truncate table country;
truncate table customer;
truncate table item;
truncate table orders;
truncate table order_line;
truncate table shopping_cart;
truncate table shopping_cart_line;
LOAD DATA INFILE 'E:\\lxh\\databak\\10000-800\\tt1' INTO TABLE address;
LOAD DATA INFILE 'E:\\lxh\\databak\\10000-800\\tt2' INTO TABLE author;
LOAD DATA INFILE 'E:\\lxh\\databak\\10000-800\\tt3' INTO TABLE cc_xacts;
LOAD DATA INFILE 'E:\\lxh\\databak\\10000-800\\tt4' INTO TABLE country;
LOAD DATA INFILE 'E:\\lxh\\databak\\10000-800\\tt5' INTO TABLE customer;
LOAD DATA INFILE 'E:\\lxh\\databak\\10000-800\\tt6' INTO TABLE item;
LOAD DATA INFILE 'E:\\lxh\\databak\\10000-800\\tt7' INTO TABLE orders;
LOAD DATA INFILE 'E:\\lxh\\databak\\10000-800\\tt8' INTO TABLE order_line;
   During the restore, watch the  change of the used quantity of physical memory by the performance monitor of the Linux.
[30 Sep 2005 10:30] Hartmut Holzgraefe
can you please add your my.cnf configuration file and the output of SHOW VARIABLES
and of SHOW STATUS to this issue?
[1 Nov 2005 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".