ERROR 1114

2006-12-19 Thread serpent
I ran into this problem while attempting to altering tables (by adding extra columns), which is just as well, as the cosequences would have been dire if I'd found it any other way. I haven't found any other unambiguous references to this problem on this list, where I was searching for a clue, so I

Re: bug

2006-12-19 Thread Raj Shekhar
ajay roy wrote: > i am getting the error somthing like that > > GET ERROR(127) TABLE HANDLER PROBLEM > stormcrow|~$ perror 127 Error code 127: Unknown error 127 MySQL error: 127 = Record-file is crashed -- raj shekhar facts: http://rajshekhar.net | opinions: http://rajshekhar.net/blog I dar

Re: interesting benchmark at tweakers.net

2006-12-19 Thread David Sparks
Jochem van Dieten wrote: > On 12/19/06, David Sparks wrote: >> I noticed an interesting benchmark at tweakers.net that shows mysql not >> scaling very well on hyperthreading and multicore cpus (see links at end >> of email). >> >> Does anyone know what engine they are using for their tests? (Innodb

rhel4 mysql max rpm question

2006-12-19 Thread Yong Lee
Hi All, I noticed that there are RPM downloads for RHEL4 but that these do not contain the ndb storage engine (ie: these are standard builds). As such, I've resolved to just use the generic x86 rpm bundles that are offered but I'm curious if the ndb storage engine will ever get included into a

Re: no log generated?

2006-12-19 Thread Daniel da Veiga
On 12/19/06, Bing Du <[EMAIL PROTECTED]> wrote: Hi, We use /usr/libexec/mysqld Ver 4.1.20 for redhat-linux-gnu on i386 (Source distribution). /etc/my.cnf has the following configurations. == [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password forma

no log generated?

2006-12-19 Thread Bing Du
Hi, We use /usr/libexec/mysqld Ver 4.1.20 for redhat-linux-gnu on i386 (Source distribution). /etc/my.cnf has the following configurations. == [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (thos

RE: URGENT: Question on table storage

2006-12-19 Thread Tom Horstmann
Hi, > I have the following table in mysql 5.0.20... > > employ > == > empid > date_time > site > > I am using this table to store all the websites accessed by each > employees. There is no primary key on that table since the same > employee will access more than 100 sites per day. If there i

Re: URGENT: Question on table storage

2006-12-19 Thread Christian Hammers
On 2006-12-19 Prem wrote: > I am using this table to store all the websites accessed by each employees. I hope you're aware that your country might have data privacy laws, too.. > There is no primary key on that table since the same employee will access > more than > 100 sites per day. If ther

URGENT: Question on table storage

2006-12-19 Thread Prem
Hello, I have the following table in mysql 5.0.20... employ == empid date_time site I am using this table to store all the websites accessed by each employees. There is no primary key on that table since the same employee will access more than 100 sites per day. If there is 100 employees t

Re: interesting benchmark at tweakers.net

2006-12-19 Thread Jochem van Dieten
On 12/19/06, David Sparks wrote: I noticed an interesting benchmark at tweakers.net that shows mysql not scaling very well on hyperthreading and multicore cpus (see links at end of email). Does anyone know what engine they are using for their tests? (Innodb, myisam, berkdb heheh) InnoDB, the f

What is your favorite laptop? SONY VAIO, Apple POWERBOOK, IBM Thinkpad, TOSHIBA, DELL, HP check it out

2006-12-19 Thread Teenwag friends
Hello, Your friend thinks you might like this ... What is your favorite laptop? SONY VAIO, Apple POWERBOOK, IBM Thinkpad, TOSHIBA, DELL, HP http://www.teenwag.com/poll?n=159 Thanks, Take back news sent via http://www.teenwag.com Personal Message : Hey I found this cool