Re: AUTO_INCREMENT problem... ER_DUP_ENTRY? (No, it's not a one byte index :)

At 17:16 -0700 on 06/18/2004, Kevin Brock wrote about AUTO_INCREMENT problem... ER_DUP_ENTRY? (No, it's not a one: We have a table with a primary index which is INT NOT NULL AUTO_INCREMENT. After inserting ~87,000,000 entries, we started seeing error 1062, ER_DUP_ENTRY. You are wasting half your

Re: Clustered Index - Where is data inserted ? Not Answered

- Original Message - From: "Paul Chu" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, June 19, 2004 10:55 PM Subject: RE: Clustered Index - Where is data inserted ? Not Answered > Hi Rhino, > > Thanks for that explanation of how and why to use a clustered index ! :) > Again,

RE: Clustered Index - Where is data inserted ? Not Answered

Hi Rhino, Thanks for that explanation of how and why to use a clustered index ! :) I am just a complete beginner with MySql. I have extensive experience with Sql Server, some Oracle and some DB2. It seems that if I want to create a very large master table with 300 million rows using MYISAM I cou

RE: Returning updated rows

There are a number of approaches which you could take to this. One option would be to 'pre-assign' rows to a server - so that each server has a distinct set of rows to work through. Another would be to use transactions to handle this, so that only one set of updates actually occur at a time (lock

RE: Professional certification

> -Original Message- > From: Brian Mansell [mailto:[EMAIL PROTECTED] > I took the certification exam this morning and passed. When > should I expect to receive the certificate (and other items) > in the mail? I'm thinking of studying for the exam. How much time did you put into studyi

Returning updated rows

Is it possible that one can return the actual rows, which where affected by an update statement? What I want to do: I have n rows in a table which symbolize some work, which have several servers to do. For this, the table has a column called INPROCESS. In order that multiple servers can work

Re: Server Startup

Go into the bin directory and startup winmysqladmin.exe That will give you a graphical control over the server. - Original Message - From: Andrew McHorney To: [EMAIL PROTECTED] Sent: Saturday, June 19, 2004 4:20 PM Subject:

Server Startup

Hello I installed the software. I would like to start up the server but there is no icon. What is the name of the executable so I can make an icon? I am running under Windows. Thanks, Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http:

Re: Clustered Index - Where is data inserted ? Not Answered

Excuse me for jumping in but isn't a primary key likely to be a poor choice for a clustering index? Wouldn't it be better to choose a non-unique key of some kind? I've used clustering indexes for years with DB2 and, assuming InnoDB uses the term in the same way, a clustering index has only one eff

Re: Question about MySQL 4.0.20 and make test failure on Linux

Tom Williams wrote: Hi! I'm trying to build MySQL 4.0.20 on RedHat 5.2 (I think) Linux system with glibc-2.2.5 and gcc-3.4.0 (which I recently upgraded to). The compile runs smoothly, but make test fails. Here is my configure command: $ ./configure --prefix=/usr/local/mysql-4.0.20 --enable-

Re: AUTO_INCREMENT problem... ER_DUP_ENTRY? (No, it's not a one byte index :)

On Jun 19, 2004, at 10:37 AM, Michael Stassen wrote: Something about your description doesn't quite fit, however. You say that you are "nowhere near the limit", but you say that resetting the "auto_increment starting point" fixes the problem. Those seem contradictory to me. To me as well, tha

Re: AUTO_INCREMENT problem... ER_DUP_ENTRY? (No, it's not a one byte index :)

To the best of my knowledge, AUTO_INCREMENT columns are limited only by the size of the int, so an INT NOT NULL AUTO_INCREMENT should go to 2,147,483,647. Something about your description doesn't quite fit, however. You say that you are "nowhere near the limit", but you say that resetting the

what is the appropriate forum to discuss test errors?

Hello, I'm trying to build the current source (fetched via bitkeeper) to have access to ndb/clusters. I am building successfully but get errors with 'make test'. I have been cycling through this exersize for 4 days, fetching the daily patches and getting a clean build every time (various Re

Solaris install of 4.0.20 - Only 20 connections allowed

All Hardware: Solaris 4 cpu, 16G ram, 900MHz, ver 5.8 MySQL: 4.0.20 binary install, 32 bit version Admin install, I maintain the my.cnf, and do db admin. Installed a production db (10 million rows) with no problems. However, can only open 20 or so connections to mysqld. The error is: ERROR 11

Re: ERROR 1045: Access denied for user: 'foo@host' (Using password: YES)

Marc Tardif <[EMAIL PROTECTED]> wrote: > I'm using mysql-3.23.58-1.9 installed from RPM on Red Hat Linux release > 9 (Shrike). First, I create a database and user to connect to this > database using the following commands: > > mysql> CREATE DATABASE foo; > mysql> GRANT ALL PRIVILEGES ON foo.

Re: AUTO_INCREMENT problem... ER_DUP_ENTRY? (No, it's not a one byte index :)

On Jun 19, 2004, at 6:03 AM, Terry Riley wrote: Just a suggestion, Kevin, but how about changing from INT to BIGINT? I thought of trying that, but since we're nowhere near the limit even for an INT I think changing to BIGINT is premature. I want to find out a bit more about what's happening firs

Re: AUTO_INCREMENT problem... ER_DUP_ENTRY? (No, it's not a one byte index :)

On Jun 18, 2004, at 5:31 PM, Scott Haneda wrote: on 06/18/2004 05:16 PM, Kevin Brock at [EMAIL PROTECTED] wrote: We have a table with a primary index which is INT NOT NULL AUTO_INCREMENT. After inserting ~87,000,000 entries, we started seeing error 1062, ER_DUP_ENTRY. While I do not know why, I wou

Re: Question about MySQL 4.0.20 and make test failure on Linux

Michael Stassen wrote: I always run `make test` when I build from source. It can catch problems. For example, mysql 4.0.17 built with gcc in Mac OS X 10.2 passed all tests and ran flawlessly for me. On the other hand, mysql 4.0.18 and 4.1.1 built on Mac OS X 10.3 seemed to build fine but fai

problem

ok this is what i want to do i have 2 tables 1 is information about a postion and the second is org info eg table 1 | Continent | Country | Postion | Name | Ward | ORG_ID | | 1

Re: AUTO_INCREMENT problem... ER_DUP_ENTRY? (No, it's not a one byte index :)

Just a suggestion, Kevin, but how about changing from INT to BIGINT? Terry --Original Message- > We have a table with a primary index which is INT NOT NULL > AUTO_INCREMENT. > > After inserting ~87,000,000 entries, we started seeing error 1062, > ER_DUP_ENTRY. > > We can ge

Re: Clustered Index - Where is data inserted ? Not Answered

Paul, - Original Message - From: ""Paul Chu"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Saturday, June 19, 2004 5:07 AM Subject: RE: Clustered Index - Where is data inserted ? Not Answered > Appreciate any help at all > > Thanks, Paul > > > -Original Message-