table in use

When i do some insert or edit operations on my BDB tables i sometimes get an error saying "table in use". After this i cannot proceed further. I only have to shut down the server and restart it all over again. Why do i get this and what should be done ??

Alphabetizing within GROUPS

Hi. Thanks for any help on this. I've been beating my head over it for hours. Here's what I am trying to do: I have four tables I am joining via a unique key (Fellow_id). The results I want to group into three categories, each alphabetized within the group. Is this too much to do in a single q

RE: MySQL Control Center works with v4.0.23 -- how about V5?

That is unfortunate that it MSQLCC is deprecated. Is there a gui tool, maybe query-browser, that will let me update, insert and delete without writing SQL statements? That was a very nice feature. Thanks, Siegfried _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, A

RE: hierarchical db/depth?

You should see it: http://www.openwin.org/mike/presentations/hierarchy/hierarchy.html Regrads! -Original Message- From: mel list_php [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 30, 2005 9:01 AM To: mysql@lists.mysql.com Subject: hierarchical db/depth? hi! I'm still trying to orga

Server hangs and table gets corrupted on simple subselect

Hi, I wonder if someone can help me with the following simple(?) MySQL problem. I have a table 'action' with about 180,000 web server requests records running under MySQL Ver 14.7 Distrib 4.1.12 (Fedora Core 4) mysql>desc action +-+--+--+-+-+-

Re: Insert Into problem

Thanks guys! >>> [EMAIL PROTECTED]> 8/30/05 1:22 PM >> The correct syntax for the second method doesn't use "VALUES()". I would always use this form if I were going to exclude any columns from receiving data. It's just safer and relies less on the SQL engine to correctly divine what it is y

RE: Error while running mysql_install_db on Solaris 8

Hi, Your error message khanstation# scripts/mysql_install_db --user=mysql Installing all prepared tables ld.so.1: ./bin/mysqld: fatal: libz.so.1: open failed: No such file or directory <-- means you don't have zlib installed or you don't

Re: Counting results for pagination + limit?

On Tuesday 30 August 2005 02:30 pm, [EMAIL PROTECTED] wrote: > Chris <[EMAIL PROTECTED]> wrote on 08/30/2005 01:51:34 PM: > > Greetings, > > > > We have a few queries that we use against our product database. We pull > > these > > > results, and only display 50 rows per page via our web interface (

Re: Error while running mysql_install_db on Solaris 8

Helal Khan <[EMAIL PROTECTED]> wrote on 08/30/2005 04:35:48 PM: > > Please see the attached output of the bug report and an output file > of the messages that came out in the screen on Sun Solaris 8 while > running the mysql_install_db for MySQL version 4,1.14, 64 bit. I got > the same message

Error while running mysql_install_db on Solaris 8

Please see the attached output of the bug report and an output file of the messages that came out in the screen on Sun Solaris 8 while running the mysql_install_db for MySQL version 4,1.14, 64 bit. I got the same message for 32 bit version also. I tried MySQL version 4,1.12, 64 bit and 32 bit al

Re: hierarchical db/depth?

Mel, >I would like to know if there is a way to have a kind of "auto-extension" >of the query if there is for example a fifth level? SQLdoesn't have recursion, so to avoid writing literal queries for each number of levels you need either (i) something like an edge list, an adjacency list, or a

Connections with bad DNS cause lockups

Hi, We seem to be running into a problem with our installation that we don't understand. We are running "mysql-server-4.0.25" from the ports collection on a FreeBSD 5.3-RELEASE-p10 machine. Its tcpwrapper'd to only allow from our /24, and a single machine outside the /24.

Re: Insert Into problem

"Ed Reed" <[EMAIL PROTECTED]> wrote on 08/30/2005 04:08:57 PM: > Can anyone please tell me why this fails, I've done this type of > thing before without a problem > > Insert Into tbl1 Select 10306, fld2, fld3, fld4 From tbl1 Where fld1=8114 > > > tbl1 has five fields all ints with fld5 being

Re: Insert Into problem

Drop the VALUES part in your second attempt: INSERT INTO tbl1 (fld1, fld2, fld3, fld4) SELECT 10306, fld2, fld3, fld4 FROM tbl1 WHERE fld1 = 8114 Note that you'll need to be running MySQL 4.0.14 or above to insert into the same table you're selecting from. __

Insert Into problem

Can anyone please tell me why this fails, I've done this type of thing before without a problem Insert Into tbl1 Select 10306, fld2, fld3, fld4 From tbl1 Where fld1=8114 tbl1 has five fields all ints with fld5 being the autoincrement index. I've also tried it as, Insert Into tbl1 (fld1, f

Re: MySQL Control Center works with v4.0.23 -- how about V5?

"Siegfried Heintze" <[EMAIL PROTECTED]> wrote on 08/30/2005 03:11:26 PM: > [Siegfried Heintze] I love MySQL Control center. I can make it work for > MySQL v4.0 but not the latest (v5). It simply does not connect to the V5 > Mysql server I just installed. It seems to hang on the connection. > > A

Re: MySQL Control Center works with v4.0.23 -- how about V5?

>From what I recall MysqlCC has been deprecated and has been replaced by MySQL Administrator (which does support v5). I don't know think mysqlcc supports v5. good luck, --bemansell On 8/30/05, Siegfried Heintze <[EMAIL PROTECTED]> wrote: > > [Siegfried Heintze] I love MySQL Control center. I c

MySQL Control Center works with v4.0.23 -- how about V5?

[Siegfried Heintze] I love MySQL Control center. I can make it work for MySQL v4.0 but not the latest (v5). It simply does not connect to the V5 Mysql server I just installed. It seems to hang on the connection. Am I doing something wrong or does MySQL Control center not support 5? Assuming it do

stopping drop index command on table

What are the consequences of cancelling(stopping) the drop index on table command if any at all? The process is running on a 9GB table and need to stop the process (dev environment). Thanks in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: Linux+AMD64+MySQL.

RV Tec wrote: Folks, I'm used to run MySQL (4.0) with OpenBSD (3.7). Now I've decided to give Linux a shot, to see if I could gain some serious performance. The server I'm using is a dual Opteron 246, with 2GB RAM, LSI MegaRAID 320. CentOS 4.1 x86_64 seems to be a good OS. Although I though

Re: Counting results for pagination + limit?

Chris <[EMAIL PROTECTED]> wrote on 08/30/2005 01:51:34 PM: > Greetings, > > We have a few queries that we use against our product database. We pull these > results, and only display 50 rows per page via our web interface (then use > "next and back page" links). An example query is: > > selec

Counting results for pagination + limit?

Greetings, We have a few queries that we use against our product database. We pull these results, and only display 50 rows per page via our web interface (then use "next and back page" links). An example query is: select distributer.short_desc, distributer.sku, distributer.avail_code, distri

Re: Linux+AMD64+MySQL.

Hello. I'm not directly answering on your questions, but this link sounds to be helpful: http://hashmysql.org/index.php?title=Opteron_HOWTO Have a look here as well: http://dev.mysql.com/doc/mysql/en/compile-and-link-options.html I'm using official binaries of MySQL in most cases, s

Re: A lot of instances of mysqld

Hello. >Is this normal? Yes. These are actually threads of a single process. JM <[EMAIL PROTECTED]> wrote: > Hi ALL, > >Is this normal? > > 26527 ?SW 0:00 /bin/sh /usr/bin/mysqld_safe > --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/db.forum.com

Re: Some Assistance Please

Greetings Rob, > > What is the optimum way to structure the database to allow for the > simplest user search? > Is it more efficient to store images and large documents in their > respective format on disc and the URL in the database or as blob objects? Most of the times, especially for read-o

Some Assistance Please

Hi All, I have been using MySQL for some time in a basic and simple manner to retain prompt information and data for my multilingual websites. My new project is however a much larger matter. The site is a repository for advertisements advertising vehicles. This includes land sea and air vehic

RE: Regarding the usage of mutex in the mysql connection threading

I can not and will not make an absolute recommendation to keep or lose the mutex before I performed a full code review. IMHO, the final stages of a project is one of the worst times to be making this kind of decision as it could impact so much work already accomplished. If you are certain tha

Re: timestamp and php

[EMAIL PROTECTED] wrote: Hi, I have a row in mysql database called time and is just a simple timestamp column When I echo it out echo $row['time']; echo $row['content']; I get the following 2005-08-30 13:50.05 "this is the text content" Now I am not worried about the time but I would like

Re: Table Collation ?

m i l e s <[EMAIL PROTECTED]> wrote on 30/08/2005 15:28:31: > Hi, > > Ive noticed that my ALL my databases and tables have > "latin1_swedish_ci" as the collation...h that wouldn't be so bad > except that I didn't set it that way by default, and I don't speak > swedish. Not that swedish is

RE: Regarding the usage of mutex in the mysql connection threading

Hi Green, We are at the last stage of the project (migration from Oracle to MySQL). We are demanded to adopt the MYODBC as a customer requrement. As mutex was implemented for oracle so it is there in our code. Now we are thinking to remove that because application level we have connection id. So,

RE: Regarding the usage of mutex in the mysql connection threading

<[EMAIL PROTECTED]> wrote on 08/30/2005 10:09:27 AM: > > Hi, > > >Please advise us whether mysql/myodbc > > > > - handles different queries/write from different threads within the same > connection or not? > > - handles different queries (or batch fetches) from multi-connections or

Re: timestamp and php

> 2005-08-30 13:50.05 "this is the text content" > (i) sort the returned rows in order (latest first) http://dev.mysql.com/doc/mysql/en/sorting-rows.html > (ii) be able to extract the individual parts of the date and display them in > UK format (ddmm) http://www.php.net/manual/en/function.

RE: Regarding the usage of mutex in the mysql connection threading

<[EMAIL PROTECTED]> wrote on 08/30/2005 10:03:51 AM: > Could any one of you please let me know in mysql/myODBC > that the session control is now under their management meaning > - handles different queries/write from different threads within the same > connection > - handles different queries (or

timestamp and php

Hi, I have a row in myslq database called time and is just a simple timestamp column When I echo it out echo $row['time']; echo $row['content']; I get the following 2005-08-30 13:50.05 "this is the text content" Now I am not worried about the time but I would like to know how to (i) sort

Table Collation ?

Hi, Ive noticed that my ALL my databases and tables have "latin1_swedish_ci" as the collation...h that wouldn't be so bad except that I didn't set it that way by default, and I don't speak swedish. Not that swedish isn't a fine language, or sweden isn't a fine country (although Ive n

Linux+AMD64+MySQL.

Folks, I'm used to run MySQL (4.0) with OpenBSD (3.7). Now I've decided to give Linux a shot, to see if I could gain some serious performance. The server I'm using is a dual Opteron 246, with 2GB RAM, LSI MegaRAID 320. CentOS 4.1 x86_64 seems to be a good OS. Although I thought that the most

innodb thread concurrency size

Hey guys, I'm looking for any best practices or a formula that is commonly used in setting the value for thread concurrency in the configuration file. I have 24 instances running on a sun 2900 server with 32GB or ram. Here is a sample of my configuration file. #use this line mfor mysql 4.1 old

RE: Regarding the usage of mutex in the mysql connection threading

Hi, Please advise us whether mysql/myodbc - handles different queries/write from different threads within the same connection or not? - handles different queries (or batch fetches) from multi-connections or not? Thanks, Narasimha -Original Message- From: Lakshmi NarasimhaRao (W

RE: Regarding the usage of mutex in the mysql connection threading

hi , Could any one of you please let me know in mysql/myODBC that the session control is now under their management meaning - handles different queries/write from different threads within the same connection - handles different queries (or batch fetches) from multi-connections P

hierarchical db/depth?

hi! I'm still trying to organize an hierachical db (I saw the last article on mysql.com: http://dev.mysql.com/tech-resources/articles/hierarchical-data.hml). I began working with what the author calls "adjency list model" (I think the nested set model is a bit too complex for what I want to do.

RE: Regarding the usage of mutex in the mysql connection threading

Hi Green, Thanks a lot for your reply. In brief if I explain the architecture it something goes like this:- - Element management Apllications uses MySQL database through DB access layer. - DB access layer provides the application some APIs needed for DB opearations. - for Each DB transactions

RE: mysqldump: Error 2013

> Have a look here: > http://dev.mysql.com/doc/mysql/en/gone-away.html Gleb, Thanks for the response. The only one that seems to apply is this one: > You may also see the MySQL server has gone away error if > MySQL is started with the --skip-networking option. I do start mySQL without networki

Re: Regarding the usage of mutex in the mysql connection threading

<[EMAIL PROTECTED]> wrote on 08/30/2005 08:54:44 AM: > > Hi, > > >We migrated a NMS project from oracle 7.3 database to mysql > 4.0.23. In the migration we kept the mutex mechanism followed in the > oracle for connection threading. Actually these mutex are mainly used > before executing

Regarding the usage of mutex in the mysql connection threading

Hi, We migrated a NMS project from oracle 7.3 database to mysql 4.0.23. In the migration we kept the mutex mechanism followed in the oracle for connection threading. Actually these mutex are mainly used before executing the sql statements which returns multiple number of records and

Re: assistance

acet technologies <[EMAIL PROTECTED]> wrote on 08/30/2005 04:01:46 AM: > dear sir, > >i am an IT engineer but i have a specialization in network, internet > >service & hardware. presently i hv setup my WISP company and i am now > free to pursue other endeavours, and i want to get to know more abo

A lot of instances of mysqld

Hi ALL, Is this normal? 26527 ?SW 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/db.forum.com.pid.pid 26554 ?S 23:08 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/db.forum.com.

Re[2]: Slow Queries Log and Index-less queries

Thanks Alexey, This is enough explanation for me ;) Cheers, HMax AP> I have a question regarding the slow queries log, and queries not using index. AP> I have a small table, with say 10 entries, like that : AP> ID |  Element AP> - AP> 1  |  One AP> 2  |  Two AP> 3  |  Three AP> 4 

Re: Slow Queries Log and Index-less queries

> > > I have a question regarding the slow queries log, and queries not using > index. > > I have a small table, with say 10 entries, like that : > ID | Element > - > 1 | One > 2 | Two > 3 | Three > 4 | Four > 5 | Five > 6 | Six > 7 | Seven > 8 | Eight > 9 | Nine > 10 | Ten > > I w

Slow Queries Log and Index-less queries

Hey list, I have a question regarding the slow queries log, and queries not using index. I have a small table, with say 10 entries, like that : ID | Element - 1 | One 2 | Two 3 | Three 4 | Four 5 | Five 6 | Six 7 | Seven 8 | Eight 9 | Nine 10 | Ten I want to get a

Re: [Replication] Problem connecting to master

Hello. If nothing helps, trace files could spill the light on your problem. See: http://dev.mysql.com/doc/mysql/en/making-trace-files.html Jan Roehrich <[EMAIL PROTECTED]> wrote: >> --skip-networking can be specified as the command line option. Use: >> show variables like 'skip_ne

assistance

dear sir, >i am an IT engineer but i have a specialization in network, internet >service & hardware. presently i hv setup my WISP company and i am now free to pursue other endeavours, and i want to get to know more about the >software angle of IT. >I need assistance on how to develop my skills fro

assistance

dear sir, >i am an IT engineer but i have a specialization in network, internet >service & hardware. presently i hv setup my WISP company and i am now free >to pursue other endeavours, and i want to get to know more about the >software angle of IT. >I need assistance on how to develop my skills fr