slow performance with MERGE tables

Hello, I am running a rather simple query on a merge table that seems to be taking much longer than it should. First let me show the table status of the tables I have merged into table 'blah': NameTypeRow_format RowsAvg_row_length Data_length Max_data_length Index_length

AIX 5L binaries?

Hello, Are there any plans for releasing AIX 5L pre-compiled binaries? I notice there are some MySQL RPMs available from other locations but they are not the latest version. If not, are there any pointers to AIX 5L compilation steps? Viraj. -

Re: insert delayed and timestamps

the unlock). So this answers my question, the value from the delayed temporary table is used. Thanks, Viraj. > -Original Message- > From: Viraj Alankar [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 02, 2002 8:50 AM > To: [EMAIL PROTECTED] > Subject: insert delayed and t

help optimizing log table deletes

Hello, We have an 'outgoing' table being used to store email header information defined as follows: CREATE TABLE outgoing ( rpath varchar(80) default NULL, auth varchar(80) NOT NULL default '', ip varchar(80) default NULL, hfrom varchar(80) default NULL, hto varchar(80) default NULL,

insert delayed and timestamps

Hello, When using 'insert delayed' syntax and there is a timestamp field in the table but not specified in the insert query, which timestamp is actually used when the record ends up in the destination table? In other words, will the timestamp value be the actual timestamp that the record was inse

delete vs delete quick

sql Hello, I'm confused as to what 'delete quick' does and when to use it. The manual states: If you specify the word QUICK then the table handler will not merge index leafs during delete, which may speed up certain kind of deletes. What does this actually mean? Viraj. --

sql help examining log table

Hello, We use mysql to store outgoing email headers from our users and do throttling on users that appear to be spamming based on some simple queries to this table. We use the Communigate mail server and this throttling script is a PERL program implemented as a content filter. More information is

Select_full_join counter

Hello, The MySQL manual states that the Select_full_join status counter should be 0. Can someone explain to me what this actually counts and why it is bad to not have this 0? I have some queries that I'm not sure how else to optimize. Thanks, Viraj.

database= in my.cnf causes mysqldump to fail

Hello, I'm not sure if this is a bug or not, but I've noticed that if I have a 'database=' in my ~/.my.cnf, calling mysqldump with any possible options always returns: mysqldump: option `--databases' doesn't allow an argument The only way I can get it working is to remove the 'database=' line f

Help on optimizing

Hello, I'm trying to optimize a table but not sure what more I can do. I have a table like the following: CREATE TABLE `outgoing` ( `rpath` varchar(80) default NULL, `auth` varchar(80) NOT NULL default '', `ip` varchar(80) default NULL, `hfrom` varchar(80) default NULL, `hto` varchar(8