What's she doing now

2009-11-29 Thread Kory Wheatley
Lincoln feared that the issue of slavery would weaken the northern war effort. Many men throughout the north would fight to save the Union. They would not fight to free the slaves. Although it is often confused with common cold, influenza is a much more severe disease!

MySQL On ipv6

2009-11-29 Thread pramod tk
Hi, I want to know whether MySQL Server runs on ipv6 machine. ie. When you start the MySQL Server it always binds to 127.0.0.1 ipaddress. IS there any way to bind MySQL Server to IPv6 loopback address [::1]. if i start MySQL Server on pure ipv6 machine which doesnt support 127.0.0.1(ipv4 loopback

RE: Is a view efficient in joins?

2009-11-29 Thread Neil Aggarwal
Jim: > A view is no more or less efficient that the queries that > make it up. Each > time you invoke the view, you repeat all the joins. That is what I was afraid of. With the large number of tables I have, the joins are going to take a lot of cycles to run. > Your solution of the summary ta

Re: Is a view efficient in joins?

2009-11-29 Thread Jim Lyons
A view is no more or less efficient that the queries that make it up. Each time you invoke the view, you repeat all the joins. A join could be more efficient only if you go to a lot of effort to ensure it forms the most efficient join(s) of the underlying tables. Your solution of the summary tab

Is a view efficient in joins?

2009-11-29 Thread Neil Aggarwal
Hello: I have a database with over 60 tables with thousands to millions or rows in each. I want to develop a summary of the data joined across all the tables. I can do this with a view, but I am concerned it will take a lot of resources to perform all the joins required by the view. Is a view e

MySQL 5.4 Support for Mac OS X 10.6.x ?

2009-11-29 Thread Steve Pincaud
Hello, I have a Mac Book Pro (64 bits x86) running with Snow Leopard aka Mac OS X 10.6.2, I have read the here under pages and my conclusion is that MySQL currently does not support Mac OS X 10.6.x, so my question is: is there any plan in the roadmap to support it ? and if so what would be the ETA

Re: Is LOAD INDEX INTO CACHE replicated?

2009-11-29 Thread Johan De Meersman
They're not data modification statements, so no, they're not replicated. On Sun, Nov 29, 2009 at 2:06 AM, Tom Worster wrote: > Are SQL statements like CACHE INDEX or LOAD INDEX INTO CACHE replicated? > > If so, is there a way to prevent that replication? > > If a slave mysqld restarts, wouldn't