Am 02.05.2012 12:52, schrieb vishesh kumar:
Hi Members,
I am using MySQL 5.0.67 . I am facing the problem of MySQL crashing
problem . MySQL Crash after every a few minutes . On investigation i
noticed that when the Open_files status variable reach 128 MySQL Crash and
i get following
Thanks for response .
I didn't set any open_files limit in my.cnf .
For testing i set open_files_limit to 300 but still MySQL crashing after
128.
~Vishesh
On Wed, May 2, 2012 at 4:28 PM, Reindl Harald h.rei...@thelounge.netwrote:
Am 02.05.2012 12:52, schrieb vishesh kumar:
Hi Members,
I am getting following in error log
120502 07:52:05 mysqld started
120502 7:52:05 [Warning] Asked for 196608 thread stack, but got
Hello,
what is the Server OS? I know on my Ubuntu Server i have config the
/etc/limits.conf and the my.cnf
After the modification you have to restart the Server.
Am 02.05.2012 um 13:58 schrieb vishesh kumar linuxtovish...@gmail.com:
I am getting following in error log
Hi,
I am pleased to announce the release of ODB 2.0.0.
ODB is an open source object-relational mapping (ORM) system for C++. It
allows you to persist C++ objects to a relational database without having
to deal with tables, columns, or SQL and without manually writing any of
the mapping code.
Sever OS is CentOS 5 and limits.conf settings is unlimited for open files .
Thanks
~Vishesh
On Wed, May 2, 2012 at 5:37 PM, LinuxInfo linuxinf...@gmx.de wrote:
Hello,
what is the Server OS? I know on my Ubuntu Server i have config the
/etc/limits.conf and the my.cnf
After the modification
On 04/27/2012 03:26 PM, Shawn Green wrote:
I frequently need to have multiple versions ready to operate on my
machine at any time. I solved the configuration file problems by only
setting them up in the basedir of the installed version.
For those special occasions when I need to configure
- Original Message -
From: Reindl Harald h.rei...@thelounge.net
why does this idiotic list-server not add
Precedence-Headers to supress autoreplies?
How many autoreplies did you get to that? :-D
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't
Thread_stack_size should be at least 256K (maybe more?)
Other memory issues to check on:
http://mysql.rjweb.org/doc.php/memory
-Original Message-
From: vishesh kumar [mailto:linuxtovish...@gmail.com]
Sent: Wednesday, May 02, 2012 4:58 AM
To: Reindl Harald
Cc:
I think you need deal with only these:
* Diff my.cnf (set as a parameter to mysqld)
* Diff tree for all the data (and reflect this in my.cnf)
* Diff port (3306 can't be shared between the instances)
-Original Message-
From: Andrés Tello [mailto:mr.crip...@gmail.com]
Sent:
Quoting Brown, Charles cbr...@bmi.com:
Can the mysql replication limited to selected schema or database?
Hi, yes it can. On the master side you control what is written to the
binlog with my.cnf entries for each DB like:
binlog-do-db=DB1
binlog-do-db=DB2
And on the slave side you use
On Wed, May 2, 2012 at 4:58 AM, vishesh kumar linuxtovish...@gmail.com wrote:
I am getting following in error log
120502 07:52:05
Yes, doable. In my.cnf on master:
Binlog-do-database = dbname1
Binlog-do-database = dbname2
Would replicate those two dbs only.
There are many other combinations using
binlog/replicate-do/ignore-db/table/wild. See the manual on replication, and
especially the flowchart on how those
I recommend to use the 'wild' modifier, if you have a default db and you
specify the schema in the query like update
schemanotreplicated.mytable. you will miss that.
Claudio
2012/5/2 Rick James rja...@yahoo-inc.com
Yes, doable. In my.cnf on master:
Binlog-do-database = dbname1
RBR solves the default db case..
S
On Wed, May 2, 2012 at 1:25 PM, Claudio Nanni claudio.na...@gmail.comwrote:
I recommend to use the 'wild' modifier, if you have a default db and you
specify the schema in the query like update
schemanotreplicated.mytable. you will miss that.
Hello Rick,
What goes into your my.cnf slave ?
Given dbname1 and dbname2
-Original Message-
From: Rick James [mailto:rja...@yahoo-inc.com]
Sent: Wednesday, May 02, 2012 12:05 PM
To: Brown, Charles
Cc: mysql@lists.mysql.com
Subject: RE: Can the mysql replication limited to one
Some mixture. Perhaps 35% of RAM for buffer_pool and 10% for key_buffer. It
depends on which needs more caching.
Note: The key_buffer does not need to be bigger than the total of all MyISAM
indexes (Index_length in SHOW TABLE STATUS, or size of .MYI files). The
buffer_pool does not need to
Nothing in the slave's my.cnf.
On the Master, binlog-do/ignore-* filters before leaving the Master.
On the Slave, replicate-do/ignore-* (if used) would filter after getting to the
Slave.
That is, you _could_ do the replicate-* instead of the binlog-*, but that would
be inefficient. Doing both
Doing both is redundant. Doing binlog (on the Master) is more efficient
because it eliminates sending the other dbs.
-Original Message-
From: a.sm...@ukgrid.net [mailto:a.sm...@ukgrid.net]
Sent: Wednesday, May 02, 2012 8:50 AM
To: mysql@lists.mysql.com
Subject: Re: Can the mysql
Here's the use case that screws up a lot of people:
USE db_that_is_not_replicated;
INSERT INTO db_that_IS_replicate.tbl ...;
Surprise! That INSERT is not replicated. Workaround: *wild will notice it.
The other way around, the INSERT will be replicated, then hang replication
because the
Hello Rick,
I think I'll go with your recommendations - but help me here a little bit.
Because all look fuzzy like a brain surgery. So make it simple and clean for me.
For the sake of simplicity, here is what my master has:
Database: db1
Tables: db1tb1, db1tb2, db1tb3
Database: db2
I guess, it only makes things even more simple.
You should use replicate-do-table=db1.tb1 and so one in slave's cnf to ensure
that only this particular table gets replicated. However, all the databases on
master will get bin-logged and you may or may not want to do that.
So making it even
Hi Charles,
I believe you would already have bin-log configured, is that right? If not, you
need to.
Secondly, If you think the bin-log generated for the entire stack of
databases/schemas is too big, you may want to restrict it using binlog-do-db
BUT that may create problem if you have any
23 matches
Mail list logo
