Planet MySQL

+0

-0

posted by Baron Schwartz (xaprb) on Fri 22 Jan 2010 23:18 UTC (Add To MySQL Librarian)
Tags:

(edit) postgresql, sql

I’d like an UNTIL clause, please. I’d use it sort of like LIMIT in MySQL and PostgreSQL, except that it would define when to stop returning rows, instead of defining how many to return. Example:

SELECT * FROM users UNTIL user_id >= 100;

That would select users up to and including user 99. Ideally the clause could accept any boolean predicate, including subqueries. I’ll hold my breath and wait for this wish to come true now.

No related posts.

Related posts brought to you by Yet Another Related Posts Plugin.

From Scratch, Get set, Go!

+1

-2

posted by Brian Aker on Fri 22 Jan 2010 21:38 UTC (Add To MySQL Librarian)
Tags:

(edit) drizzle

[brian@gaz fix_is]$ ./drizzled/drizzled --console-enable 
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use GCC atomic builtins.
100122 13:12:00  InnoDB: highest supported file format is Barracuda.
100122 13:12:00 InnoDB Plugin 1.0.4 started; log sequence number 44600
Listening on 0.0.0.0:3306
Listening on :::3306
Listening on 0.0.0.0:4427
Listening on :::4427
./drizzled/drizzled: Forcing close of thread 0 user: ''
./drizzled/drizzled: ready for connections.
Version: '2010.01.1273' Source distribution (fix_is)

drizzled> use data_dictionary;
OK

drizzled> show tables;
Tables_in_data_dictionary	
MODULES	
PLUGINS	
PROCESSLIST	

drizzled> desc PLUGINS;
Field	Type	Null	Key	Default	Extra	

PATH ./data_dictionary/plugins
ID	bigint	YES		NULL		
USER	varchar(16)	YES		NULL		
HOST	varchar(64)	YES		NULL		
DB	varchar(64)	YES		NULL		
COMMAND	varchar(16)	YES		NULL		
TIME	bigint	YES

[Read more...]

Community Events February-March

+0

-1

posted by Morgan Tocker of team blog MySQL Performance Blog on Fri 22 Jan 2010 21:14 UTC (Add To MySQL Librarian)
Tags:

(edit) community, Conferences, mysql

February and March as busy months for Community events. There’s MySQL University, Fosdem, the Seattle MySQL Meetup & Confoo.ca. Here are the details:

February 4th – I’ll be presenting a talk via MySQL University on Optimizing Queries with Explain. This talk will be about learning to read the output from MySQL’s EXPLAIN command, and optimizing some example queries from the IMDB dataset. At 5.7G in InnoDB tables imported before any secondary key indexes IMDB is one of my new favorite

+1

-3

posted by Mike Hogan on Fri 22 Jan 2010 21:05 UTC (Add To MySQL Librarian)
Tags:

(edit)

Back when the EU started the investigation of the Oracle-Sun deal, I made a bet. The bet hinged on whether Oracle would make concessions to get the EU’s approval. Please review the arguments, pro and con, and help us settle the bet.

Issue #1: The 10-Point Commitment to Customers Developers & Users of MySQL:
PRO CONCESSIONS: After meeting with the EU, Oracle issues this list of 10 concessions. Oracle prefaces the 10 points with the line: “In order further to reassure the Commission, Oracle hereby publicly commits to the following:” It then goes on to make certain commitments including #2 the non-assertion policy where is says “Oracle will change Sun’s current policy” and commit not to assert their copyright against storage engine vendors for 5 years. And continues to say: “Oracle [Read more...]

5.1 + new InnoDB Plugin

+3

-1

posted by Rob Young on Fri 22 Jan 2010 20:12 UTC (Add To MySQL Librarian)
Tags:

(edit)

If you're wondering what MySQL 5.1 with the new InnoDB Plugin is all about you'll want to tune into the webinar I am hosting next Tuesday. I'll cover the why, what and how behind the immediate performance and scale improvements that can be had, especially on modern (> 4 CPU) servers, by enabling the new plugin in MySQL 5.1. Learn more and get registered, it should be good time!

You can also take it to a deeper level by joining Brian Miezejewski from our PS team on 3/9 for a practical guide to using and tuning the new plugin features to improve performance and scale. Hope you can join us!

[Read more...]

CAOS Theory Podcast 2010.01.22

+0

-0

posted by The 451 Group on Fri 22 Jan 2010 19:57 UTC (Add To MySQL Librarian)
Tags:

(edit) podcast, software, Apache, caos theory, caostheory, cloud computing, community, consumer devices, developers, Development, gpl, Licensing, Linux, M&A, Mergers and acquisitions, mysql, open-source, opensource, Oracle, savemysql, Sun Microsystems, The 451 Group, the451group, VMWare, Zimbra

Topics for this podcast:

*Open source in consumer devices
*VMware-Zimbra deal highlights open source, cloud
*A capitalist’s guide to open source licensing
*Latest on Oracle-Sun-MySQL, M&A implications

iTunes or direct download (24:48, 5.7 MB)

Kontrollbase 2.0.1 revision 281 available for download

+0

-0

posted by Matt Reid on Fri 22 Jan 2010 19:41 UTC (Add To MySQL Librarian)
Tags:

(edit) announcement, analytics, database, kontrollbase, monitoring, mysql, reporting

A new version of Kontrollbase – the enterprise monitoring, analytics, reporting, and historical analysis webapp for MySQL database administrators and advanced users of MySQL databases – is available for download. See the downloads page or run “svn update” to get your new version today. http://kontrollsoft.com/software-downloads

Kontrollbase reporter XML Parser error has been fixed

+0

-0

posted by Matt Reid on Fri 22 Jan 2010 19:15 UTC (Add To MySQL Librarian)
Tags:

(edit) announcement, error, kontrollbase, mysql, release, xml

If you have seen the following error on the Perf Report tab “Message: SimpleXMLElement::__construct()…” – it has been fixed in revision 281. This only affects alerts 11 and 12 so you might not run into it immediately. The solution is to either remove lines “586, 590, 639, 650″ from the bin/kontroll-reporter-5.0.x_linux-x86-2.0.1.pl file, or to run [...]

The overhead of ON DUPLICATE KEY UPDATE

+0

-0

posted by of team blog MySQL@Facebook on Fri 22 Jan 2010 19:00 UTC (Add To MySQL Librarian)
Tags:

(edit)

When incrementing a table that manages a count are you an optimist or a pessimist? If the row is likely to exist, you should first try to update it and do an insert when the update fails. Otherwise, use insert ... on duplicate key udpate. It is more expensive to use insert ... on duplicate key update when update is sufficient. That is fair given that insert ... on duplicate key update must do more work (first try the insert, then try the update). You can read the code for this in sql/sql_insert.cc. It is in the functions mysql_insert and write_record. I ran a simple test using MySQL 5.0.84, InnoDB and an 8-core server. The test measures the time to run the statements above using 1, 2, 4, 8, 16 and 32 concurrent sessions. Each session ran the statement 131,072 times. These statements [Read more...]

New Colleague Blog

+2

-0

posted by Peter Gulutzan on Fri 22 Jan 2010 18:07 UTC (Add To MySQL Librarian)
Tags:

(edit) News

Readers following the performance schema saga will be happy to know that the man who designed and wrote the code, Marc Alff, has a blog. His first posting about it is at http://marcalff.blogspot.com/2010/01/performance-schema-overview.html.

MySQL on VMware Workstation/DRBD vs. VMWare ESX Server/SAN

+2

-0

posted by Oli Sennhauser of team blog MySQL Support Team on Fri 22 Jan 2010 16:05 UTC (Add To MySQL Librarian)
Tags:

(edit)

Or an active-active fail-over cluster à la VMware.

Today I have learned about a totally crazy/cool looking architecture where the expensive VMware ESX server was replace by a free/cheap VMware Workstation version in combination with DRBD.

Basically DRBD we name "the little man's SAN" and that is exactly what this customer is doing. He replaced the SAN with DRBD and now he can easily move one VMware instance to the other host. Possibly it is not that flexible and powerful as an ESX Server but also not so expensive...

The architecture looks as follows:

[Read more...]

Cannot create Windows service for MySQL.Error:0

+0

-0

posted by ushastry on Fri 22 Jan 2010 15:50 UTC (Add To MySQL Librarian)
Tags:

(edit)

Platform: Windows

People often checks MySQL's download section and when they notice that there is new version of MySQL released they just can't wait for a second & starts downloading it so that they can install it on their windows box for testing purpose. Ok fine, download is completed its time to install it. Couple of successful "NEXT" and In the last step they encounter a error message such as

"Cannot create Windows service for MySQL.Error:0"

We are so intelligent ppl that we don't want to take any help from our colleague..
And what we do is we just delete the directory in

+0

-0

posted by of team blog HowToForge on Fri 22 Jan 2010 15:18 UTC (Add To MySQL Librarian)
Tags:

(edit) centos, lighttpd, mysql, PHP

Installing Lighttpd With PHP5 And MySQL Support On CentOS 5.4

Lighttpd is a secure, fast, standards-compliant web server designed for speed-critical environments. This tutorial shows how you can install Lighttpd on a CentOS 5.4 server with PHP5 support (through FastCGI) and MySQL support.

Small status on SQLAlchemy and MySQL Connector/Python

+1

-0

posted by Geert Vanderkelen of team blog MySQL Support Team on Fri 22 Jan 2010 10:48 UTC (Add To MySQL Librarian)
Tags:

(edit) mysql, Python, myconnpy

Using SQLAlchemy unit test cases to further develop MySQL Connector/Python. It's probably debatable whether that's a good method or just lame. But it sure helps lots!

We've been pushing some code past days that makes Connector/Python almost pass all tests. Well, 4% is still failing, but I'm confident that in a few most problems will be dealt with. I had to make some changes to the SQLAlchemy v0.6 dialect as well, and some test cases had to be corrected. Hopefully those corrections will also go in the SQLAlchemy trunk later on.


shell> nosetests --dburi=mysql+mysqlconnector://root:@localhost/sqlalchemy
..
----------------------------------------------------------------------
Ran 2092

[Read more...]

1.0.1 RC2 release available

+0

-0

posted by Calpont & InfiniDB Project Team on Fri 22 Jan 2010 08:55 UTC (Add To MySQL Librarian)
Tags:

(edit) Download Release

We are pleased to announce the availability of 1.0.1 Release Candidate 2 of InfiniDB Community Edition. This is our second release candidate and is not recommended for production work.

This is our last release candidate as we will be releasing 1.0.2 Final in early February. This release includes a number of bug fixes that you can see at http://bugs.launchpad.net/infinidb. You can download the latest InfiniDB binaries, source code, and updated documeRead More...

Machines Plus Minds: E-Blobs and NoSQL options

+0

-0

posted by Mark Atwood on Fri 22 Jan 2010 03:25 UTC (Add To MySQL Librarian)
Tags:

(edit) mysql, Geek, NoSQL

Machines Plus Minds: E-Blobs and NoSQL options

The end of a patch

+4

-0

posted by of team blog MySQL@Facebook on Fri 22 Jan 2010 01:50 UTC (Add To MySQL Librarian)
Tags:

(edit)

I have been busy doing things other than modifying MySQL for a few months, but now I am back and have a few more patches to share for the Facebook patch for MySQL 5.0. Activity on this patch will soon end as we will begin working on MySQL 5.1. Yes, there will be a Facebook patch for MySQL 5.1. There are several people at Facebook who modify MySQL, so we should have good things to share for 5.1. We will also present our work at the MySQL Conference, but our session is not listed yet. The new patches are available at Launchpad. As with any change to a complex piece of software, it is wise to work with your source code provider (MySQL, MariaDB, Drizzle, Percona, etc) if you are interested in these changes. While I am a big fan of [Read more...]

When should you store serialized objects in the database?

+3

-0

posted by Morgan Tocker of team blog MySQL Performance Blog on Thu 21 Jan 2010 21:40 UTC (Add To MySQL Librarian)
Tags:

(edit) mysql, tips, eblob, friendly

A while back Friendfeed posted a blog post explaining how they changed from storing data in MySQL columns to serializing data and just storing it inside TEXT/BLOB columns. It seems that since then, the technique has gotten more popular with Ruby gems now around to do this for you automatically.

So when is it a good idea to use this technique?

If the application really is schema-less and has a lot of optional parameters that do not appear in every record, serializing the data in one column can be a better idea than having many extra columns that are NULL. The restriction on this, would be that searching on these columns now becomes more difficult[1]. A good example of this optional nature of data is user

[Read more...]

RESTful PHP Web Services – reviewed

+0

-0

posted by Matt Reid on Thu 21 Jan 2010 19:54 UTC (Add To MySQL Librarian)
Tags:

(edit) PHP, Programming, Open Source, json, mysql, programing, rest, web services, xml

I’ve been using a lot of RESTful services these days and have been waiting for a good book that is dedicated to the topic. I recently received a copy of ‘RESTful PHP Web Services’, which does a successful job of outlining proven concepts in current web technology. If you want to learn the methods for creating and consuming RESTful services then you will find many examples in this book. From the architectural plans to well thought out code samples, the book covers a lot of ground in a relatively quick read.

The first chapter gives the reader a quick introduction to RESTful services and the most common PHP frameworks in use at the time of writing. I particularly enjoyed the section on the Zend framework due to

[Read more...]

[MySQL][Spider]Spider-2.12 released

+0

-0

posted by Kentoku SHIBA on Thu 21 Jan 2010 18:22 UTC (Add To MySQL Librarian)
Tags:

(edit) mysql, spider

I'm pleased to announce the release of Spider storage engine version 2.12(beta).
Spider is a Storage Engine for database sharding.
http://spiderformysql.com/

The main changes in this version are following.
MariaDB support.
- Add server parameter "spider_connect_mutex", "spider_connect_retry_count" and "spider_connect_retry_interval".
This parameters are used for avoiding failed connected processing caused by intense connected processing. (Especially for using "spider_conn_recycle_mode=0")

Please see "99_change_logs.txt" in the download documents for checking other changes.
Thanks to Mohammad and Jay for bug report.

Enjoy!

Search

Profile

Top Voted (Last Week)

Top Voted (Last Month)

Top 20 Most Active Authors

Top 10 Most Active Team Blogs

MySQL Links

Other Links

Planetarium