Re: Pb with mysql client display

2001-08-17 Thread Xavier Leoncini
[EMAIL PROTECTED] wrote: >On Thu, Aug 16, 2001 at 10:38:46PM -0400, Xavier Leoncini wrote: > >>I have the following problem: >>When displaying a select * query from a table >>I get the following: (just showing the end). >> >>| | | 2928 | 1

Pb with mysql client display

2001-08-17 Thread Xavier Leoncini
I have the following problem: When displaying a select * query from a table I get the following: (just showing the end). | | | 2928 | 1611100 | | | | 2929 | 1251300 | +--++--+--+--+ The last column is empty, which is normal but the

Innodb restart problem

2001-08-13 Thread Xavier Leoncini
Hi, I guess somthing happenned this weekend and mysql restarted. After the doing a recovery scanning . message I get the following: Warning difficult to find free block try to increase memory buffer pool size. I have killed the process and increased the memory so now mysql is using about 90.6

Re: Innodb table size

2001-07-30 Thread Xavier Leoncini
t; >>Other then that I wouldn't know. But live with the fact that keys >>introduce overhead. It will be like that on any database system. >> >>>-Original Message- >>>From: Xavier Leoncini [mailto:[EMAIL PROTECTED]] >>>Sent: 30 July 2001 04:3

Re: Innodb table size

2001-07-30 Thread Xavier Leoncini
ut live with the fact that keys >introduce overhead. It will be like that on any database system. > >>-----Original Message- >>From: Xavier Leoncini [mailto:[EMAIL PROTECTED]] >>Sent: 30 July 2001 04:34 >>To: [EMAIL PROTECTED] >>Subject: Innodb table size >&

Innodb table size

2001-07-30 Thread Xavier Leoncini
Hello, I was wondering if someone could help me; When I load about 6Gb of raw data into a innodb table the size used by the table is about 14G. I noticed in preleminary tests that the sized used depends a lot on the number of rows in the case described above the data has about 180 millions rows,