MySQL 5.0, func stored in proc table

Hi, I compiled MySQL 5.0 from the source tree to test how stored procedures work. When I create a function, It is not stored in de mysql.func table, but in the mysql.proc table. Example of the function a create: create function fun(a int) returns int begin set a = a + 1; return

Re: Enabling Transactions

Dan Anderson [EMAIL PROTECTED] wrote: I am having a problem in one of my scripts and I need to use transactions to fix it. When I looked it up on the mySQL documentation I found: If you are using transaction-safe tables (like InnoDB or BDB), you can put MySQL into non-autocommit mode with

MySQL installation and starting problems on LynxOS

Hello, I tried installing MySQL on LynxOS, and it went fine. After installation I started mysqld and but was not able to communicate with it. When I ran mysqladmin it reported the following arjuna# /usr/local/mysql/bin/mysqladmin version /usr/local/mysql/bin/mysqladmin: connect to

loading data from a textfile into MySQL database

Greetings, I have a datafile called 'salary.txt', and it's a tab delimited file, the structure is like this: employee_nametabsalaryenter employee_nametabsalaryenter ... I have a table called 'salary', and it has the same structure as the 'salary.txt' --- employee_name salary as the columns; I

Connect mySQL

Hi geniuses, i have 2 server A B both have mysql running, is there anyway if i want to use web application on A and connect mysql on B. I think i need some code example, thanks - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September

RE: InnoDB / Linux

Hi, Its RedHat 7.3 with a 2.4 kernel. Yes the filesystem is ext3, but if your recommending a different one then I'm open to suggestions. This box is purely for mysql so anything that will benefit the database is best. As I said the disk size is not too much of a problem but its really the memory

GRANT update query: Updating host access entry for users but retaining existing passwords

Hi, I've got a MYSQL 3.23.x setup that has approx 4000 database and 4000 user accounts. 1 database per user. I created each userid from a script of the form CREATE DATABASE mdb_userid; GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, INDEX,RELOAD ON mdb_userid.* TO [EMAIL PROTECTED]

Possible Commit Syntax Change for Improved TPS

Hi, I have been studying the basic limitation that the number of committed transactions per second possible in a relational databases is limited by the number of writed per second of the underlying hard disk, since each transaction requires at least the write-ahead log data to be flushed to

DATE_ADD Dynamic Interval

Hi All, I am trying to create a table with a list of records where a script runs about once every 10 minutes that will update a certain field by an interval set (by an enum) in that particular record. My Script looks as follows: UPDATE foo_table SET NextDate=DATE_ADD(foo_table.NextDate,Period)

Am I on a wrong list?

Hi, guys. I'm quite new to this mailing list. Does anyone know how many programmers are there using this mailing list? I sent my question (below) about 6hrs ago, but still haven't receive any response. Am I on a wrong list? Could someone suggest a better mailing list or forum to discuss MySQL

Re: Am I on a wrong list?

6.4.9 LOAD DATA INFILE Syntax LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name.txt' [REPLACE | IGNORE] INTO TABLE tbl_name [FIELDS [TERMINATED BY '\t'] [[OPTIONALLY] ENCLOSED BY ''] [ESCAPED BY '\\' ] ] [LINES [STARTING BY ''] [TERMINATED BY '\n'] ] [IGNORE number LINES]

Re: Am I on a wrong list?

It seems I'm on the *right* list. :-) Thanks, Kelley. The '\r\n' solves the problem. Yes, Kelly, you are right, I'm using WinXP. Thanks again for that. cheers, feng - Original Message - From: Kelley Lingerfelt [EMAIL PROTECTED] To: Wang Feng [EMAIL PROTECTED]; Mysql List [EMAIL

RE: GRANT update query: Updating host access entry for users but retaining existing passwords

Shin, I've never tried this, so it's pure speculation, but I believe all of the grant information is contained in a regular table called user. You should be able to copy this information into a temporary table using select into, then perform regular updates to change the host information to

Re: GRANT update query: Updating host access entry for users but retaining existing passwords

Hi, Thanks for the followup/reply. On Tue, Sep 30, 2003 at 01:56:11PM +0100, Andy Eastham wrote: I've never tried this, so it's pure speculation, but I believe all of the grant information is contained in a regular table called user. I had a look into this and it seems that some of the

MySQL -- SQL -- Oracle

Folks, this is funny. I've been using Oracle for several months, and started teaching myself MySQL since last weekend. I'm currently using the MySQL version 3.23.49 I found something really interesting: In Oracle, I have to create the Foreign Key in order to join 2 tables. It's quite different

Re: MySQL -- SQL -- Oracle

typo :( correct: in Oracle, one have to use single quotes to enclose those values which are going to be inserted. but in MySQL, doubl quotes do the job well. - Original Message - From: Wang Feng [EMAIL PROTECTED] To: Mysql List [EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 12:04

Re: MySQL -- SQL -- Oracle

I found something really interesting: In Oracle, I have to create the Foreign Key in order to join 2 tables. It's quite different when I deal with MySQL. I can join two tables without creating the Foreign Key. - Is this Normal? Before learning MySQL, I thought both MySQL and Orcle use

Re: MySQL -- SQL -- Oracle

Folks, this is funny. I've been using Oracle for several months, and started teaching myself MySQL since last weekend. I'm currently using the MySQL version 3.23.49 You might want to go get the latest if you can (4.0.14). I found something really interesting: In Oracle, I have to create

Approx. Release Date of 5.0?

Hello, when is the approx. (very rough) release date of MySQL 5.0? I searched the archive but found no satisfactory answer. I am not interested in an exact date or month, just a very rough estimate. Will it approx. be in a month, in a year or in 2 years? Thank you for your answers! -- MySQL

What are the effects of key_buffer on a dedicated slave

I haven't notice a gain from increasing the key_buffer on a dedicated slave. Let's take 3.23.5x for instance. Since there is only 1 thread for replication, a Serialized committal of data, I wouldn't imagine that key_buffer at higher levels say around 50% of system memory would give a performance

Re: Possible Commit Syntax Change for Improved TPS

On Tue, Sep 30, 2003 at 01:19:19PM +0100, Oluwaseun Osewa wrote: Hi, I have been studying the basic limitation that the number of committed transactions per second possible in a relational databases is limited by the number of writed per second of the underlying hard disk, since each

Re: What are the effects of key_buffer on a dedicated slave

On Tue, Sep 30, 2003 at 10:10:29AM -0700, Dathan Vance Pattishall wrote: I haven't notice a gain from increasing the key_buffer on a dedicated slave. Let's take 3.23.5x for instance. Since there is only 1 thread for replication, a Serialized committal of data, I wouldn't imagine that

Re: MySQL 5.0, func stored in proc table

On Tue, Sep 30, 2003 at 09:26:11AM +0200, Bob Brands wrote: Hi, I compiled MySQL 5.0 from the source tree to test how stored procedures work. When I create a function, It is not stored in de mysql.func table, but in the mysql.proc table. Example of the function a create: create

copy database

HI List, Using version 4.0.15 I'm trying to copy a database. Copy db1 to (new) db2. So I created db2. And then tried the following and got the subsequent errors. # mysqldump --add-drop-table db1 | mysql db2 ERROR 1064 at line 399: You have an error in your SQL syntax near

Re: mysql index chooser

On Mon, Sep 29, 2003 at 09:14:06PM -0700, Kevin wrote: I suspect it uses some algorithm to 'guess' the number of rows, and this usually gives a lower number to bigger indicies? Did ANALYZE table help at all? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL

RE: What are the effects of key_buffer on a dedicated slave

---Original Message- --From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] --Sent: Tuesday, September 30, 2003 10:23 AM --To: Dathan Vance Pattishall --Cc: [EMAIL PROTECTED] --Subject: Re: What are the effects of key_buffer on a dedicated slave -- --That depends, of course. If your

RE: What are the effects of key_buffer on a dedicated slave [also]

---Original Message- --From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] --Sent: Tuesday, September 30, 2003 10:23 AM --To: Dathan Vance Pattishall --Cc: [EMAIL PROTECTED] --Subject: Re: What are the effects of key_buffer on a dedicated slave --Is that all your slave is doing?

Re: copy database

DePhillips, Michael P [EMAIL PROTECTED] wrote: Using version 4.0.15 I'm trying to copy a database. Copy db1 to (new) db2. So I created db2. And then tried the following and got the subsequent errors. # mysqldump --add-drop-table db1 | mysql db2 ERROR 1064 at line 399: You have

Re: What are the effects of key_buffer on a dedicated slave [also]

On Tue, Sep 30, 2003 at 11:07:59AM -0700, Dathan Vance Pattishall wrote: ---Original Message- --From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] --Sent: Tuesday, September 30, 2003 10:23 AM --To: Dathan Vance Pattishall --Cc: [EMAIL PROTECTED] --Subject: Re: What are the effects of

Re: What are the effects of key_buffer on a dedicated slave

In the last episode (Sep 30), Dathan Vance Pattishall said: I haven't notice a gain from increasing the key_buffer on a dedicated slave. Let's take 3.23.5x for instance. Since there is only 1 thread for replication, a Serialized committal of data, I wouldn't imagine that key_buffer at higher

RE: What are the effects of key_buffer on a dedicated slave [also]

---Original Message- --From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] --Sent: Tuesday, September 30, 2003 11:24 AM --To: Dathan Vance Pattishall --Cc: [EMAIL PROTECTED] --Subject: Re: What are the effects of key_buffer on a dedicated slave --[also] -- --On Tue, Sep 30, 2003 at 11:07:59AM

NOT problems

Here's my schema and data: create table person (name char(5)); insert into person values ('Bob'); insert into person values ('Jane'); In mySQL 4.1-alpha, 4.0.15a, and 3.23.58, I get the following results: mysql SELECT * FROM person WHERE NOT name = 'Bob'; Empty set (0.00 sec) mysql SELECT *

RE: What are the effects of key_buffer on a dedicated slave

---Original Message- --From: Dan Nelson [mailto:[EMAIL PROTECTED] --Sent: Tuesday, September 30, 2003 11:35 AM --To: Dathan Vance Pattishall --Cc: [EMAIL PROTECTED] --Subject: Re: What are the effects of key_buffer on a dedicated slave -- --A better question to ask might be what is my

Re: What are the effects of key_buffer on a dedicated slave [also]

On Tue, Sep 30, 2003 at 11:36:30AM -0700, Dathan Vance Pattishall wrote: Yes, I use a custom mytop (sent my patches in to you). In fact I'm making a signed java applet to simulate mytop, just to be fancy ;) as well as not having to ssh into a central box that can reach all my servers.

Re: NOT problems

At 11:37 -0700 9/30/03, Ed Smith wrote: Here's my schema and data: create table person (name char(5)); insert into person values ('Bob'); insert into person values ('Jane'); In mySQL 4.1-alpha, 4.0.15a, and 3.23.58, I get the following results: mysql SELECT * FROM person WHERE NOT name = 'Bob';

Re: copy database

In a message dated 9/30/03 1:33:07 PM Eastern Daylight Time, [EMAIL PROTECTED] writes: HI List, Using version 4.0.15 I'm trying to copy a database. Copy db1 to (new) db2. So I created db2. And then tried the following and got the subsequent

Re: Can't Access DB from MySQLCC

Randy Chrismon [EMAIL PROTECTED] wrote: Victoria Reznichenko wrote: MySQL 4.1 provides new password hashing mechanism. This error appears if you connect with pre-4.1 client to the server 4.1. ook at: http://www.mysql.com/doc/en/Password_hashing.html In the above section of the manual

Re: copy database

At 14:54 -0400 9/30/03, [EMAIL PROTECTED] wrote: In a message dated 9/30/03 1:33:07 PM Eastern Daylight Time, [EMAIL PROTECTED] writes: HI List, Using version 4.0.15 I'm trying to copy a database. Copy db1 to (new) db2. So I created db2. And then tried the following and

Problems with indexing a timestamp() field

Hello all, I am trying to set up a complete trraffic accounting using Ulogd-mysql. Since the whole idea of the project is to be able to select rows based on the timestamp value indexing is a must. The index files get created with no problem at all. However explain select refuses to use the

Re: Key_buffer_size

On Tue, Sep 30, 2003 at 08:17:20PM +0100, [EMAIL PROTECTED] wrote: Hi all :) I'm working with InnoDB tables only, and i read that the Key_buffer_size is only used for MyISAM tables. Is it true? If yes, i can put this variable to 0? Why not leave it at the default value? If MySQL

Re: copy database

In a message dated 9/30/03 3:13:59 PM Eastern Daylight Time, [EMAIL PROTECTED] writes: What if you have InnoDB tables? I don't. ;-) But I'd certainly like to know other strategies. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Possible Commit Syntax Change for Improved TPS

Hi Jeremy, Hmmm ... I guess the meat of my suggestion is that it be made available on a per-transactionbasis because in many applications some transactions are more critical than others. So even on systems where there are *some* transactions that need to be flushed to log immediately we can

RE: Key_buffer_size

Most likely your mysql database is still MyISAM, right? -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 30, 2003 12:35 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Key_buffer_size On Tue, Sep 30, 2003 at 08:17:20PM +0100, [EMAIL

RE: What are the effects of key_buffer on a dedicated slave [also]

---Original Message- --From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] --Sent: Tuesday, September 30, 2003 11:51 AM --To: Dathan Vance Pattishall --Cc: [EMAIL PROTECTED] --Subject: Re: What are the effects of key_buffer on a dedicated slave --[also] -- --On Tue, Sep 30, 2003 at 11:36:30AM

RE: Key_buffer_size

Mysql database have only innodb tables. I'm not using MyISAM. Quoting Misaochankun [EMAIL PROTECTED]: Most likely your mysql database is still MyISAM, right? -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 30, 2003 12:35 PM To: [EMAIL

Maintenace Query corrupting indexes + perf question

I have two issues I am dealing with. I am a Web app administrator who got a database position foisted upon me and I am just getting my feet wet with MySql. Here is the problem: a query we run to truncate old data from a database is corrupting the indexes on that table. Here is the query:

RE: Key_buffer_size

The mysql database he is referring to is /var/lib/mysql/mysql where it holds the access rights for users, tables, columns, etc. That HAS to be MYISAM. - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 ---Original

Re: Key_buffer_size

On Tue, Sep 30, 2003 at 09:11:59PM +0100, [EMAIL PROTECTED] wrote: Mysql database have only innodb tables. I'm not using MyISAM. Really? Unless I'm smoking crack, there used to be code in InnoDB that refused to convert the mysql.* tables to InnoDB. If that's changed, I'd love to know why.

Re: What are the effects of key_buffer on a dedicated slave [also]

On Tue, Sep 30, 2003 at 01:11:23PM -0700, Dathan Vance Pattishall wrote: ---Original Message- --From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] --Sent: Tuesday, September 30, 2003 11:51 AM --To: Dathan Vance Pattishall --Cc: [EMAIL PROTECTED] --Subject: Re: What are the effects of

RE: Key_buffer_size

Hi, I'm in the same boat here, I only have InnodDB tables except for the mysql MyISAM tables. So in theory would a value of something like 8mb be sufficient for those ? Cheers. Marvin. -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] Sent: 30 September 2003 22:13 To:

Re: Key_buffer_size

At 14:12 -0700 9/30/03, Jeremy Zawodny wrote: On Tue, Sep 30, 2003 at 09:11:59PM +0100, [EMAIL PROTECTED] wrote: Mysql database have only innodb tables. I'm not using MyISAM. Really? Unless I'm smoking crack, there used to be code in InnoDB that refused to convert the mysql.* tables to InnoDB. I

Re: What are the effects of key_buffer on a dedicated slave [also]

Jeremy Zawodny said: On Tue, Sep 30, 2003 at 01:11:23PM -0700, Dathan Vance Pattishall wrote: ---Original Message- --From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] --Sent: Tuesday, September 30, 2003 11:51 AM --To: Dathan Vance Pattishall --Cc: [EMAIL PROTECTED] --Subject: Re: What

Re: Problems with indexing a timestamp() field

It is not quite possible - there are several hundred packets per second - hence several hundred fields with equal timestamps. In order to use primary key all fields have to be unique... Peter On Tue, Sep 30, 2003 at 03:39:08PM -0700, James Kelty wrote: Maybe making it the PRIMARY KEY will

Re: What are the effects of key_buffer on a dedicated slave [also]

On Tue, Sep 30, 2003 at 02:47:35PM -0700, William R. Mussatto wrote: Have you tried mytop with debian and 3.23.49 -- version in Debian stable? we keep getting core dumps. Does it have to be run as root? Sorry if OT The only Debian Stable box I have is powered off most of the time anymore.

Re: Approx. Release Date of 5.0?

Hi! I have a hobby of guessing release dates. 4.0.0 was released in October 2001. 4.1.0 was released in April 2003. That would give us an estimate that 5.0 would be released in October 2004. But I would rather guess March 2004, because people are so eagerly waiting for stored procedures, and

Re: Can't Access DB from MySQLCC

Don't think this is the issue. If it were, I wouldn't be able to use MySQLCC on my own local database which is also 4.1.0 alpha, would I? Do you use password when you connect to the local 4.1 MySQL server? Yes. No password, no entry. Can you connect without --protocol option using 4.1 mysql

Mysql 4.1.0 utf8 on linux : maybe known bug and current bk compile problem

Hi, I'm currently doing some utf8 tests with mysql, during these tests i think i've hit a bug already discussed on this list. http://marc.theaimsgroup.com/?l=mysqlm=105593058922219w=2 http://marc.theaimsgroup.com/?t=10557702591r=1w=2 these two bug report and responses suggest that it's

InnoDB speed problems

Hi all, Because I want to use transactions in the future I have converted all tables of a copy of our production database server (1800+, 512 MB RAM, Linux) to InnoDB format. No problem until now. First, let me show you settings in my.cnf: key_buffer= 16M table_cache

Re: can NOT drop the database

Not at all!! after I typed the 'drop database my_account_database', I got the following message: Query OK, 0 rows affected (0.00sec). and I do the 'show databases', that one is still there. cheers, feng - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: