search
HomeDatabaseMysql TutorialMySQL Cluster测试过程中的错误汇总--ERROR 1296 (HY000)等等_MySQL

bitsCN.com

MySQL Cluster测试过程中的错误汇总--ERROR 1296 (HY000)等等

 

========================================【1】查看表空间数据文件大小-- ============================================================================= mysql>SELECT TABLESPACE_NAME, FILE_NAME, EXTENT_SIZE*TOTAL_EXTENTS/1024/1024 AS TOTAL_MB, EXTENT_SIZE*FREE_EXTENTS/1024/1024 AS FREE_MB, EXTRA FROM information_schema.FILES WHERE FILE_TYPE="DATAFILE";+-----------------+------------+----------------+----------------+----------------+| TABLESPACE_NAME | FILE_NAME  | TOTAL_MB       | FREE_MB        | EXTRA          |+-----------------+------------+----------------+----------------+----------------+| ts_1            | data_2.dat | 10240.00000000 | 10146.00000000 | CLUSTER_NODE=4 || ts_1            | data_2.dat | 10240.00000000 | 10146.00000000 | CLUSTER_NODE=5 || ts_1            | data_2.dat | 10240.00000000 | 10146.00000000 | CLUSTER_NODE=6 || ts_1            | data_2.dat | 10240.00000000 | 10162.00000000 | CLUSTER_NODE=7 || ts_1            | data_1.dat |   512.00000000 |    19.00000000 | CLUSTER_NODE=4 || ts_1            | data_1.dat |   512.00000000 |    19.00000000 | CLUSTER_NODE=5 || ts_1            | data_1.dat |   512.00000000 |    16.00000000 | CLUSTER_NODE=6 || ts_1            | data_1.dat |   512.00000000 |     0.00000000 | CLUSTER_NODE=7 |+-----------------+------------+----------------+----------------+----------------+ -- ============================【2】:建库报错mysql> CREATE DATABASE zhang;Query OK, 1 row affected, 2 warnings (0.01 sec)mysql> mysql> mysql> mysql> show warnings;+---------+------+----------------------------------------------------------------------------------+| Level   | Code | Message                                                                          |+---------+------+----------------------------------------------------------------------------------+| Warning | 1296 | Got error 4009 'Cluster Failure' from NDB. Could not acquire global schema lock  || Warning | 1296 | Got error 4009 'Cluster Failure' from Could not log query '%s' on other mysqld's |+---------+------+----------------------------------------------------------------------------------+2 rows in set (0.00 sec)【ok】安全模式启动/usr/local/mysql/bin/mysqld_safe &-- ==============================【3】ERROR 1296 (HY000): Got error 157 'Unknown error code' from NDBCLUSTERmysql> use bg;Database changedmysql> mysql> mysql> show create table bgt1;ERROR 1296 (HY000): Got error 157 'Unknown error code' from NDBCLUSTERmysql> mysql> mysql> mysql> mysql> mysql> show create table bgt1;ERROR 1296 (HY000): Got error 157 'Unknown error code' from NDBCLUSTERmysql> mysql> mysql> create table bgt2(id int,name varchar(20))engine=ndb;ERROR 1005 (HY000): Can't create table 'bg.bgt2' (errno: 157)【ok】之后关闭sql节点,重新启动,搞定了![root@banggo data]# /etc/rc.d/init.d/mysqld stopShutting down MySQL....                                    [确定][root@banggo data]# /etc/rc.d/init.d/mysqld startStarting MySQL...                                          [确定][root@banggo data]# mysqlWelcome to the MySQL monitor.  Commands end with ; or /g.Your MySQL connection id is 2Server version: 5.5.19-ndb-7.2.4-gpl MySQL Cluster Community Server (GPL)Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '/h' for help. Type '/c' to clear the current input statement.mysql> use bg;Database changedmysql> show tables;+--------------+| Tables_in_bg |+--------------+| bgt1         |+--------------+1 row in set (0.03 sec)mysql> desc bgt1;+-------+-------------+------+-----+---------+-------+| Field | Type        | Null | Key | Default | Extra |+-------+-------------+------+-----+---------+-------+| id    | int(11)     | NO   | PRI | 0       |       || name  | varchar(20) | YES  |     | NULL    |       |+-------+-------------+------+-----+---------+-------+2 rows in set (0.02 sec)-- =============================================================================【4】ERROR 1296 (HY000): Got error 157 'Unknown error code' from NDBCLUSTER-- =============================================================================2012-07-18 09:58:15 [MgmtSrvr] WARNING  -- Failed to allocate nodeid for API at 10.100.200.41. Returned eror: 'No free node id found for mysqld(API).'2012-07-18 09:58:16 [MgmtSrvr] WARNING  -- Failed to allocate nodeid for API at 10.100.200.39. Returned eror: 'No free node id found for mysqld(API).'2012-07-18 09:58:16 [MgmtSrvr] WARNING  -- Failed to allocate nodeid for API at 10.100.200.39. Returned eror: 'No free node id found for mysqld(API).'2012-07-18 09:58:17 [MgmtSrvr] WARNING  -- Failed to allocate nodeid for API at 10.100.200.41. Returned eror: 'No free node id found for mysqld(API).'2012-07-18 09:58:17 [MgmtSrvr] WARNING  -- Failed to allocate nodeid for API at 10.100.200.41. Returned eror: 'No free node id found for mysqld(API).'2012-07-18 09:58:18 [MgmtSrvr] WARNING  -- Failed to allocate nodeid for API at 10.100.200.39. Returned eror: 'No free node id found for mysqld(API).'2012-07-18 09:58:18 [MgmtSrvr] WARNING  -- Failed to allocate nodeid for API at 10.100.200.39. Returned eror: 'No free node id found for mysqld(API).'2012-07-18 09:58:19 [MgmtSrvr] WARNING  -- Failed to allocate nodeid for API at 10.100.200.41. Returned eror: 'No free node id found for mysqld(API).'2012-07-18 09:58:19 [MgmtSrvr] WARNING  -- Failed to allocate nodeid for API at 10.100.200.41. Returned eror: 'No free node id found for mysqld(API).'2012-07-18 09:58:20 [MgmtSrvr] WARNING  -- Failed to allocate nodeid for API at 10.100.200.39. Returned eror: 'No free node id found for mysqld(API).'【ok】:在config.ini里面加空的sql节点,以便自动扩展s[API][API]-- =============================================================================【5】数据节点报错-- =============================================================================2012-07-18 23:34:48 [ndbd] INFO     -- Start initiated (mysql-5.5.19 ndb-7.2.4)NDBFS/AsyncFile: Allocating 310392 for In/Deflate bufferAdding 7164Mb to ZONE_LO (32896,229247)Adding 4301Mb to ZONE_LO (262145,137607)NDBFS/AsyncFile: Allocating 310392 for In/Deflate bufferNDBFS/AsyncFile: Allocating 310392 for In/Deflate bufferNDBFS/AsyncFile: Allocating 310392 for In/Deflate bufferNDBFS/AsyncFile: Allocating 310392 for In/Deflate bufferNDBFS/AsyncFile: Allocating 310392 for In/Deflate bufferNDBFS/AsyncFile: Allocating 310392 for In/Deflate bufferNDBFS/AsyncFile: Allocating 310392 for In/Deflate bufferNDBFS/AsyncFile: Allocating 310392 for In/Deflate bufferNDBFS/AsyncFile: Allocating 310392 for In/Deflate bufferNDBFS/AsyncFile: Allocating 310392 for In/Deflate bufferNDBFS/AsyncFile: Allocating 310392 for In/Deflate bufferNDBFS/AsyncFile: Allocating 310392 for In/Deflate bufferWOPool::init(61, 9)RWPool::init(22, 14)2012-07-18 23:35:00 [ndbd] INFO     -- timerHandlingLab now: 12658118985 sent: 12658118306 diff: 6792012-07-18 23:36:09 [ndbd] WARNING  -- Ndb kernel thread 0 is stuck in: Allocating memory elapsed=600292012-07-18 23:36:09 [ndbd] INFO     -- Watchdog: User time: 244  System time: 68552012-07-18 23:36:35 [ndbd] ALERT    -- Node 4: Forced node shutdown completed. Occured during startphase 0. Initiated by signal 9.【ok】:调整参数值调小参数,内存超过了。-- =============================================================================【6】建立表空间报错-- =============================================================================mysql> CREATE LOGFILE GROUP lg_1 ADD UNDOFILE 'undo_1.log' INITIAL_SIZE 1024 M UNDO_BUFFER_SIZE 128 M ENGINE NDBCLUSTER;ERROR 1064 (42000): 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 'M UNDO_BUFFER_SIZE 128 M ENGINE NDBCLUSTER' at line 1mysql> 【ok】M不识别-- CREATE LOGFILE GROUP lg_1 ADD UNDOFILE 'undo_1.log' INITIAL_SIZE 536870912 UNDO_BUFFER_SIZE 67108864 ENGINE NDBCLUSTER;mysql> CREATE LOGFILE GROUP lg_1 ADD UNDOFILE 'undo_1.log' INITIAL_SIZE 536870912 UNDO_BUFFER_SIZE 67108864 ENGINE NDBCLUSTER;Query OK, 0 rows affected (27.95 sec)-- CREATE TABLESPACE ts_1  ADD DATAFILE 'data_1.dat' USE LOGFILE GROUP lg_1 INITIAL_SIZE 536870912 ENGINE NDBCLUSTER; mysql> CREATE TABLESPACE ts_1  ADD DATAFILE 'data_1.dat' USE LOGFILE GROUP lg_1 INITIAL_SIZE 536870912 ENGINE NDBCLUSTER; Query OK, 0 rows affected (28.79 sec) # 创建使用磁盘存储的表:CREATE TABLE `bgtdisk` (      `Name` varchar(50) NOT NULL,  `ProviderName` varchar(200) NOT NULL,  PRIMARY KEY (`Name`)) tablespace ts_1 storage disk ENGINE=ndbcluster DEFAULT CHARSET=utf8;-- =============================================================================【7】配置报错-- =============================================================================Caused by error 2353: 'Insufficent nodes for system restart(Restart error). Temporary error, restart node'.-- =============================================================================【8】ERROR 1528 (HY000): Failed to create LOGFILE GROUP-- =============================================================================mysql> CREATE LOGFILE GROUP lg_02 ADD UNDOFILE 'undo_02.log' INITIAL_SIZE 5368709120         UNDO_BUFFER_SIZE 67108864       ENGINE NDBCLUSTER; ERROR 1528 (HY000): Failed to create LOGFILE GROUPmysql> mysql> mysql> mysql> show errors;+-------+------+--------------------------------+| Level | Code | Message                        |+-------+------+--------------------------------+| Error | 1528 | Failed to create LOGFILE GROUP |+-------+------+--------------------------------+1 row in set (0.00 sec)mysql> []解决办法:原来现在的MYSQL只支持创建一个LOGFILE GROUP文件。只有删掉原来的才可以创建新的。-- =============================================================================【9】ERROR 1114 (HY000): The table 'UserMvpbak' is full-- =============================================================================mysql> insert into UserMvpbak select * from UserMvp limit 800000,200000;ERROR 1114 (HY000): The table 'UserMvpbak' is fullmysql> alter tablespace ts_1         add datafile 'data_15.dat'         initial_size 10737418240           engine ndb;  【ok】原有的数据文件空间满了,需要增加新的数据文件   mysql> alter tablespace ts_1    ->      add datafile 'data_2.dat'    ->      initial_size 10737418240    ->      engine ndb;Query OK, 0 rows affected (1 min 54.30 sec)mysql>  insert into bguserdb.UserPoints_2012 select * from test.UserPoints_2012 limit 1200000,300000;ERROR 1114 (HY000): The table 'UserPoints_2012' is fullalter tablespace ts_1         add datafile 'data_16.dat'         initial_size 10737418240           engine ndb;mysql> -- =============================================================================【10】ERROR 1114 (HY000): The table 'UserMvpbak' is full-- =============================================================================mysql> insert into UserMvpbak select * from UserMvp limit 940000,3000000;ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transactionmysql> [ok]mysql> replace into UserMvpbak select * from UserMvp limit 940000,800000;       Query OK, 755105 rows affected (2 min 44.54 sec)Records: 755105  Duplicates: 0  Warnings: 0-- =============================================================================【11】Node 4: Forced node shutdown completed. Occured during startphase 0. Initiated by signal 11.-- =============================================================================2012-08-15 12:35:38 [ndbd] INFO     -- Start initiated (mysql-5.5.25 ndb-7.2.7)NDBFS/AsyncFile: Allocating 310392 for In/Deflate buffer2012-08-15 12:35:45 [ndbd] WARNING  -- Ndb kernel thread 0 is stuck in: Polling for Receive elapsed=1592012-08-15 12:35:45 [ndbd] INFO     -- timerHandlingLab now: 498814955 sent: 498814782 diff: 1732012-08-15 12:35:45 [ndbd] INFO     -- Watchdog: User time: 28  System time: 4972012-08-15 12:35:47 [ndbd] INFO     -- timerHandlingLab now: 498816970 sent: 498816803 diff: 1672012-08-15 12:35:49 [ndbd] INFO     -- Watchdog: User time: 39  System time: 7412012-08-15 12:35:49 [ndbd] WARNING  -- Watchdog: Warning overslept 262 ms, expected 100 ms.2012-08-15 12:35:49 [ndbd] INFO     -- timerHandlingLab now: 498818963 sent: 498818779 diff: 184Adding 5201Mb to ZONE_LO (1152,166408)NDBFS/AsyncFile: Allocating 310392 for In/Deflate bufferNDBFS/AsyncFile: Allocating 310392 for In/Deflate bufferNDBFS/AsyncFile: Allocating 310392 for In/Deflate bufferNDBFS/AsyncFile: Allocating 310392 for In/Deflate bufferNDBFS/AsyncFile: Allocating 310392 for In/Deflate bufferNDBFS/AsyncFile: Allocating 310392 for In/Deflate bufferNDBFS/AsyncFile: Allocating 310392 for In/Deflate bufferNDBFS/AsyncFile: Allocating 310392 for In/Deflate bufferNDBFS/AsyncFile: Allocating 310392 for In/Deflate bufferNDBFS/AsyncFile: Allocating 310392 for In/Deflate bufferNDBFS/AsyncFile: Allocating 310392 for In/Deflate bufferNDBFS/AsyncFile: Allocating 310392 for In/Deflate bufferNDBFS/AsyncFile: Allocating 310392 for In/Deflate bufferNDBFS/AsyncFile: Allocating 310392 for In/Deflate bufferNDBFS/AsyncFile: Allocating 310392 for In/Deflate bufferNDBFS/AsyncFile: Allocating 310392 for In/Deflate bufferNDBFS/AsyncFile: Allocating 310392 for In/Deflate bufferNDBFS/AsyncFile: Allocating 310392 for In/Deflate bufferNDBFS/AsyncFile: Allocating 310392 for In/Deflate bufferNDBFS/AsyncFile: Allocating 310392 for In/Deflate bufferNDBFS/AsyncFile: Allocating 310392 for In/Deflate bufferNDBFS/AsyncFile: Allocating 310392 for In/Deflate bufferNDBFS/AsyncFile: Allocating 310392 for In/Deflate bufferNDBFS/AsyncFile: Allocating 310392 for In/Deflate bufferNDBFS/AsyncFile: Allocating 310392 for In/Deflate bufferNDBFS/AsyncFile: Allocating 310392 for In/Deflate bufferNDBFS/AsyncFile: Allocating 310392 for In/Deflate buffer2012-08-15 12:35:56 [ndbd] WARNING  -- Ndb kernel thread 0 is stuck in: Allocating memory elapsed=60022012-08-15 12:35:56 [ndbd] INFO     -- Watchdog: User time: 61  System time: 11792012-08-15 12:36:02 [ndbd] WARNING  -- Ndb kernel thread 0 is stuck in: Allocating memory elapsed=120062012-08-15 12:36:02 [ndbd] INFO     -- Watchdog: User time: 64  System time: 17632012-08-15 12:36:08 [ndbd] WARNING  -- Ndb kernel thread 0 is stuck in: Allocating memory elapsed=180302012-08-15 12:36:08 [ndbd] INFO     -- Watchdog: User time: 70  System time: 19572012-08-15 12:36:12 [ndbd] ALERT    -- Node 4: Forced node shutdown completed. Occured during startphase 0. Initiated by signal 11.[ok] 注释如下三个参数,启动ok!#MaxNoOfConcurrentTransactions=100000#MaxNoOfConcurrentOperations=10000000#MaxNoOfLocalOperations=11000000-- =============================================================================【12】启动管理节点报错-- =============================================================================[root@banggo mysql-cluster]# ndb_mgmd -f /usr/local/mysql/cluster-conf/config.ini --reloadMySQL Cluster Management Server mysql-5.5.25 ndb-7.2.72012-08-15 21:36:54 [MgmtSrvr] ERROR    -- at line 18: Illegal value 128 for parameter LockPagesInMainMemory.Legal values are between 0 and 22012-08-15 21:36:54 [MgmtSrvr] ERROR    -- at line 18: Could not parse name-value pair in config file.2012-08-15 21:36:54 [MgmtSrvr] ERROR    -- Could not load configuration from '/usr/local/mysql/cluster-conf/config.ini'2012-08-15 21:36:54 [MgmtSrvr] ERROR    -- Could not determine which nodeid to use for this node. Specify it with --ndb-nodeid=<nodeid> on command line[root@banggo mysql-cluster]# [root@banggo mysql-cluster]# 【ok】LockPagesInMainMemory值设置太大了!改成默认的1吧。 -- =============================================================================【13】 1528 错误-- =============================================================================mysql> CREATE LOGFILE GROUP lg_1    -> ADD UNDOFILE 'undo_2.log'    -> INITIAL_SIZE 634217728     ->  UNDO_BUFFER_SIZE 134217728          -> ENGINE NDBCLUSTER;ERROR 1528 (HY000): Failed to create LOGFILE GROUPmysql> mysql> mysql> mysql> show warnings;+---------+------+---------------------------------------------------+| Level   | Code | Message                                           |+---------+------+---------------------------------------------------+| Warning | 1296 | Got error 1504 'Out of logbuffer memory' from NDB || Error   | 1528 | Failed to create LOGFILE GROUP                    |+---------+------+---------------------------------------------------+2 rows in set (0.00 sec)【ok】# UNDO_BUFFER_SIZE不能超过config.ini的配置RedoBuffer=32M大小,否则创建失败,CREATE LOGFILE GROUP lg_1ADD UNDOFILE 'undo_1.log'INITIAL_SIZE 634217728 UNDO_BUFFER_SIZE 33554432      ENGINE NDBCLUSTER;CREATE TABLESPACE ts_1       ADD DATAFILE 'data_10.dat'       USE LOGFILE GROUP lg_1       INITIAL_SIZE 32212254720  EXTENT_SIZE 33554432       ENGINE NDBCLUSTER;  执行结束之后,需要去数据目录/var/lib/mysql-cluster/里面看看undo文件和data文件,如果存在,那么就证明建立成功了。可以建立2个表空间CREATE TABLESPACE ts_2       ADD DATAFILE 'data_20.dat'       USE LOGFILE GROUP lg_1       INITIAL_SIZE 10737418240  EXTENT_SIZE 33554432       ENGINE NDBCLUSTER;    create table bguserdb.mcbak like test.MvpCard;  alter table bguserdb.mcbak tablespace ts_1 storage disk ENGINE=ndbcluster DEFAULT CHARSET=utf8;  insert into bguserdb.mcbak select * from test.MvpCard;    CREATE TABLESPACE ts_1       ADD DATAFILE 'data_10.dat‘ USE LOGFILE GROUP lg_1 INITIAL_SIZE 32212254720  EXTENT_SIZE 33554432 ENGINE NDBCLUSTER;-- =============================================================================【14】 1528 错误-- ============================================================================= mysql> insert into bguserdb.MvpCard select * from test.MvpCard;ERROR 1297 (HY000): Got temporary error 410 'REDO log files overloaded (decrease TimeBetweenLocalCheckpoints or increase NoOfFragmentLogFiles)' from NDBCLUSTERmysql> 【】增加2个参数的值TimeBetweenLocalCheckpoints=30NoOfFragmentLogFiles=128-- =============================================================================【15】 1005 错误-- =============================================================================mysql>    create table bguserdb.mcbak like test.MvpCard;Query OK, 0 rows affected (0.07 sec)mysql>    alter table bguserdb.mcbak tablespace ts_1 storage disk ENGINE=ndbcluster DEFAULT CHARSET=utf8;ERROR 1005 (HY000): Can't create table 'bguserdb.#sql-14ab_2' (errno: 140)mysql> show errors;+-------+------+--------------------------------------------------------+| Level | Code | Message                                                |+-------+------+--------------------------------------------------------+| Error | 1005 | Can't create table 'bguserdb.#sql-14ab_2' (errno: 140) |+-------+------+--------------------------------------------------------+1 row in set (0.00 sec)mysql> show warnings;+---------+------+--------------------------------------------------------+| Level   | Code | Message                                                |+---------+------+--------------------------------------------------------+| Warning | 1296 | Got error 755 'Invalid tablespace' from NDB            || Error   | 1005 | Can't create table 'bguserdb.#sql-14ab_2' (errno: 140) |+---------+------+--------------------------------------------------------+2 rows in set (0.00 sec)mysql> 【ok】重新建立表空间:CREATE LOGFILE GROUP lg_1ADD UNDOFILE 'undo_1.log'INITIAL_SIZE 334217728 UNDO_BUFFER_SIZE 33554432      ENGINE NDBCLUSTER;CREATE TABLESPACE ts_1 ADD DATAFILE 'data_11.dat' USE LOGFILE GROUP lg_1 INITIAL_SIZE 4294967296 EXTENT_SIZE 33554432 ENGINE NDBCLUSTER;alter table bguserdb.MvpCard tablespace ts_1 storage disk ENGINE=ndbcluster DEFAULT CHARSET=utf8;insert into bguserdb.MvpCard select * from test.MvpCard limit 0,100000;-- =============================================================================【16】 1005 错误-- =============================================================================mysql> alter table order_infobak TABLESPACE ts_1 STORAGE DISK  ENGINE=ndbcluster DEFAULT CHARSET=utf8;ERROR 1005 (HY000): Can't create table 'openshop.#sql-711_3' (errno: 851)mysql> show warnings;+---------+------+---------------------------------------------------------------------------------------------------------------------+| Level   | Code | Message                                                                                                             |+---------+------+---------------------------------------------------------------------------------------------------------------------+| Warning | 1296 | Got error 851 'Maximum 8052 bytes of FIXED columns supported, use varchar or COLUMN_FORMAT DYNMIC instead' from NDB || Error   | 1005 | Can't create table 'openshop.#sql-711_3' (errno: 851)                                                               |+---------+------+---------------------------------------------------------------------------------------------------------------------+2 rows in set (0.00 sec)CREATE TABLE `order_xxxx` (  `order_sn` varchar(20) NOT NULL DEFAULT '' COMMENT '订单编号,唯一键',  `xx` tinyint(3) NOT NULL DEFAULT '1' COMMENT '交易类型 1:款到发货 2:货到付款 3:担保交易',  `xx` tinyint(1) DEFAULT '0' COMMENT '订单类型 0,正常订单 1,补发订单  2,换货订单',  `xxxxxx` varchar(30) DEFAULT '' COMMENT '关联换货单原订单号',  `xxxxxx` varchar(30) NOT NULL DEFAULT '' COMMENT '关联退单编号(该项目用来存放换货单时生成的退货单所对应的退单号)',  `xxxx` varchar(30) DEFAULT NULL COMMENT '关联退款单订单号(该项目用来存放换货时生成的退款单的对应退单号)',  `user_id` varchar(60) NOT NULL DEFAULT '' COMMENT '用户ID,关联user_users表的user_id',  `user_name` varchar(60) NOT NULL DEFAULT '' COMMENT '用户名',  `use_level` int(6) DEFAULT '0' COMMENT '下单时会员等级',  `xx` int(6) DEFAULT '0' COMMENT '下单时的淘宝拍拍会员等级',  `aa` varchar(60) NOT NULL DEFAULT '' COMMENT '收货人的姓名,用户页面填写,默认取值于表user_address',  `order_status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '订单状态  (0,未确认;1,已确认;2,已取消;3,无效;4,退货;5,锁定;6,解锁;7,完成;8,拒收;9,已合并;10,已拆分;)',  `aa` tinyint(3) NOT NULL DEFAULT '0' COMMENT '支付总状态(0,未付款;1,部分付款;2,已付款;3,已结算)',  `cc` tinyint(3) NOT NULL DEFAULT '0' COMMENT '发货总状态(0,未发货;1,备货中;2,部分发货;3,已发货;4,部分收货;5,客户已收货)',  `cc` int(11) NOT NULL DEFAULT '0' COMMENT '订单锁定状态(0,未锁定;1,已锁定)',  `ee` tinyint(1) NOT NULL DEFAULT '0' COMMENT '处理状态 (0 正常  1 挂起)',  `tt` tinyint(1) NOT NULL DEFAULT '0' COMMENT '问题单状态 (0 否  1 是)',  `notice_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '通知收款状态 (0 否  1 是)',  `timeout_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否超时单 (0 正常  1 超时)',  `depot_status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '分仓发货状态(0,未分仓 1,已分仓未通知 2,已分仓已通知)',  `return_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0未退货、1部分退货申请中、2退货申请中、3已部分退货、4已退货',  `refund_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0未退款、1部分退款申请中、2退款申请中、3已部分退款、4已退款',  `is_order_print` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否要发票',  `money_treatment_type` tinyint(1) DEFAULT '1' COMMENT '钱款处理方式:1.补款 2,退款 3,不补不退',  `order_from` varchar(20) NOT NULL DEFAULT '' COMMENT '订单来源',  `merge_from` varchar(255) DEFAULT NULL COMMENT '合并来源',  `split_to` varchar(255) DEFAULT NULL COMMENT '订单拆分为',  `split_from` varchar(255) DEFAULT '' COMMENT '由XX订单拆分生成',  `add_time` datetime DEFAULT NULL COMMENT '订单生成时间',  `confirm_time` datetime DEFAULT NULL COMMENT '订单确认时间',  `finish_time` datetime DEFAULT NULL COMMENT '订单完成时间',  `clear_time` datetime DEFAULT NULL COMMENT '订单结算时间',  `question_time` datetime DEFAULT NULL COMMENT '设为问题单时间',  `lock_time` datetime DEFAULT NULL COMMENT '订单锁定时间',  `update_time` datetime DEFAULT NULL COMMENT '订单最后更新时间',  `notice_time` datetime DEFAULT NULL COMMENT '通知收款时间',  `order_out_sn` varchar(255) NOT NULL DEFAULT '' COMMENT '外部交易号',  `beneficiary_id` mediumint(8) NOT NULL DEFAULT '0' COMMENT '受益人ID,如果开启提成功能',  `from_ad` smallint(5) NOT NULL DEFAULT '0' COMMENT '订单由某广告带来的广告id,应该取值于ad',  `pr_ids` varchar(255) NOT NULL DEFAULT '' COMMENT '参加了哪些促销',  `pr_name` varchar(255) NOT NULL DEFAULT '' COMMENT '参加促销的名字(多个)',  `referer` varchar(255) NOT NULL DEFAULT '' COMMENT '订单的来源媒体',  `how_oos` varchar(120) NOT NULL DEFAULT '' COMMENT '缺货处理方式,等待所有商品备齐后再发; 取消订单;与店主协商',  `hhh` varchar(30) NOT NULL DEFAULT '' COMMENT '通过活动购买的商品的代号;GROUP_BUY是团购AUCTION,是拍卖;SNATCH,夺宝奇兵;正常普通产品该处为空',  `extension_id` mediumint(8) NOT NULL DEFAULT '0' COMMENT '通过活动购买的物品的id,取值goods_activity;如果是正常普通商品,该处为0',  `is_separate` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0,未分成或等待分成;1,已分成;2,取消分成;',  `parent_id` mediumint(8) NOT NULL DEFAULT '0' COMMENT '能获得推荐分成的用户id,id取值于表users',  `outlet_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '代销类型(0无;1是代销;2是CPS)',  `jjj` varchar(250) DEFAULT NULL COMMENT 'CPS来源',  `inv_payee` varchar(120) NOT NULL DEFAULT '' COMMENT '发票抬头,用户页面填写',  `inv_content` varchar(120) NOT NULL DEFAULT '' COMMENT '发票内容,用户页面选择,取值shop_config的code字段的值为invoice_content的value',  `inv_type` varchar(60) NOT NULL DEFAULT '' COMMENT '发票类型,用户页面选择,取值shop_config的code字段的值为invoice_type的value',  `tax` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '发票税额',  `invoice_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '发票状态',  `delivery_station_id` int(10) NOT NULL DEFAULT '0' COMMENT '发票ID',  ......  `goods_count` int(11) NOT NULL DEFAULT '0' COMMENT '订单商品总数',  `discount` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '折扣金额',  `confirm_lasttime` datetime DEFAULT NULL COMMENT '订单确认期限',  `complete_lasttime` datetime DEFAULT NULL COMMENT '订单完成最后期限',  `settled_lasttime` datetime DEFAULT NULL COMMENT '结算最后期限',  `all_process_lasttime` datetime DEFAULT NULL COMMENT '订单全程处理期限',  `urgent_level` tinyint(3) NOT NULL DEFAULT '0' COMMENT '订单加急等级',  `period_series` int(8) NOT NULL DEFAULT '0' COMMENT '周期系列ID',  `to_buyer` varchar(255) NOT NULL COMMENT '商家给客户的留言,当该字段有值时可以在订单查询看到',  `chased_or_not` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否已追单(0 否  1 是)',  `is_agent` tinyint(2) DEFAULT '-1' COMMENT '是否代理换货',  `is_update` tinyint(1) DEFAULT '0' COMMENT '是否更新(ERP用)',  `update_type` varchar(255) DEFAULT NULL COMMENT '更新类型(ERP用)',  `last_update_time` datetime DEFAULT NULL COMMENT '最后更新时间(ERP用)',  `is_return` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否已退款(暂不使用)',  `return_fee` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '退款金额(暂不使用)',  `integral_money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '使用积分金额(暂不使用)',  `wait_pay` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否等待买家付款订单(0 否  1 是)(暂不使用)',  `tel` varchar(60) NOT NULL DEFAULT '' COMMENT '收货人的电话号码',  `mobile` varchar(60) NOT NULL DEFAULT '' COMMENT '收货人的手机号码',  `email` varchar(60) NOT NULL DEFAULT '' COMMENT '收货人的电子邮件',  `total_market_fee` decimal(10,2) NOT NULL DEFAULT '0.00',  `real_shipping_total_fee` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '真实的总快递费用,不免邮',  `cancel_code` varchar(20) NOT NULL DEFAULT '' COMMENT '取消原因编码',  `cancel_reason` varchar(20) NOT NULL DEFAULT '' COMMENT '取消原因名称',  `order_category` int(11) DEFAULT '1' COMMENT '订单种类 1:零售 2:物资领用 3:其它出库',  `reason` varchar(5) NOT NULL DEFAULT 'S' COMMENT '原因: S(零售) ;J (物资领用 ); T(其它出库 );', .......  PRIMARY KEY (`order_sn`),  KEY `user_id` (`user_id`),  KEY `order_from` (`order_from`),  KEY `order_out_sn` (`order_out_sn`),  KEY `order_status` (`order_status`),  KEY `addtime` (`add_time`),  KEY `is_update` (`is_update`),  KEY `relating_return_sn` (`relating_return_sn`),  KEY `confirm_lasttime` (`confirm_lasttime`),  KEY `complete_lasttime` (`complete_lasttime`),  KEY `settled_lasttime` (`settled_lasttime`),  KEY `all_process_lasttime` (`all_process_lasttime`),  KEY `in_consignee` (`consignee`),  KEY `in_last_update_time` (`last_update_time`),  KEY `in_source_code` (`source_code`)) TABLESPACE ts_1 STORAGE DISK  ENGINE=ndbcluster DEFAULT CHARSET=utf8 COMMENT='信息表';ERROR 1005 (HY000): Can't create table 'openshop.order_info' (errno: 851)mysql> show warnings;+---------+------+---------------------------------------------------------------------------------------------------------------------+| Level   | Code | Message                                                                                                             |+---------+------+---------------------------------------------------------------------------------------------------------------------+| Warning | 1296 | Got error 851 'Maximum 8052 bytes of FIXED columns supported, use varchar or COLUMN_FORMAT DYNMIC instead' from NDB || Error   | 1005 | Can't create table 'openshop.order_info' (errno: 851)                                                               |+---------+------+---------------------------------------------------------------------------------------------------------------------+2 rows in set (0.00 sec)[ok] ndb对表的varchar总长度有限制。-- =============================================================================【17】 1297 错误-- =============================================================================mysql> alter table ERP_BULK_ETL_FLAGE TABLESPACE ts_1 STORAGE DISK  ENGINE=ndbcluster DEFAULT CHARSET=utf8 comment '';ERROR 1297 (HY000): Got temporary error 1501 'Out of undo space' from NDBCLUSTERmysql> mysql> show errors;+-------+------+--------------------------------------------------------------+| Level | Code | Message                                                      |+-------+------+--------------------------------------------------------------+| Error | 1297 | Got temporary error 1501 'Out of undo space' from NDBCLUSTER || Error | 1296 | Got error 4350 'Transaction already aborted' from NDBCLUSTER || Error | 1180 | Got error 4350 during COMMIT                                 |+-------+------+--------------------------------------------------------------+3 rows in set (0.00 sec)mysql>[ok]1 增加数据文件,数据文件空间可能不够了。 alter tablespace ts_1 add datafile 'data_12.dat' initial_size 10737418240 engine NDBCLUSTER;alter tablespace ts_1 add datafile 'data_13.dat' initial_size 10737418240 engine NDBCLUSTER;alter tablespace ts_1 add datafile 'data_14.dat' initial_size 10737418240 engine NDBCLUSTER;2 增加undo文件alter LOGFILE GROUP lg_1 ADD UNDOFILE 'undo_21.log'  ENGINE NDBCLUSTER;-- =============================================================================【18】 1297 错误-- =============================================================================mysql> alter table account_adjust_users TABLESPACE ts_1 STORAGE DISK  ENGINE=ndbcluster DEFAULT CHARSET=utf8 comment '';ERROR 1297 (HY000): Got temporary error 1501 'Out of undo space' from NDBCLUSTERmysql> show warnings;+---------+------+--------------------------------------------------------------+| Level   | Code | Message                                                      |+---------+------+--------------------------------------------------------------+| Warning | 1297 | Got temporary error 1501 'Out of undo space' from NDB        || Error   | 1297 | Got temporary error 1501 'Out of undo space' from NDBCLUSTER || Warning | 1296 | Got error 4350 'Transaction already aborted' from NDB        || Error   | 1296 | Got error 4350 'Transaction already aborted' from NDBCLUSTER || Error   | 1180 | Got error 4350 during COMMIT                                 |+---------+------+--------------------------------------------------------------+5 rows in set (0.00 sec)mysql> -- =============================================================================【19】 1297 错误-- =============================================================================ndb_mgm> Node 7: Forced node shutdown completed. Occured during startphase 4. Caused by error 2303: 'System error, node killed during node restart by other node(Internal error, programming error or missing error message, please report a bug). Temporary error, restart node'.Node 4: Forced node shutdown completed. Occured during startphase 4. Caused by error 2308: 'Another node failed during system restart, please investigate error(s) on other node(s)(Restart error). Temporary error, restart node'.Node 5: Forced node shutdown completed. Occured during startphase 4. Caused by error 2308: 'Another node failed during system restart, please investigate error(s) on other node(s)(Restart error). Temporary error, restart node'.Node 6: Forced node shutdown completed. Occured during startphase 4. Caused by error 2308: 'Another node failed during system restart, please investigate error(s) on other node(s)(Restart error). Temporary error, restart node'.【ok1】baidu,google之,没有得到相似的案列,看到一个emporary error, restart node的提示,不得已 restart node 节点重新在4个data 节点,执行 ndbd --initial,等待2分钟,搞定!oh,my god,不知道其中的原理,但是data node确实是起来了。ndb_mgm> Node 4: Started (version 7.2.7)Node 7: Started (version 7.2.7)Node 5: Started (version 7.2.7)Node 6: Started (version 7.2.7)启动sql节点,执行检查数据,my god,原来的数据文件都无法显示了。mysql> SELECT TABLESPACE_NAME, FILE_NAME, EXTENT_SIZE*TOTAL_EXTENTS/1024/1024 AS TOTAL_MB, EXTENT_SIZE*FREE_EXTENTS/1024/1024 AS FREE_MB, EXTRA FROM information_schema.FILES WHERE FILE_TYPE="DATAFILE";Empty set (0.00 sec)mysql> 【ok2】第一次ndbd不成功,之后,再重新启动以一次ndbd,-- =============================================================================【20】 Out of undo space-- =============================================================================mysql> insert into MvpCard select * from zzbak_MvpCard limit 0,10000;ERROR 1297 (HY000): Got temporary error 1501 'Out of undo space' from NDBCLUSTERmysql> show warnings;+---------+------+--------------------------------------------------------------+| Level   | Code | Message                                                      |+---------+------+--------------------------------------------------------------+| Warning | 1297 | Got temporary error 1501 'Out of undo space' from NDB        || Error   | 1297 | Got temporary error 1501 'Out of undo space' from NDBCLUSTER |+---------+------+--------------------------------------------------------------+2 rows in set (0.00 sec)【ok】参考网址 http://forums.mysql.com/read.php?25,413217,413217I add another undo log file ,it's ok now ,but counld some one tell me how can I know the usage of my undo log file ? SELECT FILE_NAME FROM information_schema.files WHERE FILE_TYPE='UNDO LOG'/G;执行:alter LOGFILE GROUP lg_1 ADD UNDOFILE 'undo_21.log' UNDO_BUFFER_SIZE 33554432 ENGINE NDBCLUSTER;mysql> alter LOGFILE GROUP lg_1 ADD UNDOFILE 'undo_21.log' ENGINE NDBCLUSTER; Query OK, 0 rows affected (4.33 sec)mysql> SELECT FILE_NAME FROM information_schema.files WHERE FILE_TYPE='UNDO LOG';+-------------+| FILE_NAME   |+-------------+| undo_2.log  || undo_2.log  || undo_2.log  || undo_2.log  || undo_21.log || undo_21.log || undo_21.log || undo_21.log || NULL        |+-------------+9 rows in set (0.05 sec)mysql>SELECT FILE_NAME FROM information_schema.files WHERE FILE_TYPE='UNDO LOG'/G;mysql> insert into MvpCard select * from zzbak_MvpCard limit 0,10000;Query OK, 10000 rows affected (0.80 sec)Records: 10000  Duplicates: 0  Warnings: 0-- =============================================================================【21】 后台日志报错,批量insert数据-- =============================================================================2012-08-16 22:38:05 [ndbd] ERROR    -- c_gcp_list.seize() failed: gci: 38285338476552 nodes: 00000000000000000000000000000000000000000000000000000000000164002012-08-16 22:38:05 [ndbd] WARNING  -- ACK wo/ gcp record (gci: 8914/8) ref: 0fa2000e from: 0fa2000e2012-08-16 22:38:05 [ndbd] WARNING  -- ACK wo/ gcp record (gci: 8914/8) ref: 0fa2000a from: 0fa2000a2012-08-16 22:38:05 [ndbd] WARNING  -- ACK wo/ gcp record (gci: 8914/8) ref: 0fa20010 from: 0fa200102012-08-16 22:38:05 [ndbd] ERROR    -- c_gcp_list.seize() failed: gci: 38285338476553 nodes: 00000000000000000000000000000000000000000000000000000000000164002012-08-16 22:38:05 [ndbd] WARNING  -- ACK wo/ gcp record (gci: 8914/9) ref: 0fa2000e from: 0fa2000e2012-08-16 22:38:05 [ndbd] WARNING  -- ACK wo/ gcp record (gci: 8914/9) ref: 0fa2000a from: 0fa2000a2012-08-16 22:38:05 [ndbd] ERROR    -- c_gcp_list.seize() failed: gci: 38289633443840 nodes: 00000000000000000000000000000000000000000000000000000000000164002012-08-16 22:38:05 [ndbd] WARNING  -- ACK wo/ gcp record (gci: 8914/9) ref: 0fa20010 from: 0fa200102012-08-16 22:38:05 [ndbd] WARNING  -- ACK wo/ gcp record (gci: 8915/0) ref: 0fa2000a from: 0fa2000a2012-08-16 22:38:05 [ndbd] WARNING  -- ACK wo/ gcp record (gci: 8915/0) ref: 0fa20010 from: 0fa200102012-08-16 22:38:05 [ndbd] WARNING  -- ACK wo/ gcp record (gci: 8915/0) ref: 0fa2000e from: 0fa2000e【ok】减少insert的数量,一次批量从100W减少到50W,ok,不会报异常信息了。-- =============================================================================【22】 第4个data节点意外down了-- =============================================================================ndb_mgm> Node 7: Forced node shutdown completed. Caused by error 2305: 'Node lost connection to other nodes and can not form a unpartitioned cluster, please investigate if there are error(s) on other node(s)(Arbitration error). Temporary error, restart node'.ndb_mgm> 【ok】执行ndbd 重新启动起来-- =============================================================================【22】 管理台老是报警,诡异-- =============================================================================ndb_mgm> Node 7: Data usage increased to 80%(64016 32K pages of total 80000)Node 4: Data usage increased to 80%(64007 32K pages of total 80000)Node 5: Data usage increased to 80%(64014 32K pages of total 80000)Node 6: Data usage increased to 80%(64001 32K pages of total 80000)Node 4: Data usage increased to 90%(72005 32K pages of total 80000)Node 5: Data usage increased to 90%(72014 32K pages of total 80000)Node 7: Data usage increased to 90%(72010 32K pages of total 80000)Node 6: Data usage increased to 90%(72009 32K pages of total 80000)Node 6: Data usage decreased to 89%(71772 32K pages of total 80000)Node 7: Data usage decreased to 89%(71271 32K pages of total 80000)Node 4: Data usage decreased to 89%(71215 32K pages of total 80000)Node 5: Data usage decreased to 88%(70607 32K pages of total 80000)Node 5: Data usage decreased to 79%(63850 32K pages of total 80000)Node 7: Data usage decreased to 79%(63673 32K pages of total 80000)Node 4: Data usage decreased to 78%(62947 32K pages of total 80000)Node 6: Data usage decreased to 78%(62932 32K pages of total 80000)-- =============================================================================【23】 ERROR 1297 (HY000)-- =============================================================================mysql> insert into bguserdb.UserPoints_2012 select * from test.UserPoints_2012 limit 1200000,10000; ERROR 1297 (HY000): Got temporary error 899 'Rowid already allocated' from NDBCLUSTERmysql> 【ok】网上都说需要调大datamemory,但是我的是磁盘表,应该不是这个原因,不得已只有restart cluster了试试了,还好搞定了!mysql>  replace into bguserdb.UserPoints_2012 select * from test.UserPoints_2012 limit 1200000,300000;Query OK, 300000 rows affected (59.97 sec)Records: 300000  Duplicates: 0  Warnings: 0-- =============================================================================【24】 ERROR    -- c_gcp_list.seize() failed:-- =============================================================================2012-08-19 17:00:24 [ndbd] WARNING  -- ACK wo/ gcp record (gci: 233322/6) ref: 0fa2000e from: 0fa2000e2012-08-19 17:00:24 [ndbd] WARNING  -- ACK wo/ gcp record (gci: 233322/6) ref: 0fa20010 from: 0fa200102012-08-19 17:00:24 [ndbd] WARNING  -- ACK wo/ gcp record (gci: 233322/6) ref: 0fa2000a from: 0fa2000a2012-08-19 17:00:25 [ndbd] ERROR    -- c_gcp_list.seize() failed: gci: 1002110359437319 nodes: 00000000000000000000000000000000000000000000000000000000000154002012-08-19 17:00:25 [ndbd] WARNING  -- ACK wo/ gcp record (gci: 233322/7) ref: 0fa20010 from: 0fa200102012-08-19 17:00:25 [ndbd] WARNING  -- ACK wo/ gcp record (gci: 233322/7) ref: 0fa2000e from: 0fa2000e2012-08-19 17:00:25 [ndbd] WARNING  -- ACK wo/ gcp record (gci: 233322/7) ref: 0fa2000a from: 0fa2000a2012-08-19 17:00:25 [ndbd] ERROR    -- c_gcp_list.seize() failed: gci: 1002110359437320 nodes: 00000000000000000000000000000000000000000000000000000000000154002012-08-19 17:00:25 [ndbd] WARNING  -- ACK wo/ gcp record (gci: 233322/8) ref: 0fa2000e from: 0fa2000e2012-08-19 17:00:25 [ndbd] WARNING  -- ACK wo/ gcp record (gci: 233322/8) ref: 0fa2000a from: 0fa2000a2012-08-19 17:00:25 [ndbd] WARNING  -- ACK wo/ gcp record (gci: 233322/8) ref: 0fa20010 from: 0fa200102012-08-19 17:00:25 [ndbd] ERROR    -- c_gcp_list.seize() failed: gci: 1002110359437321 nodes: 00000000000000000000000000000000000000000000000000000000000154002012-08-19 17:00:25 [ndbd] WARNING  -- ACK wo/ gcp record (gci: 233322/9) ref: 0fa20010 from: 0fa200102012-08-19 17:00:25 [ndbd] WARNING  -- ACK wo/ gcp record (gci: 233322/9) ref: 0fa2000e from: 0fa2000e2012-08-19 17:00:25 [ndbd] WARNING  -- ACK wo/ gcp record (gci: 233322/9) ref: 0fa2000a from: 0fa2000a2012-08-19 17:00:25 [ndbd] ERROR    -- c_gcp_list.seize() failed: gci: 1002114654404608 nodes: 00000000000000000000000000000000000000000000000000000000000154002012-08-19 17:01:05 [ndbd] WARNING  -- ACK wo/ gcp record (gci: 233322/1) ref: 0fa2000c from: 0fa2000c2012-08-19 17:01:05 [ndbd] WARNING  -- ACK wo/ gcp record (gci: 233322/2) ref: 0fa2000c from: 0fa2000c2012-08-19 17:01:05 [ndbd] WARNING  -- ACK wo/ gcp record (gci: 233322/3) ref: 0fa2000c from: 0fa2000c2012-08-19 17:01:05 [ndbd] WARNING  -- ACK wo/ gcp record (gci: 233322/4) ref: 0fa2000c from: 0fa2000c2012-08-19 17:01:05 [ndbd] WARNING  -- ACK wo/ gcp record (gci: 233322/5) ref: 0fa2000c from: 0fa2000c2012-08-19 17:01:05 [ndbd] WARNING  -- ACK wo/ gcp record (gci: 233322/6) ref: 0fa2000c from: 0fa2000c2012-08-19 17:01:05 [ndbd] WARNING  -- ACK wo/ gcp record (gci: 233322/7) ref: 0fa2000c from: 0fa2000c2012-08-19 17:01:05 [ndbd] WARNING  -- ACK wo/ gcp record (gci: 233322/8) ref: 0fa2000c from: 0fa2000c2012-08-19 17:01:05 [ndbd] WARNING  -- ACK wo/ gcp record (gci: 233322/9) ref: 0fa2000c from: 0fa2000c2012-08-19 17:01:05 [ndbd] WARNING  -- ACK wo/ gcp record (gci: 233323/0) ref: 0fa2000c from: 0fa2000c-- =============================================================================【24】 ERROR 1114 (HY000): The table 'card_coin' is full-- =============================================================================mysql> insert into bgcarddb.card_coin select * from zbakbgcarddb.card_coin limit 0,300000;ERROR 1114 (HY000): The table 'card_coin' is fullmysql> mysql> show warnings;+---------+------+------------------------------------------------------------------------------------------------+| Level   | Code | Message                                                                                        |+---------+------+------------------------------------------------------------------------------------------------+| Warning | 1296 | Got error 902 'Out of memory in Ndb Kernel, ordered index data (increase DataMemory)' from NDB || Error   | 1114 | The table 'card_coin' is full                                                                  |+---------+------+------------------------------------------------------------------------------------------------+2 rows in set (0.00 sec)mysql> 导入大量数据的时候或者执行大量的insert或者update操作的时候,经常会出现如下报错:ERROR 1297 (HY000) at line 1: Got temporary error 1218 'Send Buffers overloaded in NDB kernel' from NDBCLUSTER这个报错的原因有几个,第一、是参数SendBufferMemory设置过小,第二、和mysqld的二进制日志有关系,第三、和网络环境有关系解决办法:查看网络环境是否OK ,是否出现双工模式部队,是否都是千兆网或者百兆网,加大SendBufferMemory的设置,一般2M就够了,设置TotalSendBufferMemory = 256M,最后如果还是出现如此报错,建议关闭mysql的二进制日志,在my.cnf中注释掉相关的参数就可以了,比如:#log-bin=mysql-bin-- =============================================================================【25】 修改了config.in之后,data node 启动,需要 ndbd --initial重新加载之后,原有的*.dat数据文件无效,启动不起来,sql节点启动之后,show tables; 原来的磁盘表都不见了,诡异啊!-- =============================================================================1 修改config.inf2 ndb_mgmd -f /usr/local/mysql/cluster-conf/config.ini --reload 重新加载管理节点3 ndbd --initial  重新启动data node4 service mysqld start5 use bu; show tables; 原来的表不存在了,丢失了。看的文档是说,原有的数据文件加载不了,我想问的是:1 如果我已经导入了很多数据,这个时候发现自己的配置参数不合理,我要修改配置参数,能不能在线修改并生效。2 如果1失败,我能否在重新启动管理节点之后,启动data node的时候,能加载进去以前的数据呢?-- =============================================================================【25】 批量insert 500W记录报错-- =============================================================================mysql> insert into bgcarddb.card_package_20120120 select * from zbakbgcarddb.card_package_20120120 ;ERROR 1297 (HY000): Got temporary error 233 'Out of operation records in transaction coordinator (increase MaxNoOfConcurrentOperations)' from NDBCLUSTERmysql> mysql> insert into bgcarddb.card_package select * from zbakbgcarddb.card_package limit 0,5000000;ERROR 1297 (HY000): Got temporary error 233 'Out of operation records in transaction coordinator (increase MaxNoOfConcurrentOperations)' from NDBCLUSTERmysql> -- =============================================================================【26】 批量insert 500W记录报错-- =============================================================================2012-08-26 00:37:25 [ndbd] INFO     -- findNeighbours from: 4861 old (left: 5 right: 5) new (65535 65535)2012-08-26 00:37:25 [ndbd] INFO     -- Watchdog: User time: 976564  System time: 11897182012-08-26 00:37:25 [ndbd] WARNING  -- Watchdog: Warning overslept 410 ms, expected 100 ms.2012-08-26 00:37:25 [ndbd] INFO     -- Arbitrator decided to shutdown this node2012-08-26 00:37:25 [ndbd] INFO     -- QMGR (Line: 5975) 0x000000022012-08-26 00:37:25 [ndbd] INFO     -- Error handler shutting down system2012-08-26 00:37:25 [ndbd] INFO     -- Error handler shutdown completed - exiting2012-08-26 00:37:38 [ndbd] ALERT    -- Node 6: Forced node shutdown completed. Caused by error 2305: 'Node lost connection to other nodes and can not form a unpartitioned cluster, please investigate if there are error(s) on other node(s)(Arbitration error). Temporary error, restart node'.[ok]:google之,大部分的方案都是 restart data node。而且一般的ndbd启动无效,需要ndbd --initial 重新加载才行。-- =============================================================================【27】 导入数据错误;-- ============================================================================= CREATE TABLE `pp_order` (  `Id` int(11) NOT NULL AUTO_INCREMENT,  `pid` varchar(255) DEFAULT NULL,  `itemCode` varchar(255) DEFAULT NULL,  `itemLocalCode` varchar(255) DEFAULT NULL,  `stockLocalCode` varchar(255) DEFAULT NULL,  `itemDetailLink` varchar(255) DEFAULT NULL,  `itemName` varchar(255) DEFAULT NULL,  `itemPicLink` varchar(255) DEFAULT NULL,  `itemRetailPrice` varchar(255) DEFAULT NULL,  `itemDealPrice` varchar(255) DEFAULT NULL,  `stockAttr` varchar(255) DEFAULT NULL,  `itemAdjustPrice` varchar(255) DEFAULT NULL,  `itemDealCount` varchar(255) DEFAULT NULL,  `itemDealState` varchar(255) DEFAULT NULL,  `account` varchar(255) DEFAULT NULL,  `itemFlag` varchar(255) DEFAULT NULL,  `refundState` varchar(255) DEFAULT NULL,  `refundStateDesc` varchar(255) DEFAULT NULL,  `availableAction` varchar(255) DEFAULT NULL,  PRIMARY KEY (`Id`),  KEY `dealCode` (`pid`(30))) TABLESPACE ts_1 STORAGE DISK  DEFAULT CHARSET=utf8;mysql> ERROR 1005 (HY000): Can't create table 'bgapidb.pp_order' (errno: 851)mysql> show warnings;+---------+------+---------------------------------------------------------------------------------------------------------------------+| Level   | Code | Message                                                                                                             |+---------+------+---------------------------------------------------------------------------------------------------------------------+| Warning | 1296 | Got error 851 'Maximum 8052 bytes of FIXED columns supported, use varchar or COLUMN_FORMAT DYNMIC instead' from NDB || Error   | 1005 | Can't create table 'bgapidb.pp_order' (errno: 851)                                                                  |+---------+------+---------------------------------------------------------------------------------------------------------------------+2 rows in set (0.00 sec)[OK],磁盘表的varchar列的占据的总长度不能多于8052B,所以合理设计字段的长度。搞定mysql>  CREATE TABLE bgapidb.`pp_order` (    ->   `Id` INT(11) NOT NULL AUTO_INCREMENT,    ->   `pid` VARCHAR(30) DEFAULT NULL,    ->   `itemCode` VARCHAR(40) DEFAULT NULL,    ->   `itemLocalCode` VARCHAR(16) DEFAULT NULL,    ->   `stockLocalCode` VARCHAR(16) DEFAULT NULL,    ->   `itemDetailLink` VARCHAR(100) DEFAULT NULL,    ->   `itemName` VARCHAR(100) DEFAULT NULL,    ->   `itemPicLink` VARCHAR(100) DEFAULT NULL,    ->   `itemRetailPrice` VARCHAR(10) DEFAULT NULL,    ->   `itemDealPrice` VARCHAR(10) DEFAULT NULL,    ->   `stockAttr` VARCHAR(120) DEFAULT NULL,    ->   `itemAdjustPrice` VARCHAR(10) DEFAULT NULL,    ->   `itemDealCount` VARCHAR(10) DEFAULT NULL,    ->   `itemDealState` VARCHAR(30) DEFAULT NULL,    ->   `account` VARCHAR(10) DEFAULT NULL,    ->   `itemFlag` VARCHAR(10) DEFAULT NULL,    ->   `refundState` VARCHAR(32) DEFAULT NULL,    ->   `refundStateDesc` VARCHAR(32) DEFAULT NULL,    ->   `availableAction` VARCHAR(60) DEFAULT NULL,    ->   PRIMARY KEY (`Id`),    ->   KEY `dealCode` (`pid`(30))    -> ) TABLESPACE ts_1 STORAGE DISK  ENGINE=NDBCLUSTER DEFAULT CHARSET=utf8;Query OK, 0 rows affected (0.24 sec)-- =============================================================================【28】 Got temporary error 4010-- =============================================================================mysql> insert into bgapidb.top_deliverysend_queue select * from zbakapi.top_deliverysend_queue limit 0,200000;  ERROR 1297 (HY000): Got temporary error 4010 'Node failure caused abort of transaction' from NDBCLUSTER【ok】内存不足,清空掉一些无用的大表,释放内存从60%降到30%ndb_mgm> all report memory;Node 4: Data usage is 30%(39215 32K pages of total 128000)Node 4: Index usage is 16%(18575 8K pages of total 115232)Node 5: Data usage is 30%(39196 32K pages of total 128000)Node 5: Index usage is 16%(18575 8K pages of total 115232)Node 6: Data usage is 30%(39489 32K pages of total 128000)Node 6: Index usage is 16%(18554 8K pages of total 115232)CREATE TABLE `top_trade` (  `Id` int(11) NOT NULL AUTO_INCREMENT,  `seller_nick` varchar(255) DEFAULT NULL,  `buyer_nick` varchar(255) DEFAULT NULL,  `title` varchar(255) DEFAULT NULL,  `type` varchar(255) DEFAULT NULL,  `created` varchar(20) DEFAULT NULL,  `iid` varchar(60) DEFAULT NULL,  `price` decimal(10,2) DEFAULT NULL,  `pic_path` varchar(255) DEFAULT NULL,  `num` int(5) DEFAULT NULL,  `tid` varchar(20) DEFAULT NULL,  `buyer_message` varchar(255) DEFAULT NULL,  `sid` varchar(255) DEFAULT NULL,  `shipping_type` varchar(50) DEFAULT NULL,  `alipay_no` varchar(60) DEFAULT NULL,  `payment` decimal(10,2) DEFAULT NULL,  `discount_fee` decimal(10,2) DEFAULT NULL,  `adjust_fee` decimal(10,2) DEFAULT NULL,  `snapshot_url` varchar(255) DEFAULT NULL,  `snapshot` varchar(255) DEFAULT NULL,  `status` varchar(60) DEFAULT NULL,  `seller_rate` varchar(20) DEFAULT NULL,  `buyer_rate` varchar(20) DEFAULT NULL,  `buyer_memo` varchar(255) DEFAULT NULL,  `seller_memo` varchar(255) DEFAULT NULL,  `pay_time` varchar(20) DEFAULT NULL,  `end_time` varchar(20) DEFAULT NULL,  `modified` varchar(20) DEFAULT NULL,  `buyer_obtain_point_fee` int(10) DEFAULT NULL,  `point_fee` int(10) DEFAULT NULL,  `real_point_fee` int(10) DEFAULT NULL,  `total_fee` decimal(10,2) DEFAULT NULL,  `post_fee` decimal(10,2) DEFAULT NULL,  `buyer_alipay_no` varchar(100) DEFAULT NULL,  `receiver_name` varchar(100) DEFAULT NULL,  `receiver_state` varchar(60) DEFAULT NULL,  `receiver_city` varchar(60) DEFAULT NULL,  `receiver_district` varchar(80) DEFAULT NULL,  `receiver_address` varchar(255) DEFAULT NULL,  `receiver_zip` varchar(10) DEFAULT NULL,  `receiver_mobile` varchar(100) DEFAULT NULL,  `receiver_phone` varchar(100) DEFAULT NULL,  `consign_time` varchar(20) DEFAULT NULL,  `buyer_email` varchar(255) DEFAULT NULL,  `commission_fee` decimal(10,2) DEFAULT NULL,  `seller_alipay_no` varchar(100) DEFAULT NULL,  `seller_mobile` varchar(50) DEFAULT NULL,  `seller_phone` varchar(50) DEFAULT NULL,  `seller_name` varchar(30) DEFAULT NULL,  `seller_email` varchar(60) DEFAULT NULL,  `available_confirm_fee` decimal(10,2) DEFAULT NULL,  `has_post_fee` varchar(20) DEFAULT NULL,  `received_payment` decimal(10,2) DEFAULT NULL,  `cod_fee` decimal(10,2) DEFAULT NULL,  `timeout_action_time` varchar(20) DEFAULT NULL,  `is_3d` varchar(20) DEFAULT NULL,  `is_lgtype` tinyint(3) DEFAULT NULL COMMENT '是否需要物流宝发货标识',  `is_brand_sale` tinyint(3) DEFAULT NULL COMMENT '是否品牌特卖订单',  `is_force_wlb` tinyint(3) DEFAULT NULL COMMENT '是否强制使用物流宝发货',  `outer_order_sn` varchar(255) DEFAULT NULL,  `is_change` tinyint(3) NOT NULL DEFAULT '1',  `is_os` tinyint(3) NOT NULL DEFAULT '0',  `channel_code` varchar(20) NOT NULL DEFAULT '',  `channel_name` varchar(255) DEFAULT NULL,  PRIMARY KEY (`Id`),  KEY `tid` (`tid`),  KEY `change_chl_status` (`channel_code`(10),`status`(24),`is_change`),  KEY `is_os` (`is_os`),  KEY `created` (`created`)) TABLESPACE ts_1 STORAGE DISK  ENGINE=ndbcluster DEFAULT CHARSET=utf8;ERROR 1118 (42000): Row size too large. The maximum row size for the used table type, not counting BLOBs, is 14000. You have to change some columns to TEXT or BLOBs-- =============================================================================【29】 Got temporary error 899 'Rowid already allocated' from NDB-- =============================================================================mysql> create table bglogdb.t1(id int, n varchar(30)) TABLESPACE ts_1 STORAGE DISK  ENGINE=ndbcluster;ERROR 1005 (HY000): Can't create table 'bglogdb.t1' (errno: 899)mysql> show warnings;+---------+------+------------------------------------------------------------+| Level   | Code | Message                                                    |+---------+------+------------------------------------------------------------+| Warning | 1297 | Got temporary error 899 'Rowid already allocated' from NDB || Error   | 1005 | Can't create table 'bglogdb.t1' (errno: 899)               |+---------+------+------------------------------------------------------------+2 rows in set (0.00 sec)【ok】,google之,没有找到办法,无奈从新启动cluster系统,建表成功。-- =============================================================================【30】 Got temporary error 899 'Rowid already allocated' from NDB-- =============================================================================CREATE TABLE bglogdb.`nc_api_logs` (  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',  `ymd` datetime NOT NULL COMMENT '请求日期',  `request_url` varchar(200) NOT NULL COMMENT '请求URL',  `post_data` text COMMENT '提交参数',  `return_data` text COMMENT '返回参数',  `ipaddr` varchar(20) DEFAULT NULL COMMENT '发送请求IP',  `status` char(3) DEFAULT NULL COMMENT '请求状态:0  已请求 返回异常     1  已请求 正常返回  ',  `created` datetime DEFAULT NULL COMMENT '该记录创建时间',  `modified` datetime DEFAULT NULL COMMENT '记录修改时间',  `api_type` varchar(55) DEFAULT NULL,  PRIMARY KEY (`id`)) ENGINE=ndbcluster  DEFAULT CHARSET=utf8;ERROR 1005 (HY000): Can't create table 'bglogdb.nc_api_logs' (errno: 708)mysql> show warnings;+---------+------+------------------------------------------------------------------------------------------+| Level   | Code | Message                                                                                  |+---------+------+------------------------------------------------------------------------------------------+| Warning | 1296 | Got error 708 'No more attribute metadata records (increase MaxNoOfAttributes)' from NDB || Error   | 1005 | Can't create table 'bglogdb.nc_api_logs' (errno: 708)                                    |+---------+------+------------------------------------------------------------------------------------------+2 rows in set (0.00 sec)【ok】,将MaxNoOfAttributes值增加到24760,搞定。-- ==================================================================================================================【31】 ERROR : Got temporary error 1234 'REDO log files overloaded (increase disk hardware)' from NDBCLUSTER-- ==================================================================================================================[root@banggo ~]# time mysqlslap --engine=ndbcluster --auto-generate-sql-write-number=100000 --auto-generate-sql-guid-primary  --concurrency=200,400,600 --number-of-queries=1000000 --iterations=2 --number-char-cols=10 --number-int-cols=10 --auto-generate-sql --create-schema=ndb –-commint=1000 --auto-generate-sql-load-type=write   mysqlslap: Cannot run query INSERT INTO t1 VALUES (uuid(),412380163,1002100976,271523606,1458696239,1603135659,696200156,1997806484,42367420,1574962246,1628033484,'5QF0PnnE7cfW1qKl2J245d0XcXRDB6THOlHqOwwXZc1aQDKLOEPTrHsJgCOsIu1aXAGv6DQXpJ67PISpOlJ723QbFrRPlK08WG3STL0IYyIxGmnYOyfI15t9oKaPYa','Z2jcNCpNNMLhJTJy1jog2idvrQ8PrgsPbbtynbD2xaj833zwmncgTDcKXkmNGWgr5Zpk82nxSM6NH5JwkncEtCaOoCf5iJwfteOtY3r1PpGjmSfWF7k0KBP0F45yO2','T9Ytu4olxEQEpCiKjpRRqfW7gm3lcJf5SBrF8f05tRBaXtuEbEaPt4OZiRJInqO727M2mF7YaJ654tCX7mw0iCQHgdbJRrQLyhNdwN9Mi7ResXAz9yssBI1jnc2EKK','SAtrnhEo3ooNJguTY4JOoMap5LHzRdCvo5fRnlGiQ45lcs68wPYcoyPlBilfCpQ0uxJZjR89X5m8xs8lHhLxXejjLKEP9YHvWcL54T6RasROkc9t9Nrg1QFEeLffuw','QGZnDT8JwbBOrns0g1NNZHhpXJAByw7P4Y4H15cygfEXQ6NzzfEYwwDJ7GW6CWNHuJQwO3mwasJtqbkp6yL2uRD2jk0v6F40QXojQQX0Irl8ITxOSBIEeX8L788DF5','6acmH2DouXXgYp9T5TYNk2nsFutO00LyaxkrrxgdL3HttJEqofEOh1Hxn2Dn2addNMK6BsjYwtPhCYXsBdHkWaZISmxWCbzRpKZ04HZ0AqZEE56PiNADpbNHMKgQnf','ucrJdwc2oekMszRzG1EI64uLD8itaLPKyGgRC8Ttf5FX4aMDRTXQPPnePTOsjpCh5k0AlL3OQAnNk2c3XzTwHHQieqaLfnulNun8FiOas4xS6PNTOtPh2jOgayu5dg','itbTtiBIGvE5FKWfpvY6Saps6FjsLCZ3x0Zrac1jOFofbBIGyiMQG3BFJmzgqOjoGGXrlOQ9fEo6H7M7pcQyfT5y7wexLMddW8K7YmG3tx9AwNAdrcRN5YLCLs1i6f','BSfYc4As73h96dOGFGsifp7stSku2iZDB5dn9oXGr5Pxiq5xyxgTefDX7yQ9YrMjwsM5gmMXrfLZLQNBGvgmauIhkci8RwkGo6LKkbkR75tSNGYX34IdySAa4kjXgR','nLP1h2SPTbMEwmWS9PYR2Nn4prgOFLrui9vF3OhYr3nnh9FrbgATvyQkh69wJsjt1e9wuqTel8PR9ZIcDKy8IGksEtoamXRf2ScoAxQwxkFyHPRMlPMwZ6onsSDesh') ERROR : Got temporary error 1234 'REDO log files overloaded (increase disk hardware)' from NDBCLUSTER【ok】google很久,增加了那2个值,但是启动起来还是报很多错误,后来想到一个外招,换个库名字,--create-schema=ndb12,搞定。-- ==================================================================================================================【32】 ERROR 1114 (HY000): The table '' is full-- ==================================================================================================================mysql> replace into bgapidb.yi_refund select * from zbakapi.yi_refund;ERROR 1114 (HY000): The table '' is fullmysql> mysql> mysql> mysql> SELECT  TABLESPACE_NAME, FILE_NAME, EXTENT_SIZE*TOTAL_EXTENTS/1024/1024 AS TOTAL_MB, EXTENT_SIZE*FREE_EXTENTS/1024/1024 AS FREE_MB, EXTRA FROM information_schema.FILES WHERE FILE_TYPE="DATAFILE" and TABLESPACE_NAME='ts_1'  order by UPDATE_TIME desc;+-----------------+-------------+----------------+------------+----------------+| TABLESPACE_NAME | FILE_NAME   | TOTAL_MB       | FREE_MB    | EXTRA          |+-----------------+-----</nodeid>
Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
机器学习基础之数字上的距离:点在空间中的距离机器学习基础之数字上的距离:点在空间中的距离Apr 11, 2023 pm 11:40 PM

本文转载自微信公众号「活在信息时代」,作者活在信息时代。转载本文请联系活在信息时代公众号。在机器学习中,一个基础的概念就是如何判断两个样本之间的差异,从而能够评价两个样本之间的相似性和类别等信息。而判断这种相似性的度量就是两个样本在特征空间内的距离。根据数据特征的不同,度量方法有很多种。一般而言,对两个数据样本x,y,定义一个函数d(x,y),如果定义其为两个样本之间的距离,那么d(x,y)则需要满足以下几条基本性质:非负性:d(x,y)&gt;=0同一性:d(x,y)=0 ⇔ x=y对

升级win11需要的C盘空间介绍升级win11需要的C盘空间介绍Dec 23, 2023 am 08:57 AM

众所周知,如果系统安装完成后占用系统盘太大,可能会导致系统运行卡顿、延迟,甚至是文件丢失。因此大家在安装win11系统之前,需要了解升级win11需要多大C盘空间,下面就跟着小编一起来看看吧。升级win11需要多大C盘空间:答:升级win11需要20-30GB的C盘空间。1、根据微软的win11配置要求可以看到,win11安装需要64GB的硬盘空间。2、但其实一般来说是不需要这么大的空间的。3、根据已经安装win11的用户反馈,win11升级大概需要20-30GB的C盘空间。4、但是如果我门只有

c盘剩余空间多大合适c盘剩余空间多大合适Jun 27, 2023 pm 02:51 PM

c盘剩余空间50-80G比较合适。由于系统在日后使用当中会产生垃圾文件,缓存文件等因此建议至少预留50GB-80GB的空间给C盘;如果您不习惯在安装软件时选择路径,日常也不是经常清理电脑,那么至少需要100GB。

如何在 Ubuntu 上添加交换空间 22.04 LTS如何在 Ubuntu 上添加交换空间 22.04 LTSFeb 20, 2024 am 11:12 AM

交换空间在Linux系统中扮演着重要角色,特别是在系统内存不足时。它充当着一个备用的内存存储空间,可以帮助系统平稳运行,即使在负载高的情况下也能保持稳定性。本文为您提供了在Ubuntu22.04LTS上添加交换空间的详细指南,以确保您的系统性能得到优化并能应对各种工作负载。了解交换空间交换空间提供虚拟内存,用于补充系统的物理RAM。当系统的RAM不足时,内核会将数据交换到磁盘,以防止内存不足和系统崩溃。Linux系统常用交换空间来处理这种情况。同时运行多个内存密集型应用程序处理非常大的文件或数据

如何释放 Xbox Series S 或 Xbox Series X 上的空间如何释放 Xbox Series S 或 Xbox Series X 上的空间Apr 19, 2023 pm 01:46 PM

Xbox游戏机有大量可供下载和玩的游戏。再加上Microsoft的Xbox游戏通行证订阅,乐趣无穷无尽的游戏收藏永远不会停止。但是,存在可用于游戏的空间问题,XboxSeriesS为356GB,XboxSeriesX为850GB。虽然这在以前的游戏版本中很好,游戏的最大大小可能在20到45GB之间,这不是最近的游戏。最近可用的游戏最终占用了磁盘上的大量空间,从而使我们下载其他游戏的空间更少。ForzaHorizo​​n5和Halo5Guardians等

iOS 17.2:如何在 iPhone 15 Pro 上录制空间视频iOS 17.2:如何在 iPhone 15 Pro 上录制空间视频Dec 15, 2023 pm 01:09 PM

如果您使用的是iPhone15或iPhone15ProMax,iOS17.2允许您录制空间视频,以便在Apple即将推出的VisionPro耳机上的照片应用程序中查看。这是你如何做到的。Apple的VisionPro耳机预计将于2024年&lt;&gt;月左右发布。在那之前,您可以为此做好准备的一种方法是使用iPhone以一种称为空间视频的特殊格式录制视频,该格式可在Apple的耳机上观看。在iPhone上观看时,空间视频显示为普通视频,但它们在VisionPro上提供了近乎三维

百度云空间不足怎么办百度云空间不足怎么办Mar 25, 2024 pm 11:01 PM

云存储已经成为我们日常生活和工作中不可或缺的一部分。随着文件数量的不断增加,云存储空间的需求也日益凸显。作为国内领先的云存储服务提供商,百度云凭借其强大的存储功能和便捷的操作体验,赢得了广大用户的青睐。但是很多用户们可能都在使用过程中遇到过空间不足的困扰,那么这篇教程就为大家带来详细的解决扩充容量办法,希望能帮助到大家!1.在百度云中登录自己的账号。(可以使用百度账号登录,也可以使用QQ账号登录)2.登录后点击百度云左侧的“免费领取2048G容量”。3.下载百度云的手机客户端,安卓手机的点击下载

头条搜索极速版空间不足怎么办头条搜索极速版空间不足怎么办Feb 27, 2024 am 11:46 AM

随着手机使用的日益频繁,许多用户可能会发现手机存储空间不足,这可能会导致一些应用无法正常运行或影响手机的整体性能。对于头条搜索极速版的用户来说,可能有的时候缓存内容很多,那么手机提示空间不足时,应该如何处理呢?那么就快来下文中跟着小编一起操作清理吧!头条搜索极速版空间不足怎么办答案:清理空间。清理空间的方法:1、首先打开头条搜索极速版软件,进入到软件的首页中后我们点击右下角的【我的】;2、然后在我的页面中滑动到下方之后找到【系统设置】功能点击;3、接着在系统设置的页面中我们点击【清除缓存】;4、

See all articles

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

DVWA

DVWA

Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software

Atom editor mac version download

Atom editor mac version download

The most popular open source editor

Dreamweaver Mac version

Dreamweaver Mac version

Visual web development tools

PhpStorm Mac version

PhpStorm Mac version

The latest (2018.2.1) professional PHP integrated development tool

SecLists

SecLists

SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.