- 浏览: 1529179 次
- 性别:
- 来自: 厦门
文章分类
- 全部博客 (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 2055假设我的mysql cluster根目录是:D:\d ... -
mysql cluster 的一些错误解决方法记录。
2013-08-21 14:57 13351、ndb_mgmd的配置文件编码问题导致解析错误 ... -
Ubuntu 11.04 x64 编译安装mysql
2012-09-15 18:28 1367转自:http://www.cnblogs.com/sin ... -
面试时 遇到一个数据库SQL 成绩排名
2012-07-17 09:55 10391、累积排名 SELECT NAME ... -
ubuntu 11.4 二进制文件(tar.gz) 安装 mysql 5.5.x
2012-02-22 21:11 1183sudo /etc/init.d/mysql.server ... -
SQL 分组统计 两个字段 行转列
2012-02-08 17:20 4148select c.MRL,c.OPERATION_ID,c. ... -
记录错位方法
2011-05-28 21:03 921目的: select `value` ... -
你的MySQL安全了吗?加铸23道安全门
2011-03-22 12:39 1048使用MySQL,安全问题不能不注意。以下是MySQL提示的 ... -
MySQL 存储过程的使用
2011-03-20 20:10 1526drop procedure if exists tes ... -
MySQL函数的创建
2011-03-19 23:15 1006drop function if exists shorten ... -
Mysql 配置SSL
2011-03-16 10:26 1280[client] ssl-ca=$DIR/cacert.pe ... -
Mysql SSL 配置
2011-03-16 10:15 3605转自:http://www.cnblogs.com/huqin ... -
在Navicate中使用 提示输入 方式输入SQL的参数。
2011-03-01 17:56 972select [$输入A] 输入参考: sele ... -
MySQL 地理时区管理
2011-01-14 11:33 2000MySQL经常被人们 ... -
两个不同表的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 1604名: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...
Percona-XtraDB-Cluster-server-57-5.7.41-31.65.1.el7.x86_64.rpm Percona-XtraDB-Cluster-devel-57-5.7.41-31.65.1.el7.x86_64.rpm Percona-XtraDB-Cluster-client-57-5.7.41-31.65.1.el7.x86_64.rpm Percona-...
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的8.0.32-24版本,这是一个基于MySQL 8.0的重大改进版。 Percona Server的核心特点在于其增强的性能和可扩展性。它采用了XtraDB...
在本案例中,我们讨论的是"percona-server-5.6.23-72.1"版本,这是Percona Server对MySQL 5.6系列的一个特定版本,编号72.1表示该版本的迭代或修复更新。 Percona Server 5.6.23-72.1主要特点和改进包括: 1. **...
percona-release-0.1-4.noarch.rpm:rpm安装包,依赖包 percona出品。percona-release-0.1-4.noarch.rpm:rpm安装包,依赖包 percona出品。percona-release-0.1-4.noarch.rpm:rpm安装包,依赖包 percona出品。
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.7.35-38 for Linux x86_64 glibc2.12 Minimal 版本详解》 Percona Server是MySQL的一个分支,由Percona公司开发并维护,旨在提供更高效、更稳定且功能丰富的数据库服务。此版本为5.7.35-38,专...
percona-release-latest.noarch.rpm
percona-xtrabackup-dbg-24_2.4.28-1.buster_amd64,安装包
Percona-Server-5.5.60-38.12-r26ef816-el7-x86_64-bundle.tar linux版,优化数据库,含有高效XtraDB引擎
Percona-XtraBackup-8.0.29-22-rc31e7ddcce3-el7-x86_64-bundle.tar安装包,适用于mysql8.0.28及以下的mysql8.0版本的Mysql数据库,用于数据的备份和恢复,支持全备份、增量备份和差异备份。
percona-zabbix-templates模板,导入到zabbix中,对mysql多方面各个指标进行监控。
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-toolkit-2.1.7-1.noarch.rpm,percona工具包。
percona-xtrabackup-24-2.4.9-1.el6.x86_64.rpm
1. **解压文件**:使用tar命令解压缩"percona-xtrabackup-2.3.6-Linux-x86_64.tar",例如`tar -xvf percona-xtrabackup-2.3.6-Linux-x86_64.tar`。 2. **配置环境变量**:将解压后的二进制文件路径添加到PATH环境...
percona-data-recovery-tool-for-innodb-0.5.tar.tar