Everything MySQL

A great place to be!

Chris
  • Male
  • Sunnyvale, CA
  • United States
Share on Facebook Share on Facebook MySpace

Chris's Friends

  • Morgan Tocker
  • Thomas A. Lekai
  • riazzz
  • Joe Devon
  • Mark R
  • Roland Bouman
  • Kevin Knapp
  • Dov Endress
  • Jason DiCioccio
  • Alexandre Almeida
  • Zachary Buckholz
  • Dan Smythe
  • Olaf Stein
  • Keri
  • Giuseppe Maxia

Chris's Discussions

BAD SQL - I've seen it happen, really!
14 Replies

So... in the shared hosting a DBA comes across many bad queries. For one reason or another a developer or admin or the guy who someone paid $10/hr writes SQL like this:SELECT DISTINCT…Continue

Tags: JOIN, inefficienct, nightmare, SQL

Started this discussion. Last reply by Dov Endress Sep 17, 2009.

Cool, cheap and easy - Inline BASH
4 Replies

I always end up using inline BASH scripts when I'm troubleshooting a server. Here are some simple but useful examples for ya.1. Check MySQL Replication and Innodb History Statusshell> while true;…Continue

Started this discussion. Last reply by Chris Sep 9, 2009.

MySQL Memory Allocation
4 Replies

What is the right way to allocate memory on a MySQL server?

Started this discussion. Last reply by Chris Sep 6, 2009.

Gifts Received

Gift

Chris has not received any gifts yet

Give a Gift

 

Chris's Page

Latest Activity

Chris posted a blog post

Ning Tech Talk on MySqL - Date Correction

Apologies for the scheduling conflict but the date has moved to the 20th of July. Save the date: July 20, 2011RSVP here: Ning-Tech-TalksThere have been many database infrastructure changes through Ning’s history since the company began in 2004. Our most recent, and hopefully final, database iteration is running on MySQL.  Over the past year we’ve designed and implemented a stable and highly available MySQL…See More
Jun 28, 2011
Chris posted a blog post

How We Implemented & Currently Maintain MySQL on the Ning Platform

MySQL Ning Meetup Coming Soon Save the date: July 20, 2011RSVP here: Ning-Tech-Talks There have been many database infrastructure changes through Ning’s history since the company began in 2004. Our most recent, and hopefully final, database iteration is running on MySQL.  Over the past year we’ve designed and implemented a stable and highly available MySQL environment.  MySQL was chosen to reduce Ning’s total…See More
Jun 20, 2011
Chris commented on Chris's blog post Comparing MySQL Statement-Based and Row-Based Replication
"Correct... The ordinal position of the column matters very much.  But try to convert a column on the slave to a different column type, lets say, from varchar(255) to text, and you'll start running into issues."
Feb 10, 2011
E. Souhrada commented on Chris's blog post Comparing MySQL Statement-Based and Row-Based Replication
"It's not true that the schemas must be the same between master and slave if you're using row-based replication. The slave schema can have additional columns not present in the master provided that those columns are at the end of the table…"
Feb 9, 2011
Chris posted a blog post

Comparing MySQL Statement-Based and Row-Based Replication

There are many ways you can replicate MySQL data, whether it be a simple two-node cluster, chain or master/master. This article explains the two types of data replication (Statement-Based Replication and Row-Based Replication) available in MySQL.There are many ways you can replicate MySQL data whether it be…See More
Feb 9, 2011
Chris posted a blog post

MySQL Workbench - Top 13 things you should know

MySQL Workbench has come a long way and keeps getting better! I honestly don't think that millage may vary on this one as it is one of the best no-cost GUI tools created for MySQL.I've always been pro command line for MySQL administration; however, there have always been powerful GUI tools that can aid administration, development and other tasks. Some great tools that I have used in the past are Toad, Navicat, phpmyadmin, and WebYog. Although all of the tools listed above are good I have had a…See More
Jan 5, 2011
Chris posted a blog post

Call for Participation - OSCON 2011

Submit a Proposal to Speak at OSCON OSCON is looking for speakers to lead sessions and tutorials during the 2011 conference. The Call for Participation is open now through February 7.Topics They're Looking For Topics we plan to explore in the 2011 program include:Doing more with less, a perpetual favoriteOpen source in smart phones and mobile networked devicesCloud computing, openness in…See More
Dec 27, 2010
Chris posted a blog post

KSCOPE11 - ODTUG Conference June 2011

Hey everyone,I always attend the O'REILLY MySQL Conference in April every year, but this year found another interesting conference that brings both Oracle and MySQL users together, KSCOPE11. This will be the second year with a dedicated MySQL track at Kscope11. There will be a clear focus on providing both developers and DBAs the right information, tools and best…See More
Dec 20, 2010
Chris posted a blog post

Simple Automation - Examining your MySQL Index Usage

I have a new article posted on the Database Journal...- Abstract -In the majority of MySQL systems, the schema is always updated and changed based on the needs and focus of the application, making it somewhat difficult to keep up with all of the changes that come down the pipe.Knowing how to index a schema based on the queries using the system is a great skill to have. In the majority of the systems I have worked on, the schema is always updated and changed based on the needs and focus of the…See More
Dec 14, 2010
Chris posted a blog post

Call for participation - MySQL Conference 2011

Gear up for the 2011 MySQL Conference! Get your presentations submitted soon, Call closes 11:59pm 10/25/2010 PDT. 2011 Conference Home PageSubmit a PaperSee More
Oct 11, 2010
Chris posted a blog post

MySQL Enterprise Dashboard - It's Cool!

I've been using MySQL Enterprise Monitor for some time now and have seen it grow from a somewhat clunky (ALPHA version) to a scalable and robust monitoring system. The MySQL Enterprise Monitor makes my job easier in a number of ways. Below is a short list of what I love about MySQL Enterprise Monitor:Tunable, agent based monitoringHistoric RRD graphsMySQL Query AnalyzerReplication topology visualizationMySQL Enterprise Monitor was highlighted during "MySQL Sunday" at the Oracle Open World…See More
Oct 7, 2010
Keri commented on Chris's video
Thumbnail

Chris Schneider of Ning presents MySQL HA Solutions

"too bad we couldn't get a pic of your "What the Varchar?" shirt...LOL"
Sep 28, 2010
Chris's blog post was featured

MySQL HA Presentation from Oracle's MySQL Sunday

MySQL Sunday at Oracle's Open world was a huge success given that it was MySQL's first year at the conference. I had a lot of fun and even a little excitement when a shirt caught fire during my presentation. Just added a video to the site for MySQL High Availability. Check it out here if you missed it at MySQL Sunday, also, you can get the slides in PDF format…See More
Sep 28, 2010

Past Events

LA MySQL MEETUP

Tuesday, Feb 24 2009
-- http://www.meetup.com/lamysql/calendar/9630123/

Chris's Photos

  • Add Photos
  • View All

Chris's Videos

  • Add Videos
  • View All

Chris's Blog

Ning Tech Talk on MySqL - Date Correction

Apologies for the scheduling conflict but the date has moved to the 20th of July.

 

Save the date: July 20, 2011

RSVP here: Ning-Tech-Talks



There have been many database infrastructure changes through Ning’s history since the company began in 2004. Our most recent, and hopefully final, database iteration is running on MySQL.  Over…

Continue

Posted on June 28, 2011 at 11:36am

How We Implemented & Currently Maintain MySQL on the Ning Platform

MySQL Ning Meetup Coming Soon

 

Save the date: July 20, 2011

RSVP here: Ning-Tech-Talks

 



There have been many database infrastructure changes through Ning’s history since the company began in 2004. Our most recent, and hopefully final, database iteration is running on MySQL.  Over the past year we’ve designed and implemented a stable and highly…

Continue

Posted on June 20, 2011 at 10:00am

Comparing MySQL Statement-Based and Row-Based Replication

There are many ways you can replicate MySQL data, whether it be a simple two-node cluster, chain or master/master. This article explains the two types of data replication (Statement-Based Replication and Row-Based Replication) available in MySQL.…

Continue

Posted on February 9, 2011 at 3:15pm — 2 Comments

MySQL Workbench - Top 13 things you should know

MySQL Workbench has come a long way and keeps getting better! I honestly don't think that millage may vary on this one as it is one of the best no-cost GUI tools created for MySQL.



I've always been pro command line for MySQL administration; however, there have always been powerful GUI tools that can aid administration,…

Continue

Posted on January 5, 2011 at 1:30pm

Comment Wall (3 comments)

You need to be a member of Everything MySQL to add comments!

Join Everything MySQL

At 10:54am on September 15, 2009, Joe Devon said…
No worries. Forgot my password for awhile though :) BTW, spreading the word: http://twitter.com/joedevon/status/4009360113

Do you have a Twitter id?
At 7:16pm on September 11, 2009, Dov Endress said…
I'll make it to the UC next year for sure, if for no other reason than to heckle :P

The Oracle move is for one of 5 product lines I take care of, so I'll definitely still have MySQL around. We've been moving a design that wasn't scalable to a new architecture, and working an Oracle switch into the equation (where it has it's own set of problems...good times indeed).

As too lunch, screw that, you and the wife and kid (still one kid right?) are having steak on ValueClick ;) .

I've been thinking about going up to San Fran for a longish weekend with the wife and kids...I'll let you know when.
At 10:57am on September 11, 2009, Dov Endress said…
I've been great really. Busy as hell with VCLK. We're transitioning a big chunk of data to Oracle. As for the UC, isn't it next April or something? I might be in the bay area for Oracle's Openworld in Oct, but I'm not sure. I'll probably make the UC next year...who knows.
 
 
 

RSS

© 2024   Created by Chris.   Powered by

Badges  |  Report an Issue  |  Terms of Service