Every now and then the following lines show up in MySQL processes, and just keep coming untill the mysql server crashes:
| 8629 | **_agbook1 | localhost | **_agbook1 | Sleep | 522 | | |
| 8668 | **_agbook1 | localhost | **_agbook1 | Query | 238 | Copying to tmp table | select x.*, y.p_filename, y.width, y.height, z.comments from book_data x left join book_pics y on (x |
| 8669 | **_agbook1 | localhost | **_agbook1 | Query | 231 | Copying to tmp table | select x.*, y.p_filename, y.width, y.height, z.comments from book_data x left join book_pics y on (x |
| 8674 | **_agbook1 | localhost | **_agbook1 | Query | 170 | Copying to tmp table | select x.*, y.p_filename, y.width, y.height, z.comments from book_data x left join book_pics y on (x |
| 8682 | **_agbook1 | localhost | **_agbook1 | Query | 35 | Copying to tmp table | select x.*, y.p_filename, y.width, y.height, z.comments from book_data x left join book_pics y on (x |
Anyone have any ideas about how i can solve this?
Thanks in advance,
Ruud Goedhart
| 8629 | **_agbook1 | localhost | **_agbook1 | Sleep | 522 | | |
| 8668 | **_agbook1 | localhost | **_agbook1 | Query | 238 | Copying to tmp table | select x.*, y.p_filename, y.width, y.height, z.comments from book_data x left join book_pics y on (x |
| 8669 | **_agbook1 | localhost | **_agbook1 | Query | 231 | Copying to tmp table | select x.*, y.p_filename, y.width, y.height, z.comments from book_data x left join book_pics y on (x |
| 8674 | **_agbook1 | localhost | **_agbook1 | Query | 170 | Copying to tmp table | select x.*, y.p_filename, y.width, y.height, z.comments from book_data x left join book_pics y on (x |
| 8682 | **_agbook1 | localhost | **_agbook1 | Query | 35 | Copying to tmp table | select x.*, y.p_filename, y.width, y.height, z.comments from book_data x left join book_pics y on (x |
Anyone have any ideas about how i can solve this?
Thanks in advance,
Ruud Goedhart