Re: Underline or minus sign ?

Back in the day '_' and '-' meant different things. In recent versions of mysql they are interchangable. Philippe Poelvoorde wrote: Gabriel PREDA wrote: I'm going to start the InnoDB engine... and I want to know if the syntax for the CNF file unified at last ? Can I use: innodb-file-per-tab

Re: SELECT Row Numbers?

Here, off the top of my head are situations in mysql where you can trust that the data is ordered in some fasion. 1. Using an order by clause on a query. 2. Using a group by the data will come out in ascending order of the column that was grouped on. 3. alter table order by has been performed and

Re: missing file ( msyql.sock)

Keep in mind that this "file" will only exist when mysqld is running. Gleb Paharenko wrote: Hello. You may create my.cnf from the examples which're shipped with MySQL distribution. MySQL will create the socket file if it doesn't exists. It's location could be specified in configuration file or in c

Re: missing library

you need to install your distro's ncurses and ncurses-devel packages. -Eric ganesan malairaja wrote: ok i found the source file .. tarball mysql-4.1.11.tar.gz after executing the ./configure command i does some checking the it gives this error checking for termcap functions library ... configure :

Re: Binlog corruption

Try upgrading to the newest 4.0 release of mysql. 4.0 up until about .19 or .20 had odd replication problems. Scott M. Grim wrote: I recently installed SUSE 9.1 64bit with MySQL 4.0.18 on a new server and have been getting the following errors: 050509 10:53:14 Error reading packet from server:

Re: amPiguous!

He's right in saying that mysql is capable of knowing. My thoughts are that it's not worth the speed loss, extra code, and potential guess work by mysql just so you don't have to type a table name. Eric Jensen wrote: The way he is joining tables is fine. You can specify how to link the using ON

Re: select's with various levels

It's possible starting with mysql 4.1 -Eric [EMAIL PROTECTED] wrote: Dear all at mysql list I'dd like to know if it is possible (and the right sintax) to execute a nested (2 or more levels) select... something like this. select * from products where productId IN ( select idNumber from othe

Re: mysql<->mysqld connection

If you really really want it it's in the internals doc from the mysqldoc bk tree. -Eric Reggie Burnett wrote: Just to echo the thoughts from Jeremiah, we have several freely available open source connectors that work *VERY HARD* tracking the protocol so it's hard to understand a situation where y

Re: Determining if a table exists

riginal Message ----- From: "Eric Bergen" <[EMAIL PROTECTED]> To: "Jim McAtee" <[EMAIL PROTECTED]> Cc: Sent: Monday, May 02, 2005 11:31 AM Subject: Re: Determining if a table exists I don't remember what commands are available in 3.21 but try these show tables like &

Re: Determining if a table exists

I don't remember what commands are available in 3.21 but try these show tables like 'table_name'; then check mysql_num_rows on the result. describe table; check mysql_num_rows show tables; then pick out the table name; 3.21 is old as alabama (forrest gump) it's time for an upgrade :) Jim McAtee wro

Re: mysql import or write my own Perl parser

oad data and when should > I write my own Perl parser to help load the table? > > What criteria would be needed to decide to read a file into a hash? > > > > Also, if I decide to use mysqlimport is there anything I should watch out > for? >

Re: 4==4something: equal vs identical

number > and a numeric comparison is done. '4aef' converts to 4. > > I suppose you could convert the integer to string instead: > > WHERE CONCAT(`id`) = "4aef" > > -- > Paul DuBois, MySQL Documentation Team > Madison, Wisconsin, USA > MySQL

Re: Warning (reformulated)

; GAT/O/CM d- s:+ a- C UL P+ L+++ E--- W+++ N++ o+ K w--- O+++ M- V > PS+ PE++ Y+ PGP+++ t+ 5-- X R !tv b DI+++ D++ G e-- h+ r--- y+ > -- ---END GEEK CODE BLOCK-- > > Check out these few php utilities that I released > under the GPL2 and that are meant for use with a > php cli binary: > > http://www.vlaamse-kern.com/sas/ > -- > > -- > > > -- Eric Bergen [EMAIL PROTECTED] http://www.ebergen.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: optimal number of connections?

hot topic, I'm wondering if we're missing out > somehow. > > Thanks > > Jeff > -- Eric Bergen [EMAIL PROTECTED] http://www.ebergen.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql import or write my own Perl parser

into a hash? > > Also, if I decide to use mysqlimport is there anything I should watch out for? > > thanks! > > > ----- > Post your free ad now! Yahoo! Canada Personals > > -- Eric Bergen [EMAIL PROTECTED] http://www.ebergen.ne

Re: Mysqladmin bug

and > intended solely for the use of the individual or entity to whom they > are addressed. If you have received this email in error please notify > the system manager. > > This footnote also confirms that this email message has been swept by > MIMEsweeper for the presence of comp

Re: Help restoring

50418 > > I'm getting > ERROR at line 84: > > Line 84 is all garbled text... > > Working with 3.23.58 ... Any thoughts? > > -- > Patrick Campbell > OurVacationStore.com > Website Administrator > Tel. 602.896.4729 > > -- Eric Bergen [EMA

Re: Wait for data to change

communicate a > change in data than a "passive detect" like you are doing? How much > control do you have over what can and cannot change your data > (specifically the field you keep polling)? What other application-based > options are open to you? > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine > > -- Eric Bergen [EMAIL PROTECTED] http://www.ebergen.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Adding fields to db table (primary key and other type)

r fields at the moment. How can I add more fields? I want to > add a primary key column which autoincrements, how can I do that? Thanks a > lot > -- Eric Bergen [EMAIL PROTECTED] http://www.ebergen.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Replication only DB

; > > > > > > -- > No virus found in this outgoing message. > Checked by AVG Anti-Virus. > Version: 7.0.308 / Virus Database: 266.7.2 - Release Date: 3/11/2005 > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > T

Re: php - mysql connection

ost", "test", "test"))){ > echo mysql_error() . "\n"; > exit(); > } > > It will give you a more descriptive error if there is one > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql >

Re: database pooling problem

dozens, > > you know...), HOW you initialize your pool (again many methods > > available), HOW you take and return connections from your pool > > (ditto), and which languages are in use in this entire process > > (again dozens of options). Just telling us that you use a web

Re: Sum() unequal number of rows

ble structures (SHOW CREATE TABLE xxx\G) and your > sample data (SELECT * FROM xxx;), then show us what you think your queries > SHOULD have given you (your expected results) and we can start to help. > The xxx in the sample commands was just a placeholder for the actual table > name

Re: Join Limits

-mail. > Please note that e-mail may be susceptible to data corruption, interception > and unauthorised amendment. Alchemetrics does not accept any liability for > any such corruption, interception, amendment or the consequences thereof. > **

Re: Exporting Data via Command Line

> > > > > > Thanks > > > > Try reading up on these commands: > > (from a command shell prompt) mysqldump > http://dev.mysql.com/doc/mysql/en/mysqldump.html > > (from within a MySQL client) SELECT ... INTO OUTFILE > http://dev.mysql.com/doc/mysql/en/select.h

Re: Speed of Inserts into MyIsam tables from mysqlbinlog

MyIsam table as the bin_logs are played back on > the system? This is also used to help gauge performance, so this method > of inserting data is important to the process as a whole. > > Regards, > > Thomas. > > -- Eric Bergen [EMAIL PROTECTED] http://www.ebergen.net

Re: Difficulty starting mysql

ld > > ./usr/libexec/mysqld > > ./usr/local/libexec/mysqld > > ./home/webcollab/mysql-4.1.10/sql/mysqld > > > > What do I need to do to make it start properly? Thanks in advance! > > > > Kelly S. Brace > > Information Technology Exchange Center > &

Re: Configuring two mysql servers on one linux server

List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- Eric Bergen [EMAIL PROTECTED] http://www.ebergen.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: queries slower on InnoDB

14 Feb 2005 15:52:21 -0600, Eric Bergen <[EMAIL PROTECTED]> wrote: > > Total row count is cached in the header for MyISAM tables. InnoDB has > > no such mechanism for this because transactions make it impossible to > > keep an exact row count. In order for InnoDB to get

Re: Empty 'Relay_Master_Log_File'?

4 Feb 2005 15:55:49 -0800 (PST), Atle Veka <[EMAIL PROTECTED]> wrote: > > On Mon, 14 Feb 2005, Eric Bergen wrote: > > > Did you copy the relay-log.info and relay logs from the seed slave? > > > > Relay_Master_Log_file is line 3 in the relay-log.info file. This file

Re: Empty 'Relay_Master_Log_File'?

ve got a copy of the > replicated DB + master.info from an existing slave. > > Thanks, > > Atle > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- Eric

Re: queries slower on InnoDB

t; For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- Eric Bergen [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Two versions of MySQL on same machine

details above and > > > > then > > > >>delete this e-mail. > >>Please note that e-mail may be susceptible to data corruption, > >>interception > >>and unauthorised amendment. Alchemetrics does not accept any > > > > liability > > > >>for > >>any such corruption, interception, amendment or the conseq

Re: "show table status" extremely slow

advance. > > Regards, > Zhe > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- Eric Bergen [EMAIL PROTECTED] http://www.bleated.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Setup question on mysql under Linux

gt; For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- Eric Bergen [EMAIL PROTECTED] http://www.bleated.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ? MySql Server on Suse Linux & XP Workstations?

Installing.html > > Thanks, > > Teddy > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- Eric Bergen [EMAIL PROTECTED] http://www.bleated.com -- MySQL

Re: Rollback and INSERT_ID() or LAST_INSERT_ID()

to avoid to use the function MAX() to get the > last ID inserted. > > Thanks for any help. > > Andre > > -- > Andre Matos > [EMAIL PROTECTED] > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:

Re: Can Mysql hold possible field values?

; > I feel that creating the application this way would ensure that no invalid > data can be entered into the table. > > Thanks for your help > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lis

Re: Upgrade correpted InnoDB tables

from happening when upgrading the > other servers? > > Thanks in advance, >Mattias J > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- Eric Berg

Re: export from older version

; > - dstefani > | > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- Eric Bergen [EMAIL PROTECTED] http://www.bleated.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: BIG InnoDB problems!

log sequence number 0 241346554 > InnoDB: !!! innodb_force_recovery is set to 5 !!! > 041230 16:46:01 [Warning] mysql.user table is not updated to new > password format; Disabling new password usage until > mysql_fix_privilege_tables is run > 041230 16:46:01 [Warning] Can'

Re: Copying users?

in computer? > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- Eric Bergen [EMAIL PROTECTED] http://www.bleated.com -- MySQL General Mailing List For list archives: htt

Re: Replication update bug/error/problem.

,1,1,1,1,1,1,1,1,1,1,now(),now()); > > On the slave get the data with "load data from master". > Both slave and master shows : > +++ > | content_id | overall_rating | > +++ > |243 | 1.00 | > +

Re: Upgrading from 3.23.58 to 4.1

t; > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- Eric Bergen [EMAIL PROTECTED] http://www.bleated.com -- MySQL General Mailing List For list archives: http://list

Re: Excel 2 mysql

like navicat but i dont see where you actually start the > app , if that is what happens. Any help is highly appreciated. > > cheers > > -Z > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.m

Re: Query Cache

> > Do you know if this is available thru the C API .. Could a User Defined > Function be written to return this? > > Any more ideas would be great.. > > Thanks > > Skex > > > -Original Message- > From: Eric Bergen [mailto:[EMAIL PROTECTED] &g

Re: Query Cache

Array["status"]["cached"]=1; > Array["status"]["count"]=1; > Array["data"][0][field1]=1; > Array["data"][0][field2]=2; > Etc... > > Any ideas would be greatly appreciated... > > Skex > > -- > MySQL Genera

Re: Newbie, MySQL test fails, spent hours, please help

; the only one I entered was the one when MySQLadmin.exe installed... is > that the username and password that should be used? > > Thanks very much. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- Eric Bergen [EMAIL PROTECTED] http://www.bleated.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: More efficient way?

ck > followed by either an insert or an update? The MySQL version is 3.2x > using MyISAM tables. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- Eric Ber

Re: Help me optimize this query

out such optimizations for update query. > > TIA, > - Manish > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- Eric Bergen [EMAIL PROTECTED] bleated.com --

Re: a query to insert values into two different tables using mySQL Server

chives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- Eric Bergen [EMAIL PROTECTED] bleated.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Table Names Begin with '#'

mambo (open source CMS) table names begin with a "#" > character. How does one describe a table that begins with "#"? > > > > -DK > > > > Daniel Kemper > > Lead Programmer > > Intellisys, Inc. > > > &g

Re: COMPRESS() vs myisampack

L General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- Eric Bergen [EMAIL PROTECTED] bleated.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: quote and null

hing like: > --- > QUOTE(str) > ... If the argument is NULL, the return value is NULL. ... > --- > > Does this seem correct? Have I missed or overlooked something? > > Cheers. > Toro > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- Eric Bergen [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Innodb log file

gt; 041028 0:10:49 Aborting > > thanks in advance > > Alejandro > > -- Eric Bergen [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: counting rows

> > Thanks, > Marco > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- Eric Bergen [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lis

Re: Table Lock Delays and Connection Pooling

with another query from a different client. Not to mention the over head of scheduling on the client side. If you have enough lock contention for table locks to be a problem you should switch to the InnoDB storage engine. -- Eric Bergen [EMAIL PROTECTED] On Mon, 18 Oct 2004 16:58:04 -0700,

Re: date time functions don't return not null rows

1 | NULL | NULL | NULL | NULL | 10 | > | 1098560298 | 2355 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 11 | > +----+--+--+--+--+--+--+--+--++ > > did i something wrong? > -- Eric Bergen [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Adding DSN into Coldfusion Admin?

is > actually running? > > Thanks very much!! > > Steve > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- Eric Bergen [EMAIL PROTECTED] -- MySQL Ge

Re: How to flush process which are in sleep state

t killing them > > Thanks in advace > ANil > DBA > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- Eric Bergen [EMAIL PROTECTED] -- MySQL General Mailin

Re: Replication and LOAD DATA LOCAL INFILE

ineer > Senvid, Inc. > 2445 Faber Place, Suite #200 > Palo Alto, CA 94303 > phone: 650-354-3612 > fax: 650-354-8890 > email: [EMAIL PROTECTED] > http://www.senvid.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To un

Re: Login error

rd for root ? > Q2. How do I know if root IS the admin for MySql ? > Q3. How can I add a Database ? > Q4. How can I add a New User to a New Database ? > > Thanks in Advance, > > -Kamal. > > -- > MySQL General Mailing List > For list archives: http://lists.mys

Re: mysql dynamic librairie client

t; Thanks you, Romain > > Sorry for my bad english :( > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- Eric Bergen [EMAIL PROTECTED] -- MySQL General Maili

Re: Data store over NFS with multiple READERS

r if the above post meant > the db had to be totally read only, or just read only from all the other > machines except the writer > > Thanks > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.my

Re: splitting a large table - does it improve performance?

gt; much.) Also smaller tables will occupy less disk space so if the drive is > defragged, there is less work for the hard drive to find the data. You can > experiment with smaller tables and use Merge tables when appropriate. > > Mike > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- Eric Bergen [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Does anyone has the experience on migrating mysql server from 32bit sysem to a 64bit system?

u Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > -- Eric Bergen [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Images

non issue. -- Eric Bergen [EMAIL PROTECTED] On Tue, 28 Sep 2004 09:19:47 -0700, Ed Lazor <[EMAIL PROTECTED]> wrote: > What do you mean "chunked"? > > I figured it would be easier to track about 32,000 images in MySQL than in > files, so I setup a test to see what t

Re: Problems with phpMyAdmin, GD library, and jpegs

If you are storing a complete image in MySQL you don't need gd at all. Just output the correct header and the image file. GD is for creating images on the fly. Also if you can store the image in a file on disk and the path to the image in MySQL. -- Eric Bergen [EMAIL PROTECTED] On Mo

Re: Images

It is possible but not very logical. MySQL isn't a filesystem. Unless you have an extreme situation you should store the path in MySQL and the image itself in a file. -- Eric Bergen [EMAIL PROTECTED] On Mon, 27 Sep 2004 18:20:02 -0400, GH <[EMAIL PROTECTED]> wrote: > I was wonder

Re: server timezone and system timezon

Have the location selecting adjust the timezone when it selects. Example select t + interval 6 hour from t -- Eric Bergen [EMAIL PROTECTED] On Mon, 27 Sep 2004 12:24:36 -0600, Elim Qiu <[EMAIL PROTECTED]> wrote: > Hi, I'm looking for help on timezone issues. > > I

Re: help!!!!!!!!!!

another document that will help you get help online easier. http://www.catb.org/~esr/faqs/smart-questions.html -- Eric Bergen [EMAIL PROTECTED] On Sun, 19 Sep 2004 07:50:14 +0200, Sven <[EMAIL PROTECTED]> wrote: > > > Warning: mysql_query() [http://www.mysql.com/doc]: Your query

Re: Upgrading MySQL. Caveats or Cautions anyone?

d pointers to docs would be appreciated. > > Thanks much > tim > -- > Tim Johnson <[EMAIL PROTECTED]> > http://www.alaska-internet-solutions.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lis

Re: FW: Backup / Restore

p/restore methodology assuming we still do lock tables and use the > binary log. This approach does take some additional admin effort if we add > or drop tables. > > -- Eric Bergen [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Fwd: please explain why this query isn't optimized

AX(changed) | > ++ > | 20040826202123 | > ++ > 1 row in set (0.00 sec) > > Getting the same answer, from a simpler query, in infinitely > less time, just seems wrong to me. > > > > > -- > MySQL General Mailing List > For list archives:

Re: multi inserts and duplicate key handling

gt; > INSERT IGNORE INTO ... > > -- > Paul DuBois, MySQL Documentation Team > Madison, Wisconsin, USA > MySQL AB, www.mysql.com > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.

Re: please explain why this query isn't optimized

00 | > > | > > | sync_date| datetime | YES | | -00-00 00:00:00 | > > | > > +------+---+--+-+-+--- > > + > > 10 rows in set (0.03 sec) > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- Eric Bergen [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: grant tables update backward compatibility

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

Re: temporary tables and replication

I believe some versions of 4.0 have problem with auto dropping temporary tables in replication. The easy fix is to drop temporary tables when you are finished with them instead of relying on mysql to do it for you. -- Eric Bergen [EMAIL PROTECTED] On Wed, 1 Sep 2004 08:16:43 -0600, Alfredo

Re: Mysql and errno 13 on RedHat

t; > Yannick > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- Eric Bergen [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Query Cache

; > Regards > Terry Riley > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- Eric Bergen [EMAIL PROTECTED] -- MySQL General Mailing List For list archives:

Re: stress test

super-smack: http://jeremy.zawodny.com/mysql/super-smack/ Or for stress testing the box itself checkout bonnie++ or http://people.redhat.com/dledford/memtest.html which isn't a memtest script but more of a general i/o cpu test. -Eric On Sat, 17 Jul 2004 00:07:12 -0700, Brad Waddell <[EMAIL PRO

Re: mysqld ended error (but no /var/lib/mysql/mysql.sock file exists!)

mysqld is trying to tell you that it doesn't have permission to create /var/lib/mysql/mysql.sock to accept incoming connections. You either need to have mysql create the sock file in another place (such as /tmp/) or give it write permission to /var/lib/mysql/ -Eric On Thu, 15 Jul 2004 17:05:13 -

Re: another left join question - multiple "left join" statements

You only need to specify from tabel on the first table. Like this. select cattbl.name as cat, dogtbl.name as dog, birdtbl.name as bird from dogtbl left join cattbl on cattbl.id=dogtbl.catid left join birdtbl on birdtbl.dogid=dogtbl.id; -Eric On Mon, 5 Jul 2004 09:28:02 -0700, bruce <[EMAIL PRO

Re: date and time functions.

Date modification functions are listed in the manual here: http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html If you are just trying to add a year to a column try something like this. update table set col = col + interval 1 year; -Eric On Sun, 4 Jul 2004 18:22:04 +1000, Hari Yell

Re: threading problems in linux C client

If you have multiple threads accessing the same connection remember to make sure that only one thread enters mysql_query() mysql_connect() or mysql_store_result() after you store the result another thread will be able to use that connection without problems. -Eric On Wed, 30 Jun 2004 11:01:35 +00

Re: FULLTEXT

alter table t add fulltext (col) -Eric On Wed, 30 Jun 2004 22:28:03 +0200, Schalk <[EMAIL PROTECTED]> wrote: > > I am using the following command on MySQL 4.0.18 > > ALTER TABLE tablename MODIFY columnname FULLTEXT; > > I keep getting an error regarding FULLTEXT. Where am I going wrong? > > K

Re: Memory to Memory INSERTS

http://dev.mysql.com/doc/mysql/en/Insert_speed.html -Eric On Tue, 29 Jun 2004 09:43:04 -0400, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > I am proposing this as a hypothetical situation and I would like the full > feedback of the group: > > Could Alejandro re-use the sections of the MyS

Re: Server tuning

If it starts swapping you have key_buffer set to high. -Eric On Tue, 29 Jun 2004 15:41:20 -0500, Victor Pendleton <[EMAIL PROTECTED]> wrote: > > max_memory is roughly equivalent to ==> key_buffer_size + (read_buffer_size > + sort_buffer_size) * max_connections > > > -Original Message-

Re: reading past "bogus data in log event" error in binary log in 4.0.18 ?

I had this same problem. This isn't fool proof or recomended but what i ended up doing was calling mysqlbinlog over and over again incrementing --position (or --offset i can't remember) until it picked up a good record again and kept going. Chances are you will lose queries but it does work. -ERic

Re: MySQL Storage Engines and Table Types.....

Show table status\G Will give you a list of tables the Type: field for each table is the storage engine. Your installation probably defaults to MyISAM -Eric On Mon, 28 Jun 2004 11:51:40 -0400, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > You can see a list of the available storage types

Re: mysql client connectivity and "orphaned" connections

When a connection is dropped most read only queries will be immediatly dropped, write queries such as your optimize table will continue until they complete as not to corrupt any table data or leave anything unfinished. -Eric On Mon, 28 Jun 2004 17:29:22 -0400, Jim <[EMAIL PROTECTED]> wrote: > >

Re: Query problem

Post the table structure, what that query it returning and what you think it should return. -Eric On Sun, 27 Jun 2004 23:33:55 +0200, Schalk <[EMAIL PROTECTED]> wrote: > > Why is the following query retuning doctype's different to what is asked > for? > SELECT * FROM documents WHERE jstate = 'Ca

Re: insert into text field

desc is a reserved word. http://dev.mysql.com/doc/mysql/en/Reserved_words.html In most cases to use desc as a column you will have to escape it with backticks like this `desc`. -Eric On Sat, 26 Jun 2004 16:19:37 +0530, Nitin <[EMAIL PROTECTED]> wrote: > > Hi all, > > There's a problem. When

Re: File locking & mysql 4

MySQL itself doesn't require file locking. Infact there is an option to turn it off. --skip-external-locking that disables using the flock() system call. Just watch out that you don't accidently start two mysqlds on the same datadir. -Eric On 24 Jun 2004 13:42:33 -0700, Shelly Zhang <[EMAIL PROT

Re: table across multiple files

Another option depending on your needs would be the MERGE table type. -Eric On Thu, 24 Jun 2004 22:21:58 +0100, Andrew Pattison <[EMAIL PROTECTED]> wrote: > > The standard MySQL distribution comes with InnoDB support. You can also > split tables into up to 255 blocks using MyISAMs RAID support.

Re: Mysql oracle migration

But unix timestamp doesn't support milliseconds either. You could store the timestamp in one column and the milliseconds in an extra smallint column. Then combine the two on output. -Eric On Thu, 24 Jun 2004 12:25:19 +0200, Gianpaolo Fasoli <[EMAIL PROTECTED]> wrote: > > Hi, > > We are looking

Re: Fetching 12 columns or 1 TEXT field?

If you are reading from a myisam variable length row table the table handler actually reads the entire row from disk regardless of the columns you choose. I would say store them in separate columns so you can use those in other parts of your queries (where statement ect) Also you don't incur the ov

Re: mysql control center documentation

mysql.com (php.net and freshmeat.net) sites all have a search features where a if a requested file is not found it performs a search for it as a key word. Example finding the mysql control center manual is as easy as requesting http://www.mysql.com/mysql control center or depending on your brows

Re: replication

un your database on some flavor of linux or if your really partial to it, a flavor of bsd. If the *nixes are out of the question at least upgrade to windows 2000 server or something based off of NT. I have also had corruption issues running under very high load on IDE drives, if you can afford it go

<    1   2