V2EX = way to explore
V2EX 是一个关于分享和探索的地方
现在注册
已注册用户请  登录
V2EX  ›  nvhanzhi  ›  全部回复第 10 页 / 共 12 页
回复总数  221
1 ... 2  3  4  5  6  7  8  9  10  11 ... 12  
2018-07-27 22:48:15 +08:00
回复了 145431 创建的主题 问与答 如何一部手机注册多个微信?
google voice 要绑定美国的手机号的,否则不能使用,淘宝所有卖 google voice 的都是骗子。
2018-07-27 10:31:42 +08:00
回复了 yyn618 创建的主题 Android 各位 V 友们 给推荐个备用机呗 日常使用 千元即可
千万不要买 360,,,纯粹是广告机,各种给你下软件,返利广告更是多到恶心!
2018-07-24 23:01:11 +08:00
回复了 nvhanzhi 创建的主题 MySQL 网站数据库经常挂,小白求助!
已开 Swap,谢谢所有大神!@all @Mac @Mazexal @agdhole @chinvo @falcon05 @jasonyang9 @jeffsun @lhy360121 @likuku @my3157 @stevenkang @salamanderMH

[root@i~]# free -h
total used free shared buff/cache available
Mem: 3.7G 1.4G 867M 49M 1.4G 2.0G
Swap: 7.8G 10M 7.8G
2018-07-24 18:50:59 +08:00
回复了 nvhanzhi 创建的主题 MySQL 网站数据库经常挂,小白求助!
Filesystem Size Used Avail Capacity iused ifree %iused Mounted on
/dev/disk1s1 466Gi 433Gi 28Gi 95% 2051882 9223372036852723925 0% /
/dev/disk1s4 466Gi 4.0Gi 28Gi 13% 4 9223372036854775803 0% /private/var/vm

搞不懂我的硬盘还有多少。。。
2018-07-23 23:10:51 +08:00
回复了 nvhanzhi 创建的主题 MySQL 网站数据库经常挂,小白求助!
@Mac myisam 完全没了解过,今天先看看情况,实在不行就试试 myisam,多谢了!
2018-07-23 23:07:11 +08:00
回复了 nvhanzhi 创建的主题 MySQL 网站数据库经常挂,小白求助!
@my3157 我的云盘是 100G 的,不知道现在用了多少,应该不超过 50G,我的图片什么的都是阿里云 OSS 上,服务器上就网站备份比较占空间
2018-07-23 23:05:53 +08:00
回复了 nvhanzhi 创建的主题 MySQL 网站数据库经常挂,小白求助!
@my3157 好 ,我把 innodb_buffer_pool_size 改成 256 了,要是还经常挂我就搞 8G 的 swap 试试。谢谢你!
2018-07-23 22:56:07 +08:00
回复了 nvhanzhi 创建的主题 MySQL 网站数据库经常挂,小白求助!
又挂了。。。
Error establishing a database connection
This either means that the username and password information in your wp-config.php file is incorrect or we can ’ t contact the database server at 127.0.0.1. This could mean your host ’ s database server is down.

Are you sure you have the correct username and password?
Are you sure that you have typed the correct hostname?
Are you sure that the database server is running?
If you ’ re unsure what these terms mean you should probably contact your host. If you still need help you can always visit the WordPress Support Forums.
2018-07-23 21:50:01 +08:00
回复了 nvhanzhi 创建的主题 MySQL 网站数据库经常挂,小白求助!
@likuku 淘宝同行竞争不过啊,人家都做 10 年了
2018-07-23 21:40:47 +08:00
回复了 nvhanzhi 创建的主题 MySQL 网站数据库经常挂,小白求助!
@likuku 我研究研究吧 先去备份网站。。。问题是网站不赚钱啊。。。
2018-07-23 21:25:19 +08:00
回复了 nvhanzhi 创建的主题 MySQL 网站数据库经常挂,小白求助!
@jeffsun @torment5524 @likuku @falcon05 我网站有 5 万多商品,每天流量两三千,IP1000 多。
@my3157 是的,只有一个盘
@likuku 买阿里云的 RDS 服务我 2 核 4G 的服务器一天要 24 块多,一年 8760,包年也要 5000 多,明显不划算啊。
2018-07-23 16:14:56 +08:00
回复了 nvhanzhi 创建的主题 MySQL 网站数据库经常挂,小白求助!
@opengps 我不懂怎样把我的 MySQL 的数据库搞到阿里云上去。。。现在是 Wordpress 直接搞的
2018-07-23 16:01:43 +08:00
回复了 nvhanzhi 创建的主题 MySQL 网站数据库经常挂,小白求助!
@likuku 改成了 512 再不行我就按这个设置 swap https://www.k2zone.cn/?p=1182

其实我不懂 innodb_buffer_pool_size 的大小具体有啥用,为什么要设置的小而不是大?
2018-07-23 15:50:06 +08:00
回复了 nvhanzhi 创建的主题 MySQL 网站数据库经常挂,小白求助!
@torment5524 我前几天 innodb_buffer_pool_size 是 1g 也挂啊。。。
2018-07-23 15:37:34 +08:00
回复了 nvhanzhi 创建的主题 MySQL 网站数据库经常挂,小白求助!
@torment5524 # free
total used free shared buff/cache available
Mem: 3881936 2122264 859316 57784 900356 1465352
Swap: 0 0 0


@chinvo 用 InnoDB 要开 swap
我不知道 InnoDB 在哪里,这是个什么东西
2018-07-23 15:26:45 +08:00
回复了 nvhanzhi 创建的主题 MySQL 网站数据库经常挂,小白求助!
@torment5524 我看不懂日志,日志比较大。。。 我的网站是 Wordpress
2018-07-23 15:24:34 +08:00
回复了 nvhanzhi 创建的主题 MySQL 网站数据库经常挂,小白求助!
2018-07-23 14:48:03 9667 [Note] InnoDB: 128 rollback segment(s) are active.
2018-07-23 14:48:03 9667 [Note] InnoDB: Waiting for purge to start
2018-07-23 14:48:03 9667 [Note] InnoDB: 5.6.36 started; log sequence number 123224907401
2018-07-23 14:48:03 9667 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2018-07-23 14:48:03 9667 [Note] - '0.0.0.0' resolves to '0.0.0.0';
2018-07-23 14:48:03 9667 [Note] Server socket created on IP: '0.0.0.0'.
2018-07-23 14:48:04 9667 [Note] Event Scheduler: Loaded 0 events
2018-07-23 14:48:04 9667 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.6.36-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL)
2018-07-23 14:48:18 9733 [Warning] You need to use --log-bin to make --binlog-format work.
2018-07-23 14:48:18 9733 [Note] Plugin 'FEDERATED' is disabled.
2018-07-23 14:48:18 9733 [Note] InnoDB: Using atomics to ref count buffer pool pages
2018-07-23 14:48:18 9733 [Note] InnoDB: The InnoDB memory heap is disabled
2018-07-23 14:48:18 9733 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-07-23 14:48:18 9733 [Note] InnoDB: Memory barrier is not used
2018-07-23 14:48:18 9733 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-07-23 14:48:18 9733 [Note] InnoDB: Using Linux native AIO
2018-07-23 14:48:18 9733 [Note] InnoDB: Using CPU crc32 instructions
2018-07-23 14:48:18 9733 [Note] InnoDB: Initializing buffer pool, size = 2.0G
2018-07-23 14:48:18 9733 [Note] InnoDB: Completed initialization of buffer pool
2018-07-23 14:48:18 9733 [Note] InnoDB: Highest supported file format is Barracuda.
2018-07-23 14:48:18 9733 [Note] InnoDB: Log scan progressed past the checkpoint lsn 123225057677
2018-07-23 14:48:18 9733 [Note] InnoDB: Database was not shutdown normally!
2018-07-23 14:48:18 9733 [Note] InnoDB: Starting crash recovery.
2018-07-23 14:48:18 9733 [Note] InnoDB: Reading tablespace information from the .ibd files...
2018-07-23 14:48:18 9733 [Note] InnoDB: Restoring possible half-written data pages
2018-07-23 14:48:18 9733 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 123225090259
2018-07-23 14:48:19 9733 [Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 84149106, file name mysql-bin.000004
2018-07-23 14:48:19 9733 [Note] InnoDB: 128 rollback segment(s) are active.
2018-07-23 14:48:19 9733 [Note] InnoDB: Waiting for purge to start
2018-07-23 14:48:19 9733 [Note] InnoDB: 5.6.36 started; log sequence number 123225090259
2018-07-23 14:48:19 9733 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2018-07-23 14:48:19 9733 [Note] - '0.0.0.0' resolves to '0.0.0.0';
2018-07-23 14:48:19 9733 [Note] Server socket created on IP: '0.0.0.0'.
2018-07-23 14:48:20 9733 [Note] Event Scheduler: Loaded 0 events
2018-07-23 14:48:20 9733 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.6.36-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL)
2018-07-23 14:48:26 9777 [Warning] You need to use --log-bin to make --binlog-format work.
2018-07-23 14:48:26 9777 [Note] Plugin 'FEDERATED' is disabled.
2018-07-23 14:48:26 9777 [Note] InnoDB: Using atomics to ref count buffer pool pages
2018-07-23 14:48:26 9777 [Note] InnoDB: The InnoDB memory heap is disabled
2018-07-23 14:48:26 9777 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-07-23 14:48:26 9777 [Note] InnoDB: Memory barrier is not used
2018-07-23 14:48:26 9777 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-07-23 14:48:26 9777 [Note] InnoDB: Using Linux native AIO
2018-07-23 14:48:26 9777 [Note] InnoDB: Using CPU crc32 instructions
2018-07-23 14:48:26 9777 [Note] InnoDB: Initializing buffer pool, size = 2.0G
InnoDB: mmap(274726912 bytes) failed; errno 12
2018-07-23 14:48:26 9777 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2018-07-23 14:48:26 9777 [ERROR] Plugin 'InnoDB' init function returned error.
2018-07-23 14:48:26 9777 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2018-07-23 14:48:26 9777 [ERROR] Unknown/unsupported storage engine: InnoDB
2018-07-23 14:48:26 9777 [ERROR] Aborting
2018-07-23 15:23:09 +08:00
回复了 nvhanzhi 创建的主题 MySQL 网站数据库经常挂,小白求助!
@lhy360121

2018-07-23 14:56:20 11266 [Note] InnoDB: Restoring possible half-written data pages
2018-07-23 14:56:20 11266 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 123228603010
2018-07-23 14:56:20 11266 [Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 84149106, file name mysql-bin.000004
2018-07-23 14:56:21 11266 [Note] InnoDB: 128 rollback segment(s) are active.
2018-07-23 14:56:21 11266 [Note] InnoDB: Waiting for purge to start
2018-07-23 14:56:21 11266 [Note] InnoDB: 5.6.36 started; log sequence number 123228603010
2018-07-23 14:56:21 11266 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2018-07-23 14:56:21 11266 [Note] - '0.0.0.0' resolves to '0.0.0.0';
2018-07-23 14:56:21 11266 [Note] Server socket created on IP: '0.0.0.0'.
2018-07-23 14:56:21 11266 [Note] Event Scheduler: Loaded 0 events
2018-07-23 14:56:21 11266 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.6.36-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL)
2018-07-23 14:57:10 11308 [Warning] You need to use --log-bin to make --binlog-format work.
2018-07-23 14:57:10 11308 [Note] Plugin 'FEDERATED' is disabled.
2018-07-23 14:57:10 11308 [Note] InnoDB: Using atomics to ref count buffer pool pages
2018-07-23 14:57:10 11308 [Note] InnoDB: The InnoDB memory heap is disabled
2018-07-23 14:57:10 11308 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-07-23 14:57:10 11308 [Note] InnoDB: Memory barrier is not used
2018-07-23 14:57:10 11308 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-07-23 14:57:10 11308 [Note] InnoDB: Using Linux native AIO
2018-07-23 14:57:10 11308 [Note] InnoDB: Using CPU crc32 instructions
2018-07-23 14:57:10 11308 [Note] InnoDB: Initializing buffer pool, size = 2.0G
2018-07-23 14:57:10 11308 [Note] InnoDB: Completed initialization of buffer pool
2018-07-23 14:57:10 11308 [Note] InnoDB: Highest supported file format is Barracuda.
2018-07-23 14:57:10 11308 [Note] InnoDB: Log scan progressed past the checkpoint lsn 123229690053
2018-07-23 14:57:10 11308 [Note] InnoDB: Database was not shutdown normally!
2018-07-23 14:57:10 11308 [Note] InnoDB: Starting crash recovery.
2018-07-23 14:57:10 11308 [Note] InnoDB: Reading tablespace information from the .ibd files...
2018-07-23 14:57:10 11308 [Note] InnoDB: Restoring possible half-written data pages
2018-07-23 14:57:10 11308 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 123229980451
2018-07-23 14:57:11 11308 [Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 84149106, file name mysql-bin.000004
2018-07-23 14:57:11 11308 [Note] InnoDB: 128 rollback segment(s) are active.
2018-07-23 14:57:11 11308 [Note] InnoDB: Waiting for purge to start
2018-07-23 14:57:11 11308 [Note] InnoDB: 5.6.36 started; log sequence number 123229980451
2018-07-23 14:57:11 11308 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2018-07-23 14:57:11 11308 [Note] - '0.0.0.0' resolves to '0.0.0.0';
2018-07-23 14:57:11 11308 [Note] Server socket created on IP: '0.0.0.0'.
2018-07-23 14:57:11 11308 [Note] Event Scheduler: Loaded 0 events
2018-07-23 14:57:11 11308 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.6.36-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL)
2018-07-23 15:20:41 +08:00
回复了 nvhanzhi 创建的主题 问与答 新浪微博的 ifttt 接口不通了???
又不行了,挖坟。。。!
2018-07-23 15:19:41 +08:00
回复了 nvhanzhi 创建的主题 MySQL 网站数据库经常挂,小白求助!
@lhy360121 日志里啥都没有啊,我把操作日志文件删除了,把 localhost 改成 127.0.0.1 了 也没有作用
1 ... 2  3  4  5  6  7  8  9  10  11 ... 12  
关于   ·   帮助文档   ·   博客   ·   API   ·   FAQ   ·   我们的愿景   ·   实用小工具   ·   3326 人在线   最高记录 6543   ·     Select Language
创意工作者们的社区
World is powered by solitude
VERSION: 3.9.8.5 · 311ms · UTC 14:02 · PVG 22:02 · LAX 07:02 · JFK 10:02
Developed with CodeLauncher
♥ Do have faith in what you're doing.