HELP!!!!! (JOIN, GROUP BY & INDEX)

how come no one response to my email? thanks! My question is below: Hi, I have some question on JOIN and INDEX usage on GROUP BY. Hope you can help me. thanks! 1. If there is any performance differenct for join from a small table to a big table and join from a big table to a small table? 2. If

JOIN, GROUP BY & INDEX

Hi, I have some question on JOIN and INDEX usage on GROUP BY. Hope you can help me. thanks! 1. If there is any performance differenct for join from a small table to a big table and join from a big table to a small table? 2. If index on group by column order, will it have any query performance gai

mysql error

g log event, reconnecting to retry, log 'replication.027' position 711963009 031117 2:44:37 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'replication.027' at position 71196300 Thanks! Hsiu-Hui -- MySQL General Mailing List For li

Innodb: Can't init databases

it databases 031112 23:44:05 Aborting Thank you for your help! Hsiu-Hui -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

cardinality in SHOW INDEX

innodb support OPTIMIZE TABLE? Thanks! Hsiu-Hui -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

select count(*) / select count(column) in innodb

innodb, is there any way to get away from the slowness? In the sql, should we avoid doing select * or select count(*)? What is the reason? Thank you for your help! Hsiu-Hui -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

help on Index

ULL | | ++++--+- ---+---+-+--++-+ thanks Hsiu-Hui -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EM

RE: Dummy problem with UPDATE for DATETIME field

your date format is not correct. It should be activity_date = '2003-9-10 10:00:00'. -Original Message- From: Franck Babin [mailto:[EMAIL PROTECTED] Sent: Monday, October 06, 2003 8:28 AM To: [EMAIL PROTECTED] Subject: Dummy problem with UPDATE for DATETIME field I have this simple sql st

replication setting

Hi, I have question on replication setting in my.cnf what is the difference between relay-log and relay-log-index? If I do not set them, what will happen? thanks Hsiu-Hui -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

case sensitive?

. They result are all the same. However, if I want to retrieve only 'sandy' instead of 'Sandy'. Is there any query to achieve that? Is there anyway to configure mysql to be case sensitive? Thanks! Hsiu-Hui -- MySQL General Mailing List For list archives: http://lists.mysql.c

RE: explain

513726 rows. -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] Sent: Friday, September 19, 2003 3:13 PM To: Hsiu-Hui Tseng Cc: [EMAIL PROTECTED] Subject: Re: explain On Fri, Sep 19, 2003 at 02:12:02PM -0700, Hsiu-Hui Tseng wrote: > Hello, > > When I do a explain on

explain

| +-+ does this say that my query is using Primary key? Thanks Hsiu-Hui -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Query performance

s that it is case in-sensitive. If case in-sensitive, the following query will be faster? select value from user_att where att_id = ? and value = '?' Thanks Hsiu-Hui -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: migrate data from myisam to innoDB

Thank you. So, the Rows in show table status is meaningless. One more question, the data_length for small table in show table status are all 16384, even the tabel without any data? thank you again Hsiu-Hui -Original Message- From: Daniel Kasak [mailto:[EMAIL PROTECTED] Sent: Thursday

migrate data from myisam to innoDB

there any way to correct the rows count in innoDB table status. thanks Hsiu-Hui -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

innodb question

After specify the variablies for innodb in my.cnf file, I started mysql server. Why I did not see the creating output? But I can see it in err file. thanks Hsiu-Hi -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PRO

help for mysql installation

configure terminate. I wanna know how to deal this question. thank you lot liu hui

user denied by mysql_connect

? by the way, mysql was installed by standard way. This is errors caused by mysql or php configuration or apache configuration? or mysql database user set up? thanks, Hui __ Do You Yahoo!? Get email at your