Showing entries 39851 to 39860 of 44080
« 10 Newer Entries | 10 Older Entries »
db4free.net now exclusively runs MySQL 5.1

It's past 7 o'clock in the morning, but this night has been a productive one (hey - no bad thinking please ;-)).

I have updated db4free.net to the latest MySQL 5.1 development source version (5.1.12-beta) and discontinued the 5.0 server. The "former" 5.1 server which ran on port 3307 is still alive, but no new accounts are being created there anymore. During the next days I plan to make the databases that run on the port 3307 server accessible on the main 5.1 server (with standard port 3306) to have everything together on one server - and let the port 3307 server die.

Before the update, most users have only used the 5.0 server, but only a little number of users did anything on the 5.1 server. My intention is to test 5.1 more intensively under a higher load and I hope that this also helps to contribute to the development of MySQL 5.1 by finding bugs or other flaws on a …

[Read more]
State of MySQL partitioning

It's been some time since I last blogged. I've been quite busy erasing all the
bugs from the partitioning implementation in MySQL 5.1. At the moment
there is 1 bug left in review and a few on its way into the main clone. The
rest of the bugs are fixed and already in the 5.1 clone. So the next 5.1
release (5.1.12) will have partitioning ready for tough tests. So if you have
been waiting for partitioning to stabilise it's time to try it out now with your
application and see how it works.

I watched an interesting animation my daughter made about how partition
pruning using dynamic PowerPoint slides. Really interesting to see what can
be done if one knows how to handle these types of tools. She's quickly
becoming our family authority on presentations.

Lately we've also started working on some extensions for the partitioning
hopefully ready for 5.2. We …

[Read more]
Conversion Formats

What format do you use to store data during transport?

I had a problem, I needed to pull data from one website system, into another. Where is the data? Its in MySQL, so I decided to skip the API for the system I am exporting the data from and instead just extracted the data from the database (and yes... I will use the API for reinserting the data... I don't want to break the business logic of the new system).

That was an easy decision.

Then I asked myself, what do I store the data in during the conversion? I needed some format because the old web site is not kept on the same system as the new. So I was going to need a flat file for a bit of time.

The first answer that came to mind?

XML!

So for the last couple of weeks I have been thinking about how I was going to design the XML schema. Not putting a lot of thought into this, just jotting down notes in my …

[Read more]
New information_schema views

As you might have recognized already, I love to take a look into the Change logs from time to time and hope to find some goodies there. Here's an especially nice one in the Change log of 5.1.12:

INFORMATION_SCHEMA contains new tables, GLOBAL_STATUS, SESSION_STATUS, GLOBAL_VARIABLES, and SESSION_VARIABLES, that correspond to the output from the SHOW {GLOBAL|SESSION} STATUS and SHOW {GLOBAL|SESSION} VARIABLES statements.

This was reason enough for me to compile MySQL 5.1 from source and take a look:

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 5.1.12-beta-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use information_schema
Database changed
mysql> show tables;
+---------------------------------------+
| Tables_in_information_schema | …
[Read more]
Too Many RSS Feeds

Okay, so maybe I went a little overboard. But having switched to RSS in order to better interact with the MySQL forums, I seem to have embraced this new way of having content delivered to me whole-heartedly. Of course I added all of the available forum feeds immediately, but then also I added feeds to Planet MySQL as well as some of the constituent blogs directly, also a few NASA blogs and some from family&friends, well, before I knew it the list of feeds has stretched the entire height of my monitor, and I have a 21.3" monitor turned into portrait orientation.

I have to admit, I like staying on top of things and having my feeds polled at 15 minute intervals. I may have to figure …

[Read more]
EuroOSCON: ?Being a MySQL Developer? slides

 

Here are my slides from my talk at EuroOSCON 2006:

 Being A MySQL Developer, EuroOSCON 2006

Enjoy! 

International PHP Cluster Disk Data Article

I’ve had an introductory article to MySQL Cluster 5.1 Disk Data published in the September 2006 issue of International PHP Magazine.

If you’re using Cluster or you’re interested in doing so, and you’ve not yet tried out MySQL 5.1, you’ll find that disk data storage makes MySQL Cluster more flexible, scalable, and cheaper to run than MySQL 4.1 and 5.0 Cluster. In the article, I’ve outlined some reasons why this is so. The article covers the basics of creating disk-based Cluster tables, and discusses some Disk Data do’s and dont’s. There’s also some info about some other improvements to MySQL Cluster that are being made in 5.1, as well as some diagrams and sample PHP5 code for accessing a MySQL Cluster. Just in case you’re not that familiar with setting up a MySQL …

[Read more]
MySQL Index Analyzer: 0.04 released

Over on the MySQL Index Analyzer site I have just released version 0.04 as a downloadable package.

This is the first GUI version that allows real analysis and has more features than the command line version.

A quick overview of what is new:

  • Swing GUI
  • Analysis features as on the command line
  • Copying of generated ALTER TABLE statements to the clipboard
  • Information on data and index size distribution
  • Rudimentary analysis of possible disk space savings

So go have a look :)

Test Drive of Solid

Not so long ago Solid released solidDB for MySQL Beta 3 so I decided now is time to take a bit closer look on new transactional engine for MySQL. While my far goal is the performance and scalability testing before I wanted to look at basic transactional properties such as deadlock detection, select for update handling and phantom reads in the repeatable read isolation level.

Solid has OPTMISTIC (default) and PESSIMISTIC concurrency control, so it was interesting to test both.

We used default isolation mode which is REPEATABLE-READ for this test.

Test 1: Solid, deadlock detection, default (OPTIMISTIC) concurrency control.

PLAIN TEXT SQL:

  1. CREATE TABLE `test2` (
  2.   `id` int(11) NOT NULL,
  3.   `names` varchar(255) DEFAULT NULL, …
[Read more]
Open source and creative destruction

Steve Hamm has a great blog entry on Alfresco and other open source (and SaaS) companies that are destroying the incumbents in markets they founded in the first place. Alfresco, of course, we founded by John Newton, who founded Documentum (and, hence, the document management industry). Now Alfresco is cannibalizing that same market.

There are other examples. Paul Doscher and JasperSoft. John Roberts and SugarCRM. Etc. Many open source business managers formerly ran huge swaths of the proprietary market.

I'm just waiting for Larry Ellison to give up his day job at Oracle to get a job at MySQL....


ADVERTISEMENT

[Read more]
Showing entries 39851 to 39860 of 44080
« 10 Newer Entries | 10 Older Entries »