Sysbench is a commonly used benchmark tool to discover ways to improve MySQL performance. It is certainly not representative for every application, but it's still a useful tool for finding bottlenecks in the MySQL code.

In MySQL 5.5 a great number of new scalability improvements have been developed. Some of these will always be active and some of them requires using new configuration parameters.

In order to assist users of MySQL I am performing a fairly extensive benchmark series where I test the various configuration parameters that have an effect on running MySQL/InnoDB using Sysbench.

The parameters can be categorized into:
1) Changes of run-time environment
2) Compile time parameters (including choice of compiler)
3) Configuration parameters for MySQL
4) Configuration parameters for InnoDB

Finally there is also a set of parameters one can use to affect the …

Hi Friends

I wanted to let you know that my employer Ning is Hiring! Ning is the largest platform in the world for creating your own custom social network. It's an exciting time to be a part of Ning since we recently decided to focus 100% of the energy of the company on our premium subscription business. Our platform now has over 70,000 paid subscribers, up from 15,000 from before transition from our “freemium” model, and we are currently seeing 80 million monthly unique visitors globally.

Because of this success, we are currently growing our organization and would love to chat with you about your background to see if there is a potential fit for our engineering team. We are hiring for a number of openings -- scalability/infrastructure engineers (We are in the top 100 largest sites in US), application developers (we have a number of killer consumer facing features to be built), system administrators (we manage …

Mark your calendars for Nov 2 as Mark Callaghan and Facebook's MySQL team will be talking about how MySQL is used at Facebook.

Working with clients, sometime I have to deal wih more than 300
tables within a schema. In order to identify tables, views,
table size, alphabetical ordering of tables, engines etc.
Information Schema is the best place to look for detailed information.

Quick Alternatives:

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 5.2.2-MariaDB-gamma Source distribution

This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> use sakila;
Database changed
MariaDB [sakila]> show full tables;
+----------------------------+------------+
| Tables_in_sakila           | Table_type |
+----------------------------+------------+
| actor                      | BASE TABLE |
| actor_info                 | VIEW       |
| address …

This is the third in a series on what’s seriously limiting MySQL in core use cases (links: part 1, 2, 3). This post is about the way MySQL handles connections, allocating one thread per connection to the server.

MySQL is a single process with multiple threads. Not all databases are architected this way; some have multiple processes that communicate through shared memory or other means. It's cheap to create a connection to MySQL, because it just requires creating a thread (or taking one from a cache). This is generally so fast that there isn't really the need for connection pools as …

“We will not walk in fear of one another. We will not be driven into an age of unreason if we dig deep into our history and remember we are not descended from fearful men.” -- Edward R. Murrow When I thought about the content of this post, it came to my mind one of the movies where George Clooney is actor, director and writer. The movie is Good Night and Good Luck, a great snapshot of post-war American history and a great way, in my opinion, to analyse how a modern and democratic society has evolved since then. On Thursday 30th of September, I resigned from Oracle. I left my role as Sales Engineering Manager in EMEA. I left my team, my colleagues and my friends but, as I said in a goodbye letter, I am taking with me all the friendship and the teaching of the 5 most beautiful years of my working life. It would take too long to mention all the great moments I had at …

Changes (as compared to 4.50.308) include:
Bug fixes:
* Removed spaces in the integer and float format in Data Export wizard (T23612)
* Fixed NullReferenceException on saving a database project with opened table editors (T23519)
* Fixed NullReferenceException on deleting a table from a database with an opened inactive editor (T56081)
* Fixed NullReferenceException on auto hiding a tool window (T56033)
* Added possibility to edit a definer for triggers in the trigger editor (T23357)
* Fixed problem with BINARY(16) column type on selecting its data to the Data Editor (T23292)
* Fixed problem with empty gray windows after editing a table in the modal editor from Database Designer (T23164, T23018)
* Fixed link on the first page in the product tour (55629)
* Fixed syntax checking for some constructions in CREATE TABLE statements (55161)
* Fixed lost connection on …

While MySQL is famously known as the "M" of the popular LAMP stack (Linux, Apache, MySQL, PHP/Perl/Python), Windows consistently ranks as the #1 development platform for MySQL in our surveys.

If you're wondering what kind of applications MySQL customers deploy on Windows, a good example is the financial reporting application developed by Alsego for a major asset management company in Luxembourg.

Read our interview of Marc Van Oost, CEO of Alsego, to learn more about why they selected MySQL on Windows, and the value they saw in the MySQL Enterprise subscription.

For more information about MySQL on Windows, visit our Resource Center & get access to whitepapers, on-demand webinars and …

MySQL is the most popular open-source database in the world. It has the distinction of being the only database that is used in every continent. Yes, even Antartica!!! The reasons for such popularity is its availability, performance, robustness, etc. It provides three types of database engines, MyISAM, InnoDB, and MySQL Archive. Out of these, the MyISAM table is the default table type. It is fast, simple, and allows full-text searching. Although it is reliable, it can become corrupt and, thus, inaccessible following a system crash. You should use appropriate corrective measures to repair MySQL database. However, if you are not able to do so then you should use a third-party MySQL recovery software to do so.

Consider a scenario wherein you have MySQL 5.0.22 database running in your system. You use it for MediaWiki installation that is reported as corrupt. When you try to repair the table, the following error message is displayed:
…

Just in case you have’t noticed — this (Southern Hemisphere) summer, we are doing our first 4-day DRBD Total High Availability training class in Australia. Our course will be held in Brisbane, on January 18-21. Yes, that’s the week before linux.conf.au 2011, also held in Brisbane, where we will be presenting too.

DRBD Total is our standard training format giving you maximum insight into the Linux cluster stack. We have offered (and continuously improved) DRBD Total for over 2 years with …