Showing entries 21376 to 21385 of 44106
« 10 Newer Entries | 10 Older Entries »
MySQL INNER JOIN Tutorial: the comma operator

Here you find information about writing inner joins with the comma operator. It’s the most basic way to combine (join) two tables. There is an alternative syntax that can be used, because in MySQL you can write inner joins in two different ways. Another popular way is it to use the INNER JOIN command or synonymous keywords like CROSS JOIN and JOIN. Please make sure to read our dedicated documentation for more information when you understand the comma operator syntax.

Syntax

The following examples are equivalent to the INNER JOIN …

[Read more]
MySQL Connector/Python 0.3.0 has been released!

MySQL Connector/Python 0.3.0, a development release, is available for download:
https://launchpad.net/myconnpy/+download

Since version 0.3.0 is still a development release, or ‘alpha’, it is not
recommended to run this in production.

MySQL Connector/Python 0.3.0 adds following features:

  • Python v2.4 support is back.
  • Support for compressed protocol.
  • Support for SSL connections (when Python’s ssl module is available).
  • Support for packets which are bigger than 16MB.
  • Max allowed packetsize defaults to 1GB.
  • Some performance improvements.

See the ChangeLog for extra details.

Please …

[Read more]
Moving from MySQL to CouchDB: Part 2

The follow-up blog post on moving your MySQL applications to CouchDB has been posted on the CouchOne blog. Part 2 digs into a bit more detail on the specifics of views, and how to perform some of the more common operations used in MySQL, such as paging and aggregation in your CouchDB view.

You can read Part 2 here

CRIB – CentRal Information Base for MySQL

CRIB is a CentRal Information Base for MySQL, a long time coming project since I worked on it on and off for a few weeks and now I decided it’s time to hand it over to the global MySQL community.

So, what is CRIB?

CRIB is a central database which collects information about all your MySQL instances which you set as clients. It is monitoring in a way, but not the typical number of connections, memory, index usage, table scans, cpu usage and such, but rather consists of a repository where, if you have tens, hundreds or even thousands of clients, you can see where a particular user was created, where a certain database name features or which tables does a database consists of. It also features a script which logs table sizes periodically (customizable) so you can graph disk usage over time and be able to forecast future disk space requirements easily.

Download the latest code with: bzr branch lp:crib

First …

[Read more]
Distributed Software Testing

About me

A word about me first: My name is Daniel Mewes and I just came over to California to work at RethinkDB as an intern for the oncoming months. After having been an undergraduate student of computer science at Saarland University, Germany for the last two years, I am exited to work on an influential real-world project at RethinkDB now. Why RethinkDB? Not only does RethinkDB develop an exciting and novel piece of database technology, RethinkDB also provides the great “startup kind” of work experience.

Software testing

In complex software systems like database management systems, different components have to work together. These components can interact in complex ways, yielding a virtually infinite number of possible states that the overall system can reach. This has consequences for software testing. As bugs in the code might only show up in a small fraction of the possible states, comprehensive testing of the …

[Read more]
foss.in 2010

I’ll be going to foss.in this year, and am totally excited (the last time I spoke there was in 2007 – Paying it Forward: Harnessing the MySQL Contributory Resources – where I talked about moving from BitKeeper to Bazaar, using Launchpad, the MySQL Forge, and more). This time around, I will be giving a talk titled: MariaDB: The new M in LAMP. I feel a little nostalgia, because the MySQL ecosystem has evolved a lot since December 2007.

The database crew is going to be strong there, as we also have Gary Pendergast, my friend from MySQL (now Oracle) giving a talk titled: Tuning MySQL for Performance, Stability and Fail Safety.

We figured we’d have some kind of meetup, either over chai or if we can …

[Read more]
Announcing TokuDB for MariaDB

Tokutek is pleased to announce support for MariaDB for the first time with TokuDB v4.1.1 for MariaDB v5.1.47.

Our customers are choosing MariaDB more and more frequently for their most demanding database applications. We are delighted to help raise MariaDB performance to the next level by making TokuDB available on this new platform. One of our customers, who wishes to remain unnamed for the present time, chose MariaDB + TokuDB for a 3 TB database after having evaluated other MySQL alternatives and finding them unacceptably slow.

TokuDB continues to be the ideal choice for complex / high-volume applications that must have fast response times and that must simultaneously store and query large volumes of rapidly arriving data:

  • Social Networking
  • Real-time clickstream analysis
  • Logfile Analysis
  • eCommerce …
[Read more]
How well does your table fits in innodb buffer pool ?

Understanding how well your tables and indexes fit to buffer pool are often very helpful to understand why some queries are IO bound and others not - it may be because the tables and indexes they are accessing are not in cache, for example being washed away by other queries. MySQL Server does not provide any information of this type, Percona Server however adds number of tables to Information Schema which makes this information possible. It is just few queries away:

PLAIN TEXT SQL:

  1. mysql> SELECT `schema` AS table_schema,innodb_sys_tables.name AS table_name,innodb_sys_indexes.name AS index_name,cnt,dirty,hashed,round(cnt*100/index_size,2) fit_pct   FROM (SELECT index_id,count(*) cnt,sum(dirty=1) dirty ,sum(hashed=1) hashed FROM innodb_buffer_pool_pages_index GROUP BY …
[Read more]
Distributed Software Testing

About me

A word about me first: My name is Daniel Mewes and I just came over to California to work at RethinkDB as an intern for the oncoming months. After having been an undergraduate student of computer science at Saarland University, Germany for the last two years, I am exited to work on an influential real-world project at RethinkDB now. Why RethinkDB? Not only does RethinkDB develop an exciting and novel piece of database technology, RethinkDB also provides the great “startup kind” of work experience.

Software testing

In complex software systems like database management systems, different components have to work together. These components can interact in complex ways, yielding a virtually infinite number of possible states that the overall system can reach. This has consequences for software testing. As bugs in the code might only show up in a small fraction of the possible …

[Read more]
MariaDB 5.1.53 And 5.2.4 Released

This past Monday updates in both the 5.1 and 5.2 series of MariaDB were released. It’s a pretty big deal, as some issues have been solved that affect a large number of users. You should read the release notes for MariaDB 5.1.53 and for MariaDB 5.2.4 as well as the release announcement. The annoucement contains download links from worldwide mirrors.

Speaking of downloads, the 5.2 series has seen a remarkable increase in download totals. Several orders of magnitude, in fact. That’s usually a pretty good sign, so I’ll take it as such. It hopefully means more people are using MariaDB, and when talking about such matters with …

[Read more]
Showing entries 21376 to 21385 of 44106
« 10 Newer Entries | 10 Older Entries »