Re: Is LOAD INDEX INTO CACHE replicated?
They're not data modification statements, so no, they're not replicated. On Sun, Nov 29, 2009 at 2:06 AM, Tom Worster f...@thefsb.org 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 it need to execute CACHE INDEX and LOAD INDEX INTO CACHE statements from its --init-file? And if a master mysql restarts, would the slave execute CACHE INDEX and LOAD INDEX INTO CACHE statements the master reads from its --init-file and writes to the big-log? tom -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=vegiv...@tuxera.be
MySQL 5.4 Support for Mac OS X 10.6.x ?
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 for GA and to get beta versions (the mysql-5.4.3-beta is supported only on osx10.5-x86_64) ? Thanks, Steve http://dev.mysql.com/downloads/mysql/5.4.html#macosx-dmg http://dev.mysql.com/doc/mysql-macosx-excerpt/5.4/en/mac-os-x-installation.html http://bugs.mysql.com/bug.php?id=46999 http://lists.mysql.com/mysql/218618 http://lists.mysql.com/mysql/218638 http://macosx.com/forums/mac-os-x-system-mac-software/311841-mysql-installation.html http://tomkeur.net/39/how-to-remove-mysql-completely-mac-os-x-leopard.html
Is a view efficient in joins?
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 efficient at making joins? Are the joins executed every time the view is used or is the data cached somehow? The other approach is for me to create a table to hold the summary data and write application code that periodically updates it. Which alternative would be best? Thanks, Neil -- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net Host your MySQL driven app on a CentOS VPS for $25/mo Unmetered bandwidth = no overage charges, 7 day free trial -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Is a view efficient in joins?
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 table is actually a good one in many instances, especially if it's not vital that it contain the most up-to-date data. On Sun, Nov 29, 2009 at 6:16 PM, Neil Aggarwal n...@jammconsulting.comwrote: 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 efficient at making joins? Are the joins executed every time the view is used or is the data cached somehow? The other approach is for me to create a table to hold the summary data and write application code that periodically updates it. Which alternative would be best? Thanks, Neil -- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net Host your MySQL driven app on a CentOS VPS for $25/mo Unmetered bandwidth = no overage charges, 7 day free trial -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com -- Jim Lyons Web developer / Database administrator http://www.weblyons.com
RE: Is a view efficient in joins?
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 table is actually a good one in many instances, especially if it's not vital that it contain the most up-to-date data. I think I will go that direction. It will be OK for the summary data to be delayed by a short interval. Thanks, Neil -- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net Host your MySQL driven app on a CentOS VPS for $25/mo Unmetered bandwidth = no overage charges, 7 day free trial -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
MySQL On ipv6
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 address) it doesnt start. Thanks in advance. Regards, Pramod TK
What's she doing now
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!