When looking at queries that are candidates for optimization I often recommend that people look at rows_sent and rows_examined values as available in the slow query log (as well as some other places). If rows_examined is by far larger than rows_sent, say 100 larger, then the query is a great candidate for optimization. Optimization could be as simple as adding a few indexes or much more complicated as in generating summary tables so you do not need to rely on large aggregations for your real-time queries.

Just to be clear this is a great rule for your “real time” queries need to be handled very quickly and in high volumes. Batch jobs, reporting queries often will have to scan through millions of rows to get few rows of result set and it is fine.

So it is all clear with rows_sent being smaller than rows_examined but can it be smaller ? Yes it can! Here are couple …

Somebody asked me if there was a cheaper alternative to using the Embarcadero Data Architect (a data modeling tool). I said sure, you can use the MySQL Workbench. My friend laughed and said, it’s to model Oracle databases and they use different data types. I broke the news to him that he can create his own user defined types and use MySQL Workbench to model problems for the Oracle Database 11g.

For example, you can launch the MySQL Workbench, and click on the Model menu option, and in the menu window click on the User Defined Types choice, as shown in the following:

Choosing the User Defined Type option, launches the following form. You can enter customized user defined types in the User Defined Types module:

…

Hadoop is an increasingly popular means of analyzing transaction data from MySQL. Up until now mechanisms for moving data between MySQL and Hadoop have been rather limited. Continuent Tungsten Replicator provides enterprise-quality replication from MySQL to Hadoop under a GPL V2 license.  Continuent Tungsten handles MySQL transaction types including INSERT/UPDATE/DELETE operations and can

Earlier this month I blogged about our new Hadoop applier, I published the docs for that this week (http://docs.continuent.com/tungsten-replicator-3.0/deployment-hadoop.html) as part of the Tungsten Replicator 3.0 documentation (http://docs.continuent.com/tungsten-replicator-3.0/index.html). It contains some additional interesting nuggets that will appear in future blog posts.

The main part of that functionality that performs the actual applier for Hadoop is based around a JavaScript applier engine – there will eventually be docs for that as part of the Batch Applier content ( …

Hi,

Sorry for the delay, I just got back into this problem today, and I basically installed dbForge Studio for MYSQL, I added the user ‘ssluser’@’localhost’, ssluser’@’192.168.0.12′, ‘ssluser’@’web-server.mgc.com’, ‘ssluser’@’127.0.0.1’ with auth_pam, and it says access denied ssluser@web-server.mgc.com, I did it thru ssh tunnel, I also tried directly from putty inside the webserver with mysql -u ssluser -p, and also with no luck it says access denied ssluser@localhost, then I deleted all the users, and recreated them with auth_pam_compat, and also the same problem. I don’t know where to go from here because I managed to get this webserver integrated with activedirectory, but just the mysql part is not successfull.

As a follow up to the previous blog announcement we are pleased to announce following conferences in EMEA & APAC which MySQL Community Team supports. As usual not only MySQL staff is attending, we are sharing our resources with Oracle VM, Linux and Java (where applicable). Please come to meet us at: 

EMEA 

• OpenSUSE Conference - Dubrovnik, Croatia, April 24-28, 2014
  • You can meet the MySQL team at our booth or at any of approved talks. Schedule for this event is not yet approved/published. Please watch the OpenSUSE website for current program schedule. 
• JavaScript UnConference, Hamburg, Germany, Apr 26, 2014 …

We are pleased to announce the SIG MySQL meeting taking place in Berlin, Germany next month! Come to hear news not only from the MySQL world but also on the other topics!

Event details:

Event Name: SIG MySQL

Date: March 27, 2014

Time: 9:30 - 17:30

Place: DOAG e.V. Geschäftsstelle Tempelhofer Weg 64 12347 Berlin  

Event URL & Agenda

We are looking to seeing you there! 

When we launched the official MySQL repos back in October, we wanted to achieve a number of things: First, we closed a gaping hole in our distribution on Linux. Some Linux distros do not ship all the MySQL products, and not everyone is able to or always wants to use the distro packages. And the […]

February 27, 2014 By Severalnines

Stockholm MongoDB User Group Meetup: “MongoDB and Hadoop” Monday, March 3, 2014 starting @ 5:00 PM

Join us next Monday as we host the Stockholm MongoDB User Group Meetup in Kista, or the Wireless Valley as it is also referred to. 

Our very own Vinay Joosery will be speaking about how to best automate the management & deployment of database clusters, specifically MongoDB clusters though the same principles apply for MySQL, MariaDB and Percona XtraDB based clusters. Henrik Ingo of MongoDB will be talking about Analytics with MongoDB & Hadoop. And Jim Dowling, a Senior Researcher at the Swedish Institute of Computer Science, will talk about a Hadoop PaaS platform. 

So whether you’re from the MySQL or NoSQL world, there’ll be plenty of good content here to walk away with in addition to getting …

One of my students asked how to convert MySQL Workbench’s default Crow’s Foot (IE) diagram to one of the other supported formats – Classic, Connect to Columns, UML, and IDEF1X. Crow’s Foot is also known as the Information Engineering Model method (covered in Chapter 3 of my MySQL Workbench: Data Modeling & Development.

It quite simple, you open the Model Overview window, click on the Model menu choice. In the dialog, click on the Relationship Notation menu option. Click on one of the choices in the nested menu, like Column to Columns.

Hope …