- 浏览: 1504690 次
- 性别:
- 来自: 厦门
文章分类
- 全部博客 (516)
- Java (49)
- Java/Struts 2.0 (25)
- Java/Spring、Spring MVC (11)
- Java/Quartz (3)
- Java/Lucene (6)
- Java/Hibernate (19)
- Java/openJPA (7)
- Java/DWR (7)
- Java/Security、Spring Security/OAuth2 (6)
- Java/Threading (9)
- Java/XML (22)
- java/design pattern (4)
- Android (2)
- JavaScript (46)
- jquery (3)
- DB/MySQL (23)
- DB/Oracle (16)
- PHP (25)
- CSS (20)
- Linux (38)
- C/C++、DLL、Makefile、VC++ (31)
- 正则 (9)
- Eclipse (4)
- 安全、网络等概念 (25)
- 集群 (7)
- 网页 (5)
- 视频\音频 (1)
- HTML (6)
- 计算机数学/算法 (3)
- Virtualbox (1)
- LDAP (2)
- 数据挖掘 (6)
- 工具破解 (1)
- 其他 (13)
- Mail (1)
- 药材 (3)
- 游戏 (2)
- hadoop (13)
- 压力测试 (3)
- 设计模式 (3)
- java/Swing (2)
- 缓存/Memcache (0)
- 缓存/Redis (1)
- OSGI (2)
- OSGI/Gemini (0)
- 文档写作 (0)
- java/Servlet (3)
- MQ/RabbitMQ (2)
- MQ/RocketMQ (0)
- MQ/Kafka (1)
- maven (0)
- SYS/linux (1)
- cache/redis (1)
- DB/Mongodb (2)
- nginx (1)
- postman (1)
- 操作系统/ubuntu (1)
- golang (1)
- dubbo (1)
- 技术管理岗位 (0)
- mybatis-plus (0)
最新评论
-
pgx89112:
大神,请赐我一份这个示例的项目代码吧,万分感谢,1530259 ...
spring的rabbitmq配置 -
string2020:
不使用增强器 怎么弄?
OpenJPA的增强器 -
孟江波:
学习了,楼主,能否提供一份源代码啊,学习一下,十分感谢!!!4 ...
spring的rabbitmq配置 -
eachgray:
...
spring-data-redis配置事务 -
qljoeli:
学习了,楼主,能否提供一份源代码啊,学习一下,十分感谢!!!1 ...
spring的rabbitmq配置
转自:http://seo3721.appspot.com/668004.html
Percona Server 5.1.47-11.0 版本发布没几天(6-21),因发现一个严重的bug,又对该版本召回,为此 Percona 重新发布了一个 11.1 的补丁版本(6-29)。
该版本是关于查询缓存的,下面是对该bug的详细描述:
MySQL Query Cache works by checking incoming queries if they may be found in query cache – this is done by performing simple check if query is starting from SEL or comment. After Query is parsed and executed MySQL stores results for SELECT queries in Query Cache. There are cases when queries will not be considered as cachable query during first check, however result for them will be stored in the query cache. This rare case was not handled properly in the new feature added and it was causing MySQL to crash.
The most typical case for queries causing issues would be queries starting with brackets such as ( select * from t1 ) Queries starting with brackets are often used with UNION queries.
今天下午下载了新发布的版本11.1的源代码,编译
./configure --with-charset=gbk --with-extra-charsets=all --enable-local-infile --enable-thread-safe-client --enable-assembler --with-plugins=innobase,partition --prefix=/home/ddb/wangwei/mysql-5.1.47-xtradb-net --with-big-tables --with-readline
正常,后来进行系统库初始化(mysql_install_db)的时候,出现错误,所无法识别参数,我靠,那说明根本就没有安装成功XtraDB 嘛。
100630 17:48:33 [ERROR] /home/ddb/wangwei/mysql-5.1.47-xtradb-net/libexec/mysqld: unknown variable 'innodb_data_home_dir=/home/ddb/wangwei/xtradb-data/mysql'
同样的编译命令,安装MySQL-5.1.45+Xtradb-1.0.6就没有这个问题。看来是源码包的问题了,也有人遇到类似的问题。http://forum.percona.com/index.php/m/5874 /#msg_5874 。
不甘心,后来改变下编译参数,把--with-plugins=innobase,partition ---》--with-plugins=max ,继续编译,编译成功,系统库初始化没有异常,汗。启动MySQL,登录之,正常:
mysql> status
--------------
/home/ddb/wangwei/mysql-5.1.47-xtradb-net/bin/mysql Ver 14.14 Distrib 5.1.47, for unknown-linux-gnu (x86_64) using readline 5.1
Connection id: 1
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.1.47-log Source distribution
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /home/ddb/wangwei/xtradb/mysql/mysqld.sock
Uptime: 27 sec
Threads: 1 Questions: 7 Slow queries: 0 Opens: 15 Flush tables: 1 Open tables: 8 Queries per second avg: 0.259
--------------
mysql> show engines ;
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| Engine | Support | Comment | Transactions | XA | Savepoints |
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| ndbcluster | NO | Clustered, fault-tolerant tables | NULL | NULL | NULL |
| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
| BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO |
| CSV | YES | CSV storage engine | NO | NO | NO |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
| FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL |
| ARCHIVE | YES | Archive storage engine | NO | NO | NO |
| InnoDB | DEFAULT | Supports transactions, row-level locking, and foreign keys | YES | YES | YES |
| MyISAM | YES | Default engine as of MySQL 3.23 with great performance | NO | NO | NO |
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
9 rows in set (0.00 sec)
mysql> show variables like 'innodb_version'; //默认版本就是XtraDB了
+----------------+------------+
| Variable_name | Value |
+----------------+------------+
| innodb_version | 1.0.8-11.0 |
+----------------+------------+
1 row in set (0.00 sec)
mysql> show variables like 'innodb_adaptive_checkpoint';
+----------------------------+----------+
| Variable_name | Value |
+----------------------------+----------+
| innodb_adaptive_checkpoint | estimate |
+----------------------------+----------+
1 row in set (0.00 sec)
MariaDB安装手册:http://kb.askmonty.org/v/installing-mariadb-binary-packages
MariaDB下载地址:http://askmonty.org/wiki/MariaDB:Download
发表评论
-
mysql中计算两点坐标距离
2016-09-12 15:35 112CREATE FUNCTION `calc_distanc ... -
在window 单机环境下将mysql cluster创建为自启动服务
2013-08-22 21:17 2015假设我的mysql cluster根目录是:D:\d ... -
mysql cluster 的一些错误解决方法记录。
2013-08-21 14:57 12881、ndb_mgmd的配置文件编码问题导致解析错误 ... -
Ubuntu 11.04 x64 编译安装mysql
2012-09-15 18:28 1317转自:http://www.cnblogs.com/sin ... -
面试时 遇到一个数据库SQL 成绩排名
2012-07-17 09:55 10021、累积排名 SELECT NAME ... -
ubuntu 11.4 二进制文件(tar.gz) 安装 mysql 5.5.x
2012-02-22 21:11 1127sudo /etc/init.d/mysql.server ... -
SQL 分组统计 两个字段 行转列
2012-02-08 17:20 4148select c.MRL,c.OPERATION_ID,c. ... -
记录错位方法
2011-05-28 21:03 871目的: select `value` ... -
你的MySQL安全了吗?加铸23道安全门
2011-03-22 12:39 1001使用MySQL,安全问题不能不注意。以下是MySQL提示的 ... -
MySQL 存储过程的使用
2011-03-20 20:10 1476drop procedure if exists tes ... -
MySQL函数的创建
2011-03-19 23:15 967drop function if exists shorten ... -
Mysql 配置SSL
2011-03-16 10:26 1237[client] ssl-ca=$DIR/cacert.pe ... -
Mysql SSL 配置
2011-03-16 10:15 3555转自:http://www.cnblogs.com/huqin ... -
在Navicate中使用 提示输入 方式输入SQL的参数。
2011-03-01 17:56 972select [$输入A] 输入参考: sele ... -
MySQL 地理时区管理
2011-01-14 11:33 1961MySQL经常被人们 ... -
两个不同表的SUM值相减
2011-01-12 15:39 1347select z.num2 - x.num1 from ( ... -
查询某条记录的前后两条
2011-01-07 11:05 704id target num 1 Gen ... -
navicate 9 注册码
2011-01-02 13:44 1567名:I Love China 组织:I Love China ... -
SQL获取上个月最后一个周末两天
2010-10-28 16:41 1505该语句可以获得: 上个月最后一个周末两天 ... -
MySQL where与having的区别
2010-10-28 10:51 1573WHERE子句是在第一步从表或视图中配全SELECT子句把数 ...
相关推荐
percona-server-server-8版本,用在ubuntu18版本,安装percona-server-server之前,先安装percona-server-common和percona-server-client软件包
percona-xtrabackup-8.0.27-19-Linux-x86_64.glibc2.12-minimal.tar.gz、 percona-xtrabackup-8.0.27-19-Linux-x86_64.glibc2.17-minimal.tar.gz、 percona-xtrabackup-80-8.0.27-19.1.el6.x86_64.rpm、 percona-...
percona-xtrabackup-2.4.24-Linux-x86_64.glibc2.12-minimal.tar.gz percona-xtrabackup-2.4.24-Linux-x86_64.glibc2.12.tar.gz percona-xtrabackup-24-2.4.24-1.el6.x86_64.rpm percona-xtrabackup-24-2.4.24-1.el7...
1、percona-toolkit-3.3.1-1-最新版.zip 2、支持centos、redhat、orace linux、ubuntu、debian、麒麟V10、欧拉系统等个版本Linux系统。 3、内部各版本安装包列表如下: percona-toolkit-3.3.1-1.el7.x86_64.rpm、 ...
percona-server-Percona-Server-8.0.32-24.tar.gz
percona-server-5.6.23-72.1
vagrant box add --name huzhenghui/Percona-CentOS-7 huzhenghui-Percona-CentOS-7-8.0.18-9-1905.1-2.box 创建空白文件夹 vagrant init huzhenghui/Percona-CentOS-7 启动虚拟机 vagrant up 测试虚拟机中...
Percona-Server-5.5.60-38.12-r26ef816-el7-x86_64-bundle.tar linux版,优化数据库,含有高效XtraDB引擎
Percona-Server-5.7.35-38-Linux.x86_64.glibc2.12-minimal.tar.gz
percona-toolkit-3.2.1-1.el7.x86_64.rpm
percona-xtrabackup-80-8.0.23-16.1.el7.x86_64.rpm和相关依赖 cd yilai rpm -Uvh *.rpm --nodeps --force rpm -ivh percona-xtrabackup-80-8.0.23-16.1.el7.x86_64.rpm
percona-release-0.1-4.noarch rpm安装包,依赖包 percona出品
percona-server-common安装包,针对ubuntu18版本;可使用sudo apt list installed | grep mysql查看系统中当前是否安装Mysql文件
Percona Server forMySQL®是任何MySQL数据库的免费,完全兼容,增强和开放源代码的替代产品。它提供了卓越的性能,可伸缩性和仪器。 Percona Server for MySQL得到了成千上万家企业的信任,可以为最苛刻的工作负载...
percona-xtrabackup-24-2.4.9-1.el6.x86_64.rpm
percona-server-client-8.0.21-12.2.el7.x86_64.rpm percona-server-server-8.0.21-12.2.el7.x86_64.rpm percona-server-shared-8.0.21-12.2.el7.x86_64.rpm percona-server-shared-compat-8.0.21-12.2.el7.x86_64....
Percona-Server-for-MySQL 文档
percona-xtrabackup-24-2.4.22-1.el7.x86_64.rpm
percona-backup-mongodb-1.6.1-1.el7.x86_64.rpm、 percona-backup-mongodb-1.6.1-1.el8.x86_64.rpm、 percona-backup-mongodb-1.6.1-x86_64.tar.gz、 percona-backup-mongodb_1.6.1-1.bionic_amd64.deb、 percona-...
Percona-XtraDB-Cluster-5.6.15.tar.gz percona-xtradb-cluster-galera.tar.gz Percona-XtraDB-Cluster-5.6.15-25.5.759.Linux.i686.tar.gz Percona-XtraDB-Cluster-5.6.15-25.5.759.Linux.x86_64.tar.gz Percona-...