Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Previous 30 Newer Entries Showing entries 61 to 90 of 139 Next 30 Older Entries

Displaying posts with tag: Technical Blog (reset)

Webinar: What you need to know for a MySQL 5.0 -> 5.1 upgrade
+5 Vote Up -1Vote Down

IOUG has a free series of three webinars on upgrading MySQL. Each webinar is an hour long, and it starts with a webinar by me tomorrow at 12 noon Central time (GMT-5) on “Why and How to Upgrade to MySQL 5.1″. The webinar assumes you are upgrading from MySQL 5.0 to MySQL 5.1, and talks a little bit about the new features, server variables, and what you need to know when upgrading to MySQL 5.1.

The software used is GoToWebinar (formerly GoToMeeting), so you will need to install that software. To register, use the links on the IOUG MySQL Upgrade Webinar Series page.

The complete list of webinars in the MySQL Upgrade Series is:
* MySQL 5.1: Why and How to Upgrade
Sheeri Cabral, The Pythian Group
Tuesday, July 27, 12:00 p.m. – 1:00 p.m. CT (GMT-5)




  [Read more...]
Using MySQL Partitioning Instead of MERGE Tables
+8 Vote Up -0Vote Down

One common question I get is how to use partitioning instead of MERGE tables. The process I use involves using stored procedures to create and drop partitions. This article will go over the stored procedures I use; special thanks to Roland Bouman for taking a look and giving great feedback to optimize this process.

First, a simple table, not partitioned (yet):

use test;
DROP TABLE IF EXISTS my_part;
CREATE TABLE IF NOT EXISTS my_part (
  id int NOT NULL,
  creationDate datetime NOT NULL,
  PRIMARY KEY (id,creationDate)
) ENGINE=InnoDB;

In real, life there is more to the table than just id and creationDate. The most important part is that the partitioned field(s) need to be part of the primary key.

Now, add the partition definition. This can be done in the


  [Read more...]
Log Buffer #196, A Carnival of the Vanities for DBAs
+1 Vote Up -0Vote Down

Welcome to Log Buffer, the weekly roundup of database industry news.

For your reading pleasure this week we have Log Buffer #196:

Charles Hooper blogs about an in-depth investigation on what can cause Oracle to ignore a hint.

Doug Burns reminds his readers that there are only two weeks left to

  [Read more...]
Three Editions of MySQL are Available
+1 Vote Up -2Vote Down

Yes, you read the title correctly — there are three editions of MySQL available, according to http://www.mysql.com/products/enterprise/server.html (http://www.mysql.com/products/enterprise/server.html). Well, that page names two, and then of course there is the community edition….

From the manual page:

MySQL Enterprise Server is available in the following editions:

* MySQL Enterprise Server – Pro is the world’s most popular open source database that enables you to rapidly deliver high performance and scalable Online Transaction Processing (OLTP) applications.
* MySQL Enterprise Server – Advanced is the most comprehensive edition of MySQL. It provides all the benefits of MySQL Enterprise Server Pro and adds horizontal table and index partitioning for improving the performance and management of VLDBs

  [Read more...]
INFORMATION_SCHEMA tables are case sensitive
+2 Vote Up -1Vote Down

I wanted to get examples of some of the extra information that the Percona server has in its INFORMATION_SCHEMA metadata, and in doing so, I stumbled across an interesting MySQL bug/feature/point — INFORMATION_SCHEMA tables (which are actually system views) are case sensitive when used in comparisons:

mysql> use information_schema;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql>  select @@version;
+--------------------+
| @@version          |
+--------------------+
| 5.1.36-xtradb6-log |
+--------------------+
1 row in set (0.00 sec)

mysql> use information_schema;
Database changed
mysql> show tables like 'innodb%';
Empty set (0.00 sec)

mysql>  show tables like 'INNODB%';

  [Read more...]
Log Buffer #195, A Carnival of The Vanities for DBAs
+0 Vote Up -0Vote Down

A short post marks Pythian’s 195th edition of Log Buffer, a blog of blogs encapsulating what’s going on in the world of database administration.

Remember if you find a link or interesting blog post that you think Log Buffer should mention, send a note to the editor at Log Buffer and be sure to include the link, and a short note on why you think that others will want to read it too.

Now on to Log Buffer #195. Alex Gorbachev starts us off with his suggested readings and funnily enough,

  [Read more...]
Log Buffer #194, A Carnival of The Vanities for DBAs
+1 Vote Up -1Vote Down

We’re well into summer and almost at our 200th edition of Log Buffer, a blog of blogs about the database world.

Remember if you find a link or interesting blog post that you think Log Buffer should mention, send a note to the editor at Log Buffer and be sure to include the link, and a short note outlining why you think that particular post would be of value to other DBAs, or what you learned from reading it.

Now on to our weekly reading in Log Buffer #194:

Oracle Exadata is a topic that is getting hotter and hotter. Following Pythian’s announcement of Exadata services Oracle’s

  [Read more...]
Log Buffer #193 – A Carnival of The Vanities for DBAs
+1 Vote Up -0Vote Down

Welcome to Log Buffer, the weekly roundup of DBA industry happenings.

Read on for the latest updates in Log Buffer #193. Don’t forget, we’re always looking for volunteer editors to publish and host an issue of Log Buffer. If you’d like this to be you, contact the Log Buffer coordinator.

ODTUG/Kaleidoscope 2010 roundup:

Sheeri

  [Read more...]
ODTUG Kscope Wrap-up and Slides
+2 Vote Up -0Vote Down

Ronald Bradford and I produced a successful MySQL track at Kaleidoscope (hereinafter referred to as Kscope). With a speaker list of Philip Antoniades, Josh Sled and Craig Sylvester of Oracle, Laine Campbell of PalominoDB, Patrick Galbraith of Northscale, Sarah Novotny of Blue Gecko, Padrig O’Sullivan of Akiba, Dossy Shiobara of Panoptic.com and Matt Yonkovic of Percona, we knew the technical content was going to be great.

As someone who’s helped organize

  [Read more...]
ODTUG Kaleidoscope 2010: Best Practices
+1 Vote Up -0Vote Down

Updated: 29-Jun-2010, 30-Jun-2010.

For me, ODTUG Kaleidoscope 2010 started on Friday with the ACE Directors briefing. Best practices topic was touched there slightly and I twitted about it. I decided that the feedback deserves a blog post so I’m simply quoting the conversation here. If you have anything to add, you know where to find the comment box.

alexgorbachev:
best practices should be forbidden or rather renamed to blue-prints #
  [Read more...]
MySQL’s SQL Deviations and Extensions
+3 Vote Up -1Vote Down

Today at Kaleidoscope I will be doing a 90-minute session comparing MySQL’s SQL syntax to the ANSI/ISO SQL:2003 standard, entitled What Do You Mean, “SQL Syntax Error”?

You can download the PDF slides now.

For those that may be following along the presentation later today (4 pm Eastern time), here are some links that I may throw out during the session:

  • SQL 2003 standard – actually it is “Information taken from the Final Committee Draft (FCD) of ISO/IEC 9075-2:2003″ but it’s extremely close to the actual standard. The actual standard is a document that costs a non-trivial amount of money to get, and cannot be



  [Read more...]
MySQL and Quoting
+4 Vote Up -2Vote Down

MySQL does not follow the ANSI SQL standard for quoting. MySQL’s default quoting behavior is that either single or double quotes can be used to quote a string (this gets me into trouble when I work with Oracle databases, as double quotes do not indicate a string!).

mysql> SELECT 'alive';
+-------+
| alive |
+-------+
| alive |
+-------+
1 row in set (0.00 sec)

mysql> SELECT "alive";
+-------+
| alive |
+-------+
| alive |
+-------+
1 row in set (0.00 sec)

Bare words are dealt with in context; in this case, a bare word would be parsed as a column name:

mysql> SELECT alive;
ERROR 1054 (42S22): Unknown column 'alive' in 'field list'

Backquotes are the way MySQL escapes table names. So, if you want a reserved word, number or operator to be the name of an object (ie, a table named “1″ or a column named “date”)

  [Read more...]
Log Buffer #192, A Carnival of The Vanities for DBAs
+1 Vote Up -0Vote Down

It’s Friday, and summer’s here. While it seems the industry is slowing down to a lazy pace, there is still some action so let’s splash right in to this week’s edition of Log Buffer DBA industry news in Log Buffer #192.

Alex Gorbachev had a few minutes to suggest the following interesting tidbits to me before running off to attend Oracle ACE Director activities at ODTUG/Kaleidoscope this weekend. One of these days we’ll have to see if he can share some of what

  [Read more...]
ODTUG Kaleidoscope 2010 — Ready… Set… Go-o-o!
+1 Vote Up -0Vote Down

It is time… Time for one more very special conference for me. Why special?

  • I have never been to ODTUG Kaleidoscope before. I always like new conferences — new experience.
  • Unlike Sheeri, I do not speak! This is one of those rare conferences where I come to slack off, meet old friends and make new ones, go to lots of sessions and actually learn stuff.
  • Coming from the DBA background, it’s not often that I come to development oriented conferences and I think I should do more of that.
  • It’s in Washington, DC. I lived there for some time and have number of good friends there. I’m really excited to see them again!
  • So what am I going to do there? I just arrived and right in time for the Oracle ACE Directors’

      [Read more...]
    OpenSQLCamp Boston Pages are online
    +5 Vote Up -1Vote Down

    OpenSQLCamp is less than 4 months away, and I have finally gotten around to updating the site. Special thanks go to Bradley Kuzsmaul and the folks at Tokutek for getting the ball rolling and making the reservation at MIT. Using MIT means that we will have *free* reliable wireless guest access and projects.

    OpenSQL Camp is a free unconference for people interested in open source databases (MySQL, SQLite, Postgres, Drizzle), including non-relational databases, database alternatives like NoSQL stores, and database tools such as Gearman. We are not focusing on any one project, and hope to see representatives from a variety of open source database projects attend. As usual I am one of the main organizers of Open SQL Camp (in previous years, Baron Schwartz, Selena Deckelmann and Eric Day have been main organizers too; this year Bradley

      [Read more...]
    Next Week’s MySQL Sessions at ODTUG Kaleidoscope
    +3 Vote Up -1Vote Down

    By now you know that there is a MySQL Track during next week’s ODTUG Kaleidoscope in Washington, DC. Ronald Bradford and I organized the schedule at the last minute (Ronald did a lot of the work!). It was difficult to fill a schedule with 19 sessions that are either 1 hour or 1.5 hours long, and to do it I ended up with three presentations.

    At each presentation I will be giving away a copy of The MySQL Administrator’s Bible, so be sure to show up! All MySQL track sessions are in Maryland C, and all times are Eastern.

    On Monday, June 28th from 4 pm – 5:30 pm I will be presenting

      [Read more...]
    Keeping Up
    +2 Vote Up -0Vote Down

    I found I never published this post as it was sitting in my drafts few months now — it was written in 13th February, 2010. I’m publishing it without any changes.

    I learn therefore I am!

    I’ve just wrote few bits about learning a new technology and after skimming through my Google Reader, I noticed a great post by Chen Shapira — Deliberate Practice. That’s reminded me about another aspect of learning that I didn’t mention — learning is a continuous process.

    There are two aspects…

    • No matter how good I am and how much I know, my knowledge and expertize become outdated relatively quickly these days unless I keep up with the
      [Read more...]
    Log Buffer #191, A Carnival of the Vanities for DBAs
    +0 Vote Up -0Vote Down

    Welcome to Log Buffer, the weekly roundup of database blogs.

    Kicking off this week in Log Buffer #191 are posts from Alisher Yuldashev:

    Randolf Geist blogs on an Advanced Oracle Troubleshooting Session – PGA/UGA memory fragmentation for when a batch process takes significantly longer than expected.

      [Read more...]
    Log Buffer #190, A Carnival of the Vanities for DBAs
    +0 Vote Up -0Vote Down

    Welcome to Log Buffer, the weekly roundup of database blogs. We’re back this week with a short Log Buffer #190. Only ten more issues, and we’ll be celebrating our 200th edition post.

    Chen Shapira was eager to share news early this week, sending along her favorite picks on Tuesday.

    Prof. Neil Gunther doesn’t like the way commercial load testing software distributes think times.



      [Read more...]
    The MySQL Track at Kaleidoscope is set!
    +5 Vote Up -1Vote Down

    The MySQL track at Kaleidoscope in Washington, DC during June 28-July 1st is set! Here is the schedule, Lincoln VI is the MySQL track room.

    Ronald has done a super job and spent a ton of hours in the past several weeks coordinating this effort. Work has kept me much busier than normal, but I have lent some time to the coordination as well. It is a credit mostly to Ronald that we have been able to plan an entire 19-session conference track, complete with confirming speakers, in less than a month. (You may notice the schedule does not have all 19 sessions full, we are just waiting for some more speakers to confirm details.)

    Whether or

      [Read more...]
    Log Buffer #189, A Carnival of the Vanities for DBAs
    +1 Vote Up -0Vote Down

    Welcome to Log Buffer, a weekly review of the database industry. This week’s issue Log Buffer #189 is generously published by Iggy Fernandez, editor of the quarterly journal of the Northern California Oracle User Group (NoCOUG).

    As always, if you’d like to host your own issue of Log Buffer, simply reach out to the Log Buffer coordinator.

    Please enjoy Iggy’s issue of Log Buffer #189.

    A Useful Tool to Centrally Manage Many MySQL Instances
    +7 Vote Up -2Vote Down

    I have been talking with a group of folks who have been making a product that has lots of free functionality, including the ability to centrally manage many MySQL instances. The administration functions include starting and stopping MySQL, seeing status and system variables, seeing and managing the MySQL config file (/etc/my.cnf), seeing and managing accounts, a small dashboard of overall health graphs, and more.

    With this free tool you can look at and manage local and remote databases. It supports ssh tunneling, including ssh using password-protected ssh keys. It’s pretty neat, and I have been working with the product manager to add features. I think this took will become the de facto standard for centralized GUI administration of MySQL.

    The tool is
    MySQL workbench….Surprise! One of the best new features for the

      [Read more...]
    An SSH tool to make your life easier
    +6 Vote Up -2Vote Down

    A MySQL user group member saw that I use Poderosa as my ssh-on-Windows tool, and asked why I did not use PuTTY. My response was that I like having tabbed windows and hate having to keep opening another PuTTY program every time I want to open another connection. With Poderosa I can open a new connection with Alt-N, and I can even connect directly to Cygwin with an icon.

    But Poderosa is not the tool I wanted to mention….Another user group member mentioned PuTTY Connection Manager. It wraps around PuTTY and gets the existing saved connections, makes a nicely tabbed browsing window where you can open sessions by double-clicking the connections, which are now listed on the right-hand side.

    See screenshot below:

      [Read more...]
    sort_buffer_size and Knowing Why
    +5 Vote Up -5Vote Down

    In How to tune MySQL’s sort_buffer_size, Baron gives a condescending viewpoint on how to tune the sort_buffer_size variable in MySQL. In a much-nicer-nutshell, his advice is “do not change sort_buffer_size from the default.”

    Baron did not explain the logic behind his reasoning, he handwaves that “people utterly ruin their server performance and stability with it,” but does not explain how changing the sort_buffer_size kills performance and stability. Regardless of how respected and knowledgeable the source, NEVER take any advice that tells you what to do or how to do it without understanding WHY.

    This article will explain the “why” of Baron’s point, and it will also talk more about understanding why, an integral

      [Read more...]
    The Doom of XtraDB and Percona Server?
    +7 Vote Up -5Vote Down

    In The Doom of Multiple Storage Engines, Peter talks about how the storage engine concept of MySQL is usually spoken of in positive terms, but there are many negatives.

    I have a hard time trying to figure out the deeper meaning behind Peter’s post, given that Percona writes a storage engine for MySQL, XtraDB. Does this mean that Percona will stop developing XtraDB? Does this mean that the Percona Server will diverge farther and farther away from MySQL so that they’re not compatible any more and migrating from MySQL to Percona Server is very difficult?

    Or maybe it’s just that Peter is saying one thing and doing the opposite; which just seems wrong because that would be blatant hypocrisy on Percona’s part.

    (This idea was a comment on

      [Read more...]
    Log Buffer #188, a Carnival of the Vanities for DBAs
    +2 Vote Up -1Vote Down

    It’s Friday already, and we know what that means! Log Buffer, the industry’s weekly review of database blogs is here again for your reading pleasure in the 188th issue.

    Starting off this week’s issue is a request from Mark Grennan a DBA who would like to let the community know about his blog MySQL Fan Boy, where he wrote an interesting post on including a script to replace MySQL table files on a live system, making it faster and limiting locking on large table loads. Also a post this week on whether MariaDB

      [Read more...]
    Liveblogging: Senior Skills: Sysadmin Patterns
    +1 Vote Up -4Vote Down

    The Beacon Pattern:
    - This is a “Get out of the business” pattern
    - Identify an oft-occurring and annoying task
    - Automate and document it to the point of being able to hand it off to someone far less technical

    Example:
    - System admins were being put in charge of scheduling rooms in the building
    - They wrote a PHP web application to help them automate the task
    - They refined the app, documented how to use it, and handed it off to a secretary
    - They have to maintain the app, but it’s far less work.

    The Community Pattern:

    - Prior to launch of a new service, create user documentation for it.
    - Point a few early adopters at the documentation and see if they can use the service with minimal support
    - Use feedback to improve documentation, and the service
    - Upon launch, create a mailing list, forum,











      [Read more...]
    Liveblogging: Seeking Senior and Beyond
    +2 Vote Up -1Vote Down

    I am attending the Professional IT Community Conference – it is put on by the League of Professional System Administrators (LOPSA), and is a 2-day community conference. There are technical and “soft” topics — the audience is system administrators. While technical topics such as Essential IPv6 for Linux Administrators are not essential for my job, many of the “soft” topics are directly applicable and relevant to DBAs too. (I am speaking on How to Stop Hating MySQL tomorrow.)

    So I am in Seeking Senior and Beyond: The Tech Skills That Get You Promoted. The first part talks about the

      [Read more...]
    MySQL Track at Kaleidoscope
    +11 Vote Up -2Vote Down

    On Monday, Ronald Bradford posted that the independent Oracle Developer Tools User Group had opened up their Kaleidoscope Conference, well-known throughout the Oracle community for in-depth technical sessions for developers, to the MySQL community. Giuseppe Maxia posted his thoughts on Tuesday.

    We have confirmed that there will be an entire MySQL track at Kaleidoscope! Because Kaleidoscope is less than 8 weeks away, we could not go through a standard call for papers. Ronald and I have been working to come up with appropriate topics and speakers for an audience that uses MySQL but is probably more familiar with Oracle. We contacted

      [Read more...]
    Log Buffer #187, a Carnival of the Vanities for DBAs
    +1 Vote Up -0Vote Down

    Welcome to Log Buffer. This week’s issue #187 was another group effort. Thanks to all our contributors – you rock!

    Suggested by Pythian’s Bradd Piontek, is a post he really liked because he used to write pipelined functions for Dynamic Search queries, – Tom Kyte’s something new I learned about estimated cardinalities. He’s also highlighted something new Tom learned about sqlplus. And the fact that Richard Foote announced the

      [Read more...]
    Previous 30 Newer Entries Showing entries 61 to 90 of 139 Next 30 Older Entries

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.