upgraded, now nulls act differently

I am running RH 2.1 ES, i recently upgraded to 3.23.56-1.72. I am using mysql as a backend for postfix MTA. I use webmin to add new users to my database. Today, after upgrading, there was a distinct problem. I added a user, left a field blank, it was the relocate_to feild, which unless i put

Newbye speed question

HI I am having a MYISAM database with 27 million rows and 19 fields all char between 15 and 1 characters long. yesterday i did a alter table mytablename add column (version char(2)); By now (18 hours later) it has not finished yet? Is there a way to somehow predict the time needed for this? Or

Re: Newbye speed question

18hrs??? So, the database has been LOCKED for 18hrs - Original Message - From: Peer Reiser [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 03, 2003 6:57 PM Subject: Newbye speed question HI I am having a MYISAM database with 27 million rows and 19 fields all

Re: How can i make mysql to print date and time automatically?

INSERT INTO your_table (field1, field2, field3) VALUES(DATE(), value2, TIME()) But check the manual for very simple things. Thanks Emery - Original Message - From: Emilio Ruben Estevez [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 17:09 Subject: How can i

unexpected index behaviour...

Hello all, I asked a similar question earlier. Then I went and did tons of tests... but I am back where I started. Basicly I am trying to store pretty high volume of data (ip traffic) in a mysql database. The only choidce for an engine is MyIsam because I need the advantage of compressed

Re: Newbye speed question

Fortunately the database is not in production :-) but it should go as soon as possible :-( On viernes, octu 3, 2003, at 11:03 Europe/Madrid, Wang Feng wrote: 18hrs??? So, the database has been LOCKED for 18hrs - Original Message - From: Peer Reiser [EMAIL PROTECTED] To: [EMAIL

Re: Newbye speed question - which setup to use for indexing

Next week I will have access to a new PomerMac G5 with Dual 2GHZ processors, and i want to do some indexing. Does anyone know if MySQL will take advantage of dual processors if the only process running is the indexing process?? Is disk I/O more important ? The bad temper of my boss seems to

mysql 4.0.15 and latest redhat enterprise AS Beta - segmention fault

HI List! mysql 4.0.15 won't start on the latest beta of the redhat enterpise AS. (will be released this month) i used the std. rpms for linux x86. i get the following error: Starting mysqld daemon with databases from /var/lib/mysql /usr/bin/mysqld_safe: line 339: 14874 Speicherzugriffsfehler

unicode_support

Hi Everybody! I use MySQL with JavaNetBeans. Please tell me, if only the InnoDb support unicode, or MyISAM also supports, and how. best regards Laszlo Illyes Library-informatics Sapientia University (Csikszereda) Miercurea-Ciuc Tel:+40266317310 Fax:+40266317310/+40266371121 Mobil:+40740055706

Re: ran out of space for bin logs

Hi, 1. Can I safely delete the binlogs and clear the binlog index by hand? The binlog index maintains admistrative informations that the daemon use to manage the binlog files. If you delete it ( i don't recommended this) the daemon will recreate it . 2. How can I regulate the size of

RE: Newbye speed question - which setup to use for indexing

Peer, How big are the table and index files? Can your OS handle files bigger than 2/4Gb? I've got a table with 55 million rows with just 3 columns all floats. I've got three indexes with all the fields in various orders. My data file is 700Mb but my index file is over 4Gb, so yours could

Re: How can i make mysql to print date and time automatically?

I am sorry, the instruction I sent doesn't work in MySQL: You should use: INSERT INTO your_table (field1, field2, field3) VALUES(CURDATE(), value2, CURTIME()) Note the CUR (I think it stands for CURrent) Thanks Emery - Original Message - From: Director General: NEFACOMP [EMAIL

How to show locks on a table?

Subject -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Why does mySQL violate NOT precedence?

I am reposting this in hopes of convincing the mySQL implementors to change mySQL or to at least gain some understanding as to why they violated the specification. Apparently, in MySQL, NOT has higher precedence than the comparison operators, so WHERE NOT name = 'Bob' is equivalent to WHERE

Install/compile problems

?xml version=1.0 ?html head title/title /head body div align=leftfont face=Arialspan style=font-size:10ptHi, /span/font/div div align=leftbr//div div align=leftfont face=Tahomaspan style=font-size:10ptSYSTEM: Compaq Alpha, Tru64 5.1, mysql4.0.15a. /span/font/div div align=leftbr/ /div div

RE: grant by option on querys

Thank you very much Paul. The order by NULL clause sped the query up from 1.5 minutes to 10 seconds! This is what we were looking for. Thanks, Brad -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 9:59 PM To: Brad Teale; '[EMAIL

GROUP BY/ORDER BY Problem

Why doesn't the following work: mysql CREATE TABLE dog(id integer, breed char(20), age integer, weight integer) ; mysql SELECT breed, MIN(age) - FROM dog - GROUP BY breed - ORDER BY MIN(age); ERROR : Invalid use of group function but this does mysql SELECT breed, MIN(age) AS

mysqld crash

Description: Upon starting mysql client with the following command: mysql -ppassword radiant Immediately error message where displayed, one per table, saying that the table existed, however no columns/fields where found. Unfortunately I do not have the

Re: Why does mySQL violate NOT precedence?

I'm not sure why you would use the syntax you are trying to use. I think you are making a few assumptions that may be incorrect. If you do this query: SELECT not name='Bob' FROM person You'll see your result is set contains all 0's. Records where name='Bob' would return 1, but you are taking

Tomcat, Connection Pooling, and MySQL

Has anyone managed to setup Tomcat to use MySQL for database connection pooling? I've found this document which gives information on it: http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-howto.html However, when I try and run it I get messages about not being able to

Locked connection doesn't disconnect

Hi. I've developed a program in Delphi 5 that uses ZeosLib components for connect to a MySQL database that uses MyISAM tables and inserts some records. If I finalize the program with Ctrl-Alt-Supr when it's inserting the records the programs disconnects from MySQL (a Disconnect method is called

Relationships - Foreign Key

Hi, sorry for my english, but, how can I do relationships between tables? Is possible? Thanks, Paulo Daniel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Why does mySQL violate NOT precedence?

Your point does not seem relevant to my question on mySQL compliance with the specification. In fact, your response doesn't even mention the specification. Perhaps I'm misunderstanding your question. You are wondering why I would ask a query like SELECT * FROM Person WHERE NOT name = 'Bob'?

RE: Tomcat, Connection Pooling, and MySQL

I got it working... unfournately it's on my laptop at home, not here at work with me I think that the issues was that the class names given in the documentation for the jdbc driver for MySQL were wrong look at the listing of the contents of the jar file, and see if you can find the

General error: Incorrect key file for table: 'RoleM'. Try to repair it

Hello, I am facing a very strange problem, my application says General error: Incorrect key file for table: 'RoleM'. Try to repair it but when i trying myisamchk then it doesn't give any corruption error. I have tried many things but nothing seems to be of any help, i would really appreciate anhy

Off-line DB Re-synchronizing?

Greetings, We have 10 people that need to use MySQL on notebooks/tablets off-line, entering data, doing searches. When they reconnect to the Internet, the database needs to upload the new data to a server and retrieve a fresh copy of some common tables. I was thinking about the LOAD DATA

Re: General error: Incorrect key file for table: 'RoleM'. Try to repair it

i googled your error and the first link looks like it may help google - General error: Incorrect key file for table www.vbulletin.com/forum/ showthread.php?t=5387goto=nextoldest hth Jeff

Replication

If I have replication already active for a single database ( already active between master and slave ) and I want to start replicating a new database on the master, what would the correct procedure be? I have a dump of the database I want to replicate. Below is the current setup for

Re: Relationships - Foreign Key

* Paulo Hi, sorry for my english, but, how can I do relationships between tables? Is possible? This is done using different types of JOIN: URL: http://www.mysql.com/doc/en/JOIN.html -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: How to write this query

Sean, Slight rewriting of Kevin's query--I assume you want to do the joins on A_ID. SELECT A_data, B_data, C_data FROM A LEFT JOIN B ON A.A_ID = B.A_ID LEFT JOIN C ON A.A_ID = C.A_ID WHERE A.A_ID = 4; This should work. For your example, the first left join gives a table with A.* and nulls for

RE: Why does mySQL violate NOT precedence?

I think the difference between mysql's precedence operation is significant to point out. Looking at the behavior of other databases, SQL Server and Oracle both respond to the query you gave with Recordss about users with names != 'Bob'. Jane returned. Significantly, this is inversion does not

Getting MySQL activity as a per database value

Folks, I've done a lot of searches, tried out the tools I could find (like phpMyAdmin/mtop). We have a server with about 30 DB's and we would LOVE to get a report that gives us queries/hour, cpu, etc.. against each DB so that we can measure activity. We are running 4.0.13 on

Replication MASTER-SLAVE

Hi everbody! I' m trying to do a replication, and this is the first time!! My MySQL is running in Windows XP (master and slave). Where are my errors? Can I configure a Master in Linux and a Slave in Windows? #Master Configuration

Re: mysqld crash

Richard, looks like a clean case of memory corruption. Your log sequence number is only 29 MB. You got problems very quickly. I regularly run tests where gigabytes of log are generated, and no crash. Linux-2.4.20 has the reputation of being stable. This might even be a hardware problem. Best

Re: How to show locks on a table?

On Fri, Oct 03, 2003 at 03:28:31PM +0400, [EMAIL PROTECTED] wrote: Subject Body: There isn't a way. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 19 days, processed 714,889,039 queries (419/sec.

RE: Replication

---Original Message- --From: Luc Foisy [mailto:[EMAIL PROTECTED] --Sent: Friday, October 03, 2003 8:45 AM --To: MYSQL-List (E-mail) --Subject: Replication -- -- --If I have replication already active for a single database ( already --active between master and slave ) and I want to start

changing TMPDIR for tempory file location

Hello all, My query is about changing the tmpdir on mysql. As stated in on the mysql.com site it states that if it is not set it uses the default, in my case, the default was /tmp. It also states that to change it you can do so in the mysqld_safe startup file. It makes no mention of

configure string for solaris?

Where can I find the configure string MySQL AB uses to compile their solaris binaries? -James -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Getting MySQL activity as a per database value

On Fri, Oct 03, 2003 at 08:29:17AM -0400, John Murtari wrote: Folks, I've done a lot of searches, tried out the tools I could find (like phpMyAdmin/mtop). We have a server with about 30 DB's and we would LOVE to get a report that gives us queries/hour, cpu, etc.. against each DB

thread problem

Hi list, I have the following problem and here is the message that displays the console when I try to connect Warning: Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent Greetings Mikel

FW: changing TMPDIR for tempory file location

-Original Message- From: dan orlic [mailto:[EMAIL PROTECTED] Sent: Friday, October 03, 2003 1:20 PM To: '[EMAIL PROTECTED]' Subject: changing TMPDIR for tempory file location Hello all, My query is about changing the tmpdir on mysql. As stated in on the mysql.com site it

RE: changing TMPDIR for tempory file location

In my.cnf its called tmpdir change that location tmpdir=where you want tmp to be - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 ---Original Message- --From: dan orlic [mailto:[EMAIL PROTECTED] --Sent: Friday,

Re: thread problem

On Fri, Oct 03, 2003 at 02:37:27PM -0500, Mikel - wrote: Hi list, I have the following problem and here is the message that displays the console when I try to connect Warning: Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for

Multiple-Column Unique Index Redundancy

I've been over a few books, the site, and the archives... Can someone please confirm that if I create a unique index over 2 columns, it will be redundant to create a regular index for the first? In other words, does the left-prefix rule apply to unique indexes that specify uniqueness over

Re: Multiple-Column Unique Index Redundancy

On Fri, Oct 03, 2003 at 06:06:10PM -0400, John Kornet wrote: I've been over a few books, the site, and the archives... Can someone please confirm that if I create a unique index over 2 columns, it will be redundant to create a regular index for the first? It is redudndant, yes. In other

Re: Newbye speed question - which setup to use for indexing

Peer Reiser wrote: Next week I will have access to a new PomerMac G5 with Dual 2GHZ processors, and i want to do some indexing. Does anyone know if MySQL will take advantage of dual processors if the only process running is the indexing process?? No, it won't directly. However, other processes

RE: Newbye speed question - which setup to use for indexing

Andy Eastham wrote: How big are the table and index files? Can your OS handle files bigger than 2/4Gb? Yes, OS X can deal with files larger than 4 GB. --Ware -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: Newbye speed question

I wonder why you have 19 fields in a single table. I don't think there is really any way to predict it, since it depends on so many different factors. On Fri, 3 Oct 2003 11:19:56 +0200, Peer Reiser [EMAIL PROTECTED] wrote: | Fortunately the database is not in production :-) but it should go

RE: Multiple-Column Unique Index Redundancy

- Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 ---Original Message- --From: John Kornet [mailto:[EMAIL PROTECTED] --Sent: Friday, October 03, 2003 3:06 PM --To: [EMAIL PROTECTED] --Subject: Multiple-Column Unique

Re: Newbye speed question - which setup to use for indexing

On Fri, Oct 03, 2003 at 06:23:24PM -0400, Ware Adams wrote: Peer Reiser wrote: Next week I will have access to a new PomerMac G5 with Dual 2GHZ processors, and i want to do some indexing. Does anyone know if MySQL will take advantage of dual processors if the only process running is the

Re: thread problem

I'm using linux, Red Hat 7.3 Linux version 2.4.22, and 3.23.55-Max-log. does This information is ok?, or I'm missing something. Greetings From: Jeremy Zawodny [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Mikel - [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: thread problem Date:

just messed up my index on my table....ugh

now the query isn't finishing executing and its killing my cpu... any idea how to rebuild the index on a table? or how to get out of this mess? :-) Thanks, Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

just messed up my index on my table....ugh

now the query isn't finishing executing and its killing my cpu... any idea how to rebuild the index on a table? or how to get out of this mess? :-) Thanks, Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

(USING PASSWORD: NO) UGH!

I just reinstalled because of this same issue. Now root has no priviledges or functions within MySQL. Does anyone know how to fix this? My data isn't important -- i just started (and I am a hopeless newbie!) It doesn't let root do squat. I was trying to give 'root' a password. Entered the

Re: just messed up my index on my table....ugh

On Fri, Oct 03, 2003 at 04:23:56PM -0400, Matt Babineau wrote: now the query isn't finishing executing and its killing my cpu... any idea how to rebuild the index on a table? or how to get out of this mess? Drop and re-add the index? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL,

(USING PASSWORD: NO) UGH 2nd try

I just reinstalled because of this same issue. Now root has no priviledges or functions within MySQL. Does anyone know how to fix this? My data isn't important -- i just started (and I am a hopeless newbie!) It doesn't let root do squat. I was trying to give 'root' a password. Entered the

Re: just messed up my index on my table....ugh

Its weird, I dropped the indexes off that table, and re-added them but the queries used to take 5 sections but now take much much longer. I did a little reading on the EXPLAIN command and it looks like my query without an index has 9427^15 rows to query. So thats where I am seeing the huge

Re: Newbye speed question - which setup to use for indexing

Jeremy Zawodny wrote: On Fri, Oct 03, 2003 at 06:23:24PM -0400, Ware Adams wrote: Peer Reiser wrote: Next week I will have access to a new PomerMac G5 with Dual 2GHZ processors, and i want to do some indexing. Does anyone know if MySQL will take advantage of dual processors if the only process

Installing

I'm attempting to install using INSTALL-BINARIES and get this message while executing mysql_install_db: [cuppjr mysql]$ scripts/mysql_install_db scripts/mysql_install_db: ./bin/my_print_defaults: cannot execute binary file WARNING: The host 'raq2.homeunix.org' could not be looked up with