一起遨游网

解决 mysql5.6 启动后就占用几百 M 内存的问题
performance_schema_max_table_instances=400
table_definition_cache=400
table_open_cache=256

根本问题就是建议安装MYSQL5.5

解决方法：
将数据库中的所有"utf8mb4_unicode_520_ci"字符全部替换成"utf8mb4_unicode_ci"，然后再导入这样就没有错误。

主要原因是5.7 或者5.6版本回到5.5版本 数据是无法导入的，替换前记得备份！

select sum(user_registered) as"注册时间" ,count(*) as "注册人数" from wp_users group by date_format(user_registered, '%Y-%m-%d %H ')='2017-7-25'

精确到每小时

SELECT CURDATE() - INTERVAL 1 DAY AS '昨天',
IFNULL(SUM(CASE HOUR(FROM_UNIXTIME(user_registered,'%Y-%M-%D %H:%I:%S')) WHEN 0 THEN 1 ELSE 0 END),0) AS '0',
IFNULL(SUM(CASE HOUR(FROM_UNIXTIME(user_registered,'%Y-%M-%D %H:%I:%S')) WHEN 1 THEN 1 ELSE 0 END),0) AS '1',
IFNULL(SUM(CASE HOUR(FROM_UNIXTIME(user_registered,'%Y-%M-%D %H:%I:%S')) WHEN 2 THEN 1 ELSE 0 END),0) AS '2',
IFNULL(SUM(CASE HOUR(FROM_UNIXTIME(user_registered,'%Y-%M-%D %H:%I:%S')) WHEN 3 THEN 1 ELSE 0 END),0) AS '3',
IFNULL(SUM(CASE HOUR(FROM_UNIXTIME(user_registered,'%Y-%M-%D %H:%I:%S')) WHEN 4 THEN 1 ELSE 0 END),0) AS '4',
IFNULL(SUM(CASE HOUR(FROM_UNIXTIME(user_registered,'%Y-%M-%D %H:%I:%S')) WHEN 5 THEN 1 ELSE 0 END),0) AS '5',
IFNULL(SUM(CASE HOUR(FROM_UNIXTIME(user_registered,'%Y-%M-%D %H:%I:%S')) WHEN 6 THEN 1 ELSE 0 END),0) AS '6',
IFNULL(SUM(CASE HOUR(FROM_UNIXTIME(user_registered,'%Y-%M-%D %H:%I:%S')) WHEN 7 THEN 1 ELSE 0 END),0) AS '7',
IFNULL(SUM(CASE HOUR(FROM_UNIXTIME(user_registered,'%Y-%M-%D %H:%I:%S')) WHEN 8 THEN 1 ELSE 0 END),0) AS '8',
IFNULL(SUM(CASE HOUR(FROM_UNIXTIME(user_registered,'%Y-%M-%D %H:%I:%S')) WHEN 9 THEN 1 ELSE 0 END),0) AS '9',
IFNULL(SUM(CASE HOUR(FROM_UNIXTIME(user_registered,'%Y-%M-%D %H:%I:%S')) WHEN 10 THEN 1 ELSE 0 END),0) AS '10',
IFNULL(SUM(CASE HOUR(FROM_UNIXTIME(user_registered,'%Y-%M-%D %H:%I:%S')) WHEN 11 THEN 1 ELSE 0 END),0) AS '11',
IFNULL(SUM(CASE HOUR(FROM_UNIXTIME(user_registered,'%Y-%M-%D %H:%I:%S')) WHEN 12 THEN 1 ELSE 0 END),0) AS '12',
IFNULL(SUM(CASE HOUR(FROM_UNIXTIME(user_registered,'%Y-%M-%D %H:%I:%S')) WHEN 13 THEN 1 ELSE 0 END),0) AS '13',
IFNULL(SUM(CASE HOUR(FROM_UNIXTIME(user_registered,'%Y-%M-%D %H:%I:%S')) WHEN 14 THEN 1 ELSE 0 END),0) AS '14',
IFNULL(SUM(CASE HOUR(FROM_UNIXTIME(user_registered,'%Y-%M-%D %H:%I:%S')) WHEN 15 THEN 1 ELSE 0 END),0) AS '15',
IFNULL(SUM(CASE HOUR(FROM_UNIXTIME(user_registered,'%Y-%M-%D %H:%I:%S')) WHEN 16 THEN 1 ELSE 0 END),0) AS '16',
IFNULL(SUM(CASE HOUR(FROM_UNIXTIME(user_registered,'%Y-%M-%D %H:%I:%S')) WHEN 17 THEN 1 ELSE 0 END),0) AS '17',
IFNULL(SUM(CASE HOUR(FROM_UNIXTIME(user_registered,'%Y-%M-%D %H:%I:%S')) WHEN 18 THEN 1 ELSE 0 END),0) AS '18',
IFNULL(SUM(CASE HOUR(FROM_UNIXTIME(user_registered,'%Y-%M-%D %H:%I:%S')) WHEN 19 THEN 1 ELSE 0 END),0) AS '19',
IFNULL(SUM(CASE HOUR(FROM_UNIXTIME(user_registered,'%Y-%M-%D %H:%I:%S')) WHEN 20 THEN 1 ELSE 0 END),0) AS '20',
IFNULL(SUM(CASE HOUR(FROM_UNIXTIME(user_registered,'%Y-%M-%D %H:%I:%S')) WHEN 21 THEN 1 ELSE 0 END),0) AS '21',
IFNULL(SUM(CASE HOUR(FROM_UNIXTIME(user_registered,'%Y-%M-%D %H:%I:%S')) WHEN 22 THEN 1 ELSE 0 END),0) AS '22',
IFNULL(SUM(CASE HOUR(FROM_UNIXTIME(user_registered,'%Y-%M-%D %H:%I:%S')) WHEN 23 THEN 1 ELSE 0 END),0) AS '23'
FROM wp_users
WHERE user_registered >= UNIX_TIMESTAMP(CURDATE() - INTERVAL 1 DAY)
AND user_registered < UNIX_TIMESTAMP(CURDATE())

timthumb需要主机支持GD库；
timthumb处理过程需要一定的服务器资源支持；
timthumb不支持外链图片；
timthumb出现过漏洞；
作者表示不再更新timthumb。
PHP略缩图神器.rar

唯一推荐的理由就是下载速度快永久分享

缺点
普通用户只能上传100M。

但是足够一般站长使用！

推荐地址:蓝奏云 https://lanzou.com/ 可能被部分渠道屏蔽无法登录或者其他问题等
无法登录使用这个地址 https://up.woozooo.com/