jorgenloland.blogspot.com jorgenloland.blogspot.com

jorgenloland.blogspot.com

Jørgen's point of view

A blog about development on the MySQL optimizer

http://jorgenloland.blogspot.com/

WEBSITE DETAILS
SEO
PAGES
SIMILAR SITES

TRAFFIC RANK FOR JORGENLOLAND.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

December

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Thursday

TRAFFIC BY CITY

CUSTOMER REVIEWS

Average Rating: 3.0 out of 5 with 8 reviews
5 star
2
4 star
0
3 star
4
2 star
0
1 star
2

Hey there! Start your review of jorgenloland.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

Desktop Preview Tablet Preview Mobile Preview

LOAD TIME

0.3 seconds

FAVICON PREVIEW

  • jorgenloland.blogspot.com

    16x16

  • jorgenloland.blogspot.com

    32x32

CONTACTS AT JORGENLOLAND.BLOGSPOT.COM

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

SCORE

6.2

PAGE TITLE
Jørgen's point of view | jorgenloland.blogspot.com Reviews
<META>
DESCRIPTION
A blog about development on the MySQL optimizer
<META>
KEYWORDS
1 the table was
2 posted by
3 jørgen løland
4 4 comments
5 email this
6 blogthis
7 share to twitter
8 share to facebook
9 share to pinterest
10 labels composite index
CONTENT
Page content here
KEYWORDS ON
PAGE
the table was,posted by,jørgen løland,4 comments,email this,blogthis,share to twitter,share to facebook,share to pinterest,labels composite index,explain,json,optimizer,optimizer trace,range,labels innodb,performance,at ntnu,no comments,labels mark leith
SERVER
GSE
CONTENT-TYPE
utf-8
GOOGLE PREVIEW

Jørgen's point of view | jorgenloland.blogspot.com Reviews

https://jorgenloland.blogspot.com

A blog about development on the MySQL optimizer

INTERNAL PAGES

jorgenloland.blogspot.com jorgenloland.blogspot.com
1

Jørgen's point of view: FAQ: InnoDB extended secondary keys

http://jorgenloland.blogspot.com/2013/10/faq-innodb-extended-secondary-indexes.html

Jørgen's point of view. Mostly about the MySQL Optimizer. Monday, October 21, 2013. FAQ: InnoDB extended secondary keys. MySQL 5.6 introduced a new feature called extended secondary keys. We get a lot of questions about it and find that most of them come from a few incorrect assumption. In this post I'll try to get rid of the confusion once and for all. Famous last words. here goes:. Q1: Do I need to do anything to enable extended secondary keys? Q2: Does extended secondary keys only work with InnoDB?

2

Jørgen's point of view: The range access method and why you should use EXPLAIN JSON

http://jorgenloland.blogspot.com/2014/03/the-range-access-method-and-why-you.html

Jørgen's point of view. Mostly about the MySQL Optimizer. Friday, March 28, 2014. The range access method and why you should use EXPLAIN JSON. I got an interesting question about EXPLAIN. And the range access method recently. The person had a query that could be written either with a BETWEEN predicate or an IN predicate, something similar to this:. CREATE TABLE orders (. Order id INT NOT NULL PRIMARY KEY,. Customer id INT,. Order date DATE,. KEY custid value (customer id, value). Given that customer id.

3

Jørgen's point of view: Index merge annoyances fixed in MySQL 5.6

http://jorgenloland.blogspot.com/2012/10/index-merge-annoyances-fixed-in-mysql-56.html

Jørgen's point of view. Mostly about the MySQL Optimizer. Tuesday, October 2, 2012. Index merge annoyances fixed in MySQL 5.6. While the index merge access types. Certainly are useful for a number of queries, there has been some frustration expressed both from customers and the community about how it. Is not used when it should have been. Is used when ref access is obviously better. Is too restricted in which conditions can be used. Consider the problem in BUG#65274. CREATE TABLE phpbb posts (. In 567 we...

4

Jørgen's point of view: Copying unused bytes is bad (duh!)

http://jorgenloland.blogspot.com/2012/04/copying-unused-bytes-is-bad-duh.html

Jørgen's point of view. Mostly about the MySQL Optimizer. Wednesday, April 18, 2012. Copying unused bytes is bad (duh! Last summer my colleague Marko Mäkelä committed this seemingly innocent performance fix for InnoDB in MySQL 5.6:. 3581 Marko Makela 2011-08-10. Bug#12835650 VARCHAR maximum length performance impact. Row sel field store in mysql format(): Do not pad the unused part of. The buffer reserved for a True VARCHAR column (introduced in 5.0.3). Oh my were we up for a ride! The MySQL server used ...

5

Jørgen's point of view: Favorite MySQL 5.6 features: an optimizer perspective

http://jorgenloland.blogspot.com/2012/12/favorite-mysql-56-features-optimizer.html

Jørgen's point of view. Mostly about the MySQL Optimizer. Monday, December 17, 2012. Favorite MySQL 5.6 features: an optimizer perspective. There are so many exciting new features in MySQL 5.6 that I almost don't know where to start. To mention a few, MySQL's multi-core scalability. Has been significantly improved to meet modern hardware, InnoDB has better index statistics. Replication has multi-threaded slaves. And global transaction identifiers. New ways to understand query plans:. Once and for all&#46...

UPGRADE TO PREMIUM TO VIEW 14 MORE

TOTAL PAGES IN THIS WEBSITE

19

LINKS TO THIS WEBSITE

mysqlquicksand.wordpress.com mysqlquicksand.wordpress.com

Presenting at FOSDEM and Percona Live | Saving you from MySQL quicksand!

https://mysqlquicksand.wordpress.com/2014/01/22/presenting-at-fosdem-and-percona-live

Saving you from MySQL quicksand! Small disruptions can cause great disaster. Presenting at FOSDEM and Percona Live. Posted by Art van Scheppingen. January 22, 2014. MySQL Conference and Expo. Very short update from my side: I’ll be presenting at FOSDEM in Brussels (1-2 February 2014) and Percona Live MySQL Conference in Santa Clara (1-4 April 2014). At FOSDEM I will present about Galera replication in real life. At Percona Live MySQL Conference I will present about our globally distributed storage layers.

mysqlquicksand.wordpress.com mysqlquicksand.wordpress.com

Spil Games MySQL StatsD project on Github | Saving you from MySQL quicksand!

https://mysqlquicksand.wordpress.com/2013/10/15/spil-games-mysql-statsd-project-on-github

Saving you from MySQL quicksand! Small disruptions can cause great disaster. Spil Games MySQL StatsD project on Github. Posted by Art van Scheppingen. October 15, 2013. Spil Games Engineering blog. Yesterday evening I already announced the happy news on the Spil Games Engineering blog. You can find our MySQL StatsD daemon in our Github repository here:. You can also talk to us directly at Percona Live London. A bit of a shame to do it this way: I tried several times to add the Spil Games Engineering feed.

mysqlquicksand.wordpress.com mysqlquicksand.wordpress.com

banpei | Saving you from MySQL quicksand!

https://mysqlquicksand.wordpress.com/author/banpei

Saving you from MySQL quicksand! Small disruptions can cause great disaster. Banpei has written 4 posts for Saving you from MySQL quicksand! Presenting Sphinx Search at Percona Live London. October 29, 2014. It has been a while since I posted on this blog. The more in depth articles are all posted on the Spil Games Engineering blog and I’m overcrowded with work in the past months that I hardly have any time left. In basis it is a MySQL case study where I will show how we at Spil Games use Sphinx Search i...

johnemb.blogspot.com johnemb.blogspot.com

John's Observation Loft: Welcome to my loft

http://johnemb.blogspot.com/2012/01/welcome-to-my-loft.html

Observations from a tall Norwegian on anything from his day-to-day work as a software geek to random topics of interest. Tuesday, January 3, 2012. Welcome to my loft. Happy New Year, everyone! This is my very first blog post ever, and as such it is going to be short. Hopefully I will find the time and inspiration to put something here soon that may be of interest to others. Subscribe to: Post Comments (Atom). The views expressed on this blog are my own and do not necessarily reflect the views of Oracle.

effectivemysql.com effectivemysql.com

Replication Techniques in depth — Effective MySQL

http://effectivemysql.com/book/replication-techniques

Tuesday, August 23, 2016. Performance, Scalability and Business Continuity. Replication Techniques in depth. June 15, 2012. The third book of the Effective MySQL series provides the reader with the tools, knowledge and tips for managing a scalable MySQL Replication environment. The Five Minute DBA. Diagnosing Common Replication Problems. Improving Standard Replication Features. Extending Replication for Practical Needs. You can find the code examples from this book at. Effective MySQL: Backup and Recovery.

johnemb.blogspot.com johnemb.blogspot.com

John's Observation Loft: January 2012

http://johnemb.blogspot.com/2012_01_01_archive.html

Observations from a tall Norwegian on anything from his day-to-day work as a software geek to random topics of interest. Tuesday, January 3, 2012. Welcome to my loft. Happy New Year, everyone! This is my very first blog post ever, and as such it is going to be short. Hopefully I will find the time and inspiration to put something here soon that may be of interest to others. Links to this post. Subscribe to: Posts (Atom). Welcome to my loft. View my complete profile. Guessing Credit Card Security Details.

effectivemysql.com effectivemysql.com

Lessons learned managing large AWS Environments — Effective MySQL

http://effectivemysql.com/presentation/lessons-learned-managing-large-aws-environments

Wednesday, August 24, 2016. Performance, Scalability and Business Continuity. Lessons learned managing large AWS Environments. February 4, 2013. At the recent AWS Meetup group. In New York, I gave a presentation on “Lessons learned managing large AWS Environments”. This included my experiences in managing and optimizing AWS costs, CLI automation for web scale (my work at GitHub. Knowing about and improving security, what is important monitoring and dealing with failure. New York MySQL Users Group.

effectivemysql.com effectivemysql.com

The history and future of the MySQL Ecosystem — Effective MySQL

http://effectivemysql.com/presentation/the-history-and-future-of-the-mysql-ecosystem

Wednesday, August 24, 2016. Performance, Scalability and Business Continuity. The history and future of the MySQL Ecosystem. June 15, 2013. This week I was the guest speaker at the New York Linux Users Group (NYLUG) Meetup. Where I had the opportunity to talk about The history and future of the MySQL Ecosystem. A video of the presentation will be available soon. New York MySQL Users Group. Join our New York MySQL Users Group for regular meetings on all things MySQL. Performance and Scalability Explained.

effectivemysql.com effectivemysql.com

Book — Effective MySQL

http://effectivemysql.com/book

Wednesday, August 24, 2016. Performance, Scalability and Business Continuity. Our Effective MySQL Books. February 8, 2013. At Effective MySQL we provide resources for the DBA, Developer and Architect to best use MySQL. This includes currently three books in our series, available in print, PDF and Kindle formats. Replication Techniques in depth. June 15, 2012. The Five Minute DBA. Diagnosing Common Replication Problems. Improving Standard Replication Features. Extending Replication for Practical Needs.

UPGRADE TO PREMIUM TO VIEW 34 MORE

TOTAL LINKS TO THIS WEBSITE

43

OTHER SITES

jorgenlindskog.com jorgenlindskog.com

Cargo

This Cargo website is currently available here: jorgenlindskog. If you are the owner and wish to activate this domain, renew your Site Upgrade. When the upgrade process is completed this domain will automatically display your Cargo website. If you need further help, visit Cargo Support.

jorgenlinnet.com jorgenlinnet.com

Site Is Offline

Bloggen kommer snart online.

jorgenlissner.dk jorgenlissner.dk

The Spiders of Europe and Greenland

The number of known spider species in Europe* counts to about 4800 ( Fauna Europaea Database v. 2009.1. The World Spider Catalog v. 10.0. This number includes about 300 doubtful species ( nomina dubia. Leaving about 4500 valid species. Thus, spiders belong to a relatively species rich group of animals (order Araneae), only outnumbered by the larger insect orders. Europe is here defined in accordance with the Fauna Europaea Database Version 2009.1. Go To Image Galleries. The Pseudoscorpions of Europe.

jorgenlokdam.dk jorgenlokdam.dk

JL

VELKOMMEN TIL JL` HJEMMESIDE. Her finder du information om.

jorgenloland.blogspot.com jorgenloland.blogspot.com

Jørgen's point of view

Jørgen's point of view. Mostly about the MySQL Optimizer. Friday, March 28, 2014. The range access method and why you should use EXPLAIN JSON. I got an interesting question about EXPLAIN. And the range access method recently. The person had a query that could be written either with a BETWEEN predicate or an IN predicate, something similar to this:. CREATE TABLE orders (. 160;  order id INT NOT NULL PRIMARY KEY,. 160;  customer id INT,. 160;  value INT,. 160;  order date DATE,. Given that customer id.

jorgenlorentzen.com jorgenlorentzen.com

Wix.com Jorgen Lorentzen created by nlewisloomart based on blank-website

jorgenlowenfeldt.wordpress.com jorgenlowenfeldt.wordpress.com

Bagateller | Bara saker som händer

Bagateller – Bara saker som händer. It is very interesting, clicking nothing wired.com/2011/12/ff cow. Så tänker nog både EU och USA just nu. 12 hours ago. Lyssnar nu. Tack. 23 hours ago. Tipset gäller framförallt kommentarsfältet. 1 day ago. Kan man få playlisten? Would you take 1m now, or 1,000 a week for the rest of your life? Hannah Jane Parkinson theguardian.com/commentisfree/. Tror att du kan hitta ett och annat där. 1 day ago. Hej och välkommen till Åkersberga! Btw Gilla oss på Facebook. Skapa en ...

jorgenlundalv.blogspot.com jorgenlundalv.blogspot.com

Trafikmedicin med Jörgen Lundälv

Trafikmedicin med Jörgen Lundälv. En blogg som handlar om trafikmedicin och trafiksäkerhet. Tisdag 13 oktober 2009. Vem ska städa upp i trafiken och dess miljöer? Det är hög tid att börja använda gamla flygfält. Dessa kan bli utomordentliga miljöer för evenemang som t.ex. street-race-aktiviteter. Detta vinner alla på. Om du vill läsa mer om street-race och nedskräpning kan du läsa min senaste debattartikel i Borås tidning, här är länken:. Ha en bra och säker dag! Onsdag 7 oktober 2009. Onsdag 10 juni 2009.