At first, after I loaded MySQL template, the graphy is not updated by poller. It turns out MySQL template require spine poller than regular CMD poller. The spine poller has a bug , you will likely to get following error:
08/06/2008 12:20:02 PM - SPINE: Poller[0] ERROR: A database insert failed! Error:'1064', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (3,'mem_buffers','2008-08-06 12:20:01','70456'),(4,'mem_swap','2008-08-06 12:20:01','8388376'),(5,'','2008-08-06 12:20:01','1min:0.27 5min:0.29 10min:0.23'),(6,'users','2008-08-06 12:20:01','3'),(7,'proc','2008-08-06 12:20:01','140'),(8,'','2008-08-06 12:20:01','Key_read_requests:190457 Key_reads:148 Key_write_requests:79884 Key_writes:27194 history_list:3 innodb_transactions:479840 read_views:1 current_transactions:1 locked_transactions:0 active_transactions:0 pool_size:32000 free_pages:0 database_pages:31999 modified_pages:0 pages_read:5187008 pages_created:1153894 pages_written:6257069 file_fsyncs:185447 file_reads:4606447 file_writes:3070647 log_writes:90720 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:277316 ibuf_merged:277316 ibuf_merges:7235 spin_w'
the problem is default query statement buffer for insert is set to small, I manually changes buffer size in spine.h and recompiled spine.
/* #define BUFSIZE 1024 */
#define BUFSIZE 65535
Everything seems to be working after this last twick.
Here's some screen shots,
