Dear MySQL users,
MySQL Community Server 5.1.42, a new version of the popular Open
Source Database Management System, has been released. MySQL 5.1.42 is
recommended for use on production systems.
For an overview of what's new in MySQL 5.1, please see
http://dev.mysql.com/doc/refman/5.1/en/my
Hi All!
I have just released PBXT 1.0.10 RC4.
The major feature of this release is the implementation of the
pbxt_flush_log_at_trx_commit system variable. This variable allows a
trade off between the durability of most recently written
transactions, and overall update speed of the engine.
At 08:25 AM 12/31/2009, you wrote:
OK, this problem (for me at least) is becoming a dead horse which I beat
daily. I was having problems, I thought, with a spatial query running
ridiculously slowly. Turns out the previous non-spatial index query I was
using is also running super slow for reason
Here's the table definition, in case that helps:
| qs| CREATE TABLE `qs` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`province` enum('BC','AB','SK','MB') collate latin1_general_ci NOT NULL,
`s_ts_r_m` varchar(15) collate latin1_general_ci NOT NULL,
`quartersection` varchar(3)
OK, this problem (for me at least) is becoming a dead horse which I beat daily.
I was having problems, I thought, with a spatial query running ridiculously
slowly. Turns out the previous non-spatial index query I was using is also
running super slow for reasons I can't figure out. So, to recap:
Hello,
you cannot change it in database level, it applies only to instance level.
else if you dont want to use query cache for certain queries you can include
"SQL_NO_CACHE" in your query ..
ex ..
SELECT SQL_NO_CACHE ID,NAME FROM EMPLOYEE; --> your query result will not
be cached here ..
SELE
Hi,
We have number of mysql database in one box.
How can we set the variables that applies to only one database. Like when i set
the query_cache_size it should be used by only those queries for which the
parameter is set ?
Thanks
