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 中文
Showing entries 1 to 30 of 32 Next 2 Older Entries

Displaying posts with tag: computing (reset)

#DBHangOps 10/02/13 — MySQL Utilities, Resource Management, and more!
+0 Vote Up -0Vote Down

Thanks to everyone who came. Definitely check out the recording below!

Heyo everybody!

Coming up this Wednesday, October 2nd, 2013 at 12:00pm pacific (19:00 GMT) is another exciting #DBHangOps. Join the google hangout to discuss:

  • MySQL Utilities from Chuck Bell!
  • How do you constrain over-consumption of resources by competing applications?
  • Network vs. Local storage for MySQL
    • How do you use this for HA? Do you use DRBD or floating VIPs?
  • Secure connections to MySQL (using SSL) (requested by Daniel)
    • Do you have experience with this? What’s the performance impact?
  • PCI Certification with MySQL — what changed for you?
  • MySQL-isms!
    • (From Gerry) Sub SELECTs — Why aren’t these as

  [Read more...]
#DBHangOps 9/17/13 — Data Warehousing, MySQL-isms, and MySQLConnect!
+0 Vote Up -0Vote Down

And that’s a wrap! Check out the recording:

Hello!

Coming up this Wednesday, September 18th, 2013 at 12:00pm pacific (19:00 GMT) come and join #DBHangOps to discuss:

  • Data warehousing in MySQL
    • Shipping large tables from production to your Data warehouse
    • Do you use Federated engine?
    • What other solutions do you use?
  • Answer some questions about MySQL-isms (requested by Tim Callaghan)
    • Why does MySQL have FRM files instead of storing them in a data dictionary table?
    • Why doesn’t InnoDB support other page sizes?
    • Why do we store data in a master.info file?
  • What are you excited to see at MySQLConnect?

As always, take a


  [Read more...]
#DBHangOps 9/4/13 — Data dictionary corruption, MySQL Utilities, Benchmarking, and MySQLConnect!
+0 Vote Up -0Vote Down

Check out the video!
Hey there everybody!

Coming up this Wednesday, September 4th, 2013 at 12:00pm pacific (19:00 GMT) take part in #DBHangOps to discuss:


  [Read more...]
#DBHangOps 8/21/13 — Fractal indexes in TokuDB and Schema tracking
+0 Vote Up -0Vote Down

Hey all!

Coming up this Wednesday, August 21st, 2013 at 12:00pm pacific (19:00 GMT) join in to talk about:

  • Gerry from Tokutek to talk about B-Tree indexes in InnoDB and fractal indexes TokuDB!
  • Schema Versioning
    • How do you manage schema versions in your development pipeline?
    • How are your schema changes deployed? Is it automated?
    • Some automated schema management tools:
  [Read more...]
#DBHangOps 7/24/13 — Innobackupex, schema migrations, and more!
+1 Vote Up -0Vote Down

And all set. Check out the recording:

Hello everybody!

Coming up this Wednesday, July 23rd, 2013 at 12:00pm pacific (19:00 GMT) join in to hear:

  • Brandon Johnson from Mozilla talk about an issue he recently worked through with XtraBackup and the process he took to identify and resolve the issues.

And also take part in discussion around:

  • How do you apply production schema changes?
    • Do you use pt-online-schema-change?
      • Issues to watch out for
    • Just run the alter!
    • Pull from a pool and apply

Make sure to follow the #DBHangops twitter search, the DBHangops Twitter Feed, or this blog post to get a link for the google hangout on Wednesday!

Excited to see all of you joining in on the conversation!

#DBHangOps 7/10/13 — Plugins, Kernel Settings, and THP!
+1 Vote Up -0Vote Down

All set, here’s the recording!

Hey there everyone!

Another informative and fun-filled #DBHangOps coming up this Wednesday, July 10th, 2013 at 12:00pm pacific (19:00 GMT). Join the discussion and contribute your experience on the following topics!

  • Plugins for MySQL
    • Which do you use?
    • Are there plugins that you want?
  • Kernel Parameters in Linux for MySQL, specifically:
  • InnoDB buffer pool size and settings
    • What works in your environment and why?
  • And If there’s time, information about the TokuDB storage engine in MariaDB!

Make


  [Read more...]
#DBHangOps 6/26/13 — Common_Schema, Plugins, Kernel Params, and more!
+1 Vote Up -0Vote Down

#DBHangOps for 6/26/13 is all done! Check out the recording below:

Hey everybody!

#DBHangOps is back this week at a slightly earlier time this Wednesday, June 26th, 2013 at 11:00am paciifc (18:00 GMT) . We’ll have special guest Shlomi Noach talking about the open source tools he’s developed to improve a DBA’s day-to-day work.

Be sure to check out the #DBHangops twitter search, the DBHangops Twitter Feed, or this blog post to get a link for the google hangout on Wednesday!

Thanks and see all of you there!

#DBHangOps 6/12/13 — Patches, Python, and Migrations!
+0 Vote Up -0Vote Down

Annnd all set! Check out the recording for the topics below:

Hello everyone!

We missed out on the last meeting time for #DBHangOps due to some conflicts, but we’re looking to come back strong this Wednesday, June 12th 2013 at 12:00pm pacific (19:00 GMT). Come join the discussion and contribute your experience on:

  • Upgrading to MySQL 5.6
    • Any issues or gotchas?
  • MySQL Python Utilities
    • How do you use them?
  • MySQL patches
    • Patches you use
    • Patches you want
  • Interesting or valuable Linux kernel settings

Be sure to check out the #DBHangops twitter search, the DBHangops Twitter Feed, or this blog post to get a link for the google hangout on Wednesday!

Looking forward to seeing you all there!

#DBHangops for 5/15/13 — Filesystems, monitoring, settings, Oh my!
+0 Vote Up -0Vote Down

Here’s the recording!

Heyo!

Now that we’ve gone through the Percona Live MySQL Conference and Expo review and had an amazing turnout to talk about it, it’s time to open up the discussion around things that DBAs want to talk about and need to be conscientious of. Join us on Wednesday at 12:00pm PDT (19:00 GMT) to take part in the discussion and share your knowledge and experience with the following topics:

  • Filesystems and MySQL — Which do you use and why?
    • Do you handle I/O alignment? How do you do it?
    • Scheduler changes?
  • Nagios checks! — Any new checks you’ve added recently?
  • The worst settings in MySQL that you always change
  • What are the most important variables to you,

  [Read more...]
2013 MySQL Conference and Expo — a #DBHangOps Review
+0 Vote Up -0Vote Down

Hey everybody!

The Percona Live MySQL Conference and Expo just wrapped up last week and we’re looking to get some conference in review talk from everyone! Talk about your favorite sessions, new things you learned, and your overall opinion of the conference!

Hop online Wednesday at 12:00pm PDT (19:00 GMT) to join the discussion and share your experience from the 2013 Percona Live: MySQL Conference and Expo.

Be sure to watch this twitter search or this blog post get a link for the google hangout tomorrow!

Some talks that were specifically called out:

  [Read more...]
#DBHangOps 4/10/13 (pre-Percona Conference!)
+0 Vote Up -0Vote Down

Annnnnd here’s the recording:

Hey all!

The Percona Live MySQL Conference and Expo is coming up in 2 weeks, meaning the last of preparations are under way. In the meantime, #DBHangOps is coming your way on Wednesday at 12:00pm PDT (19:00 GMT) with:

  • Talk about Performance Schema from Mark Leith
  • Some discussion on how people use and manage MySQL slow query logs in their environments
  • Filesystems and MySQL — which do you use, why, and how
  • What you’re excited about at Percona Live!

As always, hit up this twitter search or this blog post to grab the google hangout link to join!

See y’all on Wednesday!

#DBHangOps 3/27/13!
+0 Vote Up -0Vote Down

Hi everyone!

Here’s a video of this week’s #DBHangOps:

March 27th at 12:00pm PDT (19:00 GMT) is when the next #DBHangOps is gonna go down. Check out the twitter search and hop on the google hangout to contribute some discussion! This week’s topics are:


  [Read more...]
#DBHangOps Madness! 3/13/13
+1 Vote Up -0Vote Down

Here’s the recording!

Heyo!

March 13th at 12:00pm PDT (19:00 GMT) is the time to check in and hop online for #DBHangOps this week. Keep an ever watchful eye on the twitter search and hop on the google hangout to contribute some discussion! This week’s topics are:

  • Monitoring
    • What do you consider to be “standard” nagios checks for MySQL
  • Demos of Anemometer and MySQL Enterprise Monitor
  • Daily pain MySQL Bugs and Gotchas (e.g. show table status being cached)
  • MySQL 5.6

See all of ya on the google hangout!

#DBHangOps 02/27/13
+1 Vote Up -0Vote Down

EDIT: Video from today’s #DBHangOps!

Hey there peeps!

February 27th at 12:00pm PST it is! Check back here for more info and keep a watchful eye on the twitter search (and feel free to join the conversation!). The topics we’re looking to cover this week are:

  • Day-to-day pain points (what takes more time than it should?)
    • rolling restarts and upgrades
    • Performing checksums on your data
      $ /usr/bin/pt-table-checksum \
      --quiet \
      --ignore-databases=mysql,percona,information_schema,per
      formance_schema \
      --lock-wait-time=50 \
      --chunk-size-limit=0 \
      --no-check-plan \
      --no-check-binlog-format \
      --max-lag=1 \
      --replicate percona.checksums \
      h=database.example.com











  [Read more...]
#DBHangOps on 1/30/13 \o/
+1 Vote Up -0Vote Down

UPDATE: Here’s the recording, enjoy!

Hello everybody!

#DBHangOps coming at you this week, Wednesday 1/30/12 at 12:00pm PST. Be sure to check out this blog post tomorrow or check this twitter search to grab the link to join the Google Hangout.

This week’s topics were:
* bug fixes in recent versions
* Plugins
** authorization plugins (e.g. LDAP)
** audit plugin API — http://dev.mysql.com/doc/refman/5.5/en/writing-audit-plugins.html
*** state transitions of records in MySQL with a plugin?
* InnoDB Status variables from twitter — https://github.com/twitter/mysql/wiki/InnoDB-Status-Variables
* Table alters/schema changes
** Twitter patch for non-blocking alter table (throws a different error than









  [Read more...]
#DBHangOps on 01/16/13!
+2 Vote Up -0Vote Down

Update: Recording!

Finally, the end of year madness is over and we’re in a fresh new year. That must mean it’s time to get back into #DBHangops! Tune in on Wednesday, 1/16/13 at 5:00pm PST to get in on the fun and share your experiences.

Check back on this blog post tomorrow or check this twitter search to grab the link to join the Google Hangout.

Topics for this weeks hangout include:
* triggers: maintenance, problems, etc.
* Oracle MySQL utilities (similar to Percona toolkit)
** Slideshow of MySQL utilities
* Database caching and cache




  [Read more...]
#DBHangOps 11/28/12
+2 Vote Up -0Vote Down

Now that the thanksgiving holiday is over, it seems like the perfect time to have another #DBHangOps. If you’re interested, check this twitter search or check back on my blog here for a link to the google hangout.

Items currently on our agenda for today:
* Data corruption!
* Monitoring — what do you monitor, why, etc.
* Query killing — do you kill queries in production regularly, or in emergencies?
* Fun or useful configurations

Looking forward to chatting about MySQL stuff today!
Fun time hitting these topics this week. Check out the recording:

#DBHangOps
+0 Vote Up -0Vote Down

Woooo, just wrapped up another night of #DBHangOps, check out the video:

For those of you who aren’t familiar with this awesome series of videos, it’s a bi-weekly meeting of MySQL DBAs via a Google Hangout to simply talk about databases (specifically MySQL). The discussions range anywhere from silly stories to awesome learnings and even little gotchas to know about when working with MySQL operationally. If you’re interested in catching when the next #DBHangops will happen, check MySQL planet for a blog post about it, or check this twitter search.

We look forward to talking with you!

Advantages of weighted lists in RDBMS processing
+1 Vote Up -0Vote Down
A list is simply a list of things. The list has no structure, except in some cases, the length of the list may be known. The list may contain duplicate items. In the following example the number 1 is included twice.

Example list:
1
2
3
1

A set is similar to a list, but has the following differences:
  • The size of the set is always known

  • A set may not contain duplicates

  • You can convert a list to a set by creating a 'weighted list'. The weighted list includes a count column so that you can determine when an item in the list appears more than once:
    1,2
    2,1
    3,1
    
    Notice that there are two number 1 values in the weighted list. In order to make insertions into such a list scalable, consider using partitioning to avoid large indexes.








      [Read more...]
    Linux and open source no puff in the clouds
    +0 Vote Up -0Vote Down

    UPDATED - I had to update this post after a conversation with RightScale founder and CTO Thorsten von Eicken and for Sun’s Open Cloud announcement, which are both now included below.

    There has been some substantial technology and news regarding open source software in cloud computing lately. More proof that open source is reaching into nearly all aspects of enterprise and broader IT, and also reinforcement of the idea that open source software will continue to have a pervasive and disruptive impact on the way organizations of all shapes and sizes do their computing and deal with their data.

    First up is RightScale, which as detailed by 451 colleague and Principal Analyst William Fellows, is up and running across the pond on

      [Read more...]
    Cloud Computing for the White House?
    Employee +0 Vote Up -0Vote Down

    Ok, Now we are talking!

    Oh well, we know the Obama team is quite technology savvy and want to run the administration on the state of the art computer technologies. As an example, Obama campaign website used MySQL on the backend. 

    So then, can Cloud Computing benefits lure the administration? Security and Technology experts discuss on national public radio  if Cloud Computing will work for the White House and how their computers should run.  Kevin L. Jackson further muses if the Obama Administration should use Cloud Computing.  He believes that Cloud

      [Read more...]
    Cloud Computing for the White House?
    Employee +0 Vote Up -0Vote Down

    Ok, Now we are talking!

    Oh well, we know the Obama team is quite technology savvy and want to run the administration on the state of the art computer technologies. As an example, Obama campaign website used MySQL on the backend. 

    So then, can Cloud Computing benefits lure the administration? Security and Technology experts discuss on national public radio  if Cloud Computing will work for the White House and how their computers should run.  Kevin L. Jackson further muses if the Obama Administration should use Cloud Computing.  He believes that

      [Read more...]
    Cloud Computing for the White House?
    Employee +0 Vote Up -0Vote Down

    Ok, Now we are talking!

    Oh well, we know the Obama team is quite technology savvy and want to run the administration on the state of the art computer technologies. As an example, Obama campaign website used MySQL on the backend. 

    So then, can Cloud Computing benefits lure the administration? Security and Technology experts discuss on national public radio  if Cloud Computing will work for the White House and how their computers should run.  Kevin L. Jackson further muses if the Obama Administration should use Cloud Computing.  He believes

      [Read more...]
    Cloud Computing Expo: San Jose
    Employee +0 Vote Up -0Vote Down

    The Cloud Computing Expo at Fairmont Hotel in san Jose, CA is fast approaching and I plan to be there to learn and meet the folks interested in Cloud Computing. If you plan to be there, dont miss the hands on Cloud Computing BootCamp, also being held at Fairmont hotel on 20th Nov. and is Free.

    Led by Williamson, the Cloud Computing Bootcamp will illustrate all the major players and provide a hands-on program with configuration samples, live demos and working setups you can further adapt and play with.

    Hope to see you there and chat about how you can leverage the Sun Cloud offerings to build applications for the cloud or build your own clouds.



    Cloud Computing Expo: San Jose
    Employee +0 Vote Up -0Vote Down

    The Cloud Computing Expo at Fairmont Hotel in san Jose, CA is fast approaching and I plan to be there to learn and meet the folks interested in Cloud Computing. If you plan to be there, dont miss the hands on Cloud Computing BootCamp, also being held at Fairmont hotel on 20th Nov. and is Free.

    Led by Williamson, the Cloud Computing Bootcamp will illustrate all the major players and provide a hands-on program with configuration samples, live demos and working setups you can further adapt and play with.

    Hope to see you there and chat about how you can leverage the Sun Cloud offerings to build applications for the cloud or build your own clouds.



    Cloud Computing Expo: San Jose
    Employee +0 Vote Up -0Vote Down

    The Cloud Computing Expo at Fairmont Hotel in san Jose, CA is fast approaching and I plan to be there to learn and meet the folks interested in Cloud Computing. If you plan to be there, dont miss the hands on Cloud Computing BootCamp, also being held at Fairmont hotel on 20th Nov. and is Free.

    Led by Williamson, the Cloud Computing Bootcamp will illustrate all the major players and provide a hands-on program with configuration samples, live demos and working setups you can further adapt and play with.

    Hope to see you there and chat about how you can leverage the Sun Cloud offerings to build applications for the cloud or build your own clouds.



    Sun's Cloud Computing Portfolio
    Employee +0 Vote Up -0Vote Down

    Update: Sun has expanded its Cloud Computing portfolio with the recent acquisition of Qlayer, a cloud computing company that automates the deployment and management of both public and private clouds.  The Q-layer organization, based in Belgium, is now part of Sun's Cloud Computing business unit which develops and integrates cloud computing technologies, architectures and services.

    Cloud computing is about managing petascale data. Sun's server and storage systems can radically improve the data-intensive computing emerging in the cloud. Some clouds are closed platforms that lock you in. Sun's open source philosophy and Java principles form the core of a strategy that provides

      [Read more...]
    Sun's Cloud Computing Portfolio
    Employee +0 Vote Up -0Vote Down

    Update: Sun has expanded its Cloud Computing portfolio with the recent acquisition of Qlayer, a cloud computing company that automates the deployment and management of both public and private clouds.  The Q-layer organization, based in Belgium, is now part of Sun's Cloud Computing business unit which develops and integrates cloud computing technologies, architectures and services.

    Cloud computing is about managing petascale data. Sun's server and storage systems can radically improve the data-intensive computing emerging in the cloud. Some clouds are closed platforms that lock you in. Sun's open source philosophy and Java principles form the core of a strategy that provides

      [Read more...]
    Sun's Cloud Computing Portfolio
    Employee +0 Vote Up -0Vote Down

    Update: Sun has expanded its Cloud Computing portfolio with the recent acquisition of Qlayer, a cloud computing company that automates the deployment and management of both public and private clouds.  The Q-layer organization, based in Belgium, is now part of Sun's Cloud Computing business unit which develops and integrates cloud computing technologies, architectures and services.

    Cloud computing is about managing petascale data. Sun's server and storage systems can radically improve the data-intensive computing emerging in the cloud. Some clouds are closed platforms that lock you in. Sun's open source philosophy and Java principles form the core of a strategy that provides

      [Read more...]
    Test Drive MySQL on Solaris 10 for FREE in EZQual Virtual Labs. No Installation, No Cost
    Employee +0 Vote Up -0Vote Down

    MySQL is the defacto database of choice for most WebScale and Cloud Computing deployments.

    Every day you go to website like Facebook, CraigsList , eBay, Google, PriceGrabber, Yahoo!, and Zappos, you are touching a page that  uses MySQL.
    MySQL's popularity is due in large part to its flexibility. MySQL supports over 20 platforms and scales to handle terabytes of data. And, because MySQL is open source, it can be customized to an application's unique specifications. This flexibility has two-fold benefits for ISVs: MySQL is better able to address their applications' specific needs and it won't impose restrictions on their future development.

    Through the Sun Partner Advantage Program(SPA) , ISVs can now leverage Sun's entire portfolio of offerings - including MySQL. The SPA Program connects ISVs with



      [Read more...]
    Showing entries 1 to 30 of 32 Next 2 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.