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 cust

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 ge

Innodb performance (again)

ze=80M set-variable = 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 Ellerbro

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 yie

encrypt wierdness

t from? Is it a random salt? This confused the hell our of me for around an hour! -- Richard Ellerbrock [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mys

Re: New user InnoDB comments

ize=80M set-variable = innodb_additional_mem_pool_size=10M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 -- Richard Ellerbrock [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.

New user InnoDB comments

ounts. 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)

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

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

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]> 2

Re: Connection related SIG 11 crash in 3.23

nifests itself? 30mins ok? It is still running though. I see both your machines 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] --

Re: RV: RPM with berkely-bd

/usr/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 libra

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 hardw

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

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] >>> Christia

Re: Bug with 'show databases|tables'

RPM's supplied by MySQL team. Or downgrade 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: ht

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: quo

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] >>&g

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:3

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: 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 o

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: http:/

Re: Text Max

Firstly, text is a reserved word in mysql. Secondly, varchars or chars can only have 255 characters. You should use a text type column which can be very large (megabytes!). You have read the manual on the different field types? [EMAIL PROTECTED] wrote: > > Hi, > > I`m setting up a field in my D

Re: bug with timestamp fields in table

I thinks you are mis-understanding the concept of a timestamp column. Timestamp coulumns automatically get updated with the current date and time whenever a record is modified. You are probably looking for a datetime column type. -- Richard Ellerbrock [EMAIL PROTECTED] >>> <[EMA

Re: Importing Common Separated Values file

Yes, read up on LOAD DATA statement in manual. -- Richard Ellerbrock [EMAIL PROTECTED] >>> Clement <[EMAIL PROTECTED]> 2001/01/25 09:33:46 >>> Hi, Can you suggest a way to import a CSV file into a MySQL table? Your help is greatly appreci

Re: Sizing HEAP table using .MYD/MYI

the structure of the table, so the table could have 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? Y

Re: Memory

dates. -- 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.

Re: MySQL on Netware - Again!

! -- 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, f

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 wan

Re: temp tables lock unrelated tables

hort time on a very fast system. Look here for more info, particularly chapter 2. You want to modify the nfract parameter of /proc/sys/vm/bdflush. The web page is http://www.ieee.calpoly.edu/LUG/LinuxWorld00/expo/track-1/session-62/ Maybe t

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 >

Re: checking table "fullness"

h LFS 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

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 >>&

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 php

Re: copying table

Read the manual on INSERT statement. You can INSERT and SELECT at the same time. Alejandro Lujan Toro wrote: > > I have a calendar db, and in there a base table (with > holidays and such). I need to create a table, exactly the > same as the base (data included). Is there an easy way of > doing t

Re: ############ need some help ##############

Maybe you should read the manual for the answer! It is well explained under Limitations! -- Richard Ellerbrock [EMAIL PROTECTED] >>> "Rih Naoufal" <[EMAIL PROTECTED]> 2001/01/18 01:45:07 >>> i have a problem using mysql queries like = "select id from tab

Re: time_to_sec problem

It's a known bug with 3.23.22 - upgrade to the latest version (3.23.30?) and the problem will go away. Please have a look at the upgrade history in the online manual. -- Richard Ellerbrock [EMAIL PROTECTED] >>> Wolfgang Riedel <[EMAIL PROTECTED]> 2001/01/17 04:39:13 >&

Re: ulimit - recommended setting

://lists.mysql.com -- Richard Ellerbrock [EMAIL PROTECTED] >>> "Johan Björk" <[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 c

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 st