"Just heard that Monty gave his resignation to Sun today," a tipster we trust writes about Michael Widenius, the Finnish-born main author of open-source database software MySQL. Sun Microsystems had aqcuired Monty's company, also called MySQL, for a cool billion in January. So who's running the show now? Best guess is Brian Aker, another prominent MySQL developer. Aker released a lightweight, Web 2.0-oriented version of MySQL called Drizzle in late July, but he's still at ...

Database company Continuent announced the availability of its "Tungsten stack" earlier today. These programs are meant to improve the replication capabilities of the open-source MySQL database, with an eye toward other database products in the near future. Tungsten is apparently written in Java, allowing it to run on a variety of platforms, including Windows, Linux, and the Macintosh. According to the press release, the Tungsten software provides master-slave replication, in which one database server is ...

CFLAGS="-O3 -mpentiumpro -mstack-align-double"CXX=gccCXXFLAGS="-O3 -mpentiumpro -mstack-align-double -felide-constructors -fno-exceptions -fno-rtti" ./configure --prefix=/usr/local/mysql5 \ --with-charset=utf8 \ --with-collation=utf8_general_ci \ --enable-thread-safe-client \ --with-extra-charsets=gbk,latin1 \ --with-client-ldflags=-all-static \ --with-mysqld-ldflags=-all-static \ --enable-assembler \ --with-unix-socket-path=/usr/local/mysql5/var/mysql.sock \ --sysconfdir=/usr/local/mysql5/etc --disable-shared

Man, this video hits too close to home. Developers all over the world are in pain, so go ahead - hug one right now! Dedicated to all developers at blinkx, MySQL, and beyond. Similar Posts:Must-Know People In The MySQL Field Matt Dancing 2008 - Stunning [VIDEO] Sun buys MySQL for $1bln! MySQL Conference Liveblogging: Monitoring Tools (Wednesday 5:15PM) Best Moment Of The World Cup Final

呃，别会错意，我的意思不是说 MySQL 开始 filesort 就会不稳定，而是说他的排序算法不是 stable 的。 某表中有两个字段，一个是 log_time, DATETIME 类型， 一个是 user_id , BIGINT 类型。 SQL 是 SELECT XXX FROM xx_table WHERE user_id = 111 ORDER BY log_time DESC 。 一开始表上的索引建错了，建成了 user_id,log_time 的联合索引，于是上面的 SQL 用上这个索引以后，就做了 filesort ， 这时候发现所有 log_time 相同的列顺序是乱的，有的按照插入顺序，有的不是。而当重新建立 log_time,user_id 的索引之后，结果中 log_time 相同的就都是按照插入顺序来排序的了。 这个发现有啥用？似乎也没啥太大用处倒是。如果为了严格保持插入顺序，那么设计时候就应该用精度更高的 log_time 。不过如果对插入顺序的要求不是非常严格的要求，那么正确建立索引直接利用它的特性也还算省事。

原文地址：http://jan.kneschke.de/projects/mysql/order-by-rand 翻译：ShiningRay 译者序 之前有位朋友提到从MySQL随机取1条记录其实只要SELECT * FROM table ORDER BY RAND() LIMIT 1即可。其实这个语句有很大的性能问题，对于大表的效率是非常低下的。我们可以看一下MySQL对其的解释： EXPLAIN SELECT * FROM `money_logs` ORDER BY RAND( ) LIMIT 1 id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE table ALL NULL NULL NULL NULL 173784 Using temporary; Using filesort 这个SQL语句无法使用任何索引，还必须使用临时表和文件排序，在一个15万条记录的MyISAM表需要花大约0.3秒。已经是相当慢的了。如何优化，请往下看： 第一个例子我们先假设ID是从1开始并且1和ID的最大值之间没有任何空档。 将工作移入应用程序 第一个想法：如果我们可以事先在应用程序中计算出ID，那么就可以简化整个工作。 SELECT MAX(id) FROM random; ## generate random id in application SELECT name FROM random WHERE id = <random-id> 由于As MAX(id) == COUNT(id) 我们只要生成从1到MAX(id)之间一个随机数，并将其传给数据库并取回随机行。 上面第一个SELECT基本上是一个可以被优化掉的空操作。第二个是一个针对常量的eq_ref查询，同样也很快。 将任务放入数据库 ...

Simple Invoices is an open source, web-based invoicing application which is ideal for freelancers & small businesses. It is not an ERP application & does not have lots of features. It simply enables you to define the job done, select the customer and generate a nice looking invoice. Some features of Simple Invoices: Export to PDF Export to Microsoft Word, Excel or plain text Multiple invoice types Invoice templates Invoice preferences - customise all the ...

来源：安全焦点 作者：tsenable (tsenable_at_gmail...) MYSQL 注射精华 前言 鄙人今天心血来潮突然想写篇文章,鄙人从来没写过文章,如果有错误的地方请多多指教.本文需要有基础的SQL语句知识才可以更好的理解.建议想学习的人多去了解一下SQL语句和编程语言,知己知彼才能百战百胜. 我不希翼得到读者您的好评,尽管我尽力了;只希望本文能解决您学习过程的障碍,希望您早日掌握有关MYSQL注入方面的知识. 1.MYSQL 注射的产生. 漏洞产生原因 : 程序执行中未对敏感字符进行过滤,使得攻击者传入恶意字符串与结构化数据查询语句合并,并且执行恶意代码. 咱们先创造一个没有过滤的程序. 因为我机器上没有PHP,所以我就是用 JAVA了,我会详细注释. 代码 数据库: create database if not exists `test`; USE `test`; /*数据表 `account` 的表结构*/ DROP TABLE IF EXISTS `account`; CREATE TABLE `account` ( `accountId` bigint(20) NOT NULL auto_increment, `accountName` varchar(32) default NULL, `accountPass` varchar(32) default NULL, PRIMARY KEY (`accountId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*数据表 `account` 的数据*/ insert into `account` values (1,'account1','account1'); /*数据表 `admin` 的表结构*/ DROP TABLE IF EXISTS `admin`; CREATE ...

I have great news for MySQL users. A very nice side effect has emerged from the development of the NeverBlock support for MySQL. I am glad to announce the release of a new MySQL driver for Ruby applications. It builds on top of the original Ruby MySQL driver but it comes with two notable additions:Asynchronous query processing support Threaded access supportThanks to help from Roger Pack and Aman Gupta we were able to put the ...

Welcome to the 112th edition of Log Buffer, the weekly review of database blogs. First, thanks to last issue’s contributors–Joe Izenman, Dan Norris, and Jason Massie–for snatching victory from the jaws of defeat and making LB#111 a worthwhile read. That’s what it’s all about! Oracle’s up first, starting with our old friend Doug Burns and his Time Matters series, in which he holds up to the light the concept of DB Time: “. . . ...

During the process of building the new query analysis feature for MySQL Enterprise Monitor 2.0, we thought the best way to test it at a nascent stage was to use it to tune our own application (since we use MySQL as the backend repository). What we found was actually quite interesting. It also showed that even to seasoned developers, who know that frameworks while helpful, often aren‘t the most direct, concise way to get things ...

Though the event is still happening in Charlottesville, VA Nov. 14-16th (Fri night through Sunday), the new web page for OpenSQL Camp is http://www.opensq.... The content has been ported over to MediaWiki, and a captcha has been put in place that is activated on any page change that adds an external URL. Whether you are into MySQL, PostgreSQL, Drizzle, or some other open source SQL database, go forth and register for OpenSQL Camp, without having ...

In writing my last article, I mentioned working with John Arbash Meinel, one of the lead developers of Bazaar, in attempting to diagnose and fix the performance bottlenecks apparent in using Bazaar with larger, history-rich projects like the MySQL Server. Well, after running some tests and building a custom branch of Bazaar that John pointed me to, I am happy to tell you that help is just around the corner. In my last article, you ...

Today Continuent is publishing the Tungsten Replicator, which provides advanced open source master/slave replication for MySQL. Publishing code is the first step to creating a robust alternative to current MySQL replication and will be followed by similar support for Oracle, PostgreSQL, and many other databases.We started with master/slave replication on MySQL for a very simple reason: we know it well. And we know that while MySQL replication has many wonderful features like simple set-up, it ...

Se avete mai lavorato e manipolato i database MySQL è probabile che abbiate utilizzato phpMyAdmin per gestire il vostro database da un’interfaccia web. Nel caso in cui siate alla ricerca di un’alternativa più leggera dovreste però provare phpMinAdmin: l’installazione è estremamente veloce (si tratta di un singolo script PHP) e possiede un’interfaccia grafica semplice ma completa, che permette di accedere alle funzioni più importanti di MySQL. Per utilizzarlo è sufficiente caricare il file PHP nella ...

In this second part of my Launchpad guidebook series, I'll be covering the code management and repository features of Launchpad.net. If you missed the first part of my series, go check it out and get established on Launchpad.net. Then pop back to this article to dive into the magic of http://code.launc.... In this article, we'll cover the following aspects of the code management pieces of Launchpad: The Structure of Project Source Code on Launchpad.net Pulling ...

Author:NinGoo posted on NinGoo.net 对于MySQL，很多印象其实都是来自比较老的4.x版本，实际上MySQL在后续的5.0，5.1和6.0版本中还是做出了很多的改进，特别是原来一些动不动要重启的操作，慢慢的都可以在线做了，如果要做企业级数据库，在线操作的支持是必不可少的。由于我们在产品库中大量开始使用5.1，所以打算写一个系列短文，介绍一些个人觉得比较实用的新特性。因为MySQL这样的开源软件，版本分支比较多，所以每篇文章涉及的一些小版本可能不太一样。 MySQL有很多种日志，包括error log，general query log，binary log，slow query log等。在以前的版本，这些日志的开启或者关闭，都是需要重启服务器的，而且都是记录到日志文件。从MySQL5.1.6版开始，general query log和slow query log开始支持写到文件或者数据库表两种方式，并且日志的开启，输出方式的修改，都可以在Global级别动态修改。 如果说日志是写到文件还是表，对于DBA来说不是那么在乎的话，那么可以动态的开启关闭日志真的可以说是DBA们梦寐以求的。尤其是slow log query，以前一直在头疼，开启吧，可能影响性能，不开吧，对于一些性能差的SQL又没有其他好用的捕获方式。因为开还是不开，涉及到重启服务的问题。 下面演示一下通过设置几个Global级别参数来开启关闭general query log和slow log query的过程： root@NinGoo>select version(); +---------------+ | version() | +---------------+ | 5.1.25-rc-log | +---------------+ 1 row in set (0.00 sec) 设置日志输出方式为文件 root@NinGoo>set global log_output=file; Query OK, 0 rows affected (0.00 sec) 设置general log和slow query log的日志文件路径 root@NinGoo>set global general_log_file='/tmp/general.log'; Query OK, 0 rows affected (0.00 sec) root@NinGoo>set global slow_query_log_file='/tmp/slow.log'; Query OK, 0 rows affected (0.00 ...

Author:NinGoo posted on NinGoo.net 对于MySQL，很多印象其实都是来自比较老的4.x版本，实际上MySQL在后续的5.0，5.1和6.0版本中还是做出了很多的改进，特别是原来一些动不动要重启的操作，慢慢的都可以在线做了，如果要做企业级数据库，在线操作的支持是必不可少的。由于我们在产品库中大量开始使用5.1，所以打算写一个系列短文，介绍一些个人觉得比较实用的新特性。因为MySQL这样的开源软件，版本分支比较多，所以每篇文章涉及的一些小版本可能不太一样。 MySQL有很多种日志，包括error log，general query log，binary log，slow query log等。在以前的版本，这些日志的开启或者关闭，都是需要重启服务器的，而且都是记录到日志文件。从MySQL5.1.6版开始，general query log和slow query log开始支持写到文件或者数据库表两种方式，并且日志的开启，输出方式的修改，都可以在Global级别动态修改。 如果说日志是写到文件还是表，对于DBA来说不是那么在乎的话，那么可以动态的开启关闭日志真的可以说是DBA们梦寐以求的。尤其是slow log query，以前一直在头疼，开启吧，可能影响性能，不开吧，对于一些性能差的SQL又没有其他好用的捕获方式。因为开还是不开，涉及到重启服务的问题。 下面演示一下通过设置几个Global级别参数来开启关闭general query log和slow log query的过程： root@NinGoo>select version(); +---------------+ | version() | +---------------+ | 5.1.25-rc-log | +---------------+ 1 row in set (0.00 sec) 设置日志输出方式为文件 root@NinGoo>set global log_output=file; Query OK, 0 rows affected (0.00 sec) 设置general log和slow query log的日志文件路径 root@NinGoo>set global general_log_file='/tmp/general.log'; Query OK, 0 rows affected (0.00 sec) root@NinGoo>set global slow_query_log_file='/tmp/slow.log'; Query OK, 0 rows affected (0.00 ...

With the recent acquisition of MySQL by Sun, there has been talk about the MySQL open source database now becoming relevant to large enterprises, presumably because it now benefits from Sun's global support, professional services and engineering organizations. In a blog post about the acquisition, SUN CEO Jonathan Schwartz wrote that this is one of his objectives. While the organizational aspects may have been addressed by the acquisition, MySQL faces some technology limitations which hinder ...

Tiene una pinta brutal.