i am getting this wierd error in the mysql log:
120604 8:31:32 [Warning] option 'table_cache': unsigned value
536870912 adjusted to 524288
I have 28G of ram in my server, can anyone tell me what this value
should be set to ?
what is the syntax - i have tried different syntax -- get the same
Am 04.06.2012 14:39, schrieb Joey L:
i am getting this wierd error in the mysql log:
120604 8:31:32 [Warning] option 'table_cache': unsigned value
536870912 adjusted to 524288
I have 28G of ram in my server, can anyone tell me what this value
should be set to ?
what is the syntax - i
Can you explain this further ?
Sorry a little slow ?
table count * expected connections
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Am 04.06.2012 14:45, schrieb Joey L:
Can you explain this further ?
Sorry a little slow ?
table count * expected connections
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_table_cache
signature.asc
Description: OpenPGP digital signature
Joey, you've over allocated the cache. MySQL is telling you that it has
corrected the allocation.
Check out the docs for the meaning behind the numbers.
On Mon, Jun 4, 2012 at 2:01 PM, Reindl Harald h.rei...@thelounge.netwrote:
Am 04.06.2012 14:45, schrieb Joey L:
Can you explain this
Dear all,
I install mysql in CentOS -5.4 through 2 commands :
yum install mysql-server
yum install mysql-client
And I can see directories created in /var/lib/mysql directory.
But now i want to change it to my /hdd1-1 diretcory and alse set logging
directories.
So , I search my.cnf file
created in /var/lib/mysql directory.
But now i want to change it to my /hdd1-1 diretcory and alse set logging
directories.
So , I search my.cnf file as:
[root@ws-test ~]# find / -name my.cnf
[root@ws-test ~]#
Now how could I solve this issue from where mysql picks its configuration
or it go
in /var/lib/mysql directory.
But now i want to change it to my /hdd1-1 diretcory and alse set logging
directories.
So , I search my.cnf file as:
[root@ws-test ~]# find / -name my.cnf
[root@ws-test ~]#
Now how could I solve this issue from where mysql picks its configuration
or it go for its
I got the error after setting my.cnf file in /etc directory.
110601 15:23:02 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
After some research i found the cause of this error : the new my.cnf is
very old and mysql_upgrade is needed
So , Can
Hi,
You probably didn't run mysql_install_db.
Peter Boros
On Wed, 2011-06-01 at 15:52 +0530, Adarsh Sharma wrote:
I got the error after setting my.cnf file in /etc directory.
110601 15:23:02 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
: Shutdown complete
I checked /hdd2-1/myisam_data/mysql-bin.index file is there , how to comes
Thanks
Peter Boros wrote:
Hi,
You probably didn't run mysql_install_db.
Peter Boros
On Wed, 2011-06-01 at 15:52 +0530, Adarsh Sharma wrote:
I got the error after setting my.cnf file in /etc
.
Peter Boros
On Wed, 2011-06-01 at 15:52 +0530, Adarsh Sharma wrote:
I got the error after setting my.cnf file in /etc directory.
110601 15:23:02 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
After some research i found the cause of this error
December 2010 06:37
To: mysql@lists.mysql.com
Subject: my.cnf file
Dear all,
I am able to install Mysql-5.1.4 o a Linux Machine without any error.
All is working fine.
But I am searching a file my.cnf which is most important and is used
in
mysql but cannot able
://ronaldbradford.com/blog/tag/my-cnf/
Andy
From: ext Adarsh Sharma [adarsh.sha...@orkash.com]
Sent: 30 December 2010 06:37
To: mysql@lists.mysql.com
Subject: my.cnf file
Dear all,
I am able to install Mysql-5.1.4 o a Linux
: my.cnf file
Dear all,
I am able to install Mysql-5.1.4 o a Linux Machine without any error.
All is working fine.
But I am searching a file my.cnf which is most important and is used in
mysql but cannot able to find it.
I install mysql by yum install mysql-server and yum install mysql-client
commands
://ronaldbradford.com/blog/tag/my-cnf/
Andy
From: ext Adarsh Sharma [adarsh.sha...@orkash.com]
Sent: 30 December 2010 06:37
To: mysql@lists.mysql.com
Subject: my.cnf file
Dear all,
I am able to install Mysql-5.1.4 o a Linux Machine without any error.
All is working
Subject: my.cnf file
Dear all,
I am able to install Mysql-5.1.4 o a Linux Machine without any error.
All is working fine.
But I am searching a file my.cnf which is most important and is used in
mysql but cannot able to find it.
I install mysql by yum install mysql-server
From: ext Adarsh Sharma [adarsh.sha...@orkash.com]
Sent: 30 December 2010 06:37
To: mysql@lists.mysql.com
Subject: my.cnf file
Dear all,
I am able to install Mysql-5.1.4 o a Linux Machine without any error.
All is working fine.
But I am
Dear all,
I am able to install Mysql-5.1.4 o a Linux Machine without any error.
All is working fine.
But I am searching a file my.cnf which is most important and is used in
mysql but cannot able to find it.
I install mysql by yum install mysql-server and yum install mysql-client
commands.
Sydney Puente schrieb:
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
Please look in /etc/my.cnf
If not found create one. Of cause, MySQL can start and run without a 'my.cnf'
file that’s why you couldn't find one. In the absence of the my.cnf file,
MySQL will use default for every parameter .
Charles,
-Original Message-
From: walter harms
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 --pid-file=/var/lib/mysql/object01.pid
mysql13669 13614 0 Sep24 ?00:21:40 /usr/sbin/mysqld --basedir=/
--datadir=/var/lib
= 'root';
+---+
| host |
+---+
| % |
| 127.0.0.1 |
| localhost |
| object01 |
+---+
Sydney Puente schrieb:
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
Yes I enter the password manually into the remote mysql client (actually
Oracle's SQL developer) when I login.
I thought I would restart mysql with the /etc/init.d/mysql script and go back
to the original default settings without any my.cnf present. Just to check it
was some setting in my.cnf
Did you remove the my.cnf file and then run /etc/init.d/mysql stop? The my.cnf
probably had non-default paths for the pid file, so if you remove the config
file, now the startup script is looking in the wrong location.
Also for your password issue, please show use the exact command you're
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 --pid
.
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 --pid-file=/var/lib/mysql/object01.pid
mysql13669 13614 0 Sep24 ?00:21:40 /usr/sbin/mysqld --basedir
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
@lists.mysql.com
Sent: Friday, November 13, 2009 3:10 AM
Subject: cannot find my.cnf file
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
michel wrote:
I set up mysql and can't start it because I need to hard code the IP address parameter (bind-address) into my.cnf ... but I have three of them in different sub directories of /mysql/mysql-test/suite
Should there not be one basic one?
I set up mysql and can't start it because I need to hard code the IP address
parameter (bind-address) into my.cnf ... but I have three of them in different
sub directories of /mysql/mysql-test/suite
Should there not be one basic one?
Hello.
The MySQL server can be started without a configuration file, only
with command line options. You can manually specify the location
of my.cnf file with --defaults-file=path command line option. See:
http://dev.mysql.com/doc/mysql/en/program-options.html
sol beach [EMAIL
to be smacking into the limit of 100 concurrent
connections.
AFAIK, no /etc/my.cnf file no $HOME/.my.cnf file exist.
I've looked looked at the startup scripts do not see any
--config-file qualifier be specified.
datadir=/a/mysqldata/ and there is no *cnf file in this folder either
# find / -name \*cnf
Sql, query,
Hi, all,
I found on our clients mysql database machines, there is no my.cnf file by
doing a global search, but when I did the following command, it seems that
mysql process is referring to this file
(--default-extra-file=/export/mysql/data/my.cnf ).
Do you think it's normal
Unidux,
Tuesday, November 05, 2002, 9:38:59 AM, you wrote:
USHL Where can I find the complete sample configuration include the explanation
USHL of my.cnf file? I tried mysql.com documentation, but only a bit there.
Some info you can find in the manual:
http://www.mysql.com/doc/en
Having some other folks helping me out here with this
MySQL problems that I am having.
I have found out that I am missing the my.cnf from the
/etc directory and I am trying to create the file from
scratch, this is what I have so far and also MySQL is
installed from .tgz in this directory.
Hi,
Where can I find the complete sample configuration include the explanation
of my.cnf file? I tried mysql.com documentation, but only a bit there.
Please Advise.
Thanks,
Han Lin
-
Before posting, please check:
http
. In
my.cnf file you can set up options for InnoDB or BDB.
LP Trouble is there is no my.cnf file on my computer.
LP Do I have to create the file myself ?
Yup.
LP or is the InnoDB settings configured right by default?
If you use 3.23. you must specify at least innodb_data_file_path in
my.cnf
I use mysql 3.23.4 max on linux and it have worked just fine.
Now I want to use Transactions so I thougt that I should use the my.cnf to configure
for that.
Trouble is there is no my.cnf file on my computer.
Do I have to create the file myself ?
or is the InnoDB settings configured right
I use mysql 3.23.4 max on linux and it have worked just fine.
Now I want to use Transactions so I thougt that I should use the my.cnf
to configure for that.
Trouble is there is no my.cnf file on my computer.
Do I have to create the file myself ?
or is the InnoDB settings configured
At 16:17 +0200 9/25/02, Lindberg, Petrus wrote:
I use mysql 3.23.4 max on linux and it have worked just fine.
Now I want to use Transactions so I thougt that I should use the
my.cnf to configure for that.
Trouble is there is no my.cnf file on my computer.
Do I have to create the file myself
Hi,
I use mysql 3.23.4 max on linux and it have worked just fine.
Now I want to use Transactions so I thougt that I should use the my.cnf to
configure for that.
Trouble is there is no my.cnf file on my computer.
Do I have to create the file myself ?
or is the InnoDB settings configured right
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 25 September 2002 15:18
To: [EMAIL PROTECTED]
Subject: No my.cnf file on Linux?
I use mysql 3.23.4 max on linux and it have worked just fine.
Now I want to use Transactions so I thougt that I should use the my.cnf to
configure for that.
Trouble
of the documentation and from what I can tell it is being started
via the /etc/init.d/mysql script (which looks exactly the same as the
mysql.server script) but I cannot locate the my.cnf file that the docs
talk about. Can I just create this file from scratch to start MySQL as a
different user, or do I have
that it is not running as 'root' though on startup. I've read a
lot of the documentation and from what I can tell it is being started
via the /etc/init.d/mysql script (which looks exactly the same as the
mysql.server script) but I cannot locate the my.cnf file that the docs
talk about. Can I just create
Also note that a search for 'my.cnf' in the online documentation section of
mysql.com returns exactly zero (0) results. Hint, hint ...
Les Neste 678-778-0382 http://www.lesneste.com
I've done that, too... but that's because MySQL's doc search engine is
interpreting the . as something special. If you search for other things
relating to that, you'll actually find an index saying my.cnf
configuration options or syntax.. something along those lines.
Weird stuff.
Mike
Les
Hi all
Is there a document available somewhere outlining
some guidelines regarding what parameters should be
set in the my.cnf files for the MySQL database and to
what values?
thanks
=
__
Do You Yahoo!?
Get email alerts NEW webcam
: Wednesday, September 05, 2001 2:45 PM
Subject: Re: my.cnf file
Hi all
Is there a document available somewhere outlining
some guidelines regarding what parameters should be
set in the my.cnf files for the MySQL database and to
what values?
thanks
I'm still testing out MySQL and I'm trying to find the my.cnf file referred
to at
http://www.mysql.com/doc/O/p/Option_files.html
The page says to look in:
/etc/my.cnf
DATADIR/my.cnf
defaults-extra-file (The file specified with --defaults-extra-file=# )
~/.my.cnf
but none of these files
I'm still testing out MySQL and I'm trying to find the my.cnf
file referred to at
http://www.mysql.com/doc/O/p/Option_files.html
...
but none of these files seem to exist on my machine.
...
MySQL came pre-installed on that machine. Is it possible (or, indeed,
normal) that the MySQL
Hi,
I have several problems to do with tuning mysql to run on a Sun E450.
Firstly, I cannot get the mysql to read the my.cnf file. If it is
installed in the data directory, mysql boots OK but ignores it, while if
I copy it into the /etc directory I get the following error
Starting mysqld daemon
Make sure my.cnf is mode 744.
David Allen wrote:
Hi,
I have several problems to do with tuning mysql to run on a Sun E450.
Firstly, I cannot get the mysql to read the my.cnf file. If it is
installed in the data directory, mysql boots OK but ignores it, while if
I copy it into the /etc
53 matches
Mail list logo
