Since one of our users has encountered a problem when modifying data via Data Editor, we decided to bring such a situation to our users’ attention. Let’s assume you have the following table: CREATE TABLE dept( DeptNo INT(10), DName VARCHAR(14), loc VARCHAR(13), Salsum FLOAT ); Let’s execute the following query in the SQL document: SELECT [...]

Don’t share root user password and mysql.user table acess with anyone till you have full trust on it. Because that encrypted password is real password in MySQL so if anyone knows that than he/she can easily login with any user if he has access to his host. Check with “mysql -uroot ” command, If you … Continue Reading …

Read the original article at A History lesson for Cloud Detractors

We've all seen cloud computing discussed ad nauseam on blogs, on Twitter, Quora, Stack Exchange, your mom’s Facebook page... you get the idea. The tech bloggers and performance experts often pipe in with their graphs and statistics showing clearly that dollar-for-dollar, cloud hosted virtual servers can’t compete with physical servers in performance, so why is everyone pushing them? It's just foolhardy, they say.

On the other end, management and their bean counters would simply roll their eyes saying this is why the tech guys aren't running the business.

News/Feedback
Registration for Percona Live: MySQL Conference and Expo is open! The conference is from Tuesday, April 10th through Thursday, April 12th. Use code PL-pod and save 10% off the early bird prices!.

The next free Oracle Technology Network Developer Day for MySQL will be Thursday, February 9th, 2012 in Frankfurt, Germany. http://www.oracle.com/webapps/events/ns/EventsDetail.jsp?p_eventId=148478&src=7314534&src=7314534&Act=240

read more

Pluggable M3 (Monitis Monitor Manager) Framework

Who needs an introduction about M3? – Perhaps no one!
After gaining some reputation with M3, providing extra-easy integration of any monitor into Monitis it was time to take it to the next level.

Generally speaking, the work flow of M3 was described in detail in this article.

After some thought and design, we’ve decided it’d be best if M3 was pluggable. Pluggable in terms of being able to easily add execution and parsing plugins.
The interface and behavior of M3 …

Don't miss these talks at MySQL Users Conference:Tuesday, April 10MySQL Replication 101, 9:30 am -12:30 pm in Room 3Wednesday, April 11What's new in MySQL 5.5 and 5.6 Replication, 11:00 am - 12:00 pm in Room 7Be a Data Management Hero with Good Backups!, 1:00 pm - 2:00 pm in Room 6One to Many: The Story of Sharding at Box, 1:00 pm - 2:00 pm in Room 3Build simple and complex replication

As Keith announced today, there are two more Oracle ACE Directors for MySQL expertise. In case you are wondering how an ACE Director compares to a regular ACE, here is an overview and some FAQ.

MariaDB 5.3 has now three statistics counters for Multi Range Read optimization:

MariaDB [test]> show status like 'Handler_mrr%';
+-------------------------------+-------+
| Variable_name                 | Value |
+-------------------------------+-------+
| Handler_mrr_extra_key_sorts   | 0     |
| Handler_mrr_extra_rowid_sorts | 0     |
| Handler_mrr_init              | 0     |
+-------------------------------+-------+
3 rows in set (0.08 sec)

I’ve just added the first two. The reason for having them is as follows: the point of MRR is to provide speedup over regular execution by doing reads in disk order. In order to make reads in disk order, MRR needs buffer space where it accumulates and sorts read requests. If there are too many read requests to fit into the buffer, MRR will make multiple accumulate-sort-read passes.

Doing multiple …

MySQL is coming to Frankfurt am Main in Germany for a MySQL Developer Day, Febuary 9th.

This developer day has a wide range of sessions and two great resources:  Johannes Schlüter, MySQL Software Developer (great PHP resource as well) and Giuseppe Maxia, Oracle ACE Director for MySQL.

Take advantage of this chance to learn more about MySQL !  More information on the event in Germany can be found here.

Paris France will also host a Developer day in March 21st. More information on this will becoming soon.

Read the original article at What Wouldn’t Google Do?

In his latest book, What Would Google Do? Jeff Jarvis seems to have authored a gushing tribute to the search giant that has pledged to do no evil. He paints a very optimistic picture, and shows us over and over how Google has opened up industries, and how that same openness helps consumers like you and I.

Jarvis, if you don't know him by name, has been a journalist for some time, but gained particular cred and notoriety when he blogged with the headline "Dell lies. Dell Sucks" after his horrible experiences with Dell computers and customer service.

While digging through Googly chapters, on Real Estate, …