帖子列表

• MySQL 5.0 新特性教程 存储过程:第四讲...

  ELM 发表于: 2007-09-18,

  Error Handling 异常处理 　　 好了，我们现在要讲的是异常处理 1. Sample Problem: Log Of Failures 问题样例：故障记录 　　 当INSERT失败时，我希望能将其记录在日志文件中...

• MySQL 5.0 新特性教程 存储过程:第三讲...

  ELM 发表于: 2007-09-18,

  The New SQL Statements 新SQL语句 Variables 变量 　　 在复合语句中声明变量的指令是DECLARE。 　　 (1) Example with two DECLARE statements 　　 两个DECLARE语句...

• MySQL 5.0 新特性教程 存储过程:第二讲...

  ELM 发表于: 2007-09-18,

  Why MySQL Statements are Legal in a Procedure Body 　　 什么MySQL语句在存储过程体中是合法的？ 　　什么样的SQL语句在Mysql存储过程中才是合法的呢？你可以创建一个包含I...

• MySQL 5.0新特性教程 存储过程:第一讲...

  ELM 发表于: 2007-09-18,

  Introduction 简介 MySQL 5.0 新特性教程是为需要了解5.0版本新特性的MySQL老用户而写的。简单的来说是介绍了“存储过程、触发器、视图、信息架构视图”,在此感谢译者陈朋...

• 11.8. Full-Text Search Functions

  ELM 发表于: 2007-09-08, 回复: 2

  11.8.1. Boolean Full-Text Searches 11.8.2. Full-Text Searches with Query Expansion 11.8.3. Full-Text Stopwords 11.8.4. Full-Text Restrictions 11.8.5. Fine-Tunin...

• Non-technical Guide to Isolating Slow My...

  ELM 发表于: 2007-01-26,

  MySQL is ubiquitous. As such there are many non-technical users who rely on MySQL but don't want to become MySQL experts beyond routine maintenance. When query-...

• How To Look At MySQL Joins and More ORDE...

  ELM 发表于: 2007-01-26,

  The main purpose of this article is to demonstrate how to look at MySQL joins. By "look at" I mean how to see through MySQL's eyes, so-to-speak. This task is fu...

• How To Index For Joins With MySQL

  ELM 发表于: 2007-01-26,

  From time to time I see people asking "What do I index to join these tables efficiently?" Often, someone just gives them an answer without really explaining the...

• MySQL ORDER BY With LIMIT and ANALYZE

  ELM 发表于: 2007-01-26,

  In this third case we get to see some really fun stuff: The effect of ANALYZE on index selection for a three table join, an ORDER BY with LIMIT optimization, a...

• Table Design and MySQL Index Details

  ELM 发表于: 2007-01-26,

  It's not often I get to work with a true homemade database design. In this case the customer (or their developer to be accurate) had designed the whole database...

• Indexing Basic MySQL Queries

  ELM 发表于: 2007-01-26,

  "Why is the server so slow?" That's what one customer was asking in regards to her dual 2.8 GHz Xeon with 3 Gigs of RAM server. Her primary website is a bulleti...

• MySQL性能优化 - 参数调整

  ELM 发表于: 2007-01-23,

  无聊中，看到一片MySQL的文件，觉得不错，就翻译了一下，没想到用了1个多小时，好长啊。 原文http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-...

• 提高mysql性能的方法!

  ELM 发表于: 2007-01-13, 回复: 1

  一、问题的提出 在应用系统开发初期，由于开发数据库数据比较少，对于查询SQL语句，复杂视图的的编写等体会不出SQL语句各种写法的性能优劣，但是如果将应用系统提交实际应用后，随着...

• MySQL索引分析和优化

  ELM 发表于: 2007-01-13,

  MySQL索引分析和优化 什么是索引？ 索引用来快速地寻找那些具有特定值的记录，所有MySQL索引都以B-树的形式保存。如果没有索引，执行查询时MySQL必须从第一个记录开始扫描整...

• 让Mysql支持事务处理

  ELM 发表于: 2007-01-13,

  在RedHat 7.2 下已经验证 一、在linux 6.2下安装 1.在mysql网站上下载稳定最大功能版本 （当前版本为 3.23.47-max） 2.注意你可以下载二进制版本没，而不需要编译；不必下载RPM版...

• MySQL群集双机模拟方案(MySQL Cluster)...

  ELM 发表于: 2007-01-13,

  MySQL群集双机模拟方案 转载请注明出处 MSN:danieyren@hotmail.com 硬件配置 普通PC server * 2 (最小集群环境需要4台服务器） 模拟环境 red hat linux9 for x86 (or re...

• MySQL集群配置

  ELM 发表于: 2007-01-13,

  一、介绍 ======== 这篇文档旨在介绍如何安装配置基于2台服务器的MySQL集群。并且实现任意一台服务器出现问题或宕机时MySQL依然能够继续运行。 注意！ 虽然这是基于2台服务...