Re: adding then removing index produces different query results

On 1/24/08, Chris <[EMAIL PROTECTED]> wrote: > > mysql mysql wrote: > > Thanks for the response Chris, although I can't seem to reproduce the > > problem now, but I'm sure you're right. > > > > There's something else strange that I've encountered while trying to > > optimize this query. I've got t

Re: performance of heterogeneous joins

Nope, no difference, AFAIK. Alex K wrote: Any ideas pertaining this newbie question? Thank you so much, Hi Guys, Is there a performance hit when joining across multiple databases as opposed to joining multiples tables in one database? Suppose the same tables are available across all database

Re: adding then removing index produces different query results

mysql mysql wrote: Thanks for the response Chris, although I can't seem to reproduce the problem now, but I'm sure you're right. There's something else strange that I've encountered while trying to optimize this query. I've got two machines, dev and production. After adding the index to the tit

Re: performance of heterogeneous joins

Any ideas pertaining this newbie question? Thank you so much, > Hi Guys, > > Is there a performance hit when joining across multiple databases as > opposed to joining multiples tables in one database? Suppose the same > tables are available across all databases. > > Thank you, > > Alex > -- MyS

Re: Does PHP 4.4 work with mySQL 5.0?

You can expect your PHP binaries to work just fine. The last major upgrade of the client protocol was between 4.0 and 4.1, so 4.1 compatible clients can use 5.0 without trouble. When you say: export db/import db, you must be careful about your method. Upgrading version by moving binary data (ie.

Does PHP 4.4 work with mySQL 5.0?

Hi. I've got mySQL 4.1.22 installed from sources on Linux --- ./configure --prefix=/usr/local/mysql and PHP 4.4.2 installed from sources --- ./configure --prefix=/usr/local/php --with-mysql=/usr/local/mysql I want to upgrade mySQL from 4.1.22 to 5.0.5 by doing: 1) export DB 2)

Re: suggestion for disk configuration

Luca, In my testing I have had better throughput with RAID 10 (at least with XFS). I have not worried about the log files so much, so you might want to investigate that some. I would love to see benchmarks of your SAS array though. If you have a blog you should publish them if at all possi

suggestion for disk configuration

Hi, I have to install a mysql server for managing several database, from small to quite big (tables with about 2M rows). I've got a SAS disk array and I was wondering what the best configuration could be: 1) raid 10 2) raid 5 3) a combination (e.g., raid10 for the data and raid 5 for the logs).

Re: transfer huge mysql db

Thanks Everybody for your help! I'll think over what would be the best in my situation... /me hoping to add a success story to this thread later On Jan 24, 2008 3:08 PM, Matthias Witte <[EMAIL PROTECTED]> wrote: > On Thu, Jan 24, 2008 at 01:42:38PM +0200, Ivan Levchenko wrote: > > Hi All, > > >

Re: transfer huge mysql db

On Thu, Jan 24, 2008 at 01:42:38PM +0200, Ivan Levchenko wrote: > Hi All, > > What would be the best way to transfer a 20 gig db from one host to another? If it consists of MyISAM tables you can do a pre rsync with everything up and running. Then you would lock all tables and do the real sync[1]

Re: transfer huge mysql db

A binary copy will require that you shut down the db, rather than just lock some tables for a while, which may be more desirable. I've always found the mysql compression to be a bit weak over a slow link. The way I tend to do this sort of thing is: mysqldump --opt -B dbname | bzip2 -9c | ssh

Re: transfer huge mysql db

do binary copy. sql dump will be slow. Saravanan --- On Thu, 1/24/08, Ivan Levchenko <[EMAIL PROTECTED]> wrote: > From: Ivan Levchenko <[EMAIL PROTECTED]> > Subject: transfer huge mysql db > To: mysql@lists.mysql.com > Date: Thursday, January 24, 2008, 6:12 PM > Hi All, > > What would be the b

Re: transfer huge mysql db

heh.. a little problem with this is that i'm going to do all of this remotely. I was thinking on doing a mysqldump with the compress flag. Anything to say about mysql migration tools? can it be used to do the job more efficiently? Its just that the db is in high use and i don't want to lock the

transfer huge mysql db

Hi All, What would be the best way to transfer a 20 gig db from one host to another? Thanks in advance for your answers! -- Best Regards, Ivan Levchenko [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[

Re: failed queries

John Roddy wrote: I know that successful, data changing queries get logged in the binary log. But is there any > way to see the actual queries that fail (i.e. timeouts, deadlocks)? I'm hoping there's a > way other than using the general query log, which takes up too much space just to catch >