
jorgenloland.blogspot.com
Jørgen's point of viewA blog about development on the MySQL optimizer
http://jorgenloland.blogspot.com/
A blog about development on the MySQL optimizer
http://jorgenloland.blogspot.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Thursday
LOAD TIME
0.3 seconds
16x16
32x32
PAGES IN
THIS WEBSITE
19
SSL
EXTERNAL LINKS
43
SITE IP
172.217.9.225
LOAD TIME
0.328 sec
SCORE
6.2
Jørgen's point of view | jorgenloland.blogspot.com Reviews
https://jorgenloland.blogspot.com
A blog about development on the MySQL optimizer
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?
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.
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...
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 ...
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....
TOTAL PAGES IN THIS WEBSITE
19
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.
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.
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...
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.
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.
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.
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.
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.
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.
TOTAL LINKS TO THIS WEBSITE
43
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.
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.
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.
Wix.com Jorgen Lorentzen created by nlewisloomart based on blank-website
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 ...
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.