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
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 ..
SELECT
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:
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`
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
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.
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