nvidhive / mycheckpoint Goto Github PK
View Code? Open in Web Editor NEWAutomatically exported from code.google.com/p/mycheckpoint
Automatically exported from code.google.com/p/mycheckpoint
Hi,
I can't find a mailing list so I thought I'd file a bug! :)
I'm trying to configure MyCheckpoint to talk to a master MySQL server from
about 100 nodes across various datacentres.
The links are already in place (we're using them for replication) however I
can't get MyCheckpoint to use a "read_only" user to connect to the clients and
send the reports using a different user to the master.
Is this possible?
I'm hoping that there might be a way of adding something such as the following
to the config file:
[server]
host=<master_host_name>
port=<master_host_port>
database=<master_host_database>
user=<user_with_write_privs_on_master>
pass=<password_for_above_user>
I'm also interested in knowing if I can have all clients write to the same
database on the master (I'm not keen on the idea of having to maintain 100
databases and then writing the reports for each server!)
Thanks in advance,
Matt
Original issue reported on code.google.com by [email protected]
on 19 Aug 2010 at 9:13
What steps will reproduce the problem?
1.install and run on a server with existing data
2.i have ran this on two servers same results
3.percona 5.5.29
What is the expected output? What do you see instead?
What is the output when running with the "--verbose --debug" options?
[root@vagrant-ci]:~$ mycheckpoint --defaults-file=/z/dbscripts/vagrant-ci.cnf
--verbose
-- Using /z/dbscripts/vagrant-ci.cnf as defaults file
-- mycheckpoint rev 208, build 201011041330. Copyright (c) 2009-2010 by Shlomi
Noach
-- database is rladmin
-- Non matching deployed revision. Will auto-deploy
-- metadata table created
-- numbers table created
-- charts_api table created
-- html_components table created
-- custom_query table created
-- custom_query_view created
-- Global status & variables recorded
-- Master and slave status recorded
-- OS CPU info recorded
-- OS load average info recorded
-- OS mem info recorded
-- OS mountpoints info recorded
-- OS page io activity recorded
-- status_variables table exists
-- alert_condition table created
-- alert table created
-- alert_pending table created
-- sv_latest view created
-- sv_diff view created
-- sv_sample view created
-- status_variables_aggregated_hour table exists
-- status_variables_aggregated_day table exists
-- sv_hour view created
-- sv_day view created
-- sv_param_change view created
-- report views created
-- 24/7 report view created
-- recent reports views created
-- sv_report_sample_recent_aggregated view created
-- reports minmax views created
-- report human views created
-- sv_report_chart_sample_timeseries view created
-- sv_report_chart_hour_timeseries view created
-- sv_report_chart_day_timeseries view created
-- report charts labels views created
-- report charts views created
-- report 24/7 chart view created
-- custom chart views created
(1267, "Illegal mix of collations (utf8_bin,NONE) and (binary,IGNORABLE) for
operation 'case'")
--
-- Re-execute with --verbose --debug for detailed message and strack trace.
What version of the mycheckpoint are you using? 208
What version of the MySQL are you using? (SELECT VERSION())5.5.29-29.4-log
What version of Python are you using? (python --version)Python 2.6.6
On what operating system? centos 6.3
What is your sql_mode? (SELECT @@global.sql_mode)
mysql> SELECT @@global.sql_mode;
+-------------------+
| @@global.sql_mode |
+-------------------+
| |
+-------------------+
1 row in set (0.00 sec)
mysql>
Please provide any additional information below.
Original issue reported on code.google.com by [email protected]
on 30 Jan 2013 at 7:41
From our email thread, this is a tracking ticket for creating custom charts of
multiple metrics.
Some thoughts:
If code is the easiest way, perhaps supporting 'plugins' that define the
charts? Place a .py file with a chart define in /etc/mycheckpoint/charts and
have it load them and create the chart that is defined in the .py file?
Looking at the code, it seems pretty simple to define graphs, so perhaps they
don't even need to be .py files.
Thoughts?
Original issue reported on code.google.com by [email protected]
on 20 Mar 2012 at 4:50
What steps will reproduce the problem?
1. FreeBSD 8.0
2. MySQL 5.3.2
3. mycheckpoint rev 132, build 201006041210
What is the output when running with the "--verbose --debug" options?
from sets import ImmutableSet
-- mycheckpoint rev 132, build 201006041210. Copyright (c) 2009-2010 by Shlomi
Noach
-- database is mycheckpoint
-- Non matching deployed revision. Will auto-deploy
-- metadata table created
-- numbers table created
-- charts_api table created
-- Global status & variables recorded
-- Cannot read /proc/stat. Skipping
-- Cannot read /proc/loadavg. Skipping
-- Cannot read /proc/meminfo. Skipping
-- OS mountpoints info recorded
-- status_variables table created
-- custom_query table created
-- alert_condition table created
-- alert table created
-- alert_pending table created
-- sv_latest view created
-- sv_diff view created
-- sv_sample view created
-- sv_hour view created
-- sv_day view created
-- sv_param_change view created
-- report views created
-- 24/7 report view created
-- recent reports views created
-- sv_report_sample_recent_aggregated view created
-- reports minmax views created
-- report human views created
-- sv_report_chart_sample_timeseries view created
-- sv_report_chart_hour_timeseries view created
-- sv_report_chart_day_timeseries view created
-- report charts labels views created
-- dycharts views created
(1271, "Illegal mix of collations for operation 'concat'")
Traceback (most recent call last):
File "/usr/local/bin/mycheckpoint", line 3670, in <module>
deploy_schema()
File "/usr/local/bin/mycheckpoint", line 3584, in deploy_schema
create_status_variables_views()
File "/usr/local/bin/mycheckpoint", line 3327, in create_status_variables_views
create_report_google_chart_views(report_chart_views)
File "/usr/local/bin/mycheckpoint", line 2332, in
create_report_google_chart_views
act_query(query)
File "/usr/local/bin/mycheckpoint", line 147, in act_query
num_affected_rows = cursor.execute(query)
File "/usr/local/lib/python2.6/site-packages/MySQLdb/cursors.py", line 166, in
execute
self.errorhandler(self, exc, value)
File "/usr/local/lib/python2.6/site-packages/MySQLdb/connections.py", line 35,
in defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (1271, "Illegal mix of collations for operation 'concat'")
--
-- Make sure you have executed mycheckpoint with 'deploy' after last
install/update.upgrade
-- If not, run again with same configuration, and add 'deploy'. e.g.:
-- mycheckpoint --host=my_host deploy
--
Original issue reported on code.google.com by tomaz.muraus
on 6 Jun 2010 at 9:18
What steps will reproduce the problem?
1. Install on a system where InnoDB Storage engine is not installed/running
What is the expected output? What do you see instead?
Unable to install, "deploy" throws error
What is the output when running with the "--verbose --debug" options?
[root@m-sysmon2 bin]# mycheckpoint-119
--monitored-host=sbk-sysmon1.production.bigcharts.com
--defaults-file=/usr/share/mycheckpoint/.my-checkpoint.cnf
--database=mycheckpoint_sbk deploy -v --debug
-- mycheckpoint rev 119, build 201003300820. Copyright (c) 2009-2010 by
Shlomi Noach
-- database is mycheckpoint_sbk
-- Deploy requested. Will deploy
-- metadata table created
-- numbers table created
-- charts_api table created
-- Global status & variables recorded
-- Master and slave status recorded
-- Non-local monitoring; will not read OS data
-- status_variables table exists
-- alert_condition table created
-- alert table created
-- alert_pending table created
-- sv_latest view created
-- sv_diff view created
-- sv_sample view created
-- sv_hour view created
-- sv_day view created
-- sv_param_change view created
(1054, "Unknown column 'innodb_buffer_pool_pages_free' in 'field list'")
Traceback (most recent call last):
File "/usr/bin/mycheckpoint-119", line 3235, in <module>
deploy_schema()
File "/usr/bin/mycheckpoint-119", line 3149, in deploy_schema
create_status_variables_views()
File "/usr/bin/mycheckpoint-119", line 2843, in create_status_variables_views
""")
File "/usr/bin/mycheckpoint-119", line 2711, in create_custom_views
act_query(custom_query)
File "/usr/bin/mycheckpoint-119", line 143, in act_query
num_affected_rows = cursor.execute(query)
File "/usr/lib/python2.6/site-packages/MySQLdb/cursors.py", line 173, in
execute
self.errorhandler(self, exc, value)
File "/usr/lib/python2.6/site-packages/MySQLdb/connections.py", line 36,
in defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (1054, "Unknown column 'innodb_buffer_pool_pages_free' in
'field list'")
--
-- Make sure `mycheckpoint_sbk` schema exists, e.g.
-- CREATE DATABASE `mycheckpoint_sbk`
-- Make sure the user has ALL PRIVILEGES on the `mycheckpoint_sbk` schema. e.g.
-- GRANT ALL ON `mycheckpoint_sbk`.* TO 'my_user'@'my_host' IDENTIFIED BY
'my_password'
-- The user will have to have the SUPER privilege in order to disable
binary logging
-- - Otherwise, use --skip-disable-bin-log (but then be aware that slaves
replicate this server's status)
-- In order to read master and slave status, the user must also be granted
with REPLICATION CLIENT or SUPER privileges
-- - Otherwise, use --skip-check-replication
--
[root@m-sysmon2 bin]#
What version of the mycheckpoint are you using? 88,118,119
What version of the MySQL are you using? 5.1.37-community-log
On what operating system? Script running on 2.6.30.9-96.fc11.i686.PAE
Remote hosts are Win2003 R2 x86 w/ SP2
Please provide any additional information below.
If I comment out all the INnoDB references i can install, but using new
versions it's a pain :|
Original issue reported on code.google.com by [email protected]
on 6 Apr 2010 at 7:57
As stated in the release notes:
"
mycheckpoint now has a version recognition mechanism. There is no need to call
mycheckpoint
with the “deploy” argument on first install or after upgrade. mycheckpoint
will recognize a
change of version and will auto-deploy before moving on to monitoring your
system."
This is great, although I don't quite like how it is so verbose.
Perhaps avoid printing out that the table doesn't exist (i.e.:
/usr/bin/mycheckpoint:109: Warning: Unknown table 'metadata'
num_affected_rows = cursor.execute(query)
)
This is of course from the DROP TABLE IF EXISTS.. Perhaps a create table if
not exists instead?
Or do I have the wrong idea and you prefer having verbose output as default?
Original issue reported on code.google.com by [email protected]
on 7 Jan 2010 at 2:48
To complete the remote monitoring scheme, add to the existing --monitored-host,
--monitored-port and --monitored-socket the user & password details.
Original issue reported on code.google.com by [email protected]
on 22 Aug 2010 at 6:09
What steps will reproduce the problem?
1. Just launch mycheckpoint
What is the expected output? What do you see instead?
Expected : "New entry added"
See instead : (1054, "Unknown column 'mysql' in 'field list'")
What is the output when running with the "--verbose --debug" options?
-- Using /etc/mycheckpoint.conf as defaults file
-- mycheckpoint rev 231, build 201305231510. Copyright (c) 2009-2013 by Shlomi
Noach
-- database is mycheckpoint_test_sd_03
-- monitored host is: 127.0.0.1
-- Global status & variables recorded
-- Master and slave status recorded
-- OS CPU info recorded
-- OS load average info recorded
-- OS mem info recorded
-- OS mountpoints info recorded
-- OS page io activity recorded
(1054, "Unknown column 'mysql' in 'field list'")
Traceback (most recent call last):
File "/usr/local/bin/mycheckpoint", line 5055, in <module>
collect_status_variables()
File "/usr/local/bin/mycheckpoint", line 4446, in collect_status_variables
num_affected_rows = act_query(query)
File "/usr/local/bin/mycheckpoint", line 254, in act_query
num_affected_rows = cursor.execute(query)
File "/usr/lib/pymodules/python2.6/MySQLdb/cursors.py", line 166, in execute
self.errorhandler(self, exc, value)
File "/usr/lib/pymodules/python2.6/MySQLdb/connections.py", line 35, in defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (1054, "Unknown column 'mysql' in 'field list'")
--
-- Re-execute with --verbose --debug for detailed message and stack trace.
--
What version of the mycheckpoint are you using?
mycheckpoint rev 231, build 201305231510
What version of the MySQL are you using? (SELECT VERSION())
5.5.31-MariaDB-log
What version of Python are you using? (python --version)
Python 2.6.6
On what operating system?
DEBIAN 6.0.7
What is your sql_mode? (SELECT @@global.sql_mode)
Empty
Original issue reported on code.google.com by [email protected]
on 11 Sep 2013 at 12:21
What steps will reproduce the problem?
1.I get errors with mycheckpoint crash tables
2.
3.
What is the expected output? What do you see instead?
110816 21:00:02 [ERROR] /usr/libexec/mysqld: Table
'./mycheckpoint/status_variables' is marked as crashed and should be repaired
110816 21:00:02 [ERROR] /usr/libexec/mysqld: Table
'./mycheckpoint/status_variables' is marked as crashed and should be repaired
110816 21:00:05 [ERROR] /usr/libexec/mysqld: Table
'./mycheckpoint/status_variables_aggregated_hour' is marked as crashed and
should be repaired
110816 21:00:07 [ERROR] /usr/libexec/mysqld: Table
'./mycheckpoint/status_variables_aggregated_day' is marked as crashed and
should be repaired
110816 21:05:01 [ERROR] /usr/libexec/mysqld: Table './mycheckpoint/alert' is
marked as crashed and should be repaired
110816 21:05:02 [ERROR] /usr/libexec/mysqld: Table
'./mycheckpoint/alert_pending' is marked as crashed and should be repaired
110819 12:40:02 [ERROR] /usr/libexec/mysqld: Table
'./mycheckpoint/status_variables' is marked as crashed and should be repaired
110819 12:40:03 [ERROR] /usr/libexec/mysqld: Table
'./mycheckpoint/status_variables' is marked as crashed and should be repaired
110819 12:40:13 [ERROR] /usr/libexec/mysqld: Table
'./mycheckpoint/status_variables_aggregated_hour' is marked as crashed and
should be repaired
110819 12:40:19 [ERROR] /usr/libexec/mysqld: Table
'./mycheckpoint/status_variables_aggregated_day' is marked as crashed and
should be repaired
110819 12:45:02 [ERROR] /usr/libexec/mysqld: Table './mycheckpoint/alert' is
marked as crashed and should be repaired
110819 12:45:03 [ERROR] /usr/libexec/mysqld: Table
'./mycheckpoint/alert_pending' is marked as crashed and should be repaired
110820 10:05:03 [ERROR] /usr/libexec/mysqld: Table
'./mycheckpoint/status_variables' is marked as crashed and should be repaired
110820 10:05:03 [ERROR] /usr/libexec/mysqld: Table
'./mycheckpoint/status_variables' is marked as crashed and should be repaired
110820 10:15:02 [ERROR] /usr/libexec/mysqld: Table './mycheckpoint/alert' is
marked as crashed and should be repaired
110825 14:20:02 [ERROR] /usr/libexec/mysqld: Table
'./mycheckpoint/status_variables' is marked as crashed and should be repaired
110825 14:20:02 [ERROR] /usr/libexec/mysqld: Table
'./mycheckpoint/status_variables' is marked as crashed and should be repaired
110825 14:20:05 [ERROR] /usr/libexec/mysqld: Table
'./mycheckpoint/status_variables_aggregated_hour' is marked as crashed and
should be repaired
110825 14:20:13 [ERROR] /usr/libexec/mysqld: Table
'./mycheckpoint/status_variables_aggregated_day' is marked as crashed and
should be repaired
110825 14:21:07 [ERROR] /usr/libexec/mysqld: Table './mycheckpoint/alert' is
marked as crashed and should be repaired
110825 14:21:07 [ERROR] /usr/libexec/mysqld: Table
'./mycheckpoint/alert_pending' is marked as crashed and should be repaired
110826 12:50:02 [ERROR] /usr/libexec/mysqld: Table
'./mycheckpoint/status_variables' is marked as crashed and should be repaired
110826 12:50:03 [ERROR] /usr/libexec/mysqld: Table
'./mycheckpoint/status_variables' is marked as crashed and should be repaired
110826 12:50:10 [ERROR] /usr/libexec/mysqld: Table
'./mycheckpoint/status_variables_aggregated_hour' is marked as crashed and
should be repaired
110826 12:50:15 [ERROR] /usr/libexec/mysqld: Table
'./mycheckpoint/status_variables_aggregated_day' is marked as crashed and
should be repaired
110826 12:55:01 [ERROR] /usr/libexec/mysqld: Table './mycheckpoint/alert' is
marked as crashed and should be repaired
110826 12:55:02 [ERROR] /usr/libexec/mysqld: Table
'./mycheckpoint/alert_pending' is marked as crashed and should be repaired
What is the output when running with the "--verbose --debug" options?
N/A
What version of the mycheckpoint are you using?
208
What version of the MySQL are you using? (SELECT VERSION())
5.5.13
On what operating system?
Linux
Please provide any additional information below.
Original issue reported on code.google.com by [email protected]
on 26 Aug 2011 at 5:06
What steps will reproduce the problem?
1. install mycheckpoint debian package
2. create the following /etc/mycheckpoint.cnf file
[mycheckpoint]
smtp_host = localhost
smtp_from = [email protected]
smtp_to = [email protected]
[client]
host=localhost
socket=/var/run/mysqld/mysqld.sock
user=root
password=
port=3306
3. try to run mycheckpoint
What is the expected output? What do you see instead?
# mycheckpoint
-- ERROR: Cannot connect to database
-- ERROR: Failed sending email
(2002, "Can't connect to local MySQL server through socket
'/var/run/mysqld/mysql.sock' (2)")
If I run "mycheckpoint --defaults-file=/etc/mycheckpoint.cnf" then it will run
correctly.
What is the output when running with the "--verbose --debug" options?
# mycheckpoint --verbose --debug
-- Will assume /etc/mycheckpoint.cnf as defaults file
-- mycheckpoint rev 132, build 201006041210. Copyright (c) 2009-2010 by Shlomi
Noach
-- database is mycheckpoint
-- ERROR: Cannot connect to database
-- Sending cannot access message from [email protected] to:
[email protected] via: localhost
-- ERROR: Failed sending email
Traceback (most recent call last):
File "/usr/bin/mycheckpoint", line 3454, in send_email_message
s = smtplib.SMTP(smtp_host)
File "smtplib.py", line 244, in __init__
(code, msg) = self.connect(host, port)
File "smtplib.py", line 310, in connect
raise socket.error, msg
error: (111, 'Connection refused')
(2002, "Can't connect to local MySQL server through socket
'/var/run/mysqld/mysql.sock' (2)")
Traceback (most recent call last):
File "/usr/bin/mycheckpoint", line 3661, in ?
monitored_conn, write_conn = open_connections()
File "/usr/bin/mycheckpoint", line 109, in open_connections
db = database_name)
File "/usr/lib/python2.4/site-packages/MySQLdb/__init__.py", line 75, in Connect
return Connection(*args, **kwargs)
File "/usr/lib/python2.4/site-packages/MySQLdb/connections.py", line 164, in __init__
super(Connection, self).__init__(*args, **kwargs2)
OperationalError: (2002, "Can't connect to local MySQL server through socket
'/var/run/mysqld/mysql.sock' (2)")
--
-- Make sure you have executed mycheckpoint with 'deploy' after last
install/update.upgrade
-- If not, run again with same configuration, and add 'deploy'. e.g.:
-- mycheckpoint --host=my_host deploy
--
Looks like the socket option is not parsed correctly... The email stuff looks
to be OK. Besides, it would be cool if the default socket would be equivalent
to what debian uses (mysqld.sock, not mysql.sock)
What version of the mycheckpoint are you using?
mycheckpoint 132-1
What version of the MySQL are you using? (SELECT VERSION())
5.0.51a
On what operating system?
Debian Etch and Lenny
Thanks in advance
Original issue reported on code.google.com by [email protected]
on 28 Jun 2010 at 3:36
What is the feature request?
MyCheckpoint should produce aggregate charts summarising certain metrics from
multiple servers.
How will this change current behavior?
The system currently only produces charts on a per-server basis.
What parameters/options will be required?
Unknown
What version of the mycheckpoint are you using?
170
What version of the MySQL are you using?
5
On what operating system?
Centos
Original issue reported on code.google.com by [email protected]
on 19 Jul 2010 at 1:06
What steps will reproduce the problem?
1. Use a different monitoring host then write host
2. Run mycheckpoint <parameters> -v
3. Mysql-problem: (1146, "Table 'mycheckpoint.custom_query_view' doesn't exist")
What is the expected output? Full creation of 58 tables in database
mycheckpoint_HOST
What do you see instead? Only 5 tables are created, python script stops after
that one.
What version of the mycheckpoint are you using? revision 174
What version of the MySQL are you using? 5.1.37
On what operating system? SLES 11
I think the problem is the use of the wrong connection-parameter in the
get_rows call (no connection is defined so it uses the monitor-connection. For
this query, it should use the write_conn instead). Problem was fixed when
replacing:
query = """SELECT custom_query_id, chart_name FROM %s.custom_query_view""" %
database_name
rows = get_rows(query)
with:
query = """SELECT custom_query_id, chart_name FROM %s.custom_query_view""" %
database_name
rows = get_rows(query,write_conn)
Also, I think it is strange that no parameters can be defined for the user and
password on the monitored mysql database. Now it needs to be the same one of
both servers...
Original issue reported on code.google.com by [email protected]
on 13 Aug 2010 at 9:53
What steps will reproduce the problem?
1. take a sample every 2 minutes
2. the chart can not display
3. The google chart return the error "The requested URL /chart... is too
large to process."
What version of the mycheckpoint are you using?
revision 76
What version of the MySQL are you using?
MySQL-5.1.41
On what operating system?
CentOS 5.3
Please provide any additional information below.
the chart URL:
http://chart.apis.google.com/chart?
cht=lc&chs=400x200&chts=303030,12&chtt=Latest+13+hours:+Jan+11,+00:19++-
++Jan+11,+13:08&chdl=com_select_psec|com_insert_psec|com_delete_psec|com_up
date_psec|com_replace_psec&chdlp=b&chco=ff8c00,4682b4,9acd32,dc143c,9932cc&
chd=s:NMMLLLLKJJIHHHHGGGGGGGFFFFFFFFFEFFFFFEEEEEEEEFEEDDDEDDDDDDEDDDDDDDDDD
DDDDDDCDCDDDDCCDDCCDCCCCCCCCDCCCCDCCCCCCCCCCCCCCCCCDCCCCCDCCCCCCDCCDCDDDDDD
DDDDDDDDDEEEEEEEFFFFFFGGFFGGGGGHHHHHHHHIIHIIJJJJJKJKKKKKKLJLMLMMMNNONOOPQRR
SSSSUUUUVVVVWWWYYXYYYZYYZdihhhheeedcccbcbZZZadbbZYYZbaaZZZaZYZZYZZZYZZZZYYY
ZZYYYYYXZaYZYYXXXYYYYZYXXYYYZXXXXXYYYYXZZYYZYZZXYaZYZYZZaZYYaaaaaaZZaZZZZZ,
DDDCCCCCCCCBCBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBABBBBABA
ABBBBBBABBBAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABAAAAAAAAAABBAAAAAAAAAB
BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBCCCCCCCCCCCCCCCCCCCCCCCCDCDDDDDDDDDDDEEEEEEEE
FEFFFFFFFFFFGFGFFFGIJIIIIHHHHHHHGHGGGGGHGGGGFGGGGGFGGFFFGFFFFFFFFGFFFFFFFFF
FFFFFFFFFFFFFFFFFFFFFFFFFEFEFFFFFFFFFFFFFFFFFFFFFFFFFFGFFFFFFFFFFFFF,AAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA,aaZWVWVUSRQO
PNONNMMMMNMLLKKLLMKJKJJJJIJIJIIJJLJIHHHHHGGHHHIHHGHHGHHHGGGHGGGFGFGHHGGGGFF
FFEDEFFFEFFFEFFFFEFEEEEEEEEEEEEFFFEEEFFGFFFFFFFFFFFFFGFFFGGGFFGFGHHHIIJJKKK
KKKKMMLLLLMNNONNOOPPPQQQPRSTSSSTSSUUTUVUSXWVYYYZYaZabccghhiiiklkkklnnoopssq
srssrruz97787310zyyzxxwutsuyvusrrsutututsssttstusqtrtrprtssqqrrqqtursrrpqpq
ssqtrqprrrsppopqrrrqpturqsrtsqpvtqsrsswssswuvwvxtuvtsttt,AAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA&chxt=x,y&chxr=1,0,3740.1
7&chxl=0:||||04:00||||08:00||||12:00||&chxs=0,505050,10&chg=7.81,25,1,2,5.3
4,0&chxp=0,5.34,13.15,20.96,28.77,36.58,44.39,52.20,60.01,67.82,75.63,83.44
,91.25,99.06
Original issue reported on code.google.com by [email protected]
on 11 Jan 2010 at 7:12
mycheckpoint mails appear in one's client as having been sent the moment they
are fetched from server, as opposed to presenting the actual time at which they
have been sent.
So a mail client waking up after a couple days may present a dozen alert mails
as though all have been sent just now.
Original issue reported on code.google.com by [email protected]
on 16 Nov 2011 at 6:05
What steps will reproduce the problem?
1. Install MySQL 5.5. Install mycheckpoint.
2. Install MariaDB 10.0 over MySQL
3. run mycheckpoint
What is the expected output? What do you see instead?
Getting this error:
(1064, "You have an error in your SQL syntax; check the manual that corresponds
to your MariaDB server version for the right syntax to use near 'pool(s) load
completed at 150403 3:44:20, 2002160, 4393, 187680, 8026, 0, 13412' at line 3")
What is the output when running with the "--verbose --debug" options?
-- mycheckpoint rev 231, build 201305231510. Copyright (c) 2009-2013 by Shlomi
Noach
-- database is mycheckpoint
-- Global status & variables recorded
-- OS CPU info recorded
-- OS load average info recorded
-- OS mem info recorded
-- OS mountpoints info recorded
-- OS page io activity recorded
(1064, "You have an error in your SQL syntax; check the manual that corresponds
to your MariaDB server version for the right syntax to use near 'pool(s) load
completed at 150403 3:44:20, 2001855, 76, 192454, 8192, 0, 1342107' at line 3")
Traceback (most recent call last):
File "/usr/local/bin/mycheckpoint", line 5055, in <module>
collect_status_variables()
File "/usr/local/bin/mycheckpoint", line 4446, in collect_status_variables
num_affected_rows = act_query(query)
File "/usr/local/bin/mycheckpoint", line 254, in act_query
num_affected_rows = cursor.execute(query)
File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 173, in execute
self.errorhandler(self, exc, value)
File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
ProgrammingError: (1064, "You have an error in your SQL syntax; check the
manual that corresponds to your MariaDB server version for the right syntax to
use near 'pool(s) load completed at 150403 3:44:20, 2001855, 76, 192454, 8192,
0, 1342107' at line 3")
What version of the mycheckpoint are you using?
231 from RPM
What version of the MySQL are you using? (SELECT VERSION())
10.0.17-MariaDB-log
What version of Python are you using? (python --version)
Python 2.6.6
On what operating system?
CentOS 6
What is your sql_mode? (SELECT @@global.sql_mode)
Got empty value from that query
Please provide any additional information below.
Apparently MariaDB 10 has a few string values in the SHOW STATUS output which
confuse mycheckpoint. Namely, Innodb_buffer_pool_load_status has this value:
Buffer pool(s) load completed at 150403 3:44:20
mycheckpoint bails out at the processing of this value.
Original issue reported on code.google.com by [email protected]
on 3 Apr 2015 at 10:48
mycheckpoint --verbose --debug deploy
-- mycheckpoint rev 208, build 201011041330. Copyright (c) 2009-2010 by Shlomi
Noach
-- database is mycheckpoint
-- Deploy requested. Will deploy
-- metadata table created
-- numbers table created
-- charts_api table created
-- html_components table created
-- custom_query table created
(1064, "You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near 'OR REPLACE\n
ALGORITHM = TEMPTABLE\n DEFINER = CURRENT_USER\n ' at line 2")
What version of the mycheckpoint are you using?
208
What version of the MySQL are you using? (SELECT VERSION())
4.1.22
On what operating system?
Red Hat Enterprise Linux Server release 5.3 (Tikanga)
Please provide any additional information below.
Can improve this tool to support mysql 4.X ?
Original issue reported on code.google.com by [email protected]
on 15 Dec 2010 at 3:18
What steps will reproduce the problem?
1. When running "select * from db\G" you will notice on a default installation
there are two blank user entries:
*************************** 1. row ***************************
Host: %
Db: test
User:
*************************** 2. row ***************************
Host: %
Db: test\_%
User:
2. lets say I have two users with two different databases that start with
"test_". Both users will be able to see the others database with these
defaults in place.
3. Here is the test:
-- as root
create database test_user1;
create database test_user2;
grant select on `test_user1`.* to 'user1'@'localhost';
grant select on `test_user2`.* to 'user2'@'localhost';
-- as user1
mysql -uuser1
[Wed Apr 13 14:33:35 2011] (user1@localhost) [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| test |
| test_user1 |
| test_user2 | <-- user1 should NOT be able to see this database
+--------------------+
4 rows in set (0.00 sec)
[Wed Apr 13 14:33:40 2011] (user1@localhost) [(none)]> show grants;
+-------------------------------------------------------+
| Grants for user1@localhost |
+-------------------------------------------------------+
| GRANT USAGE ON *.* TO 'user1'@'localhost' |
| GRANT SELECT ON `test_user1`.* TO 'user1'@'localhost' |
+-------------------------------------------------------+
What version of the secure are you using?
This was from the MySQL Conference
On what operating system?
Any OS, any version of MySQL.
Please provide any additional information below.
Please let me know if you need anything else.
best,
Chris Schneider
Original issue reported on code.google.com by [email protected]
on 13 Apr 2011 at 9:39
What steps will reproduce the problem?
1. Set up mycheckpoint to monitor a live server remotely, as follows:
/etc/mycheckpoint.cnf:
[mycheckpoint]
#smtp_host = mail.my-server-company.com
#smtp_from = [email protected]
#smtp_to = [email protected]
monitored_port=3306
monitored_host=livedbserver.com
monitored_user=monitoring_user
monitored_password=[*****]
purge_days = 60
[client]
user=monitoring_user
password=[*****]
socket=/var/run/mysqld/mysqld.sock
port=3306
host=localhost
database=mycheckpoint
skip_check_replication=True
2. Deploy and run:
user@monitoringhost$ mycheckpoint deploy
Add the following row to crontab:
*/5 * * * * mycheckpoint
What is the expected output? What do you see instead?
While mycheckpoint is logging rows into the status_variables table, I'm not
getting any rows from the sv_diff view:
mysql> SELECT questions, uptime, warning_count, ts FROM status_variables;
+-----------+---------+---------------+---------------------+
| questions | uptime | warning_count | ts |
+-----------+---------+---------------+---------------------+
| 241039414 | 1281504 | 0 | 2012-11-02 16:20:01 |
| 241101176 | 1281804 | 0 | 2012-11-02 16:25:01 |
| 241152461 | 1282105 | 0 | 2012-11-02 16:30:01 |
| 241205392 | 1282405 | 0 | 2012-11-02 16:35:01 |
| 241258591 | 1282705 | 0 | 2012-11-02 16:40:01 |
| 241307251 | 1283005 | 0 | 2012-11-02 16:45:02 |
| 241354124 | 1283305 | 0 | 2012-11-02 16:50:01 |
| 241409544 | 1283605 | 0 | 2012-11-02 16:55:01 |
| 241459330 | 1283905 | 0 | 2012-11-02 17:00:01 |
| 241501222 | 1284205 | 0 | 2012-11-02 17:05:01 |
+-----------+---------+---------------+---------------------+
10 rows in set (0.00 sec)
mysql> SELECT * FROM sv_diff;
Empty set (0.00 sec)
mysql>
What is the output when running with the "--verbose --debug" options?
user@monitoringhost$ mycheckpoint --verbose --debug
-- Using /etc/mycheckpoint.cnf as defaults file
-- mycheckpoint rev 208, build 201011041330. Copyright (c) 2009-2010 by Shlomi
Noach
-- database is mycheckpoint
-- monitored host is: livedbserver.com
-- Global status & variables recorded
-- Non-local monitoring; will not read OS data
-- New entry added: id=22; ts=2012-11-02 17:08:32
-- Collecting custom data
-- No alert conditions defined
-- Status variables checkpoint complete
What version of the mycheckpoint are you using?
Revision 208
What version of the MySQL are you using? (SELECT VERSION())
livedbserver.com:
mysql> SELECT VERSION();
+----------------+
| VERSION() |
+----------------+
| 5.1.65-ius-log |
+----------------+
1 row in set (0.00 sec)
Monitoring host:
mysql> SELECT VERSION();
+-----------------------------+
| VERSION() |
+-----------------------------+
| 5.1.61-0ubuntu0.10.10.1-log |
+-----------------------------+
1 row in set (0.00 sec)
What version of Python are you using? (python --version)
user@monitoringhost$ python --version
Python 2.6.6
On what operating system?
livedbserver.com:
CentOS
Monitoring host:
Ubuntu
What is your sql_mode? (SELECT @@global.sql_mode)
livedbserver.com:
mysql> SELECT @@global.sql_mode;
+-------------------+
| @@global.sql_mode |
+-------------------+
| |
+-------------------+
1 row in set (0.00 sec)
Monitoring host:
mysql> SELECT @@global.sql_mode;
+-------------------+
| @@global.sql_mode |
+-------------------+
| |
+-------------------+
1 row in set (0.00 sec)
Original issue reported on code.google.com by [email protected]
on 2 Nov 2012 at 5:16
I'm having issues trying remote monitoring to work either in r174 or r190.
I'm trying a basic setup, 2 production databases and one monitoring database
which would store the various monitorings.
Either cases 1 or 2 of the manual didn't work for me (from monitored to
monitoring, or from monitoring to monitored).
use case 1. from the production database (sql1) to the monitoring database
(sql-monitor).
[root@sql1 mycheckpoint-190]# mycheckpoint --host=sql-monitor --user=dbmonitor
--password=mypassword --port=3306 --monitored-host=localhost
--monitored-socket=/var/lib/mysql/mysql.sock --database=mycheckpoint_sql1
--skip-defaults -v --debug
-- mycheckpoint rev 190, build 201009020925. Copyright (c) 2009-2010 by Shlomi
Noach
-- database is mycheckpoint_sql1
-- monitored host is: localhost
-- monitored host credentials undefined; using write host credentials
-- Global status & variables recorded
-- Master and slave status recorded
-- OS CPU info recorded
-- OS load average info recorded
-- OS mem info recorded
-- OS mountpoints info recorded
-- OS page io activity recorded
-- New entry added
-- Collecting custom data
(1146, "Table 'mycheckpoint_sql1.custom_query' doesn't exist")
Traceback (most recent call last):
File "/usr/bin/mycheckpoint", line 4407, in ?
collect_custom_data()
File "/usr/bin/mycheckpoint", line 1291, in collect_custom_data
for custom_query in get_rows(query):
File "/usr/bin/mycheckpoint", line 306, in get_rows
cursor.execute(query)
File "/usr/lib64/python2.4/site-packages/MySQLdb/cursors.py", line 163, in execute
self.errorhandler(self, exc, value)
File "/usr/lib64/python2.4/site-packages/MySQLdb/connections.py", line 35, in defaulterrorhandler
raise errorclass, errorvalue
ProgrammingError: (1146, "Table 'mycheckpoint_sql1.custom_query' doesn't exist")
--
-- Make sure you have executed mycheckpoint with 'deploy' after last
install/update.upgrade
-- If not, run again with same configuration, and add 'deploy'. e.g.:
-- mycheckpoint --host=my_host deploy
If I check, the given table is existing on sql-monitor, though empty:
mysql> select * from mycheckpoint_sql1.custom_query;
Empty set (0.00 sec)
If I skip-custom, I get same error but on different table:
ProgrammingError: (1146, "Table 'mycheckpoint_sql1.alert_condition' doesn't
exist")
From my point of view, looks like mycheckpoint is trying to do
custom_collect_data() on localhost, hence the table not existing.
Eventually, it worked with both --skip-custom and --skip-alerts parameters.
Also I had some issues while the prod used r174 and the schema was r190. Maybe
a warning could be in order like something saying that the client version is
inferior to the server (I don't know if you store the version number somewhere
in the database, but it could definitely be a plus!)
Thanks in advance, cause I'd really like to have the alert feature back up!
G.
Original issue reported on code.google.com by [email protected]
on 8 Sep 2010 at 3:33
What steps will reproduce the problem?
1. With crontab each 5 minutes, generate mycheckpoint records from localmachine
stored to remote database
mycheckpoint_r223.py --host=xxx.xxx.xxx.xxx --port=3306 --user=mycheckpoint
--password=mycheckpoint --database=mcp_webprod --monitored-host=localhost
--monitored-socket=/tmp/mysql.sock --verbose --debug
-- mycheckpoint rev 0, build 0. Copyright (c) 2009-2010 by Shlomi Noach
-- database is mcp_webprod
-- monitored host is: localhost
-- monitored host credentials undefined; using write host credentials
-- Global status & variables recorded
-- Master and slave status recorded
-- OS CPU info recorded
-- OS load average info recorded
-- OS mem info recorded
-- OS mountpoints info recorded
-- OS page io activity recorded
-- New entry added: id=252; ts=2012-06-13 11:05:16
-- Collecting custom data
-- 2012-06-13 11:05:16 Entry aggregated into status_variables_aggregated_hour
-- 2012-06-13 11:05:16 Entry aggregated into status_variables_aggregated_day
-- No alert conditions defined
-- Status variables checkpoint complete
2. Check that some datas are recorded in mcp_webprod database as wanted for
more than 12 hours
3. On remote computer (host of remote database), with crontab each hour
generate mycheckpoint reports in html manner and store it in apache web server
space
mysql -umycheckpoint -pmycheckpoint mcp_webprod --execute="SELECT html FROM
sv_report_html" --silent --raw > /data/www/mycheckpoint/webprod.html
mysql -umycheckpoint -pmycheckpoint mcp_webprod --execute="SELECT html FROM
sv_report_html_brief" --silent --raw > /data/www/mycheckpoint/webprod_brief.html
mysql -umycheckpoint -pmycheckpoint mcp_webprod --execute="SELECT * FROM
sv_param_change" --silent --raw >
/data/www/mycheckpoint/webprod_paramchange.html
4. Check that files are well generated
[dba@frlusv113 mycheckpoint]$ ll
-rwxrwx--- 1 webservd webservd 197682 Jun 13 10:53 webprod.html
-rwxrwx--- 1 webservd webservd 110227 Jun 13 10:53 webprod_brief.html
-rwxrwx--- 1 webservd webservd 0 Jun 13 10:53 webprod_paramchange.html
Note that webprod_paramchange.html file size is zero bytes because no parameter
chage have occur since mycheckpoint is running ;)
5. Watch with your favorite browser (chrome 19.0 or firefox 13.0 for me) these
generate html reports
Note that reports are well formatted but there is no graph in it, only empty
gray boxes - see attached pdfs.
6. Click on [url] link (in my example innodb_buffer_pool_pages graph box)
It open a graph centric web page holding a single graph (from
chart.apis.google.com). And graph is there !!
What is the expected output? What do you see instead?
Generated web page full of graphics
What is the output when running with the "--verbose --debug" options?
What version of the mycheckpoint are you using?
r223
What version of the MySQL are you using? (SELECT VERSION())
Monitored database : mysql> 5.5.16-log
Remote mcp database : mysql> 5.5.16-log
What version of Python are you using? (python --version)
Monitored database : Python 2.4.3
On what operating system?
Both Linux RedHat 5 Enterprise
What is your sql_mode? (SELECT @@global.sql_mode)
Monitored database :
mysql> SELECT @@global.sql_mode;
+-------------------+
| @@global.sql_mode |
+-------------------+
| |
+-------------------+
1 row in set (0.00 sec)
Remote mcp database :
mysql> SELECT @@global.sql_mode;
+-------------------------------------------------------------------------------
-------------------------------------------+
| @@global.sql_mode
|
+-------------------------------------------------------------------------------
-------------------------------------------+
|
NO_AUTO_VALUE_ON_ZERO,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO
_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
+-------------------------------------------------------------------------------
-------------------------------------------+
1 row in set (0.00 sec)
Please provide any additional information below.
Please find attached pdfs:
* mcp_webprod.monitoring_full report.pdf
* mcp_webprod.monitoring_latest 24 hours report.pdf
* mcp_webprod.monitoring_full report - innodb_buffer_pool_pages.pdf
Original issue reported on code.google.com by [email protected]
on 13 Jun 2012 at 9:31
Attachments:
What steps will reproduce the problem?
1. mycheckpoint [...] deploy
What is the expected output? What do you see instead?
-- mycheckpoint. Copyright (c) 2009 by Shlomi Noach
-- numbers table created
-- charts_api table created
-- status_variables table exists
-- sv_latest view created
-- sv_diff view created
-- sv_sample view created
-- sv_hour view created
-- sv_day view created
-- sv_param_change view created
-- report custom views created
-- recent reports views created
-- recent reports minmax views created
-- report_human custom views created
(1140, 'Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP
columns is illegal if there is no GROUP BY clause')
--
-- Make sure `mycheckpoint` schema exists, e.g.
-- CREATE DATABASE `mycheckpoint`
-- Make sure the user has ALL PRIVILEGES on the `mycheckpoint` schema. e.g.
-- GRANT ALL ON `mycheckpoint`.* TO 'my_user'@'my_host' IDENTIFIED BY
'my_password'
-- The user will have to have the SUPER privilege in order to disable
binary logging
-- - Otherwise, use --skip-disable-bin-log (but then be aware that slaves
replicate this server's status)
-- In order to read master and slave status, the user must also be granted
with REPLICATION CLIENT or SUPER privileges
-- - Otherwise, use --skip-check-replication
--
What version of the product are you using? On what operating system?
Latest Debian package and svn's trunk have both the issue. OS: Debian Linux
/ stable
Please provide any additional information below.
Original issue reported on code.google.com by [email protected]
on 21 Dec 2009 at 8:44
What steps will reproduce the problem?
1. Install with maria 5.5.22 Ubuntu 11.04
2.
3.
What is the expected output? What do you see instead?
What is the output when running with the "--verbose --debug" options?
(1060, "Duplicate column name 'handler_icp_attempts'")
--
-- Re-execute with --verbose --debug for detailed message and strack trace.
--
root@aqua:/opt/Suneese/utilities/housekeeping# /usr/local/bin/mycheckpoint
--debug --verbose --defaults-file=/root/.my-checkpoint.cnf
-- Using /root/.my-checkpoint.cnf as defaults file
-- mycheckpoint rev 208, build 201011041330. Copyright (c) 2009-2010 by Shlomi
Noach
-- database is mycheckpoint
-- Non matching deployed revision. Will auto-deploy
-- metadata table created
-- numbers table created
-- charts_api table created
-- html_components table created
-- custom_query table created
-- custom_query_view created
-- Global status & variables recorded
-- Master and slave status recorded
-- Non-local monitoring; will not read OS data
-- status_variables table exists
-- Will add the following columns to status_variables: handler_icp_attempts
(1060, "Duplicate column name 'handler_icp_attempts'")
Traceback (most recent call last):
File "/usr/local/bin/mycheckpoint", line 4854, in <module>
deploy_schema()
File "/usr/local/bin/mycheckpoint", line 4763, in deploy_schema
upgrade_status_variables_table()
File "/usr/local/bin/mycheckpoint", line 1926, in upgrade_status_variables_table
act_query(query)
File "/usr/local/bin/mycheckpoint", line 246, in act_query
num_affected_rows = cursor.execute(query)
File "/usr/lib/pymodules/python2.6/MySQLdb/cursors.py", line 166, in execute
self.errorhandler(self, exc, value)
File "/usr/lib/pymodules/python2.6/MySQLdb/connections.py", line 35, in defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (1060, "Duplicate column name 'handler_icp_attempts'")
--
-- Re-execute with --verbose --debug for detailed message and strack trace.
--
What version of the mycheckpoint are you using? 308
What version of the MySQL are you using? (SELECT VERSION()) maria 5.5.22
On what operating system? Ubuntu 11.04
Please provide any additional information below.
Original issue reported on code.google.com by [email protected]
on 8 Apr 2012 at 9:28
I'm sure I'm not the only one that has a monitoring specific server that
everything funnels down to. This causes the OS graphs to be entirely blank. It
would be handy to be able to disable rendering them entirely from the UI.
Original issue reported on code.google.com by [email protected]
on 20 Mar 2012 at 4:51
What steps will reproduce the problem?
1. Put ONLY_FULL_GROUP_BY in sql_mode variable in my.ini ([mysqld] section)
2. Restart MySQL server
3. Run mycheckpoint
What is the expected output? What do you see instead?
Regular run messages, no error
What is the output when running with the "--verbose --debug" options?
[dba@frlusv112 ~]$ ./mycheckpoint_r223.py --host=xxx.xxx.xxx.xxx --port=3306
--user=mycheckpoint --password=mycheckpoint --database=mcp_webprod
--monitored-host=localhost --monitored-socket=/tmp/mysql.sock --verbose --debug
--rebuild-aggregation
-- mycheckpoint rev 0, build 0. Copyright (c) 2009-2010 by Shlomi Noach
-- database is mcp_webprod
-- monitored host is: localhost
-- monitored host credentials undefined; using write host credentials
-- Global status & variables recorded
-- Master and slave status recorded
-- OS CPU info recorded
-- OS load average info recorded
-- OS mem info recorded
-- OS mountpoints info recorded
-- OS page io activity recorded
-- New entry added: id=7; ts=2012-06-12 15:05:43
-- Collecting custom data
(1055, "'mcp_webprod.status_variables2.ts' isn't in GROUP BY")
Traceback (most recent call last):
File "./mycheckpoint_r223.py", line 4960, in ?
write_status_variables_hour_aggregation(status_variables_insert_timestamp)
File "./mycheckpoint_r223.py", line 4404, in write_status_variables_hour_aggregation
num_affected_rows = act_query(query)
File "./mycheckpoint_r223.py", line 247, in act_query
num_affected_rows = cursor.execute(query)
File "/usr/lib64/python2.4/site-packages/MySQLdb/cursors.py", line 163, in execute
self.errorhandler(self, exc, value)
File "/usr/lib64/python2.4/site-packages/MySQLdb/connections.py", line 35, in defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (1055, "'mcp_webprod.status_variables2.ts' isn't in GROUP BY")
--
-- Re-execute with --verbose --debug for detailed message and stack trace.
--
What version of the mycheckpoint are you using?
r223
What version of the MySQL are you using? (SELECT VERSION())
mysql> SELECT VERSION();
+------------+
| VERSION() |
+------------+
| 5.5.16-log |
+------------+
1 row in set (0.00 sec)
What version of Python are you using? (python --version)
[dba@frlusv112 ~]$ python -V
Python 2.4.3
On what operating system?
Linux RedHat 5 Enterprise
Please provide any additional information below.
Thanks
Original issue reported on code.google.com by [email protected]
on 12 Jun 2012 at 1:12
What steps will reproduce the problem?
1.Rhel5
2.mysql Ver 14.12 Distrib 5.0.22, for redhat-linux-gnu (i686) using
readline 5.0
3.Config file
[client]
host=localhost
socket=/var/lib/mysql/mysql.sock
user=root
password=<>
port=3306
What is the expected output? What do you see instead?
Deploy...
ericfe@[root]~/rds-work>mycheckpoint --defaults=./mycheckpoint.defaults -v
deploy
-- mycheckpoint rev 119, build 201003300820. Copyright (c) 2009-2010 by
Shlomi Noach
-- database is mycheckpoint
-- Deploy requested. Will deploy
-- metadata table created
-- numbers table created
-- charts_api table created
-- Global status & variables recorded
-- Master and slave status recorded
-- OS CPU info recorded
-- OS load average info recorded
-- OS mem info recorded
-- OS mountpoints info recorded
-- status_variables table exists
-- Will add the following columns to status_variables: custom_16, custom_17
-- status_variables table upgraded
-- alert_condition table created
-- alert table created
-- alert_pending table created
-- sv_latest view created
-- sv_diff view created
-- sv_sample view created
-- sv_hour view created
-- sv_day view created
-- sv_param_change view created
-- report custom views created
-- 24/7 report view created
-- recent reports views created
(2013, 'Lost connection to MySQL server during query')
--
-- Make sure `mycheckpoint` schema exists, e.g.
-- CREATE DATABASE `mycheckpoint`
-- Make sure the user has ALL PRIVILEGES on the `mycheckpoint` schema. e.g.
-- GRANT ALL ON `mycheckpoint`.* TO 'my_user'@'my_host' IDENTIFIED BY
'my_password'
-- The user will have to have the SUPER privilege in order to disable
binary logging
-- - Otherwise, use --skip-disable-bin-log (but then be aware that slaves
replicate this server's status)
-- In order to read master and slave status, the user must also be granted
with REPLICATION CLIENT or SUPER privileges
-- - Otherwise, use --skip-check-replication
What is the output when running with the "--verbose --debug" options?
Above
What version of the mycheckpoint are you using? 119
What version of the MySQL are you using? (SELECT VERSION())
mysql Ver 14.12 Distrib 5.0.22, for redhat-linux-gnu (i686) using readline 5.0
On what operating system?
rhel 5
Original issue reported on code.google.com by [email protected]
on 31 Mar 2010 at 5:29
What steps will reproduce the problem?
1.running mycheckpoint http
2.when open url in browser ,report error:
Exception happened during processing of request from ('172.16.153.1', 52752)
Traceback (most recent call last):
File "/usr/lib64/python2.4/SocketServer.py", line 222, in handle_request
self.process_request(request, client_address)
File "/usr/lib64/python2.4/SocketServer.py", line 241, in process_request
self.finish_request(request, client_address)
File "/usr/lib64/python2.4/SocketServer.py", line 254, in finish_request
self.RequestHandlerClass(request, client_address, self)
File "/usr/lib64/python2.4/SocketServer.py", line 521, in __init__
self.handle()
File "/usr/lib64/python2.4/BaseHTTPServer.py", line 316, in handle
self.handle_one_request()
File "/usr/lib64/python2.4/BaseHTTPServer.py", line 310, in handle_one_request
method()
File "/usr/bin/mycheckpoint", line 4238, in do_GET
html = http_embed_code(html, '<div class="header">', html_embed)
File "/usr/bin/mycheckpoint", line 4186, in http_embed_code
html = html.replace(anchor, "%s%s" % (anchor, code))
AttributeError: 'array.array' object has no attribute 'replace'
mycheckpoint revsion 192
rhel 5.4
mysql-pyhon 1.2.1-1
python2.4
mysql 5.1.48
Original issue reported on code.google.com by [email protected]
on 5 Oct 2010 at 2:29
While generating a human report, I get to see values such as:
DML:
SELECT: 0.01/sec 4.4%
INSERT: 3.59/sec 2873.3%
UPDATE: 0.00/sec 0.0%
DELETE: 0.01/sec 6.7%
REPLACE: 0.00/sec 0.0%
SET: 0.03/sec 20.0%
COMMIT: 0.03/sec 26.7%
slow: 0.00/sec 0.0% (slow time: 10sec)
And also:
Selects:
Full scan: 0.06/sec 1100.0%
Full join: 0.00/sec 0.0%
Range: 0.00/sec 0.0%
Sort merge passes: 0.00/sec
It seems to me that doing 1100% full scans or 2873.3% of INSERTs would be
amazing, but not
really possible :)
Original issue reported on code.google.com by [email protected]
on 12 Nov 2009 at 9:22
What is the feature request?
custom_query.custom_query_id should be an auto increment. This would make it
easier to add custom_queries to a set of different hosts.
How will this change current behavior?
Remove the need to calculate the value by hand
What parameters/options will be required?
ALTER TABLE custom_query MODIFY custom_query_id int(10) unsigned NOT NULL
auto_increment;
Original issue reported on code.google.com by [email protected]
on 6 Mar 2012 at 12:12
What is the feature request?
Currently myCheckPoint documentation explain that we can generate parameter
change tracking report as a simple query "SELECT * FROM sv_param_change;" who
generate a one row sql result. Documentation show us a formatted result :
+---------------------+-----------------+-----------+-----------+
| ts | variable_name | old_value | new_value |
+---------------------+-----------------+-----------+-----------+
| 2009-11-04 13:00:01 | max_connections | 500 | 200 |
+---------------------+-----------------+-----------+-----------+
In real case, this query ran from command line given us a flat result like this:
> mysql -umycheckpoint -pmycheckpoint dbname --execute="SELECT * FROM
sv_param_change" --silent > paramchange.html
ts variable_name old_value new_value
2012-06-18 11:35:01 max_connections 200 100
Redirecting this result to a file isn't exploitable as human report easily.
Solution: In documentation, insert following code to explain how to export
directly result to html code:
> mysql -umycheckpoint -pmycheckpoint dbname --execute="SELECT * FROM
sv_param_change" --silent --html > paramchange.html
<TABLE
BORDER=1><TR><TH>ts</TH><TH>variable_name</TH><TH>old_value</TH><TH>new_value</T
H></TR><TR><TD>2012-06-18
11:35:01</TD><TD>max_connections</TD><TD>200</TD><TD>100</TD></TR></TABLE>
How will this change current behavior?
Just export result formated in html code
What parameters/options will be required?
--html in mysql command line
What version of the mycheckpoint are you using?
r223
What version of the MySQL are you using?
5.5.16-log
On what operating system?
Linux RedHat 5 Enterprise
Thanks
Original issue reported on code.google.com by [email protected]
on 18 Jun 2012 at 11:51
What is the feature request?
Run once, to prevent from running more than once from crond.
How will this change current behavior?
Not much, see included patch.
What parameters/options will be required?
None, but one could prefer a "force_run" parameter to bypass run_once
What version of the mycheckpoint are you using?
208
What version of the MySQL are you using?
5.x
On what operating system?
Linux (Gentoo, RH, SuSE)
Original issue reported on code.google.com by [email protected]
on 31 Aug 2011 at 1:06
Attachments:
As discussed:
I'd like to be able to pull data from one source and insert/log to another, in
order to facilitate
centralized storage for the historical data.
Using different schemas would work great, as long as there's something like
--source-host and --
target-host (same for credentials etc as well of course)
This is a feature request.
Original issue reported on code.google.com by [email protected]
on 10 Nov 2009 at 5:53
What steps will reproduce the problem?
1.
/usr/local/skysql/mycheckpoint/bin/mycheckpoint -o --database=mon_node10
--monitored-user=root --monitored-password=skyvodka
--monitored-socket=/tmp/mysql_sandbox5010.sock --user=skysql
--password=skyvodka --host="10.0.0.102" --port=5010 --disable-bin-log
--purge-days=1
2.
3.
What is the expected output? What do you see instead?
SQL Error
What is the output when running with the "--verbose --debug" options?
What version of the mycheckpoint are you using?
8.4
What version of the MySQL are you using? (SELECT VERSION())
What version of Python are you using? (python --version)
On what operating system?
What is your sql_mode? (SELECT @@global.sql_mode)
Please provide any additional information below.
It is required that the connection is free of transaction.
commit the connection fixe the issue or just move disable bin log before the
first query
SELECT COUNT(*) AS same_deploy
FROM mon_node10.metadata
WHERE
revision = 208
AND build = 201011041330
AND mysql_version = '5.5.28a-MariaDB-log'
AND database_name = 'mon_node10'
AND custom_queries = (SELECT IFNULL(GROUP_CONCAT(custom_query_id ORDER BY chart_order, custom_query_id SEPARATOR ','), '') FROM mon_node10.custom_query)
AND last_deploy_successful = 1
Good work
Original issue reported on code.google.com by [email protected]
on 8 Jan 2013 at 9:33
What steps will reproduce the problem?
1. Install 208-1 on Ubuntu
2. /usr/bin/mycheckpoint --defaults-file=/etc/mycheckpoint.cnf
--skip-check-replication
What is the expected output? What do you see instead?
I get an error:
expected a character buffer object
--
-- Re-execute with --verbose --debug for detailed message and strack trace.
--
What is the output when running with the "--verbose --debug" options?
root@mysql:~# /usr/bin/mycheckpoint --defaults-file=/etc/mycheckpoint.cnf
--skip-check-replication --debug
expected a character buffer object
Traceback (most recent call last):
File "/usr/bin/mycheckpoint", line 4864, in <module>
write_status_variables_hour_aggregation(status_variables_insert_timestamp)
File "/usr/bin/mycheckpoint", line 4322, in write_status_variables_hour_aggregation
query = query.replace("${aggregation_timestamp}", aggregation_timestamp)
TypeError: expected a character buffer object
--
-- Re-execute with --verbose --debug for detailed message and strack trace.
What version of the mycheckpoint are you using?
208-1 (deb - form Ubuntu)
What version of the MySQL are you using? (SELECT VERSION())
5.1.57-rel12.8-log
On what operating system?
Please provide any additional information below.
Ubuntu Linux
Linux mysql 2.6.32-30-server #59-Ubuntu SMP Tue Mar 1 22:46:09 UTC 2011 x86_64
GNU/Linux
many thanks for any help here in advance,
Niels.
Syndicat IT & Internet
http://www.syndicat.com
Original issue reported on code.google.com by [email protected]
on 31 Mar 2012 at 10:39
What steps will reproduce the problem?
1. Startup http mode
2. browse to page
3. crash
What is the expected output? What do you see instead?
Exception happened during processing of request from ('10.11.1.1', 59995)
Traceback (most recent call last):
File "/usr/lib64/python2.4/SocketServer.py", line 222, in handle_request
self.process_request(request, client_address)
File "/usr/lib64/python2.4/SocketServer.py", line 241, in process_request
self.finish_request(request, client_address)
File "/usr/lib64/python2.4/SocketServer.py", line 254, in finish_request
self.RequestHandlerClass(request, client_address, self)
File "/usr/lib64/python2.4/SocketServer.py", line 521, in __init__
self.handle()
File "/usr/lib64/python2.4/BaseHTTPServer.py", line 316, in handle
self.handle_one_request()
File "/usr/lib64/python2.4/BaseHTTPServer.py", line 310, in handle_one_request
method()
File "/usr/local/bin/mycheckpoint", line 4730, in do_GET
html = http_embed_code(html, '<div class="header">', html_embed)
File "/usr/local/bin/mycheckpoint", line 4535, in http_embed_code
html = html.replace(anchor, "%s%s" % (anchor, code))
AttributeError: 'array.array' object has no attribute 'replace'
What is the output when running with the "--verbose --debug" options?
[root@mon001 ~]# /usr/local/bin/mycheckpoint http --verbose --debug
-- mycheckpoint rev 208, build 201011041330. Copyright (c) 2009-2010 by Shlomi
Noach
-- database is mycheckpoint
-- Will not monitor the database
read databases
started httpserver on port 12306...
----------------------------------------
Exception happened during processing of request from ('10.11.1.1', 60042)
Traceback (most recent call last):
File "/usr/lib64/python2.4/SocketServer.py", line 222, in handle_request
self.process_request(request, client_address)
File "/usr/lib64/python2.4/SocketServer.py", line 241, in process_request
self.finish_request(request, client_address)
File "/usr/lib64/python2.4/SocketServer.py", line 254, in finish_request
self.RequestHandlerClass(request, client_address, self)
File "/usr/lib64/python2.4/SocketServer.py", line 521, in __init__
self.handle()
File "/usr/lib64/python2.4/BaseHTTPServer.py", line 316, in handle
self.handle_one_request()
File "/usr/lib64/python2.4/BaseHTTPServer.py", line 310, in handle_one_request
method()
File "/usr/local/bin/mycheckpoint", line 4730, in do_GET
html = http_embed_code(html, '<div class="header">', html_embed)
File "/usr/local/bin/mycheckpoint", line 4535, in http_embed_code
html = html.replace(anchor, "%s%s" % (anchor, code))
AttributeError: 'array.array' object has no attribute 'replace'
----------------------------------------
What version of the mycheckpoint are you using? mycheckpoint rev 208, build
201011041330
What version of the MySQL are you using? (SELECT VERSION()) 5.0.77
On what operating system? CentOS 5
Please provide any additional information below.
Original issue reported on code.google.com by [email protected]
on 23 Feb 2012 at 3:14
What steps will reproduce the problem?
1. On a Percona Xtra Cluster running centos 6.3, install the rpm
2. Do the initial run
What is the expected output? What do you see instead?
Erros on inserting status variables
What is the output when running with the "--verbose --debug" options?
[SAC][root@ussacpxc-test-cluster-1]:/tmp$ /usr/local/bin/mycheckpoint --verbose
--debug --defaults-file=/etc/mycheckpoint.cnf
-- Using /etc/mycheckpoint.cnf as defaults file
-- mycheckpoint rev 231, build 201305231510. Copyright (c) 2009-2013 by Shlomi
Noach
-- database is rladmin
-- Global status & variables recorded
-- Master and slave status recorded
-- OS CPU info recorded
-- OS load average info recorded
-- OS mem info recorded
-- OS mountpoints info recorded
-- OS page io activity recorded
(1064, "You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near 'primary,
0.000000, 0.000000, 0.000000, 1, 0.000000, 0, 0, 172.20.28.160:3306,172' at
line 3")
Traceback (most recent call last):
File "/usr/local/bin/mycheckpoint", line 5055, in <module>
collect_status_variables()
File "/usr/local/bin/mycheckpoint", line 4446, in collect_status_variables
num_affected_rows = act_query(query)
File "/usr/local/bin/mycheckpoint", line 254, in act_query
num_affected_rows = cursor.execute(query)
File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 173, in execute
self.errorhandler(self, exc, value)
File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
ProgrammingError: (1064, "You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right syntax to
use near 'primary, 0.000000, 0.000000, 0.000000, 1, 0.000000, 0, 0,
172.20.28.160:3306,172' at line 3")
--
-- Re-execute with --verbose --debug for detailed message and stack trace.
--
What version of the mycheckpoint are you using? Happens in both 208 and 231
What version of the MySQL are you using? (SELECT VERSION())
Server version: 5.5.30-log Percona XtraDB Cluster (GPL), wsrep_23.7.4.r3843
What version of Python are you using? (python --version)
Python 2.6.6
On what operating system?
CentOS release 6.3 (Final)
What is your sql_mode? (SELECT @@global.sql_mode)
+-------------------+
| @@global.sql_mode |
+-------------------+
| |
+-------------------+
1 row in set (0.00 sec)
Please provide any additional information below.
I think the issue is the wsrep values in the status_variables table are not
correct.
I have attached the wsrep status and variables from my test server.
Allen
Original issue reported on code.google.com by [email protected]
on 3 Jun 2013 at 5:33
What steps will reproduce the problem?
1. status_variables_aggregated_hour table exists
2.
3.
What is the expected output? What do you see instead?
-- status_variables_aggregated_hour table exists
(1146, "Table 'mycheckpoint.status_variables_aggregated_hour' doesn't exist")
What is the output when running with the "--verbose --debug" options?
Traceback (most recent call last):
File "mycheckpoint.py", line 2260, in create_status_variables_hour_aggregation_table
act_query(query)
File "mycheckpoint.py", line 247, in act_query
num_affected_rows = cursor.execute(query)
File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 166, in execute
self.errorhandler(self, exc, value)
File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 35, in defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (1005, "Can't create table
'mycheckpoint.status_variables_aggregated_hour' (errno: 139)")
-- status_variables_aggregated_hour table exists
(1146, "Table 'mycheckpoint.status_variables_aggregated_hour' doesn't exist")
Traceback (most recent call last):
File "mycheckpoint.py", line 4950, in <module>
deploy_schema()
File "mycheckpoint.py", line 4847, in deploy_schema
create_status_variables_views_and_aggregations()
File "mycheckpoint.py", line 3914, in create_status_variables_views_and_aggregations
upgrade_status_variables_hour_aggregation_table()
File "mycheckpoint.py", line 2021, in upgrade_status_variables_hour_aggregation_table
return upgrade_status_variables_aggregation_table("status_variables_aggregated_hour")
File "mycheckpoint.py", line 1994, in upgrade_status_variables_aggregation_table
existing_columns = [row["Field"] for row in get_rows(query, write_conn)]
File "mycheckpoint.py", line 268, in get_rows
cursor.execute(query)
File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 166, in execute
self.errorhandler(self, exc, value)
File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 35, in defaulterrorhandler
raise errorclass, errorvalue
ProgrammingError: (1146, "Table 'mycheckpoint.status_variables_aggregated_hour'
doesn't exist")
What version of the mycheckpoint are you using? 231
What version of the MySQL are you using? (SELECT VERSION())5.5.33a-MariaDB-log
What version of Python are you using? (python --version) Python 2.6.8
On what operating system? SUSE Linux Enterprise Server 11 (x86_64)
What is your sql_mode? (SELECT @@global.sql_mode) NO_AUTO_CREATE_USER
Please provide any additional information below.
Original issue reported on code.google.com by [email protected]
on 17 Jul 2014 at 3:35
What is the feature request?
(1054, "Unknown column 'mysql' in 'field list'")
How will this change current behavior?
What parameters/options will be required?
What version of the mycheckpoint are you using?
mycheckpoint-231
What version of the MySQL are you using?
percona 5.6
On what operating system?
centos 6.x
hey,Shlomi Noach!
i love the mycheckpoint.i have use the mycheckpoint very long time,and it run
very good!!but now i update my mysql to 5.6,and some change to percona 5.6,i
also used the tokudb for new system,that have some bugs!
i just give the error info!
1.
percona 5.6 with tokudb engine
(1166, "Incorrect column name
'tokudb_nonleaf_nodes_flushed_to_disk_checkpoint_uncompressed_by_diff'")
2.
percona 5.6
(1054, "Unknown column 'mysql' in 'field list'")
3.
mysql 5.6
(1166, "Incorrect column name
'tokudb_nonleaf_nodes_flushed_to_disk_checkpoint_uncompressed_by_diff'")
tkx,wait for your reply!!!mycheckpint big fan.
Original issue reported on code.google.com by [email protected]
on 20 Aug 2014 at 3:06
Hi I tried to install mycheckpoint via rpm but getting an error. I use MariaDB
5.2.x with yum exclude for mysql, so manually compiled MySQL-python but not
getting any where ?
* CentOS 6.0 64bit
* MariaDB 5.2.10 64bit
* Python 2.7.2
Server version 5.2.10-MariaDB-mariadb107
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 1 day 3 hours 49 min 9 sec
Threads: 1 Questions: 7 Slow queries: 0 Opens: 15 Flush tables: 1 Open
tables: 8 Queries per second avg: 0.0
which python
alias python='/opt/python2.7.2/bin/python'
/opt/python2.7.2/bin/python
mycheckpoint --help
Traceback (most recent call last):
File "/usr/local/bin/mycheckpoint", line 22, in <module>
import MySQLdb
ImportError: No module named MySQLdb
MySQL-python install
wget
http://sourceforge.net/projects/mysql-python/files/mysql-python/1.2.3/MySQL-pyth
on-1.2.3.tar.gz/download
tar xvzf MySQL-python-1.2.3.tar.gz
cd MySQL-python-1.2.3
/opt/python2.7.2/bin/python setup.py build
/opt/python2.7.2/bin/python setup.py install
output
#######################
[root@host MySQL-python-1.2.3]# /opt/python2.7.2/bin/python setup.py build
running build
running build_py
creating build
creating build/lib.linux-x86_64-2.7
copying _mysql_exceptions.py -> build/lib.linux-x86_64-2.7
creating build/lib.linux-x86_64-2.7/MySQLdb
copying MySQLdb/__init__.py -> build/lib.linux-x86_64-2.7/MySQLdb
copying MySQLdb/converters.py -> build/lib.linux-x86_64-2.7/MySQLdb
copying MySQLdb/connections.py -> build/lib.linux-x86_64-2.7/MySQLdb
copying MySQLdb/cursors.py -> build/lib.linux-x86_64-2.7/MySQLdb
copying MySQLdb/release.py -> build/lib.linux-x86_64-2.7/MySQLdb
copying MySQLdb/times.py -> build/lib.linux-x86_64-2.7/MySQLdb
creating build/lib.linux-x86_64-2.7/MySQLdb/constants
copying MySQLdb/constants/__init__.py ->
build/lib.linux-x86_64-2.7/MySQLdb/constants
copying MySQLdb/constants/CR.py -> build/lib.linux-x86_64-2.7/MySQLdb/constants
copying MySQLdb/constants/FIELD_TYPE.py ->
build/lib.linux-x86_64-2.7/MySQLdb/constants
copying MySQLdb/constants/ER.py -> build/lib.linux-x86_64-2.7/MySQLdb/constants
copying MySQLdb/constants/FLAG.py ->
build/lib.linux-x86_64-2.7/MySQLdb/constants
copying MySQLdb/constants/REFRESH.py ->
build/lib.linux-x86_64-2.7/MySQLdb/constants
copying MySQLdb/constants/CLIENT.py ->
build/lib.linux-x86_64-2.7/MySQLdb/constants
running build_ext
building '_mysql' extension
creating build/temp.linux-x86_64-2.7
gcc -pthread -fno-strict-aliasing -g -O2 -DNDEBUG -g -fwrapv -O3 -Wall
-Wstrict-prototypes -fPIC -Dversion_info=(1,2,3,'final',0) -D__version__=1.2.3
-I/usr/include/mysql -I/opt/python2.7.2/include/python2.7 -c _mysql.c -o
build/temp.linux-x86_64-2.7/_mysql.o -fno-omit-frame-pointer -g -pipe
-Wp,-D_FORTIFY_SOURCE=2 -fstack-protector --param=ssp-buffer-size=4 -m64
-DUNIV_LINUX
In file included from _mysql.c:36:
/usr/include/mysql/my_config.h:1217:1: warning: "HAVE_WCSCOLL" redefined
In file included from /opt/python2.7.2/include/python2.7/Python.h:8,
from pymemcompat.h:10,
from _mysql.c:29:
/opt/python2.7.2/include/python2.7/pyconfig.h:887:1: warning: this is the
location of the previous definition
gcc -pthread -shared build/temp.linux-x86_64-2.7/_mysql.o -L/usr/lib64/mysql
-L/opt/python2.7.2/lib -lmysqlclient_r -lz -lnsl -lrt -lresolv -lpthread
-lcrypt -lnsl -lm -lpthread -lrt -lpython2.7 -o
build/lib.linux-x86_64-2.7/_mysql.so
#######################
[root@host MySQL-python-1.2.3]# /opt/python2.7.2/bin/python setup.py install
running install
running bdist_egg
running egg_info
writing MySQL_python.egg-info/PKG-INFO
writing top-level names to MySQL_python.egg-info/top_level.txt
writing dependency_links to MySQL_python.egg-info/dependency_links.txt
reading manifest file 'MySQL_python.egg-info/SOURCES.txt'
reading manifest template 'MANIFEST.in'
warning: no files found matching 'MANIFEST'
warning: no files found matching 'ChangeLog'
warning: no files found matching 'GPL'
writing manifest file 'MySQL_python.egg-info/SOURCES.txt'
installing library code to build/bdist.linux-x86_64/egg
running install_lib
running build_py
copying MySQLdb/release.py -> build/lib.linux-x86_64-2.7/MySQLdb
running build_ext
creating build/bdist.linux-x86_64
creating build/bdist.linux-x86_64/egg
creating build/bdist.linux-x86_64/egg/MySQLdb
copying build/lib.linux-x86_64-2.7/MySQLdb/times.py ->
build/bdist.linux-x86_64/egg/MySQLdb
copying build/lib.linux-x86_64-2.7/MySQLdb/connections.py ->
build/bdist.linux-x86_64/egg/MySQLdb
copying build/lib.linux-x86_64-2.7/MySQLdb/cursors.py ->
build/bdist.linux-x86_64/egg/MySQLdb
copying build/lib.linux-x86_64-2.7/MySQLdb/converters.py ->
build/bdist.linux-x86_64/egg/MySQLdb
creating build/bdist.linux-x86_64/egg/MySQLdb/constants
copying build/lib.linux-x86_64-2.7/MySQLdb/constants/CLIENT.py ->
build/bdist.linux-x86_64/egg/MySQLdb/constants
copying build/lib.linux-x86_64-2.7/MySQLdb/constants/FIELD_TYPE.py ->
build/bdist.linux-x86_64/egg/MySQLdb/constants
copying build/lib.linux-x86_64-2.7/MySQLdb/constants/FLAG.py ->
build/bdist.linux-x86_64/egg/MySQLdb/constants
copying build/lib.linux-x86_64-2.7/MySQLdb/constants/REFRESH.py ->
build/bdist.linux-x86_64/egg/MySQLdb/constants
copying build/lib.linux-x86_64-2.7/MySQLdb/constants/CR.py ->
build/bdist.linux-x86_64/egg/MySQLdb/constants
copying build/lib.linux-x86_64-2.7/MySQLdb/constants/__init__.py ->
build/bdist.linux-x86_64/egg/MySQLdb/constants
copying build/lib.linux-x86_64-2.7/MySQLdb/constants/ER.py ->
build/bdist.linux-x86_64/egg/MySQLdb/constants
copying build/lib.linux-x86_64-2.7/MySQLdb/__init__.py ->
build/bdist.linux-x86_64/egg/MySQLdb
copying build/lib.linux-x86_64-2.7/MySQLdb/release.py ->
build/bdist.linux-x86_64/egg/MySQLdb
copying build/lib.linux-x86_64-2.7/_mysql_exceptions.py ->
build/bdist.linux-x86_64/egg
copying build/lib.linux-x86_64-2.7/_mysql.so -> build/bdist.linux-x86_64/egg
byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/times.py to times.pyc
byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/connections.py to
connections.pyc
byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/cursors.py to cursors.pyc
byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/converters.py to
converters.pyc
byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/constants/CLIENT.py to
CLIENT.pyc
byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/constants/FIELD_TYPE.py to
FIELD_TYPE.pyc
byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/constants/FLAG.py to
FLAG.pyc
byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/constants/REFRESH.py to
REFRESH.pyc
byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/constants/CR.py to CR.pyc
byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/constants/__init__.py to
__init__.pyc
byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/constants/ER.py to ER.pyc
byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/__init__.py to __init__.pyc
byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/release.py to release.pyc
byte-compiling build/bdist.linux-x86_64/egg/_mysql_exceptions.py to
_mysql_exceptions.pyc
creating stub loader for _mysql.so
byte-compiling build/bdist.linux-x86_64/egg/_mysql.py to _mysql.pyc
creating build/bdist.linux-x86_64/egg/EGG-INFO
copying MySQL_python.egg-info/PKG-INFO -> build/bdist.linux-x86_64/egg/EGG-INFO
copying MySQL_python.egg-info/SOURCES.txt ->
build/bdist.linux-x86_64/egg/EGG-INFO
copying MySQL_python.egg-info/dependency_links.txt ->
build/bdist.linux-x86_64/egg/EGG-INFO
copying MySQL_python.egg-info/top_level.txt ->
build/bdist.linux-x86_64/egg/EGG-INFO
writing build/bdist.linux-x86_64/egg/EGG-INFO/native_libs.txt
zip_safe flag not set; analyzing archive contents...
creating dist
creating 'dist/MySQL_python-1.2.3-py2.7-linux-x86_64.egg' and adding
'build/bdist.linux-x86_64/egg' to it
removing 'build/bdist.linux-x86_64/egg' (and everything under it)
Processing MySQL_python-1.2.3-py2.7-linux-x86_64.egg
Removing
/opt/python2.7.2/lib/python2.7/site-packages/MySQL_python-1.2.3-py2.7-linux-x86_
64.egg
Copying MySQL_python-1.2.3-py2.7-linux-x86_64.egg to
/opt/python2.7.2/lib/python2.7/site-packages
MySQL-python 1.2.3 is already the active version in easy-install.pth
Installed
/opt/python2.7.2/lib/python2.7/site-packages/MySQL_python-1.2.3-py2.7-linux-x86_
64.egg
Processing dependencies for MySQL-python==1.2.3
Finished processing dependencies for MySQL-python==1.2.3
Original issue reported on code.google.com by [email protected]
on 18 Dec 2011 at 9:17
Hi,
Again, I'm filing here in the absence of a mailing list - is there an IRC room
or something that I could use instead?
I'm after a guide to writing custom reports. I've got a number of servers that
will (hopefully!) be reporting into a central server (see issue 13) and I want
to create a report that only shows certain metrics but for multiple servers on
the same page.
Is there a way of integrating the system_report queries into custom reports?
Thanks,
Matt
Original issue reported on code.google.com by [email protected]
on 19 Aug 2010 at 9:15
What steps will reproduce the problem?
1. delay_key_write = all
2. mycheckpoint --monitored-host=db-slave --database=mycheckpoint_slave
What is the output when running with the "--verbose --debug" options?
(1064, "You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near 'all, 0, 100, 0,
300, 1000, 0, 954839, 7, 1, 1, 1024, 4395, 34, 0, 0, 3847, 5205,' at line 3")
Traceback (most recent call last):
File "/usr/local/bin/mycheckpoint", line 4861, in <module>
collect_status_variables()
File "/usr/local/bin/mycheckpoint", line 4275, in collect_status_variables
num_affected_rows = act_query(query)
File "/usr/local/bin/mycheckpoint", line 246, in act_query
num_affected_rows = cursor.execute(query)
File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 173, in execute
self.errorhandler(self, exc, value)
File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
ProgrammingError: (1064, "You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right syntax to
use near 'all, 0, 100, 0, 300, 1000, 0, 954839, 7, 1, 1, 1024, 4395, 34, 0, 0,
3847, 5205,' at line 3")
What version of the mycheckpoint are you using?
mycheckpoint-208-1.noarch
What version of the MySQL are you using? (SELECT VERSION())
5.5.15-log
On what operating system?
CentOS Linux release 6.0 (Final)
Please provide any additional information below.
Original issue reported on code.google.com by [email protected]
on 29 Aug 2011 at 9:54
What steps will reproduce the problem?
1. run mysqlcheckpoint against MySQL 5.5.4
2.
3.
What is the expected output? What do you see instead?
Output received:
mycheckpoint --verbose --skip-check-replication
-- Using /etc/mycheckpoint.cnf as defaults file
-- mycheckpoint rev 170, build 201007152036. Copyright (c) 2009-2010 by Shlomi
Noach
-- database is mycheckpoint
-- Global status & variables recorded
-- OS CPU info recorded
-- OS load average info recorded
-- OS mem info recorded
-- OS mountpoints info recorded
-- OS page io activity recorded
(1054, "Unknown column 'auto' in 'field list'")
--
-- Make sure you have executed mycheckpoint with 'deploy' after last
install/update.upgrade
-- If not, run again with same configuration, and add 'deploy'. e.g.:
-- mycheckpoint --host=my_host deploy
--
What is the output when running with the "--verbose --debug" options?
What version of the mycheckpoint are you using?
rev 170, build 201007152036
What version of the MySQL are you using? (SELECT VERSION())
5.5.4-m3-log
On what operating system?
Linux - Debian
Please provide any additional information below.
mysql> SHOW GLOBAL VARIABLES LIKE 'concurrent_insert';
+-------------------+-------+
| Variable_name | Value |
+-------------------+-------+
| concurrent_insert | AUTO |
+-------------------+-------+
1 row in set (0.00 sec)
In MySQL 5.0 and 5.1 concurrent_insert accepts value 0, 1 or 2.
In MySQL 5.5 also the values NEVER and AUTO are valid.
The insert on mycheckpoint.status_variables looks like :
INSERT INTO status_variables (......) VALUES ( .... , auto , .....)
Resulting in an error.
Fix:
diff mycheckpoint mycheckpoint.orig
4078c4078
< variable_values = ", ".join(["'%s'" % status_dict[column_name] for
column_name in sorted_list(status_dict.keys())])
---
> variable_values = ", ".join(["%s" % status_dict[column_name] for
column_name in sorted_list(status_dict.keys())])
Original issue reported on code.google.com by [email protected]
on 19 Jul 2010 at 6:00
What steps will reproduce the problem?
/usr/local/bin/mycheckpoint --verbose --debug
--defaults-file=/etc/mycheckpoint.cnf
-- Using /etc/mycheckpoint.cnf as defaults file
-- mycheckpoint rev 231, build 201305231510. Copyright (c) 2009-2013 by Shlomi
Noach
-- database is mycheckpoint
-- Global status & variables recorded
-- Master and slave status recorded
-- OS CPU info recorded
-- OS load average info recorded
-- OS mem info recorded
-- OS mountpoints info recorded
-- OS page io activity recorded
(1064, "You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near '06:15:47, 60, 0,
1, 0, 1, 10, 0, 2, 3, 1, 3145716, 0, 607, 700896, 10566, 0, 1, ' at line 3")
Traceback (most recent call last):
File "/usr/local/bin/mycheckpoint", line 5055, in <module>
collect_status_variables()
File "/usr/local/bin/mycheckpoint", line 4446, in collect_status_variables
num_affected_rows = act_query(query)
File "/usr/local/bin/mycheckpoint", line 254, in act_query
num_affected_rows = cursor.execute(query)
File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 173, in execute
self.errorhandler(self, exc, value)
File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
ProgrammingError: (1064, "You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right syntax to
use near '06:15:47, 60, 0, 1, 0, 1, 10, 0, 2, 3, 1, 3145716, 0, 607, 700896,
10566, 0, 1, ' at line 3")
--
-- Re-execute with --verbose --debug for detailed message and stack trace.
--
What is the expected output? What do you see instead?
See error above
What is the output when running with the "--verbose --debug" options?
See error above
What version of the mycheckpoint are you using? rev 231, build 201305231510
What version of the MySQL are you using? (SELECT VERSION()) 5.6.12-log
What version of Python are you using? (python --version) Python 2.6.6
On what operating system? Linux
What is your sql_mode? (SELECT @@global.sql_mode) NO_ENGINE_SUBSTITUTION
Please provide any additional information below.
If I change the "is_neglectable_variable" routine as follows it works:
def is_neglectable_variable(variable_name):
if variable_name.startswith("ssl_"):
return True
if variable_name.startswith("ndb_"):
return True
if variable_name == "last_query_cost":
return True
if variable_name == "rpl_status":
return True
if variable_name == "slave_last_heartbeat":
return True
return False
Original issue reported on code.google.com by [email protected]
on 31 Jul 2013 at 11:43
What steps will reproduce the problem?
1. install mycheckpint from svn as well as latest tgz (208)
2. mysql -uusernmae -p mycp_stage_worker --silent --raw --execute="SELECT html
FROM sv_report_html_24_7" > /var/www/mysql/mycp_stage_worker/report24_7.html
3. as well as mysql -uusernmae -p mycp_stage_worker --silent --raw
--execute="SELECT html FROM sv_report_html_24_7" | sed "s/\&/\&/g" >
/var/www/mysql/mycp_stage_worker/report24_7.html
What is the expected output? What do you see instead?
I expect to see the charts; I do not see the charts
What is the output when running with the "--verbose --debug" options?
NA. the reports are generated and are stored in the db, but no charts are
displayed when viewing the rendered html
What version of the mycheckpoint are you using?
What version of the MySQL are you using? (SELECT VERSION())
What version of Python are you using? (python --version)
On what operating system?
What is your sql_mode? (SELECT @@global.sql_mode)
Please provide any additional information below.
Original issue reported on code.google.com by [email protected]
on 15 Nov 2012 at 5:54
What steps will reproduce the problem?
1. [myuser@mycomputer ~]$ mycheckpoint --host=centralserver --port=3306
--user=mycheckpoint --password=mycheckpoint --database=mcp_centralserver
--monitored-host=localhost --monitored-socket=/tmp/mysql.sock
(1146, "Table 'mcp_webprod.status_variables_aggregated_hour' doesn't exist")
--
-- Re-execute with --verbose --debug for detailed message and strack trace.
--
2. In mysql database we can find 13 just created tables :
mysql> show tables;
+-----------------------+
| Tables_in_mcp_webprod |
+-----------------------+
| alert |
| alert_condition |
| alert_pending |
| charts_api |
| custom_query |
| custom_query_view |
| html_components |
| metadata |
| numbers |
| status_variables |
| sv_diff |
| sv_latest |
| sv_sample |
+-----------------------+
13 rows in set (0.01 sec)
3.
What is the expected output? What do you see instead?
What is the output when running with the "--verbose --debug" options?
1. [myuser@mycomputer ~]$ mycheckpoint --host=centralserver --port=3306
--user=mycheckpoint --password=mycheckpoint --database=mcp_centralserver
--monitored-host=localhost --monitored-socket=/tmp/mysql.sock --verbose --debug
-- mycheckpoint rev 208, build 201011041330. Copyright (c) 2009-2010 by Shlomi
Noach
-- database is mcp_centralserver
-- monitored host is: localhost
-- monitored host credentials undefined; using write host credentials
-- Non matching deployed revision. Will auto-deploy
-- metadata table created
-- numbers table created
-- charts_api table created
-- html_components table created
-- custom_query table created
-- custom_query_view created
-- Global status & variables recorded
-- Master and slave status recorded
-- OS CPU info recorded
-- OS load average info recorded
-- OS mem info recorded
-- OS mountpoints info recorded
-- OS page io activity recorded
-- status_variables table exists
-- alert_condition table created
-- alert table created
-- alert_pending table created
-- sv_latest view created
-- sv_diff view created
-- sv_sample view created
-- status_variables_aggregated_hour table exists
(1146, "Table 'mcp_centralserver.status_variables_aggregated_hour' doesn't
exist")
Traceback (most recent call last):
File "/usr/local/bin/mycheckpoint", line 4854, in ?
deploy_schema()
File "/usr/local/bin/mycheckpoint", line 4767, in deploy_schema
create_status_variables_views_and_aggregations()
File "/usr/local/bin/mycheckpoint", line 3856, in create_status_variables_views_and_aggregations
upgrade_status_variables_hour_aggregation_table()
File "/usr/local/bin/mycheckpoint", line 1968, in upgrade_status_variables_hour_aggregation_table
return upgrade_status_variables_aggregation_table("status_variables_aggregated_hour")
File "/usr/local/bin/mycheckpoint", line 1941, in upgrade_status_variables_aggregation_table
existing_columns = [row["Field"] for row in get_rows(query, write_conn)]
File "/usr/local/bin/mycheckpoint", line 267, in get_rows
cursor.execute(query)
File "/usr/lib64/python2.4/site-packages/MySQLdb/cursors.py", line 163, in execute
self.errorhandler(self, exc, value)
File "/usr/lib64/python2.4/site-packages/MySQLdb/connections.py", line 35, in defaulterrorhandler
raise errorclass, errorvalue
ProgrammingError: (1146, "Table
'mcp_centralserver.status_variables_aggregated_hour' doesn't exist")
--
-- Re-execute with --verbose --debug for detailed message and strack trace.
--
What version of the mycheckpoint are you using?
mycheckpoint-208
I made some try with Python simple script and noarch.rpm archive. Both are same
What version of the MySQL are you using? (SELECT VERSION())
mysql> SELECT VERSION();
+------------+
| VERSION() |
+------------+
| 5.5.16-log |
+------------+
1 row in set (0.00 sec)
What version of Python are you using? (python --version)
Python 2.4.3
On what operating system?
Linux RedHat 5 Enterprise - Kernel 2.6.18-164.el5
Please provide any additional information below.
Any idea ?? Thanks
Original issue reported on code.google.com by [email protected]
on 7 Jun 2012 at 4:40
After installing mycheckpoint, creating mycheckpoint schema and granting
privileges, mycheckpoint is not recording any data. All tables are created, but
remain empty. Any idea what I am missing here?
Output with -v --debug:
-- mycheckpoint rev 208, build 201011041330. Copyright (c) 2009-2010 by Shlomi
Noach
-- database is mycheckpoint
-- Non matching deployed revision. Will auto-deploy
-- metadata table created
-- numbers table created
-- charts_api table created
-- html_components table created
-- custom_query table created
-- custom_query_view created
-- Global status & variables recorded
-- Master and slave status recorded
-- OS CPU info recorded
-- OS load average info recorded
-- OS mem info recorded
-- OS mountpoints info recorded
-- OS page io activity recorded
-- status_variables table exists
-- alert_condition table created
-- alert table created
-- alert_pending table created
-- sv_latest view created
-- sv_diff view created
-- sv_sample view created
-- status_variables_aggregated_hour table exists
-- status_variables_aggregated_day table exists
-- sv_hour view created
-- sv_day view created
-- sv_param_change view created
(1054, "Unknown column 'innodb_rows_read_psec' in 'field list'")
Traceback (most recent call last):
File "/usr/bin/mycheckpoint", line 4854, in ?
deploy_schema()
File "/usr/bin/mycheckpoint", line 4767, in deploy_schema
create_status_variables_views_and_aggregations()
File "/usr/bin/mycheckpoint", line 3864, in create_status_variables_views_and_aggregations
create_report_views("""
File "/usr/bin/mycheckpoint", line 3842, in create_report_views
act_query(custom_query)
File "/usr/bin/mycheckpoint", line 246, in act_query
num_affected_rows = cursor.execute(query)
File "build/bdist.linux-x86_64/egg/MySQLdb/cursors.py", line 174, in execute
File "build/bdist.linux-x86_64/egg/MySQLdb/connections.py", line 36, in defaulterrorhandler
OperationalError: (1054, "Unknown column 'innodb_rows_read_psec' in 'field
list'")
--
-- Re-execute with --verbose --debug for detailed message and strack trace.
--
Additional information:
OS: Centos 5.6
Mycheckpoint version: 208
MySQL version: 5.1.57
Python version: 2.4.3
MySQL-python: 1.2.3
Original issue reported on code.google.com by [email protected]
on 16 Jan 2012 at 2:58
What steps will reproduce the problem?
1. Shutdown mysqld
2. tty 1: ncat -l dev-gnt-2.int.linuxvoid.org 3306
3. tty 2: time mycheckpoint --host=sysserver1.int.linuxvoid.org
--monitored-host=dev-gnt-2.int.linuxvoid.org --database=mycheckpoint_devgnt2 -v
What is the expected output? What do you see instead?
Time-out expected within 1 or 2 minutes. But it runs to infinity and back.
What is the output when running with the "--verbose --debug" options?
On ^C in ncat:
-- Using /etc/mycheckpoint.cnf as defaults file
-- mycheckpoint rev 208, build 201011041330. Copyright (c) 2009-2010 by Shlomi
Noach
-- database is mycheckpoint_devgnt2
-- monitored host is: dev-gnt-2.int.dirkzwager.com
-- monitored host credentials undefined; using write host credentials
-- ERROR: Cannot connect to database
-- Sending cannot access message from [email protected]
to: [email protected] via: smtp.int.dirkzwager.com
-- + Sent
(2013, "Lost connection to MySQL server at 'reading initial communication
packet', system error: 0")
--
-- Re-execute with --verbose --debug for detailed message and strack trace.
--
real 65m3.434s
user 0m0.100s
sys 0m0.000s
On ^C in mycheckpoint followed by ^C in ncat:
-- Using /etc/mycheckpoint.cnf as defaults file
-- mycheckpoint rev 208, build 201011041330. Copyright (c) 2009-2010 by Shlomi
Noach
-- database is mycheckpoint_devgnt2
-- monitored host is: dev-gnt-2.int.dirkzwager.com
-- monitored host credentials undefined; using write host credentials
^C
Traceback (most recent call last):
File "/usr/bin/mycheckpoint", line 4845, in <module>
monitored_conn, write_conn = open_connections()
KeyboardInterrupt
real 0m10.904s
user 0m0.100s
sys 0m0.000s
What version of the mycheckpoint are you using?
rev. 208
What version of the MySQL are you using? (SELECT VERSION())
mysql Ver 14.14 Distrib 5.1.52, for pc-linux-gnu (x86_64) using readline 5.1
On what operating system?
Linux dev-gnt-2 2.6.34-gentoo-r6 #1 SMP Tue Sep 28 10:16:39 CEST 2010 x86_64
Intel(R) Core(TM)2 Quad CPU Q6600 @ 2.40GHz GenuineIntel GNU/Linux
Please provide any additional information below.
As requested in issue 23.
Original issue reported on code.google.com by [email protected]
on 21 Sep 2011 at 11:13
Background:
I installed mycheckpoint couple months ago, it worked very well on 5.1.42.
Recently I upgraded to MySQL 5.5.13, and 'mycheckpiont' collapsed.
What is the expected output? What do you see instead?
-- See below the error...
What is the output when running with the "--verbose --debug" options?
---------------
[root@dbh1 ~]# mycheckpoint -uroot -pxxxxxxxxx --skip-disable-bin-log
--skip-check-replication --socket=/var/lib/mysql/mysql.sock --verbose --debug
Traceback (most recent call last):
File "/usr/local/bin/mycheckpoint", line 22, in ?
import MySQLdb
File "/usr/lib64/python2.4/site-packages/MySQLdb/__init__.py", line 19, in ?
import _mysql
ImportError: libmysqlclient_r.so.15: cannot open shared object file: No such
file or directory
-------------
What version of the mycheckpoint are you using?
-- 208
What version of the MySQL are you using? (SELECT VERSION())
-- 5.5.13
On what operating system?
-- Red Hat Enterprise Linux Server release 5.5 (Tikanga)
Please provide any additional information below.
Thanks,
[email protected]
Original issue reported on code.google.com by [email protected]
on 10 Jun 2011 at 8:44
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.