SPAM ?
Hi, I keep receiving this message by several dozens each day, how can this be stopped? Regards Jacques -Message d'origine- De : Jerry Schwartz [mailto:[EMAIL PROTECTED] Envoyé : jeudi 22 mars 2007 17:53 À : [EMAIL PROTECTED]; 'James Tu' Cc : 'MySQL List' Objet : RE: Finding a record in a result set I don't think that will work. If there are 1,000 records that qualify but none for Joe, then it will return 1,001. If Joe is in record 1 of the retrieved record set, and there are 999 other people who match the WHERE clause, then it will retrieve 1,000. Am I missing something? Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Thursday, March 22, 2007 12:33 PM To: James Tu Cc: MySQL List Subject: Re: Finding a record in a result set I want to do a query of all employees from Maine, ordered by hiring date, and figure out where Joe falls in that list. (i.e. which record number is he?) If 'Joe' is a unique name LOL... SELECT 1 + COUNT(*) FROM employees WHERE name 'Joe' AND state = 'MA' AND hiredate datevalue; PB James Tu wrote: Is there some quick way to do the following in MySQL? (I know I can use PHP to search through the result set, but I wanted to see if there's a quick way using some sort of query) Let's say I know that Joe is from Maine. I want to do a query of all employees from Maine, ordered by hiring date, and figure out where Joe falls in that list. (i.e. which record number is he?) -James --MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] --No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.17/730 - Release Date: 3/22/2007 7:44 AM -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Index not used sometimes -- why?
Sometimes, when I run a query on a table, the index will be used. But if I run the SAME query, but on a larger set of rows (e.g., where id BETWEEN 1 AND 10 vs WHERE id BETWEEN 1 AND 500), the index is not used. (EXPLAIN tells me this.) And as a result, the query runs slow. The question I have is, why is the index not used on larger-range queries? Could it be because the key_buffer_size parameter is too small? Presently, it's set at the default value of 8M. Could increasing that value to, say, 128M, potentially solve this problem? Or is there some other factor involved? Thanks. ...Rene -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SPAM ?
Hi, I also get the problem of keep receiving the email from the email list Yeah, same here. I keep getting e-mail from a list that I subscribed to and confirmed my subscription for ... Dang, how do I solve that. ;) -- Martijn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Index not used sometimes -- why?
M5 a écrit : Sometimes, when I run a query on a table, the index will be used. But if I run the SAME query, but on a larger set of rows (e.g., where id BETWEEN 1 AND 10 vs WHERE id BETWEEN 1 AND 500), the index is not used. (EXPLAIN tells me this.) And as a result, the query runs slow. The question I have is, why is the index not used on larger-range queries? Could it be because the key_buffer_size parameter is too small? Presently, it's set at the default value of 8M. Could increasing that value to, say, 128M, potentially solve this problem? Or is there some other factor involved? Thanks. ...Rene --MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Hi, As far as I know the key_buffer doesn't affect this... It's a decision that the optimiser take at some point. I think that when he detects that he would need to scan more than 60% of the index, he decide that that would be too much read for nothing and that a full scan may be better. This is generally a wise decision but in some case it's not (because you don't really scan 60%, or because all the row you wanna read are sequential or ...) To be sure, he has the best information to take his decision, make sure your table is analyze, especially if you do many delete in your table! You could force him to use the index but beware of that solution as it may have an impact if you dataset change with time (growth) Regards, -- Mathieu Bruneau aka ROunofF === GPG keys available @ http://rounoff.darktech.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: problems with replication when db is changed
Bgs a écrit : Greetings, We have regular problems with mysql replication when there is a db change. This is mostly ALTER TABLE. The sync breaks and we either have to do the changes manually or either shut down the whole system for a new sync from zero. Is there a way to sync alter table commands on the fly? Shouldn't they be executed just as the insert/update commands? Regards Bgs I never experienced such issues... (Unless someone killed the alter table) What error do you see in the replication exactly ? (Also which version of mysql are you using ?) -- Mathieu Bruneau aka ROunofF === GPG keys available @ http://rounoff.darktech.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
right configuration.
Hi Friends, We are in the processing of building a new Mysql database. We are planing to use innodb. I need help on couple of questions. 1. What are the best parameter setting in my.cnf for innodb. 2. Is it possible to allocate each table a separate tablespace. 3. Is it possible to create index in a separate tablespace. 4. We planing to create partitioning at application level, is there a limit on no. of partitions, and also is there is a limit on number of rows on each partition. 5. We are planing to migrate from oracle to mysql, is there any particular way to speed up migrating huge data from oracle to mysql. 6. What are the different events do we need to moinitor in Mysql. thanks a lot for all you help. regards anandkl