monkeydev：200907 17:36:42 [Note] Plugin 'FEDERATED' is disabled.
/www/server/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
200907 17:36:42 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
200907 17:36:42 InnoDB: The InnoDB memory heap is disabled
200907 17:36:42 InnoDB: Mutexes and rw_locks use GCC atomic builtins
200907 17:36:42 InnoDB: Compressed tables use zlib 1.2.11
200907 17:36:42 InnoDB: Initializing buffer pool, size = 256.0M
200907 17:36:42 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file /www/server/data/ibdata1 did not exist:
InnoDB: a new database to be created!
200907 17:36:42 InnoDB: Setting file /www/server/data/ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
200907 17:36:42 InnoDB: Log file /www/server/data/ib_logfile0 did not exist: new to be created
InnoDB: Setting log file /www/server/data/ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
200907 17:36:42 InnoDB: Log file /www/server/data/ib_logfile1 did not exist: new to be created
InnoDB: Setting log file /www/server/data/ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
200907 17:36:42 InnoDB: Waiting for the background threads to start
200907 17:36:43 InnoDB: 5.5.62 started; log sequence number 0
200907 17:36:43 [Note] Recovering after a crash using mysql-bin
200907 17:36:43 [Note] Starting crash recovery...
200907 17:36:43 [Note] Crash recovery finished.
200907 17:36:43 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
200907 17:36:43 [Note] - '0.0.0.0' resolves to '0.0.0.0';
200907 17:36:43 [Note] Server socket created on IP: '0.0.0.0'.
200907 17:36:43 [Warning] Insecure configuration for --pid-file: Location '/www/server/data' in the path is accessible to all OS users. Consider choosing a different directory.
200907 17:36:43 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
不知道这是什么情况啊
google 里面的都试过了
还是不行 啊
wangsongyan：Please run mysql_upgrade to create it.
mysql 这种情况怎么查？qaqLjj： 如图，怎么查询同时掌握了第一张表所有技能的员工呢？ 也就是说，希望的结果如下： emp 神崎 相田
mysql 查询shimingzhoudf：A 表有 1，2，3，4 个字段 我现在查询结果需要是这样 表名 中文名 1 2 3 4 数据 x x x x x ... ... .. .. .. .. 其实中文名就是 4 字段的值 我看别人这样写过: select 4 中文名, * where 表名; 但我自己用老报语法错误shimingzhoudf：语法是这样 select…
一个 mysql 库容纳多少个表会比较明显的影响速度？l890908：理论上来说基本上没有限制(42 亿多)，但是同时访问的表越多，文件描述符就越多，从操作系统角度来说还是有影响的；那么在实操过程中多少个表会比较明显的影响速度？qiayue：可以不用考虑极限了，按照业务分库分表即可。举例我们的统计 SDK，每个接入的 app 都给一个单独的库，这样不同 app 互不影响。
mysql 必知必会的多表联结问题？amiwrong123：在书中 15.2.3 中，让查询订单编号为 20005 的订单中的物品信息。 由于查询列来自三个表，所以书中连接了三个表。 select prod_name, vend_name, prod_price, quantity from orderitems, products, vendors where products.vend_i…
与Spring和Hibernate长期交易？ - java我要解决的根本问题是运行一个任务，该任务在MySQL中生成多个临时表，这些临时表需要保留足够长的时间，以便在创建Java之后从Java中获取结果。由于涉及的数据量很大，因此必须分批完成任务。每个批处理都是对通过JDBC调用的存储过程的调用。对于大型数据集，整个过程可能需要半小时或更长时间。为了确保对临时表的访问，我在一个带有TransactionCallba…