I am using the innodb storage engine for a table that is used for a lot
of SELECT's on columns that are defined as indexes. I have not enabled
the query cache as of now since the innodb buffer pool already caches
data and index information for InnoDB tables. So my question is - is
the query
The query cache lays at the server level, above individual engine
implementations, and thus affects all of them.
It (case-sensitively!) compares the current query with the queries in the
query cache, and if there's an EXACT match (including all parameter
positions, wheres, and whatnot), it
Hello
I noticed that mysql 6 alpha is no longer available so I want to
remove it from my laptop and install the latest 5.x version. I have
just restored my Linux system image so my database is clean and empty
and is a good moment to do it.
My question is, how can I remove it completely from my
Yes, you only have to delete the directories.
Carlos
On 11/12/2009 8:16 AM, Miguel Cardenas wrote:
Hello
I noticed that mysql 6 alpha is no longer available so I want to
remove it from my laptop and install the latest 5.x version. I have
just restored my Linux system image so my database is
Hello,
I want to log all sql queries made against a mysql db.
Googled and found I should add a line to my.cnf.
However I cannot find a my.cnf file
[r...@radium init.d]# ps -ef | grep mysql
root 13614 1 0 Sep24 ?00:00:00 /bin/sh /usr/bin/mysqld_safe
--datadir=/var/lib/mysql
should be in
/etc/my.cnf
or try the following at the command line
locate my.cnf
That should give you the location
On Thu, 2009-11-12 at 18:10 +, Sydney Puente wrote:
Hello,
I want to log all sql queries made against a mysql db.
Googled and found I should add a line to my.cnf.
Also note that mysql doesn't need a my.cnf file and will happily run with
default values. It's possible that there is none and you'll have to create it.
To see where your mysqld is configured to check for the config file do:
mysql --verbose --help | grep -C3 my.cnf
This will give you a list of
You must copy /usr/share/doc/MySQL-server-community-5.1.39/my-somefile.cnf
file into /etc/my.cnf
If no .cnf file in /etc
MySQL use default config.
if server has 2G RAM
then use my-huge.cnf
Good luck.
- Original Message -
From: Sydney Puente sydneypue...@yahoo.com
To: