Query Cache Behavior

2007-05-11 Thread Paul J. Boyes
Hello, I am hoping to get pointed in the right direction/save some time... I have a db in which some web services are constantly inserting/updating data. However, when I run selects from the command line mysql app, I do not see the changes that these services have made unless I do a flush

Re: Query Cache Behavior

2007-05-11 Thread Paul J. Boyes
This is our problem: http://bugs.mysql.com/bug.php?id=27210 Thanks, Paul Baron Schwartz wrote: Hi, Paul J. Boyes wrote: Hello, I am hoping to get pointed in the right direction/save some time... I have a db in which some web services are constantly inserting/updating data. However

Rename of Table That Receives a High Volume of Reads

2007-03-21 Thread Paul J. Boyes
a large number of reads? Will it work? What are the drawbacks? Having never done this with MySQL, I am hoping to get some advice from others who may have attempted this, are in the know, etcAny info you can provide would be greatly appreciated. Thanks, Paul J. Boyes -- MySQL General

Re: Rename of Table That Receives a High Volume of Reads

2007-03-21 Thread Paul J. Boyes
Great. That is the assumption under which I have been working. I was really hoping for confirmation. I appreciate it! Thanks for responding. Thanks, Paul Chris Comparini wrote: On Wednesday 21 March 2007 16:31, Paul J. Boyes wrote: Hello, I have a fairly sizeable aggregate