Re: C API Function for count(*)

2010-05-14 Thread Dan Nelson
In the last episode (May 14), Tim Johnson said: > I have MySQL version 5.0.84 on linux slackware 13.0 32-bit. > > I am working with a relatively new API written in a programming language > with a small user base (newlisp). The newlisp API imports a number of C > API functions from the system My

C API Function for count(*)

2010-05-14 Thread Tim Johnson
I have MySQL version 5.0.84 on linux slackware 13.0 32-bit. I am working with a relatively new API written in a programming language with a small user base (newlisp). The newlisp API imports a number of C API functions from the system MySQL shared object. If I were to issue a count(*) query fr

Re: libexec/mysqld: unknown option '--skip-bdb'

2010-05-14 Thread Joerg Bruehe
Hi Kris, all, Kris wrote: > Joerg, thanks again for the help. > > I disagree with you. that's perfectly fine - combining our two different viewpoints, we will be able to show more of the issue at hand than from one point alone. > >>> I doubt many more users try to create a clean test installa

Re: libexec/mysqld: unknown option '--skip-bdb'

2010-05-14 Thread Kris
>Do not install software in /tmp in Linux. >/tmp is not guaranteed to survive a reboot. Thank you for the heads up. Well... there is *another* bug where if one specifies in their my.cnf filepaths that are over 100 characters, the filenames are truncated at 100, hence making it impossible to really

Re: libexec/mysqld: unknown option '--skip-bdb'

2010-05-14 Thread Kris
Joerg, thanks again for the help. I disagree with you. > > I doubt many more users try to create a clean test installation of > > MySQL, in a specific directory, on a machine that already has MySQL > > installed. > > Correct - but if really the occurrence in "mysql_install_db" were the > issue,

Re: Can't create foreign key

2010-05-14 Thread Prabhat Kumar
I have faced the same issue in past. * key name must be a unique*. On Fri, May 14, 2010 at 11:33 PM, wrote: > Nope, that wasn't the problem. I wasn't aware that the foreign key name > must be unique. So, if you have a foreign key named "fk_lesson", that same > name cannot exist already, even if

RE: Can't create foreign key

2010-05-14 Thread jc
Nope, that wasn't the problem. I wasn't aware that the foreign key name must be unique. So, if you have a foreign key named "fk_lesson", that same name cannot exist already, even if on a different table. I named the foreign key something completely different and that solved the problem. Jesse -

RE: Can't create foreign key

2010-05-14 Thread jc
Interesting. Thanks for that tip on showing the INNODB STATUS. It turned up the error: A foreign key constraint of name `cc/fk_lessons` already exists. ...which tells me that a foreign key name cannot already be in use even if on a different table (at least that's what it appears to be saying).

Re: Can't create foreign key

2010-05-14 Thread Carsten Pedersen
Haven't done this in a while, but I'm guessing that you can't create both a constraint and an index with the same name? Type mismatch will in my experience most often generate an errno 150. / Carsten j...@msdlg.com skrev: I'm trying to create a foreign key by executing the following statement

RE: Can't create foreign key

2010-05-14 Thread Gavin Towey
Perror 121 says: OS error code 121: Remote I/O error Which I'm not too sure why an ALTER to add an constraint would give that error. Normally though, foreign key errors are shown in the SHOW ENGINE INNODB STATUS \G output, look for more details there. Regards, Gavin Towey -Original Messag

Can't create foreign key

2010-05-14 Thread jc
I'm trying to create a foreign key by executing the following statement: ALTER TABLE `cc`.`takenlessons` ADD CONSTRAINT `fk_lessons` FOREIGN KEY (`LessonID` ) REFERENCES `cc`.`lessons` (`id` ) ON DELETE CASCADE ON UPDATE NO ACTION , ADD INDEX `fk_lessons` (`LessonID` ASC) ; I'

Re: libexec/mysqld: unknown option '--skip-bdb'

2010-05-14 Thread Joerg Bruehe
Kris, all, Kris wrote: > On Fri, 2010-05-14 at 10:28 +0200, Joerg Bruehe wrote: >>> The following error just won't go away: >>> >>> 100513 21:53:35 [ERROR] /tmp/msource/libexec/mysqld: unknown option >>> '--skip-bdb' >>> >>> ... even after I manually search for the location where this flag is >>>

Re: Implementation of Key Caches

2010-05-14 Thread Shawn Green
James W. McKelvey wrote: According to the 5.1 docs, I can have multiple key caches for MYISAM on a 32-bit host, each with up to 4G. But that means that each cache can take the entire address space of a process. How does the MySQL server get around the limitation? If the OS fails to allow t

Re: libexec/mysqld: unknown option '--skip-bdb'

2010-05-14 Thread Gerald L. Clark
Kris wrote: Hello, I am trying to produce an automated, reliable, and repeatable way of testing mysql releases, and I am finding an error that makes this impossible to accomplish. I am trying to compile mysql and install it in a non-standard directory. I do notwant mysql installed in /usr or /u

Implementation of Key Caches

2010-05-14 Thread James W. McKelvey
According to the 5.1 docs, I can have multiple key caches for MYISAM on a 32-bit host, each with up to 4G. But that means that each cache can take the entire address space of a process. How does the MySQL server get around the limitation? -- MySQL General Mailing List For list archives: http:

Re: libexec/mysqld: unknown option '--skip-bdb'

2010-05-14 Thread Kris
On Fri, 2010-05-14 at 10:28 +0200, Joerg Bruehe wrote: > > The following error just won't go away: > > > > 100513 21:53:35 [ERROR] /tmp/msource/libexec/mysqld: unknown option > > '--skip-bdb' > > > > ... even after I manually search for the location where this flag is > > passed, and manually edi

Re: starting multiple instances with mysqld_multi

2010-05-14 Thread Yang Wang
Hi,Nitin Below information for your reference. for my.cnf [mysqld5129] port=5506 socket=/tmp/mysql5129.sock basedir=/opt/MySQL5129 datadir=/opt/MySQL5129/var user=mysql log-error=/var/log/mysqld5129.log pid-file=/tmp/mysqld5129.pid #log

Re: Array data type

2010-05-14 Thread Joerg Bruehe
Hi Samrat, all! Samrat Kar wrote: > Hello, > > > > How to store multiple values in a single field? Is there any array data type > concept in mysql? "Multiple values in a single field" would be an explicit violation of the relational model (on which the SQL language is based) and cause all ki

Re: Array data type

2010-05-14 Thread Carsten Pedersen
There are SETs and ENUMs, but I've always found that dealing with them is annoying. YMMV / Carsten On Fri, 14 May 2010 13:54:29 +0530, "Samrat Kar" wrote: > Hello, > > > > How to store multiple values in a single field? Is there any array data > type > concept in mysql? >

Re: libexec/mysqld: unknown option '--skip-bdb'

2010-05-14 Thread Joerg Bruehe
Hi Kris, all, what you describe here seems to be related to MySQL bug# 50336 http://bugs.mysql.com/bug.php?id=50336 : Kris wrote: > [[...]] > > I am trying to compile mysql and install it in a non-standard directory. > I do notwant mysql installed in /usr or /usr/local. For example, I am > tryi

Array data type

2010-05-14 Thread Samrat Kar
Hello, How to store multiple values in a single field? Is there any array data type concept in mysql? Regards, Samrat Kar FRD, BARC Tel: 022-25597295 Alternate Email: esam...@yahoo.com

Re: multiple level database hierarchy

2010-05-14 Thread Joerg Bruehe
Hi! Peng Yu wrote: > I seems that mysql and may SQL has only two levels databases->tables. > Where there many tables, it become hard to properly name the tables > and databases. I'm wondering if there is any variant of SQL or some > other database that support arbitrary levels of complexity. Whe

libexec/mysqld: unknown option '--skip-bdb'

2010-05-14 Thread Kris
Hello, I am trying to produce an automated, reliable, and repeatable way of testing mysql releases, and I am finding an error that makes this impossible to accomplish. I am trying to compile mysql and install it in a non-standard directory. I do notwant mysql installed in /usr or /usr/local. For