不多说上图
[2017-10-13 08:52:28]{"router":"site/test","process_time":1.05578303337,"include_files":110}
[2017-10-13 08:52:29]{"router":"site/test","process_time":1.65018391609,"include_files":110}
[2017-10-13 08:52:30]{"router":"site/test","process_time":2.24326276779,"include_files":110}
[2017-10-13 08:52:31]{"router":"site/test","process_time":2.83484601974,"include_files":110}
[2017-10-13 08:52:32]{"router":"site/test","process_time":3.45267605782,"include_files":110}
[2017-10-13 08:52:43]{"router":"site/test","process_time":0.045606136322,"include_files":110}
[2017-10-13 08:52:43]{"router":"site/test","process_time":0.0466020107269,"include_files":110}
[2017-10-13 08:52:44]{"router":"site/test","process_time":0.0419600009918,"include_files":110}
[2017-10-13 08:52:44]{"router":"site/test","process_time":0.0458340644836,"include_files":110}
[2017-10-13 08:52:44]{"router":"site/test","process_time":0.0436880588531,"include_files":110}
因为在框架里面，所以include_files就这么多（没办法，没开始opcache）
前5条是用的localhost后5条是127.0.0.1，瞅瞅，就是这样的区别！
navicat是个好软件，mariadb也是，不过，默认的mariadb在查看的时候可能会是乱码（特别是debian 9，默认没有mysql,只有mariadb了）
1、进入console，如果set names utf8，然后select能够看到正常的数据，这证明几件事，client有问题，字符串不对
2、如果是1所说的问题。那么修改my.cnf，修改[mysqld] [mysql] [client]中的数据
XML/HTML代码
- [mysqld]下增加character-set-server=utf8
- [client]下增加default-character-set=utf8
- [mysql] 下增加default-character-set=utf8
如果还是无效。。则尝试在mysqld下再增加：
XML/HTML代码（与上面的有一行重复）
- [mysqld]
- init_connect='SET collation_connection = utf8_unicode_ci'
- init_connect='SET NAMES utf8'
- character-set-server=utf8
- collation-server=utf8_unicode_ci
- skip-character-set-client-handshake
参考 ：http://blog.csdn.net/fzq1988215/article/details/48808001
dcloud更新失败有几个原因：
1、manifest.json在打包的时候不对
2、checkversion的时候用数字和字符串比较
3、版本小于当前版本，但判断的时候没判断好
4、wgt文件不是zip压缩的
5、网络原因，没下载好文件
基于以上几个原因。除了网络原因。其他可以一试（下次我试一下直接打包成zip，然后改名成wgt试一下看看）
原来的数据库是N年前的，默认字符集是latin1，但是有一些旧代码中，连接参数写的是UTF8，于是就这样。。。DB字符集为latin1，连接UTF8，存到数据库也是UTF8，wj但查看的时候显示是???
为了标准统一，于是使用mysqldump -uxx -p database a b c d e > dump.sql，将部分表先导出来
然后修改导出sql的charset=latin1;改为charset=utf8;
至此，操作完成。简单粗暴
-------EOF--
deeka说，如果有200G呢。目前我是停机处理的。因为要处理的数据也不是很多。如果不是因为升级换库的时候出现不能访问我也不会这么做。
但好象也没有特别好的方案。因为直接alter的时候也是各种不正常。才dump的
说实话，在datatables里，我觉得这个回复挺重要的！https://datatables.net/forums/discussion/33723/new-user-help-columns-vs-columndefs-for-client-side-rendering-of-ajax-data
提问：
XML/HTML代码
- Hi,
-
- I'm a beginner with DataTables. I'm trying to use DataTables AJAX to pull records from the server (an ASP.NET MVC app.) Each record coming from the server has name, address line 1, address line 2, city, state, zip. I want my table to combine and format all those fields into one column on the client.
-
- My questions are:
- 1. Would I use columns.render, or columnDefs.render?
- 2. Do I need both columns and columnDefs?
- 3. Do I need to specify either the table column name (e.g., NameAndAddress) in "columns", or do I need to list each field coming back from the server?
- 4. How do I use "targets"? Does "targets" refer to the column in the displayed table, or the column under "columns"?
-
- Thanks for your help. I've been though the documentation a few times and I'm still confused about columns vs. columnDefs.
回答：
"columns" & "columnsDefs" ultimately serve the same purpose.
The differences being:
- "columns" requires you to provide a configuration or null for all columns. "columnDefs" requires you to only proved configuration for columns that have "special" configurations
- I have found "columns" best used if handling array of strings as your rows. I have found "columnDefs" best used if handling objects as your rows
"targets" takes a single string or int value, or array of previous two to denote which columns this configuration is for. I suggest using column class instead of column # in the event you want to use ColReorder extension.
Here are examples of how I have configured columns in my application.
HTML：
XML/HTML代码
- <th class="actionsCol no-print">Actions</th>
- <th class="StatusCol">Status</th>
- <th class="IsFinalCol">Final<br>Plan</th>
- <th class="VrsnCol">Vrsn</th>
- <th class="CutCntCol">Cut<br>Cnt</th>
- <th class="CarCntCol">Car<br>Cnt</th>
JS关键代码：
JavaScript代码
- "columnDefs": [
- {
-
- "targets": 'actionsCol',
- "sorting": false,
- "orderable": false,
- "type":"html",
- "width": "8%",
- className: "dt_nowrap_col no-print",
- "render": function (data, type, row) {
- return $.jqote(yv.templates.action_icons, data);
- }
- },
- {
- "targets": ['IsFinalCol','CutCntCol','CarCntCol','VrsnCol','StatusCol'],
- "width": "5%"
- },
- etc
- ]
看到这些定义，估计你应该能够想得出如何更好的应用了吧？
----EOF---
其他参考 ：
