innodb, optimizer and outer join

= f.foo_id where f.foo_id = 1 select * from foo_child fc left join foo f on fc.foo_id = f.foo_id where f.foo_id = 1 Best Regards, Boyd E. Hemphill MySQL Certified Professional [EMAIL PROTECTED] Triand, Inc. www.triand.com O: (512) 248-2278 x 405

Apple install

? Best Regards, Boyd E. Hemphill WEST Project Manager MySQL Certified Professional [EMAIL PROTECTED] Triand, Inc. www.triand.com O: (512) 248-2278 x 405 M: (512) 470-6146

RE: SELECT DISTINCT Problem

. If not then there is a bug. Hope that helps set your expectation of the distinct key word. Best Regards, Boyd E. Hemphill WEST Project Manager MySQL Certified Professional [EMAIL PROTECTED] Triand, Inc. www.triand.com -Original Message- From: James Purser [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 08

FW: Moving innodb from Linux to Windows

Best Regards, Boyd E. Hemphill MySQL Certified Professional [EMAIL PROTECTED] Triand, Inc. www.triand.com O: (512) 248-2278 M: (713) 252-4688 -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED] Sent: Sunday, November 14, 2004 11:32 AM To: Boyd E. Hemphill Cc: [EMAIL

Moving innodb from Linux to Windows

you can resolve the problem. 04 13:47:03 [ERROR] C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt: Can't open file: 'grade.InnoDB' (errno: 1) I am pulling my hair out! Please help! Best Regards, Boyd E. Hemphill MySQL Certified Professional [EMAIL PROTECTED] Triand, Inc

optimizing InnoDB tables

TABLE? Too, what exactly happens after 4.1.3? Is space, in fact, recovered and defragged? Thanks for your time! Best Regards, Boyd E. Hemphill MySQL Certified Professional [EMAIL PROTECTED] Triand, Inc. www.triand.com O: (512) 248-2278 M: (713) 252-4688 -Original Message- From

innodb monitoring

by issuing show innodb status. Is it possible to access the others in a similar way? Thanks for your time! Best Regards, Boyd E. Hemphill MySQL Certified Professional [EMAIL PROTECTED] Triand, Inc. www.triand.com O: (512) 248-2278 -- MySQL General Mailing List For list archives: http

RE: Using CREATE PROCEDURE/FUNCTION

Marti: Stored procedures are new in version 5.0. Best Regards, Boyd E. Hemphill MySQL Certified Professional [EMAIL PROTECTED] Triand, Inc. www.triand.com O: (512) 248-2287 M: (713) 252-4688 -Original Message- From: Marti Quixal [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 25

RE: excel

Another way to do this is to get the data as HTML then just open the file in Excel. The mysql client has a switch for HTML output. Just redirect the output of your query to a file. Try the following: mysql -h query.sql /path/result.sql Best Regards, Boyd E. Hemphill MySQL Certified

RE: Best method to export Excel data into MySQL?

Regards, Boyd E. Hemphill MySQL Certified Professional [EMAIL PROTECTED] Triand, Inc. www.triand.com O: (512) 248-2287 M: (713) 252-4688 -Original Message- From: Eve Atley [mailto:[EMAIL PROTECTED] Sent: Friday, August 20, 2004 8:53 AM To: [EMAIL PROTECTED] Subject: Best method to export

check table

changed from the server? 4. The doc is unclear about what is performed for InnoDB specifically. I am assuming it the same operation as for MyISAM but would like to have this clarified. Best Regards, Boyd E. Hemphill MySQL Certified Professional [EMAIL PROTECTED] Triand, Inc. www.triand.com O: (512

RE: Restoring dump file problem

Andre: If you are using enforcing FK constraints it may be that the tables are in the wrong order. Try inserting the line SET foreign_key_checks = 0; at the front of the file and SET foreign_key_checks = 1; at the end, then try again. Hope this helps. Best Regards, Boyd E

RE: 1 day 28 min insert

that spending $1500 or so on some MySQL consulting would be much less expensive than an Oracle license, plus the cost of porting, plus the consulting it would take to get your Oracle server tuned for your app. Best Regards, Boyd E. Hemphill MySQL Certified Professional [EMAIL PROTECTED] Triand

RE: Database export

are different per storage engine, so closely consult the documentation. (Note the repetition of closely). Given the size of your DB it should fit on a DVD if you have a burner available, otherwise you can likely rig a USB or Firewire drive to do the trick. Best Regards, Boyd E. Hemphill MySQL Certified

Useful DBA Unix for analyze (check) tables

be quite desirable. Consider that you can add the check table command to this script and periodically/automatically check the tables too. Hope some of you out there find this useful. Best Regards, Boyd E. Hemphill MySQL Certified Professional [EMAIL PROTECTED] Triand, Inc. www.triand.com O: (512) 248

Tuning InnoDB situation

array. We are using the InnoDB storage engine. The DB contains about 160 tables. The DB is about 50GB in size. Thanks for your time. Best Regards, Boyd E. Hemphill [EMAIL PROTECTED] Triand, Inc. Life is not a journey to the grave arriving safely in a well preserved body, but rather a skid

assigning values to user variables in the mysql client

/update_unitest.sql ; set sql_auto_is_null = 0 ; Be sure to clean up your data directory by deleting the file created as select ... into outfile places files into the diretory of the db on which the query is entered Boyd E. Hemphill -- MySQL General Mailing List For list archives: http

Display of ? and Hex conversion

All: We discovered a rather odd situation where some space characters where being displayed as ?. In tracking this down, it was determined that the server had stored the hex value A0 rather than 20 by using this query: select LocationId, LevelId, Hex(NameLn),NameLn from Location where

RE: COPY row?

John: Try: Insert into TABLE Select * from TABLE where TABLEID = ?; Update TABLE set column = 'desired value' where TABLEID = newPK; It's a bit manual, but defn the quick and dirty for a single row now and again. Best Regards, Boyd E. Hemphill [EMAIL PROTECTED] Triand, Inc

EJB - Entity Beans

. Or something like this anyway! Please help! Thanks for your time. Best Regards, Boyd E. Hemphill [EMAIL PROTECTED] Triand, Inc. www.triand.com O: (512) 248-2287 M: (713) 252-4688 -Original Message- From: Sudip Shekhawat [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 09, 2004 2:33 PM

RE: 4.1 Beta

I just installed 4.0.18 under Windows XP Home (I know, I know). After searching my hard drive I cannot find my.cnf or my.ini Where do I find the file? What is its name? Thanks Boyd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

innodb FK column rename

All: What are the consequences of renaming a column in a child table that is the FK to the parent? Will innodb remap or do I need to destroy the relationship, index and column and recreate? I am using 4.0.13 Thanks for your time! Boyd E. Hemphill -- MySQL General Mailing List For list

Very large query text?

I am having a tough time of it in production today ... Any help would be appreciated. I am executing a query of about 10k in size. When I do this it takes about 15 seconds. If I remove a bunch of case, sum and if statements but get the same explain plan the query runs in 5 seconds (it size is

urban myth?

Regards, Boyd E. Hemphill [EMAIL PROTECTED] Triand, Inc. www.triand.com O: (512) 248-2287 M: (713) 252-4688 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: urban myth?

To all who answered thank you. This answer below is the one that I can use to convince him what he proposes is not necessarily safe. Now I just need to decide how to convince him it was his idea :-) Best Regards, Boyd E. Hemphill [EMAIL PROTECTED] Triand, Inc. www.triand.com O: (512) 248

sql_no_cache

missing something? Boyd E. Hemphill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: sql_no_cache

?) the query was still running on the server. Thus it appears as if TOAD either cached the result or was going to the query cache itself. Best Regards, Boyd E. Hemphill [EMAIL PROTECTED] Triand, Inc. www.triand.com O: (512) 248-2287 M: (713) 252-4688 -Original Message- From: Boyd E. Hemphill

RE: Going Crazy in KY

. Using an absolute path is more simple (c:\path\etc...). Best Regards, Boyd E. Hemphill [EMAIL PROTECTED] Triand, Inc. www.triand.com O: (512) 248-2287 M: (713) 252-4688 -Original Message- From: Chris Stevenson [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 27, 2004 2:12 PM To: [EMAIL

Optimization and the use of indexes

index to use? I read through 7.2.4 and several other sections but no luck. Paul D...Jeremy Z, are you out there? Save me! :-) Best Regards, Boyd E. Hemphill [EMAIL PROTECTED] Triand, Inc. www.triand.com O: (512) 248-2287 M: (713) 252-4688 -- MySQL General Mailing List For list archives

RE: Optimization and the use of indexes

Jeremy: That has to be a record for fastest response with the most use. WOW! I do use Explain but knowing this info allows me to use it in a more intelligent way. Thank you very much for your time. Best Regards, Boyd E. Hemphill [EMAIL PROTECTED] Triand, Inc. www.triand.com O: (512) 248

RE: BETWEEN

I too cannot get the site correctly. I am using IE. If I wait long enough (about 2 min) text will appear but the images never seem to make it. Best Regards, Boyd E. Hemphill [EMAIL PROTECTED] Triand, Inc. www.triand.com O: (512) 248-2287 M: (713) 252-4688 -Original Message- From

RE: BETWEEN

provide a suggestion? Thanks in advance. Best Regards, Boyd E. Hemphill [EMAIL PROTECTED] Triand, Inc. www.triand.com O: (512) 248-2287 M: (713) 252-4688 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: BETWEEN

Max: Thanks for the tip. Unfortunately I am not using a FreeBSD environment. My options are to either run a WinXP client remotely or to run something Linux based in a terminal emulator (Putty). Any suggestions would be appreciated. Best Regards, Boyd E. Hemphill [EMAIL PROTECTED] Triand, Inc

Question regarding defaults

at the time the ddl (not really too big a deal) or is it doing the conversion at run time (i.e. each time a row is inserted in the DB). Thanks for your time and expertise! Best Regards, Boyd E. Hemphill [EMAIL PROTECTED] Triand, Inc. www.triand.com O: (512) 248-2287 M: (713) 252-4688

XML to MySQL

Are there any open source (or other) to load an XML document directly to a MySQL table or set of tables? Any recommendations would be greatly appreciated. Best Regards, Boyd E. Hemphill [EMAIL PROTECTED] Triand, Inc. Life is not a journey to the grave arriving safely in a well preserved body

What exactly is happening with this table create?

is happening in terms of the objects I am creating? That is: Am I creating for indexes or two? Are they the pk and ak that I want (last two statements) or is the server only creating the first two? Any insight here is greatly appreciated! Best Regards, Boyd E. Hemphill [EMAIL PROTECTED] Triand

RE: Changing the primary key

tables you will need to accommodate the new key in each of them as well. If it is OK to get more than one row back from the FK reference then you can ignore the concern. Best Regards, Boyd E. Hemphill [EMAIL PROTECTED] Triand, Inc. Life is not a journey to the grave arriving safely in a well

Show Processlist command

for your time. Best Regards, Boyd E. Hemphill [EMAIL PROTECTED] Triand, Inc. Life is not a journey to the grave arriving safely in a well preserved body, but rather a skid in broadside, thoroughly used, totally worn, and loudly proclaiming: WOW! What a ride! -- MySQL General Mailing List

RE: found rows in union

as different queries. Does this mean that MySQL does _not_ have the concept of a bind variable and thus have to reparse any query that has parameter changes? Thanks for your time. Best Regards, Boyd E. Hemphill [EMAIL PROTECTED] Triand, Inc. Life is not a journey to the grave arriving safely

Working around Insert ... Select

to this temporary table. While this will work (the table is static) it will take a long time. Does anyone have a better solution? Thank you for your time! Best Regards, Boyd E. Hemphill [EMAIL PROTECTED] Triand, Inc. Life is not a journey to the grave arriving safely in a well preserved

RE: Need help with ledger type query

with a foundation for flexibility if you wish to add more transaction types in the future such as a transfer or stock option. BTW, you can use a case statement to help with signing the number properly. I just discovered this the other day and am really tickled with it! Best Regards, Boyd E

RE: Who can help the Newbie???

days series. Best Regards, Boyd E. Hemphill [EMAIL PROTECTED] Triand, Inc. www.triand.com O: (512) 248-2287 M: (713) 252-4688 -Original Message- From: Randal [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 02, 2004 1:26 PM To: [EMAIL PROTECTED] Subject: Who can help the Newbie??? I am

RE: Load Data and Timestamps

Mark: I am not familiar with timestamp, but you may need to explicitly specify a NULL value in the timestamp column for the loader. Hope this helps Best Regards, Boyd E. Hemphill [EMAIL PROTECTED] Triand, Inc. Life is not a journey to the grave arriving safely in a well preserved body

RE: Re[2]: Type TEXT

If speed is a concern and storage is not, I believe that the fixed length char() will provide a better speed. Best Regards, Boyd E. Hemphill [EMAIL PROTECTED] Triand, Inc. www.triand.com O: (512) 248-2287 M: (713) 252-4688 -Original Message- From: Richard Davey [mailto:[EMAIL