Re: transaction with bdb table gives error Lock table is out of available locks

2005-12-09 Thread Marco Baroetto
Bdb tables locks are at page level, how can I determine the number of pages of my table? mysql show variables like '%binlog_cache_size%'; +---++ | Variable_name | Value | +---++ | binlog_cache_size | 32768 | |

Re: transaction with bdb table gives error Lock table is out of available locks

2005-12-09 Thread Marco Baroetto
Hi, here's my create table: mysql show create table parametrivaloriplc; ++-+ | Table | Create Table| ++-+ | parametrivaloriplc | CREATE

Re: Optimize: 14 hours and still running!

2005-12-09 Thread Gleb Paharenko
Hello. As was mentioned by other members without seeing your configuration settings it is difficult to say about InnoDB performance. You can indirectly monitor the OPTIMIZE speed by ROW OPERATIONS section of SHOW INNODB STATUS. For InnoDB it maps to ALTER TABLE, which rebuilds the table.

Re: transaction with bdb table gives error Lock table is out of available locks

2005-12-09 Thread Marco Baroetto
Maybe i got it! For the chronicle: I resolved the problem decreasing the max_bdb_lock to the default value and creating an index on the column used in the where clause of my query. Probably mysql tried to lock the whole table because the primary key wasn't in the where clause. Cheers, Marco

Re: String Manipulation

2005-12-09 Thread Will McDonald
On 09 Dec 2005 10:45:04 +0800, Jeffrey G. Ubalde I have been thinking about this for hours, and I cant quite get the correct keyword for me to search it in the manual. for example i have a field that contains string1:string2:string3 where colon ':' is the delimiter. How do i create a select

Re: SELECT all except ... ?

2005-12-09 Thread Will McDonald
On 09/12/05, Frank Rust [EMAIL PROTECTED] wrote: Is there a possibility to select all columns from a table except one or two columns? For example I have a table with 30 columns and want all columns but one column *not*. Do I have to write a very long select statement with 29 column names that

Re: recursive queries

2005-12-09 Thread Gleb Paharenko
Hello. Though I haven't read this article, but its title looks promicing: http://dev.mysql.com/tech-resources/articles/hierarchical-data.html Duncan Miller wrote: I am looking to do a query on a self join table that returns the parent records. Obviously there are ways to do

Re: Rpm installation problem

2005-12-09 Thread Gleb Paharenko
Hello. It is a bug: http://bugs.mysql.com/bug.php?id=15223 Like temporary workaroud I use on my FC4 system MySQL-shared-compat-4.1.13-0 rpm. Logg, Connie A. wrote: I am trying to install the following rpm on a red hat linux machine.=20

Re: SELECT all except ... ?

2005-12-09 Thread SGreen
Frank Rust [EMAIL PROTECTED] wrote on 12/09/2005 01:59:35 AM: Is there a possibility to select all columns from a table except one or two columns? For example I have a table with 30 columns and want all columns but one column *not*. Do I have to write a very long select statement with 29

Fw: SELECT all except ... ?

2005-12-09 Thread Rhino
Oops, I meant to send this to the original poster _and_ the list :-) Rhino - Original Message - From: Rhino [EMAIL PROTECTED] To: Frank Rust [EMAIL PROTECTED] Sent: Friday, December 09, 2005 9:02 AM Subject: Re: SELECT all except ... ? - Original Message - From: Frank

Normalization question

2005-12-09 Thread Rod Heyd
Hi Everyone, I've got a little debate that maybe you can all help me settle. I have three tables that I need to join, but there are performance problems with the joins due to some misunderstandings of my predecessor about what's needed to join the tables efficiently. Here's the setup. t1 has a

Re: Normalization question

2005-12-09 Thread SGreen
Rod Heyd [EMAIL PROTECTED] wrote on 12/09/2005 11:01:38 AM: Hi Everyone, I've got a little debate that maybe you can all help me settle. I have three tables that I need to join, but there are performance problems with the joins due to some misunderstandings of my predecessor about

Re: Normalization question

2005-12-09 Thread Michael Stassen
Rod Heyd wrote: Hi Everyone, I've got a little debate that maybe you can all help me settle. I have three tables that I need to join, but there are performance problems with the joins due to some misunderstandings of my predecessor about what's needed to join the tables efficiently. Here's

Re: SELECT all except ... ?

2005-12-09 Thread sheeri kritzer
It's not possible in the query, but I wonder if there's a UDF you could write that takes in the name of a table, and then a list of columns NOT to show, and outputs a string of comma-separated values. That'd be neat, so then you could write: SELECT allBut(mytable,badfield1,badfield2,. . .) FROM

Re: MySQL newb trying to write a trigger...

2005-12-09 Thread Jake Peavy
you could also have a look at http://dev.mysql.com/tech-resources/articles/mysql-triggers.pdf which I found useful. -jp

cursor in 4.1

2005-12-09 Thread Kemin Zhou
All, I am using the perl DBI to access a large table. I need to a simple manipulation of the table then write it to a file. If I use the simple select * from table then process this statement on the client side, it looks that the client first receive all the content of the table. This

copying data!!!

2005-12-09 Thread Sachin Bhugra
Hello Friend, Can you please let me know how to copy data from a column in table A to a column in table B. e.g. I want to copy value of column age from table 2 to column age in table 1, provided the entries in column name, which is there in both the table, should match. In MySQL v 4 it could be

Re: cursor in 4.1

2005-12-09 Thread Paul DuBois
At 11:17 -0800 12/9/05, Kemin Zhou wrote: All, I am using the perl DBI to access a large table. I need to a simple manipulation of the table then write it to a file. If I use the simple select * from table then process this statement on the client side, it looks that the client first receive

RE: copying data!!!

2005-12-09 Thread Jimmy Guerrero
Hello, We expect to offer native support for LDAP and PAM authentication, late next year. Thanks, Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com -Original Message- From: Sachin Bhugra [mailto:[EMAIL PROTECTED] Sent: Friday, December 09, 2005 1:38 PM To:

CAST as SIGNE=?ISO-8859-1?Q?D,_bad_id=E9a??=

2005-12-09 Thread Test USER
in an application i have written there is the need to do a search from mysql using numbers that are stored in a varchar column. it is not possible to store only the results with numbers in a seperate column. so i was looking at CAST(), is this a big performance loss? is there some way of

Re: CAST as SIGNE=?ISO-8859-1?Q?D,_bad_id=E9a??=

2005-12-09 Thread SGreen
Assuming that your text data is in the column `userinput` and you want the integer values to be in the column `numericvalue`, this statement will populate the `numericvalue` column all at once: UPDATE `odd_data_table` SET `numericvalue` = `userinput` + 0; You are better off checking for

Re: CAST as S=?ISO-8859-1?Q?IGNED,_bad_id=E9a??=

2005-12-09 Thread Test USER
Hello, thanks for your help! I dont really get it :) You suggestion is to have a seperate column with the name numericvalue and insert userinput into that and add a zero, right? Could you explain more, why when how will this help me :) Quoting [EMAIL PROTECTED]: Assuming that your text data

Re: copying data!!!

2005-12-09 Thread Sachin Bhugra
Tnx for the reply Jimmy. I also sent another question( i know its a very silly question for you all..but believe me i am tryin this for past three days and not able to get it) Pls hlp..(just give me hint in right direction, and i will try to do the rest) Tnx Sachin -- MySQL General Mailing

Re: CAST as S=?ISO-8859-1?Q?IGNED,_bad_id=E9a??=

2005-12-09 Thread SGreen
I misunderstood, I thought you were looking for a way of converting your numbers-as-strings into a native numeric format. Please describe you situation better: What language are you using to build your application. Are you composing the SQL statement client-side or server-side? What kind of

Re: recursive queries

2005-12-09 Thread Eric Bergen
I believe that some time in the future mysql will support oracle style connect by prior syntax but it's not implemented yet. Gleb Paharenko wrote: Hello. Though I haven't read this article, but its title looks promicing: http://dev.mysql.com/tech-resources/articles/hierarchical-data.html

Re: copying data!!!

2005-12-09 Thread Ezra Taylor
Check this out. http://dev.mysql.com/doc/refman/5.0/en/insert-select.html On 12/9/05, Sachin Bhugra [EMAIL PROTECTED] wrote: Hello Friend, Can you please let me know how to copy data from a column in table A to a column in table B. e.g. I want to copy value of column age from table 2 to

Re: CAST as S=?ISO-8859-1?Q?IGNED,_bad_id=E9a??=

2005-12-09 Thread Test USER
Hi again :) The table contains a column named value and is in the format varchar(255). This column contains specifications for different computer products. There is also a id column so i know which product it belongs to. value(varchar) 80 17 1024x768 USB DiVX For example, the first value 80

Re: Optimize: 14 hours and still running!

2005-12-09 Thread Eric Bergen
Is the box swapping? Gleb Paharenko wrote: Hello. As was mentioned by other members without seeing your configuration settings it is difficult to say about InnoDB performance. You can indirectly monitor the OPTIMIZE speed by ROW OPERATIONS section of SHOW INNODB STATUS. For InnoDB it maps to

ANN: Database Workbench 2.8.0 update

2005-12-09 Thread Martijn Tonies
Ladies, gentlemen, This week, Database Workbench 2.8.0 was released. However, that build included an error with MySQL and loading index metadata and an specific error with Firebird/InterBase. There's a new installer available at our website. Below is the original announcement...

RE: copying data!!!

2005-12-09 Thread Gordon Bruce
This is kind of ugly, but with the multitable limitations of 3.23 it probably works. CREATE TABLE TEMP SELECT table_1 columns except age, table_2 age FROM table_1 INNER JOIN table_2 USING (name); TRUNCATE table_1; INSERT INTO table_1 SELECT * FROM TEMP; DROP TABLE_1;

RE: copying data!!!

2005-12-09 Thread Gordon Bruce
Sorry the DROP TABLE Should be TEMP not table1 -Original Message- From: Gordon Bruce [mailto:[EMAIL PROTECTED] Sent: Friday, December 09, 2005 3:51 PM To: Sachin Bhugra; mysql@lists.mysql.com Cc: [EMAIL PROTECTED] Subject: RE: copying data!!! This is kind of ugly, but with the

Re: CAST as S=?ISO-8859-1?Q?IGNED,_bad_id=E9a??=

2005-12-09 Thread SGreen
This sounds like a simple case of bad design. You need to be able to locate specific values for various product descriptions but they are all mangled together into just one field. You end up trying to do substring matches and all hell breaks loose and performance hits the skids. My

Re: CAST as S=?ISO-8859-1?Q?IGNED,_bad_id=E9a??=

2005-12-09 Thread Michael Stassen
Test USER wrote: Hi again :) The table contains a column named value and is in the format varchar(255). This column contains specifications for different computer products. There is also a id column so i know which product it belongs to. value(varchar) 80 17 1024x768 USB DiVX For example, the

Re: CAST as S=?ISO-8859-1?Q?IGNED,_bad_id=E9a??=

2005-12-09 Thread Test USER
Oh, is it really such a bad design? Here is some more. What is substring matches, and why do i need them? TBL_PRODUCTS ID PRODUCTNAME 1 SAMSUNG TV 2 PHILIPS DVD-PLAYER 3 PHILIPS TV 4 MAXTOR DMAX 5 LaCie HARDDIVE -

Re: CAST as S=?ISO-8859-1?Q?IGNED,_bad_id=E9a??=

2005-12-09 Thread Test USER
Yes the ordering is the only problem i have seen so far but i´m concerned that the = ? might cause problems to? It seems to work but since it orders the results wrong can i be sure that it will always do this correct for me? In the ordering it seems like mysql thinks that 80Gb is larger than

Min permissions to run `mysqladmin version`

2005-12-09 Thread Scott Haneda
I need to run `mysqladmin version` from a remote host, on the same LAN, what are the min permissions for a user I need to set up to get this data? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com

Re: Min permissions to run `mysqladmin version`

2005-12-09 Thread Paul DuBois
At 16:33 -0800 12/9/05, Scott Haneda wrote: I need to run `mysqladmin version` from a remote host, on the same LAN, what are the min permissions for a user I need to set up to get this data? No permissions are necessary, you just need an account that has no privileges. The account needs only

IN(INT VS CHAR)

2005-12-09 Thread Test USER
When using IN should i design the database to use int's or is the performance equal? WHERE col IN('test','test2','test3') vs WHERE col IN(1,2,3) - FREE E-MAIL IN 1 MINUTE! - [EMAIL PROTECTED] - http://www.pc.nu -- MySQL General Mailing List

Re: CAST as S=?ISO-8859-1?Q?IGNED,_bad_id=E9a??=

2005-12-09 Thread SGreen
MUCH BETTER!! Sorry I doubted you. However you have to remember that unless you declare a second numeric column in your PRODUCT_SPECS table then everything will be treated as strings. Sorting will be as strings, comparisons will be as strings, and any attempt to use them as numbers while they