MySQL Host Template -- Updated on 2006-08-10

[utdrmac]

Hi all. I installed teMySQL successfully. But when I go look at teMySQL - Old Command Stats, I see this:



Changing any of the ones that say 'None' doesn't save.

I've been able to reproduce this on two different machines that have the latest cacti installed.

Any ideas on why these aren't being saved?

[jbsegal]

Can anyone make any educated guesses about whether I'm just begging for pain if I start trying to get this to work?

[jbsegal]

Can anyone make any educated guesses about whether I'm just begging for pain if I start trying to get this to work?

And the answer is "pain" - in the form of rrdtool processes that run a long time - perhaps forever and eat all the system memory, given half a chance.

It's interesting to note that I DID get some data back from the time it was running, in the windows between machine reboots.

Philo: Is there any chance you'll ever come back to this package?

[krpaum]

how to set all of template for this graph or provide me a document for set template in cacti please

[xaprb]

I've created some improved MySQL templates.

Overview:
http://www.xaprb.com/blog/2008/04/27/im ... for-mysql/

Permanent homepage, where everyone can contribute and maintain:
http://code.google.com/p/mysql-cacti-templates/

Hopefully someone will post screenshots. I don't have any.

[karias]

I've created some improved MySQL templates.

Overview:
http://www.xaprb.com/blog/2008/04/27/im ... for-mysql/

Permanent homepage, where everyone can contribute and maintain:
http://code.google.com/p/mysql-cacti-templates/

Hopefully someone will post screenshots. I don't have any.

in the readme you mention perl scripts to make customized templates if we wanted to, that wasn't part of the tar.gz. Where can I get that?

[fletch]

I get this error in the cacti.log and no RRD's (cacti v0.8.6k):
06/10/2008 03:51:04 PM - CACTID: Poller[0] ERROR: A database insert failed! Error:'1064', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (1748,'','2008-06-10 15:51:04','Key_read_requests:15022982 Key_reads:49509 Key_write_requests:4338830 Key_writes:48441 history_list:26 innodb_transactions:4090 read_views:1 current_transactions:1 locked_transactions:0 active_transactions:0 pool_size:512 free_pages:0 database_pages:511 modified_pages:0 pages_read:30550 pages_created:12383 pages_written:13918 file_fsyncs:1396 file_reads:15782 file_writes:2889 log_writes:1298 pending_aio_log_ios:0 pending_aio_sync_ios:0 pending_buf_pool_flushes:0 pending_chkp_writes:0 pending_ibuf_aio_reads:0 pending_log_flushes:0 pending_log_writes:0 pending_normal_aio_reads:0 pending_normal_aio_writes:0 ibuf_inserts:0 ibuf_merged:0 ibuf_merges:0 spin_waits:4077 spin_rounds:12207 os_waits:2055 rows_inserted:147208 rows_updated:44 rows_deleted:3 rows_read:324156 Table_locks_waited:1 Table_locks_immediate:73701 Slow_queries:2 Open_files:108 Open_tables:64 Opened_tables:14237 innodb_open_files:300 open_files'

thanks

[fletch]

Ah, I see there are patches for this error:
http://forums.cacti.net/about27152.html

I might try those

thanks

[fletch]

Since my cmd.php only takes 7 seconds to complete - I can handle using cmd.php instead of cactid to work around this per:
http://code.google.com/p/mysql-cacti-te ... etail?id=2

Happily mysql cactified,

thanks

[nightwisher]

Script tamplete is excelent i have some problems with mem cache with graph i read manual and all set it ok bu in some reason its not visible graph !
Also i use Gentoo Linux 2008.0 and Cacti Version 0.8.7b !

Thanks for this its usefull and recomanded

[gninja]

What, exactly is not valid about:

Code: Select all

root@cacti-poller1 /data/cacti $ /usr/local/bin/php -q scripts/mysql_stats.php innodb test-db3.xxxx XXXX xxxx
file_reads:27072419 file_writes:151234300 file_fsyncs:7064781 insert_buffer_inserts:86686369 insert_buffer_merged:86686369 insert_buffer_merges:16414341 log_writes:6920051 buffer_pool_size:1024000 buffer_free_pages:0 buffer_database_pages:1022366 buffer_modified_pages:0 buffer_hit_rate:916 queries_inside:0 queries_queue:0 rows_inserted:2392202428 rows_updated:31494345 rows_deleted:118675207 rows_read:2746593512 spin_waits:11012648 spin_rounds:856321883 os_waits:9016175

Confused, frustrated, argh. It's all variable:####...

[gninja]

Is it that some of my counters have passed the 32bit integer point?

[gninja]

Ok, I think it's this line in poller.c:

Code: Select all

snprintf(poller_items[i].result, 254, strip_alpha(trim(poll_result)));

I've updated the code, bumped that 254 to a 500, recompiled, and am no longer seeing that error.. I'll go file a bug tomorrow if it's actually working correctly.

[portos67]

hello
I have installed mysql-cacti-templates-1.1.1 in my cacti server.

But my graph have no data and when i enter this command for all hosts i have a result.

#php -q ss_get_mysql_stats.php --host 172.159.264.215 --items bd,be,bn,bf,bi,bn --user cactiuser --pass lkdfqmke

I result :
bd:9 be:3092 bf:14 bi:1 bn:33965

Why i have no graph it is all NAN???


help me it is very urgent


thanks for all!!!!!

[shgoyal]

http://www.faemalia.net/mysqlUtils/
The link doe not work for me. Please help.