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 152 Next 30 Older Entries

Displaying posts with tag: Learning (reset)

OurSQL Episode 46: It's About Time
+1 Vote Up -0Vote Down

This week we talk about time formats and time zones in MySQL - including how changing the system time changes TIMESTAMP values but not DATETIME values. We also talk about how to handle and store microseconds in MySQL.

From the MySQL manual:
date and time types
TIMESTAMP properties and how it is stored in UTC transparently in the database
ALLOW_INVALID_DATES sql_mode

read more

OurSQL Episode 44: Elemental Replication (Tungsten, that is)
+2 Vote Up -0Vote Down

Last week's podcast, containing an overview of replication

This week we have Robert Hodges, CEO of Continuent, talking about the Tungsten replicator, which has an open source component with global transaction id's and can be used for many features, including high availability and replication to systems other than MySQL. Tungsten Replicator won Application of the Year award at the 2011 O'Reilly MySQL Conference.

read more

OurSQL Episode 42: The Buzz about MySQL 5.6
+2 Vote Up -0Vote Down

This week we talk about what's new in MySQL 5.6 and the return of labs.mysql.com. We also feature people's reactions to the 5.6 announcement and a special song by Solomon Chang (lyrics below).

Show notes:
If you want to see it for youreslf, there is a video from the O'Reilly Conference of Tomas Ulin's Keynote, "State of the Dolphin".

Olav Sandstå's blog post on index condition pushdown optimization.

read more

OurSQL Episode 40: TokuDB 5.0 part 2
+3 Vote Up -0Vote Down

This week we conclude the interview with Tokutek's co-founder and Chief Scientist, Martin Farach-Colton. Part 1 of the interview. TokuDB is a transactional, fully ACID-compliant storage engine that uses fractal trees for data and indexes, instead of MySQL's standard B-tree implementation. Combined with TokuDB's message-based architecture, TokuDB data and indexes do not fragment, have completely online column and index addition and removal and unlike InnoDB and XtraDB, do not fall apart when indexes no longer fit into memory.

read more

OurSQL Episode 39: TokuDB 5.0 part 1
+3 Vote Up -0Vote Down

TokuDB is a transactional, fully ACID-compliant storage engine that uses fractal trees for data and indexes, instead of MySQL's standard B-tree implementation. Combined with TokuDB's message-based architecture, TokuDB data and indexes do not fragment, have completely online column and index addition and removal and unlike InnoDB and XtraDB, do not fall apart when indexes no longer fit into memory.

We spoke with Martin Farach-Colton, co-founder and Chief Scientist of Tokutek about the TokuDB storage engine, including the new features in TokuDB 5.0, which was announced on Tuesday.

read more

OurSQL Episode 32: Backup tools you already have [Backup series #2]
+2 Vote Up -0Vote Down

Show notes:

Previous backup series podcast:
Backup glossary [Backup series #1]

Feedback:
In the backup glossary we asked if anyone knew how to get logical data out of physical InnoDB files. Mike Hamrick of Blue Gecko wrote in to say that Percona's InnoDB recovery tool helps to do just that. He writes:

"The 'page_parser' tool will read ibdata files or individual .ibd files and turn them into a series of 16k page files suitable for processing with a tool called 'constraints_parser' which spits out a number of tab separated lines of table data suitable for a LOAD DATA INFILE.

read more

OurSQL Episode 27: To SQL or No[tto]SQL, that is the question
+5 Vote Up -0Vote Down

We talk about HandlerSocket with special guest Patrick Galbraith of Blue Gecko, have some Ear Candy and talk about OSCon and the Strata Conferences

The HandlerSocket announcement blog post from Yoshinori Matsunobu of DeNA: http://yoshinorimatsunobu.blogspot.com/2010/10/using-mysql-as-nosql-stor...

HandlerSocket in Percona's build: http://www.mysqlperformanceblog.com/2010/12/14/percona-server-now-both-s...

PBXT has had it for years: http://pbxt.blogspot.com/2010/12/handlersocket-why-did-out-version-did.h...

sample MySQL settings using HandlerSocket from

  [Read more...]
Fantastic VoltDB presentation (video and slides available) by Tim Callaghan at the Boston MySQL User Group
+4 Vote Up -0Vote Down

Special thanks to Tim Callaghan for giving a fantastic presentation of VoltDB at Monday's Boston MySQL User Group meeting. Even though the title was "for SQL developers" there was a lot of content for DBAs as well (how backups are done, what the data and server-level architecture is, etc). It was an EXCELLENT presentation on how VoltDB works, and what applications it is and is not appropriate for. The video is almost 2 hours long; there's a LOT of excellent information in it.

The slides can be downloaded (PPT format) from:
http://technocation.org/files/doc/2010_09_VoltDB.ppt

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...]
How To Learn Oracle (MySQL, SQL Server, Java…)
+6 Vote Up -0Vote Down

Today I’ve read the following email on the mailing list of Sydney Oracle Meetup. I thought that this question is asked many times in attempt to find a silver bullet to learning Oracle so I wanted to publish my reply here on the blog, especially, that I’m a firm believer in one silver bullet that exists — there are no silver bullets.

Hi everybody,

My name is Sebastian and I’m new in the group. Yesterday I arrived late because I had a problem at work at the very last minute. However I found the meeting super interesting.

I’d like to see if someone could give me some piece of advise… I have ZERO experience

  [Read more...]
MySQL site down? Can't get MySQL Docs? Technocation has a mirror!
+2 Vote Up -3Vote Down

If the MySQL site (including documentation) isn't working for you, try a mirror site.

"But," you ask, "how do I know what the mirror sites are if I can't access the site?"

Great question! Technocation has a mirror site (updated daily) at http://technocation.org/mirror/mysql/.

Also, we have purchased www.mysqlmirrors.com which points to the official list of mirrors at http://technocation.org/mirror/mysql/downloads/mirrors.html.

read more

MySQL User Group Videos
+1 Vote Up -0Vote Down

2009 Boston MySQL User Group Videos:

Dec 2009 - Time Zones in MySQL (Sheeri K. Cabral) - video - PDF presentation - Description

Nov 2009 - How InnoDB works: Exploring SHOW ENGINE INNODB STATUS (Sheeri K. Cabral) - video - PDF presentation - Description

read more

Learning Drizzle
+0 Vote Up -0Vote Down

Wanting to learn Drizzle? My friend Kent is doing just that, and documenting everything as he goes. It’s a great time to learn, as we head up to the bell milestone (which will be awesome) and big user visible changes are certainly slowing.

So, head on over to Learning Drizzle and learn Drizzle with Kent. Should be awesome.

Eric Day and Patrick Galbraith speak about Drizzle at the July 2009 Boston MySQL User Group
+0 Vote Up -0Vote Down

Eric Day and Patrick Galbraith spoke on Drizzle, Gearman and Narada at the July 2009 Boston MySQL User Group. This is part 1 of the video, which is about an hour long and is about Drizzle.

"We will explain what the Drizzle project is, what we aim to accomplish, and an overview of where we are at."

The slides can be downloaded from http://www.oddments.org/notes/DrizzleGearmanBoston2009.pdf

The User Group calendar item for this event is http://www.meetup.com/mysqlbos/calendar/10607736/

read more

Last 3 Days of Free JavaFX, MySQL and GlassFish Training Class - Atlanta, Raleigh, Cleveland
Employee_Team +0 Vote Up -0Vote Down

I just found out but Sang has been teaching a series of 1-day free training sessions on JavaFX, MySQL and GlassFish. The full list is at his JavaPassion Site but by now there are only 3 days left, so check it out and signup if you are interested and available.

June 24th, Atlanta, GA
June 25th, Raleigh, NC
June 26th, Cleveland, OH

Network Management Data Reduction and Smoothing -- A MySQL Webinar
Employee +1 Vote Up -0Vote Down

ScienceLogic embeds MySQL (http://www.mysql.com/" target="_blank) in its EM7 network management appliances. An installation of EM7 can perform over half a billion database queries daily, storing massive amounts of data for both real-time and trended performance reporting.

Michael McFadden, senior software architect with ScienceLogic, will discuss all this in an upcoming MySQL webinar (http://mysql.com/news-and-events/web-seminars/display-361.html).

Network Management Data Reduction and Smoothing -- A MySQL Webinar
Employee +0 Vote Up -0Vote Down

ScienceLogic embeds MySQL (http://www.mysql.com/" target="_blank) in its EM7 network management appliances. An installation of EM7 can perform over half a billion database queries daily, storing massive amounts of data for both real-time and trended performance reporting.

Michael McFadden, senior software architect with ScienceLogic, will discuss all this in an upcoming MySQL webinar (http://mysql.com/news-and-events/web-seminars/display-361.html).

Network Management Data Reduction and Smoothing -- A MySQL Webinar
Employee +0 Vote Up -0Vote Down

ScienceLogic embeds MySQL (http://www.mysql.com/" target="_blank) in its EM7 network management appliances. An installation of EM7 can perform over half a billion database queries daily, storing massive amounts of data for both real-time and trended performance reporting.

Michael McFadden, senior software architect with ScienceLogic, will discuss all this in an upcoming MySQL webinar (http://mysql.com/news-and-events/web-seminars/display-361.html).

Video: InnoDB Database Recovery Techniques
+0 Vote Up -0Vote Down

Video for the presentation at the 2009 MySQL Camp:
InnoDB Database Recovery Techniques
Peter Zaitsev (Percona)

Description:
Have you ever had Innodb database corrupted or have deleted data accidentally and want it back ? This session will go through various approaches you can use to get most of your data back using MySQL build in features as well as third party open source tool.

This session speaks about Innodb database recovery techniques (apart from recovering from back).

First we will discuss various types of Innodb corruption and data loss scenarios ranging from user error to hardware failures.

read more

Video: Understanding How MySQL Works by Understanding Metadata, part 2
+0 Vote Up -0Vote Down

Part 2 of "Understanding How MySQL Works by Understanding Metadata", presented by Sheeri K. Cabral (The Pythian Group) and Patrick Galbraith (Lycos Inc.). This was a 3-hour tutorial.

The PDF of the slides can be found at http://technocation.org/files/doc/2009_04_Understanding.pdf.

From the official abstract at http://www.mysqlconf.com/mysql2009/public/schedule/detail/5682:

We have spent countless hours researching over 1,000 pieces of metadata. In the process, we have learned a lot about how MySQL works, and realized that it was a pretty good learning method.

read more

Video: Understanding How MySQL Works by Understanding Metadata, part 1
+0 Vote Up -0Vote Down

Part 1 of "Understanding How MySQL Works by Understanding Metadata", presented by Sheeri K. Cabral (The Pythian Group) and Patrick Galbraith (Lycos Inc.). This was a 3-hour tutorial.

The PDF of the slides can be found at http://technocation.org/files/doc/2009_04_Understanding.pdf.

From the official abstract at http://www.mysqlconf.com/mysql2009/public/schedule/detail/5682:

We have spent countless hours researching over 1,000 pieces of metadata. In the process, we have learned a lot about how MySQL works, and realized that it was a pretty good learning method.

read more

Video: What the MySQL Is This, Anyway?
+0 Vote Up -0Vote Down

Giuseppe Maxia and I are in the exact middle of our leg of the MySQL Campus Tour. Yesterday's session is was recorded -- A PDF of the slides can be downloaded at http://technocation.org/files/doc/2009_04_Tour.pdf (21 Mb).

The video is below:

read more

Real Time Data Warehousing Presentation
+0 Vote Up -0Vote Down

At the March Boston MySQL User Group meeting, Jacob Nikom of MIT's Lincoln Laboratory presented "Optimizing Concurrent Storage and Retrieval Operations for Real-Time Surveillance Applications." In the middle of the talk, Jacob said he sometimes calls what he did in this application as "real-time data warehousing", which was so accurate I decided to give that title to this blog post.

The slides can be downloaded in PDF format (1.3 Mb) at http://www.technocation.org/files/doc/Concurrent_database_performance_02.pdf. The 54 minute video can be downloaded (644Mb) at http://technocation.org/node/693/download or streamed directly in your browser at

  [Read more...]
Video: Partitioning in MySQL 5.1
+0 Vote Up -0Vote Down

At the January 2009 Boston User Group I presented a session on the new partitioning feature in MySQL 5.1. I go through how to define partitions, how partitioning makes queries faster, the different types of partitioning and when to use each type, and the restrictions and limitations of partitioning.

The sildes are available at http://www.technocation.org/files/doc/2009_01_Partitioning.pdf. The 380.6 Mb .mov movie (1 hr 16 min) can be played directly in your browser at http://technocation.org/node/671/play or downloaded at http://technocation.org/node/671/download.

read more

New in MySQL 5.1: The Presentation
+0 Vote Up -0Vote Down

What's new, in a nutshell: http://dev.mysql.com/doc/refman/5.1/en/mysql-nutshell.html.

Release notes: http://dev.mysql.com/doc/refman/5.1/en/news-5-1-x.html (In the video, it's the page entitled "Changes in release 5.1.x").

And yes, very early on (at about 2 minutes in) I talk about my take on Monty's controversial post at http://monty-says.blogspot.com/2008/11/oops-we-did-it-again-mysql-51-released.html

read more

SQL Newbie Book
+0 Vote Up -0Vote Down

I have written a new book on SQL DML. This is a total beginner book: how to commit and rollback, how to query, how to add data, etc.

Probably not of interest to most of the people who read this blog but if you know of anyone completely new to SQL, this would make a great Christmas present. Only 14.95. It is completely vendor agnostic, although the examples all use Oracle and MySQL.

You can view the Table Of Contents, Preface and Index here. I plan to release some of the chapters for free on the blog and will make the PDF of the book available at a discount. I have several more

  [Read more...]
How to Stop Hating MySQL
+0 Vote Up -0Vote Down

At LISA 2008, I gave a presentation entitled "How to Stop Hating MySQL: Fixing Common Mistakes and Myths".

The presentation slides can be downloaded as a PDF at:

http://technocation.org/files/doc/stophatingmysql.pdf

View the video online at http://technocation.org/node/646/play or download the 202.5 MB Flash video file (.flv) directly at http://technocation.org/node/646/download.

Here are some notes and links I referred to:

read more

EVCA: MySQL as a VC success story — Lessons Learned
Employee +0 Vote Up -0Vote Down

Today at the Venture Capital Forum in Hilton Arc de Triomphe, Paris, I received the EVCA “Hall of Fame” Award on behalf of MySQL AB. What a timing, to meet with investment bankers and venture capitalists now!

In these times of a deep finance crisis, of no credit handed out by banks and of general doom and gloom, it felt great to be somewhat of an “everybody’s darling”. In the VC community, MySQL is seen as a great success — and in particular, we’re seen by European VCs as a European success story (despite over 50 % of our personnel and most of our Management Team being US-based, at the point of time when the VCs exited).

  [Read more...]
Cluster Talk at March 2008 Boston User Group -- Slides and Video Are Up!
+0 Vote Up -0Vote Down

Well, nobody from Sun showed up in person, but we got a great rendition of "Where were you when you heard THE NEWS that Sun bought MySQL?" from Mark Rubin, the MySQL Sales Engineer for the New England area, and from Giuseppe Maxia, who revealed something very interesting and riveting.

From there, Giuseppe gave a short talk on what it's like to work at MySQL, and then we moved on to the topic of the user group meeting, "What is MySQL Cluster Good For?"

The slides for the talk are downloadable in PDF Format 61kB and Flash (SWF) format, 31kB

read more

Backups: A Video Presentation By Keith Murphy From the June 2008 Boston MySQL User Group
+0 Vote Up -0Vote Down

The Boston MySQL User Group was lucky enough to get Keith Murphy to speak at the June User Group meeting, about backups.

Links referred to in the presentation:

MyLVMBackup by Lenz Grimmer
http://lenz.homelinux.org/mylvmbackup/

InnoDB Hot Backup:
Prices are at:
http://www.innodb.com/hot-backup/order/
and at the time of this writing are:
1-Year License ? 390 USD$ 605 per server
Perpetual License ? 990 USD$ 1540 per server

read more

Previous 30 Newer Entries Showing entries 61 to 90 of 152 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.