Hi folks --
New to MySQL. I'm developing C-language connector software and, while
debugging, I often get the error message "MySQL server has gone away" if, say,
I've stopped at a breakpoint and then issued a call that resembles:
mysql_query(pmysql,
"insert into usrs(usr,email) values(\"pete
On Wednesday 15 April 2009 17:24:21 Baron Schwartz wrote:
> Hi!
>
> I just blogged about this:
> http://www.mysqlperformanceblog.com/2009/04/15/how-to-decrease-inno
>db-shutdown-times/
>
> Short version:
>
> mysql> set global innodb_max_dirty_pages_pct = 0;
>
> and wait until Innodb_buffer_pool_pag
Hi!
I just blogged about this:
http://www.mysqlperformanceblog.com/2009/04/15/how-to-decrease-innodb-shutdown-times/
Short version:
mysql> set global innodb_max_dirty_pages_pct = 0;
and wait until Innodb_buffer_pool_pages_dirty is smaller. Then shut down.
On Wed, Apr 15, 2009 at 9:10 AM, Nico
What kind of query do you use?
I think that MySQL is scalable in using best query on the multi-core ( or
SMP ) server.
It is same on InnoDB and MyISAM on over 4-cores.
Regards,
Genie Japo
-Original Message-
From: Moon's Father [mailto:yueliangdao0...@gmail.com]
Sent: Friday, April 10,
Hi,
after many years that I've been using mysql (with almost all Innodb
tables) I still can't make myself a reason of the unbearably long
shutdown times: almost everytime it takes at least 4 minutes to stop
completely and to kill the process; sometimes I even had to kill -9
mysqld.
Currently
rd Edition
- MySQL Edition
More info and a 30-day trial version on www.upscene.com
Pricing information available on:
http://www.upscene.com/purchase.php#adg
More information available here:
http://www.upscene.com/displaynews.php?item=20090415
With regards,
Martijn Tonies
Upscene Productions - Data
I would not compare binlog positions. I would use mk-heartbeat from
Maatkit. It tells the truth in a much simpler and more direct way.
Instead of checking things that indicate your data is being
replicated, just replicate some data and check the data itself.
--
MySQL General Mailing List
For li
I'd just write a perl script to do it and return the appropriate status
code/message to nagios. Shouldn't be hard at all. PhP or any language that
can talk to mysql would work, too. You just mentioned the position, you'll
have to compare the names of the binlog files as well: position 100 in fil
You could try this:
http://www.consol.de/opensource/nagios/check-mysql-health
(in German but should be self-explanatory).
Cheers,
Andrew
-Original Message-
From: Gabriel - IP Guys [mailto:gabr...@impactteachers.com]
Sent: 15 April 2009 10:12
To: replicat...@lists.mysql.com
Cc: mysql@l
Good morning guys, (and girls), I hope all is well. I've been given the
task to, and I quote - "Write a Nagios plugin to test the replication
status of two servers by
comparing the position on the master to that on the slave"
To save myself a lot of work, I'd like to know if anything has been
Hi guys,
I am using stored procedures and stored functions for the first time.
And currently stuck at a this point where. I am unable to retrieve
results returned by stored function using MySql C API.
Kindly let me know how to do so. In case you need details I'll share
the source code.
Cheers,
Ve
11 matches
Mail list logo
