Re: --log-slave-update

Hi, There is nothing that, you can not enable log_slave_updates on slave. Basically, it is useful in a situation when you have 1 master and 2 or more slave in chain series. In this model 1st slave server should work as master as well as slave. So, log_slave_update and binlog can be enabled to log

Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)

Just try mysqladmin ping that whether mysql is working or not Krishna On Thu, Apr 3, 2008 at 5:45 AM, Vidal Garza <[EMAIL PROTECTED]> wrote: > Hi... > I need test mysql connections but i have a problem... > > freebsd# uname -a > FreeBSD freebsd.aduanet.net 6.3-RELEASE FreeBSD 6.3-RELEASE #0: Wed

Re: Cross database queries

On Thu, Apr 3, 2008 at 2:04 AM, Ben Roberts <[EMAIL PROTECTED]> wrote: > > Hello, > > Does anybody have any info on cross-database joins? > > i.e. doing a join across various tables that are located inside different > databases (albeit on the same database server). Yes, Implemented and working

Re: Innodb vs myisam

Hi, On myisam storage system mysql> explain select ui.user_id, ucp.user_id,ucp.payment_date from user_info ui, user_course_payment ucp where ui.user_id=ucp.user_id; ++-+---++---+---+-+-++--

--log-slave-update

Hi All, I have Master - Slave setup, with just one slave. Can i set --log-slave-update on slave. I have mysql running on debain with 8 cpu and 8 GB RAM. Also in this link http://dev.mysql.com/doc/refman/5.0/en/replication-solutions-switch.html Its says not to set --log-slave-update on slave, so

Re: Innodb vs myisam

Hi, I have executed ANALYZE TABLE for myisam tables, but still myisam is showing more scanning of rows as compared to innodb. What does ANALYZE TABLE command exactly do for myisam storage engine. Thanks Krishna On Wed, Apr 2, 2008 at 9:48 PM, Rob Wultsch <[EMAIL PROTECTED]> wrote: > On Wed, Apr

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)

Hi... I need test mysql connections but i have a problem... freebsd# uname -a FreeBSD freebsd.aduanet.net 6.3-RELEASE FreeBSD 6.3-RELEASE #0: Wed Jan 16 04:18:52 UTC 2008 [EMAIL PROTECTED] :/usr/obj/usr/src/sys/GENERIC i386 freebsd# mysql --version mysql Ver 14.12 Dis

Re: Cross database queries

On Wed, 2008-04-02 at 21:34 +0100, Ben Roberts wrote: > Hello, > > Does anybody have any info on cross-database joins? > > i.e. doing a join across various tables that are located inside > different databases (albeit on the same database server). > > I'm interesested in any potential pitfalls,

Help with db design

Hi, I have a complex legacy application with around 30 tables which is in need of re-factoring, as there are tables with lots of nulls. I've partially managed to achieve this so that my queries mostly return correct information. But there are some circumstances where duplicate data is returne

Cross database queries

Hello, Does anybody have any info on cross-database joins? i.e. doing a join across various tables that are located inside different databases (albeit on the same database server). I'm interesested in any potential pitfalls, limitations, and performance issues. There doesn't appear to be mu

Re: Innodb vs myisam

On Wed, Apr 2, 2008 at 8:52 AM, Jay Pipes <[EMAIL PROTECTED]> wrote: > The MyISAM isn't scanning more rows. It's that the InnoDB "rows" output in > EXPLAIN is an estimate and the MyISAM one is accurate... > > -jay Also, if he was testing one storage engine vs another he might have dumped the ta

Re: Innodb vs myisam

The MyISAM isn't scanning more rows. It's that the InnoDB "rows" output in EXPLAIN is an estimate and the MyISAM one is accurate... -jay Krishna Chandra Prajapati wrote: Hi All, I have same table configuration, every thing same except the storage engine. Explain result on innodb system mys

Re: Innodb vs myisam

On Wed, Apr 2, 2008 at 5:06 AM, Krishna Chandra Prajapati < [EMAIL PROTECTED]> wrote: > Horribly ugly stuff > I know I sure as heck am not going to spend half an hour to turn those queries into something understandable, and I expect no one else will either. If you want help please remove all

Innodb vs myisam

Hi All, I have same table configuration, every thing same except the storage engine. Explain result on innodb system mysql> explain select ucpr.course_amount, ucpr.coupon_amount, ucp.payment_order_id, ui.course_id, uct.ref, uet.ref, ui.user_id, ucpr.coupon, ucp.payment_service_id, ucp.payme

Re: Master - Slave MySQL Database Server

On Wed, Apr 2, 2008 at 1:09 PM, Kaushal Shriyan <[EMAIL PROTECTED]> wrote: > hi, > > Is there a step by step guide to set up Master - Slave MySQL Database Server > > Thanks and Regards > > Kaushal > Hi, what are the different test cases used for this set up Thanks and Regards Kaushal -- My

Re: Indices in InnoDB/MySQL

Hi ! Robert DiFalco wrote: Right, the proof is that if I have an PKEY on ID and an index just on VALUE in MySQL then a query that would use both ID and VALUE works fine with just the index on VALUE. An index is a means to speed up access to the data when the most identifying thing, the primar

Master - Slave MySQL Database Server

hi, Is there a step by step guide to set up Master - Slave MySQL Database Server Thanks and Regards Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]