SQL_BIG_RESULT being ignored?

but shouldn't that hint force the temporary table to disk rather than a HEAP table? Thanks for any help anyone can provide, kabel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Performance of MySQL IN() given a list of constants.

mes concurrently and, since it may involve multiple connections (please don't ask) I don't think temp tables would work. I could take it with CREATE TABLE `baz_$SESSION_ID`... etc., where I generate some session ID, but I may go with the IN() stuff for starters just to see. Thank you VE

Performance of MySQL IN() given a list of constants.

| foo | range | idx_bar_id | idx_bar_id | 5 | NULL |7 | Using where | Does anyone have experience with the performance of IN(), given a list of constants, on an indexed column? Any pointers to more information on this would be greatly appreciated. Thanks in advance! kabel --

Re: self-joins in hierarchical queries: optimization problem

Not sure if this is the exact problem you're trying to solve, but this helped me in a similar situation. http://dev.mysql.com/tech-resources/articles/hierarchical-data.html kabel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: ad hoc replication for 3 X 40 000 rows

Might be worth checking out an ETL tool (Talend, Pentaho's Kettle) + cron (or the windows equivalent) to automate this. kabel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Table problem

running out of space on your temp partition.. if a query is either creating an explicit temporary table or generating one as part of execution, it may be filling it up. kabel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: MAC address as primary key - BIGINT or CHAR(12)

ress defined as BIGINT > 2. MAC address set as primary key > > Should I consider changing it to CHAR(12)? > > Replies will be appreciated. > Ilia And, if you use default charsets of anything else, make sure you set this column to CHARACTER SET ascii. A smaller index is a happi

Annoying .mysql_history problem

ql_history to be written as I go. Thanks for any pointers, kabel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: dynamically splitting a table through one full table scan

t feels it should be possible to do the split through a single scan. Any suggestions? thanks, Jacek Jacek, Have you looked into MySQL partitioning? If you're using version 5.1, it might really help.. just partition the big table on chunk ID. http://dev.mysql.com/doc/refman/5.1/en/partition

"ONLY IN"

d NOT NULL, `run_id` int(11) unsigned NOT NULL, `is_active` tinyint(1) NOT NULL default '1', PRIMARY KEY (`edition_id`,`run_id`); Thanks in advance, kabel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Percentage growth query.

x27;m currently using temporary tables to store the results of each query, however, I think there's a way to accomplish this using subqueries. Any thoughts? TIA, kabel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.

Union query

Thanks in advance for any help kabel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to know the maximum length of a field

analyse()? SELECT column FROM table PROCEDURE ANALYSE(10, 2000); kabel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL Stored Procedure error 1307

On Friday 18 April 2008 10:26:16 Ananda Kumar wrote: > can u please try this a root user > > mysql -uroot > > regards > anandkl > Same result, unfortunately. kabel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://l

MySQL Stored Procedure error 1307

t think that's the case. The results of mysqlcheck mysql for the proc tables are: mysql.proc OK mysql.procs_priv OK Anyone have any thoughts, or come across this before? TIA, kabel -- MySQL General Mailing List Fo