Re: error 1041: Out of memory;

2012-02-28 Thread Mihamina Rakotomandimby
On 02/28/2012 03:34 PM, Shafi AHMED wrote: pls assist - please give more information (OS, ...) - you can search the web with -- "ulimit more memory" -- "mysql you-os increase memory" -- "mysql you-os increase memory ulimit" -- "mysql configuration memory" -- ... -- RMA. -- MySQL General Mail

Re: does the number of column affect performance

2012-02-28 Thread Zheng Li
even if I select all columns every time no matter it is Table A or B, A has better performance? On 2012/02/29, at 4:41, Paul DuBois wrote: > > On Feb 28, 2012, at 9:59 AM, Zheng Li wrote: > >> for example >> there are 2 tables to save same data >> table A has 10 columns: a primary key column

Re: does the number of column affect performance

2012-02-28 Thread Michael Dykman
not to mention, updating any field on table 2 requires the entire contents to be written out again instead of being able to effect those columns individually. Quite a few NoSL solutions work on a similar model which, while useful in places, is decidedly NOT relational. If you are *certain* that t

Re: does the number of column affect performance

2012-02-28 Thread Paul DuBois
On Feb 28, 2012, at 9:59 AM, Zheng Li wrote: > for example > there are 2 tables to save same data > table A has 10 columns: a primary key column and 9 blob column > table B has 2 columns : a primary key column and 1 blob column which includes > all data in 2nd~10th columns of table A > > are th

error 1041: Out of memory;

2012-02-28 Thread Shafi AHMED
Dear All, I am getting below errors intermittently.. this is "all of a sudden " messages where the queries generated causing the prob...memory seems to be fine. pls assist [28-Feb-2012 15:54:05] MySQL error 1041: Out of memory; Check if mysqld or some other process uses all available memory.