确定删除吗?
在本演示中,我将讨论1。在MySQL2上使用物联网(IOT)。在mysql和mongodb中存储时间序列数据。我将在mysql和mongobd中进行使用物联网传感器和存储时间序列数据的现场演示(我还将演示世界上最小的mysql服务器)。之后,我将讨论如何在MySQL中存储时间序列,以及典型的挑战(即如何有效地存储原始度量)和数据优化技术:针对写入或选择、摘要表等进行优化。我们将讨论将时间序列数据存储为经典关系表(名称值或值作为字段)以及将其存储为MySQL5.7中的JSON对象。
1.
2. About Me Alexander Rubin, Principal Architect, Percona • Working with MySQL for over 10 years – Started at MySQL AB, Sun Microsystems, Oracle (MySQL ConsulDng) – Joined Percona in 2013
3.
4. Level of Light Every plant comes with one – a liOle plasDc label tucked into the pot with an icon on it that lets you know what level of light it needs.
5.Cost ($35 +) Size Need to add Wifi module
6.Particle Photon $19 hOps://store.parDcle.io
7.Intel Edison ~$60 hOp://www.intel.com/ content/www/us/en/ do-it-yourself/ edison.html
8.WiFi Module - ESP8266 $6 hOps:// www.sparkfun.com/ products/13678
9.Particle Demo…
10.Demo Recap… 100% Cloud IoT
11.console.parDcle.io
12.Measurement Results…
13. Storing data in MySQL: wide table CREATE TABLE `sensor_wide` ( `id` int(11) NOT NULL AUTO_INCREMENT, `light` int(11) DEFAULT NULL, `temp` double DEFAULT NULL, `humidity` double DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 + Storage is good - Alter table is a hard, not flexible
14. Storing data in MySQL: key/value CREATE TABLE `cloud_data` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `data` varchar(255) DEFAULT NULL, `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=11106 DEFAULT CHARSET=latin1 + Flexible - High overhead on storage
15. Storing data in MySQL 5.7: JSON store CREATE TABLE `event_stream_json` ( `doc` json DEFAULT NULL, `_id` varchar(32) GENERATED ALWAYS AS (json_unquote(json_extract(`doc`,'$._id'))) STORED NOT NULL, `name` varchar(255) GENERATED ALWAYS AS (json_unquote(json_extract(`doc`,'$.name'))) VIRTUAL, UNIQUE KEY `_id` (`_id`), KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 + Very Flexible + indexes - Some overhead on storage
16.Edison Demo…
17.
18.http://bugs.mysql.com/bug.php?id=2 [12 Sep 2002 5:26] Mark Matthews Description: Other JDBC drivers I have used make toast for breakfast. MySQL Connector/J doesn't make toast, it can only pour a bowl of froot loops. When I ask it to make toast, the "NoToast" exception is thrown. I think you should look into this.
19.Fixing MySQL Bug#2
20.
21.
22.Bug fixed, please enjoy your MySQL toast...