InnoDB and duplicate key

I am playing around with portable sql queries (mysql, oracle and postgres). When executing: ipplan= BEGIN; BEGIN ipplan= INSERT INTO area (areaaddr, descrip, customer) VALUES (16777216, 'kjshdf', 1) ; ERROR: Cannot insert a duplicate key into unique index area_areaaddr_key ipplan= SELECT

Re: Mysql/Php Help?

I really suggest you do a little homework and read the tutorials in both the php and mysql manuals. They are really valuable and should give you the examples you need. Maintainer IPPlan (https://sourceforge.net/projects/iptrack/) sql Gary Lefko wrote: Can someone writ eme an example of

Innodb performance (again)

= innodb_additional_mem_pool_size=10M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 [myisamchk] set-variable = key_buffer=256M set-variable = sort_buffer=256M set-variable = read_buffer=2M set-variable = write_buffer=2M -- Richard Ellerbrock [EMAIL PROTECTED

Re: encrypt wierdness

time? Please give me an application for this behaviour and I will be happy :-) Tonu Samuel wrote: On Thu, 7 Jun 2001, Richard Ellerbrock wrote: Looking at the encrypt function, it optionally takes a salt parameter. Using encrypt without specifying a salt yields random results: mysql

encrypt wierdness

! -- Richard Ellerbrock [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED

Re: New user InnoDB comments

-variable = innodb_lock_wait_timeout=50 -- Richard Ellerbrock [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

New user InnoDB comments

. Thanks for the help. PS: I am willing to test stuff on my development machine. -- Richard Ellerbrock [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: saving database during os changeover

Kris Gonzalez wrote: I'm going to be switching from my OS from Linux to Solaris and was wondering what steps I would need to take to save my tables during the OS conversion and restore them once it is complete. Is it as simple as tarballing the /var/lib/mysql directory and extracting it

Re: Mysql speed :)

Are the Mysql supplied statically linked binaries built using these optimised glibc 2.2 libraries, or are they just the stock standard 2.1.3 libraries? -- Richard Ellerbrock [EMAIL PROTECTED] Sinisa Milivojevic [EMAIL PROTECTED] 2001/04/05 05:06:45 Peter Zaitsev writes: Hello mysql

Re: SELECT ... FOR UPDATE

From the manual: If you are using FOR UPDATE on a table handler with page/row locks, the examined rows will be write locked. I agree that this does not tell me much. When are the rows unlocked? -- Richard Ellerbrock [EMAIL PROTECTED] Andrew Gould [EMAIL PROTECTED] 2001/04/02 03:56:33 I am

Re: RV: RPM with berkely-bd

/src/redhat/BUILD directory. Done. -- Richard Ellerbrock [EMAIL PROTECTED] "serconsur" [EMAIL PROTECTED] 2001/03/22 10:31:35 Hi, I have downloaded the standard binary RPM for i386 (3.22.35) but it doesn t include the Berkeley-DB library for the use the transaction in MYSQL.

Re: Connection related SIG 11 crash in 3.23

are SMP. Try to boot with a UNI Processor kernel and see again. There have been problems in the past with SMP installations. -- Richard Ellerbrock [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com

Re: setting a new default nice value

when it takes too long. I know in upcoming versions of php they plan to somehow "fix" this - how I do not know. Oh yes, my databases are normalised. -- Richard Ellerbrock [EMAIL PROTECTED] Wagner Christoph [EMAIL PROTECTED] 2001/03/20 04:21:02 for mysqld -child processes. i set i

Re: Very slow connection times.

This is documented in the manual as a "kernel fork bomb". See manual for solution. -- Richard Ellerbrock [EMAIL PROTECTED] "Paul Coleman" [EMAIL PROTECTED] 2001/03/21 12:35:28 I am running mysql version 3.23.35 on a linux platform. The hardware platform is a PIII 7

Re: wishlist: create_tmp_priv in mysql.db

I have asked this before and was told that it is not going to happen soon. That was a LONG time ago. Maybe in 4.0? The only alternative now is to create a scratch database with enough rights and create your temp tables there. -- Richard Ellerbrock [EMAIL PROTECTED] Christian Hammers [EMAIL

Re: Bug with 'show databases|tables'

to Redhat 6.2 if you want a stable system. I don't think 7.0 is ready for real production work. -- Richard Ellerbrock [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: Why Heap Tables doesn´t support auto increment colums

Why not use a timestamp column to guarentee the order in which rows get inserted into the table? You can then order on the timestamp column. Gerhard Schmidt wrote: --d6Gm4EdcadzBjdND Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding:

Re: Best way to duplicate a table in a running database?

What is wrong with the CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name [(create_definition,...)] [table_options] [select_statement] syntax. Note that you can append a SELECT statement to a CREATE statement to automatically add rows to the new table. Read the following manual sections:

Re: Ignoring duplicate records during bulk import

You will need to add a primary key to the column in your table that will uniquely identify a record. The IGNORE keyword only ignores records that would generate a "duplicate key" error if there is already a record in the table with the same key value. So, use ALTER TABLE and add a primary key to

Re: Select not working selectively

You have read the manual? http://www.mysql.com/doc/F/u/Full_table.html Nathan Cook wrote: When I run this query on a 20,000 record table with 18 fields. The table has some identical entries and I am trying to get a count of those entries descending. SELECT email, fname,

Re: Change character set

Firstly, upgrade to 3.23.x as with 3.22 you will need to compile from sources to change character sets. Next, read the following section in the manual: http://www.mysql.com/doc/L/a/Languages.html -- Richard Ellerbrock [EMAIL PROTECTED] [EMAIL PROTECTED] 2001/01/25 01:50:33 Hello, I am

Re: Best way to duplicate a table in a running database?

Woops! Sorry, but I somehow missed the version number. Yes. You could probably shutdown the server, copy the relevant files making sure the permissions are correct and then restart the server. I would rather upgrade to 3.23.x though! -- Richard Ellerbrock [EMAIL PROTECTED] [EMAIL PROTECTED

Re: Memory

. -- Richard Ellerbrock [EMAIL PROTECTED] "Johan Geuze" [EMAIL PROTECTED] 2001/01/23 02:39:04 Hello, I've got a mysql database(3.23) on a very slow disk, the database is only 50mb in size but the harddisk seems to be the real bottleneck here. The linux box where mysql is running

Re: Sizing HEAP table using .MYD/MYI

fixed row lengths. This can make a table very large indeed. Are you using varchar or char columns? Also, is it correct that the MYD is the datafile and MYI the index file? Yes. -- Richard Ellerbrock [EMAIL PROTECTED] - Before

Re: Help with Dates

Yes, mysql can do date arithmetic. Read up on date_add and date_sub functions in the manual. -- Richard Ellerbrock [EMAIL PROTECTED] Mike Podlesny [EMAIL PROTECTED] 2001/01/22 03:01:10 I have a script that saves a date in to a mySQL database. The date I want to be saved is 14 days from

Re: MySQL on Netware - Again!

% there! -- Richard Ellerbrock [EMAIL PROTECTED] Diego Deboni Rossetto [EMAIL PROTECTED] 2001/01/22 03:23:19 Hello Folks! Again someone is asking for MySQL on Netware. Sorry if you guys are tired of this... but Netware is all over... I ve checked the list archives, found some threads about

Re: PHP and MySQL combo

ps -ef|grep -c mysql Subtract 3 from this as this is the default number of daemons that start. One is spawned for each new child. Yes, if the php script terminates, the mysql child will also terminate. This is not the behaviour with persistant connections though. Please move this over to the

Re: forcing tcp/ip connect when connecting to localhost

Normally connecting to the true DNS hostname or the ip address of the machine will do the trick. Connecting to localhost will connect via the loopback address of 127.0.0.1. -- Richard Ellerbrock [EMAIL PROTECTED] Ben Peter [EMAIL PROTECTED] 2001/01/19 02:19:47 Hi all, can I force the mysql

Re: checking table fullness

support. You just need to know where to find them! Also what about RAID tables? -- Richard Ellerbrock [EMAIL PROTECTED] [EMAIL PROTECTED] 2001/01/19 02:22:18 I need to test the relative "fullness" of a given table relative to its maximum size on the OS. I am doing everything through

Re: checking table fullness

Richard Ellerbrock wrote: I am not 100% sure I understand you but I presume you are talking about the 2Gig file size limit of some OS'es? If this is the case, just find out where MySQL stores its databases and have a look at the filesize - you are using the C API, so doing a call to get

Re: archive of old mails in lists?

Read the footer of EVERY message sent to the mysql list Including this one. -- Richard Ellerbrock [EMAIL PROTECTED] "Tomas Mas-Esteve (ECE)" [EMAIL PROTECTED] 2001/01/17 03:51:45 Hello, is a archive where all the mails sent to mysql list are stored? if yes, where is the archi

Re: ulimit - recommended setting

://lists.mysql.com -- Richard Ellerbrock [EMAIL PROTECTED] "Johan Bjrk" [EMAIL PROTECTED] 2001/01/17 01:19:13 One simple(?) question. What's the recommended setting for ulimit on a system running MySQL 3.23.27, Red Hat 7.0, and PHP which now and then when connecting with mysql_pconnect