Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 107 10 Older Entries

Displaying posts with tag: Database Management (reset)

Howto automate MySQL slow query analysis with amazon RDS
+0 Vote Up -0Vote Down
If you’ve used relational databases for more than ten minutes, I hope you’ve heard of slow queries. Those are those pesky little gremlins that are slowing down your startup, and preventing scalability you so desperately need. Luckily there’s a solution. What I’ve found is if I send a report to developers every week, it keeps […]
E-commerce – Uptime and Web apps are the keys
+0 Vote Up -0Vote Down

Since 2011 e-commerce has grown from $856,000,000.00 to closing out 2013 at more than $1,248,000,000,000.00 in global revenues, a nearly 41% growth rate over a two year span. The forecast for 2014  is targeted at $1,500,000,000,000.00, another 20% increase is gross revenues (see chart below). With trillions of dollars in play year on year now, and astounding revenue growth rates still ahead, it is critical that any e-commerce site be diligently monitoring not just their website uptime, but more importantly their Web applications. Obviously it is critical that your customers be able to get to your website, but if it doesn’t build fast and complete client requests and transactions even faster then

  [Read more...]
Connect to MySQL in the Amazon Public Cloud
+0 Vote Up -0Vote Down
Troubleshooting MySQL on Amazon can be a real test of patience. There are quite a few different things to watch out for in terms of connectivity & networking. Sometimes a checklist can help. Join 16,000 others and follow Sean Hull on twitter @hullsean. Here’s my exhaustive list of things that can block you. 1. Be […]
Are SQL Databases Dead?
+1 Vote Up -0Vote Down
I like the image of this city of Mesa Verde. It’s fascinating to see how ancient cities were built, especially as an inhabitant of one of the worlds largest cities today, New York. I’m a long time relational database guy. I worked at scores of dot-coms in the 90′s as an old-guard Oracle DBA, and […]
5 great things about Markus Winand’s book SQL Performance Explained
+0 Vote Up -0Vote Down
Join 12,100 others and follow Sean Hull on twitter @hullsean. 1. Covers databases broadly You may not have noticed, but there’s a whole spectrum of relational databases on offer. Of course in the database world, most get infatuated with one, and that becomes their bread & butter before long. Their life, their passion, their devotion. […]
Why Oracle won’t kill MySQL
+1 Vote Up -0Vote Down
Join 15,000 others and follow Sean Hull on twitter @hullsean. 1. MySQL does not compete with Oracle It’s a myth that MySQL somehow poses a threat to Oracle. Oracle’s customers tend to be large enterprises running apps like e-business suite. These are certified to run on Oracle, and further they sit close to finance. MySQL […]
3 Simple Patterns for Tighter MySQL Code
+0 Vote Up -0Vote Down

Join 8000 others and follow Sean Hull on twitter @hullsean. SQL is derided by many and for good reason. It’s key to scalability yet terribly difficult to write good code. Here’s a few quick tips to write tighter queries in MySQL 1. Get rid of those Subqueries! Subqueries are a standard part of SQL, unfortunately […]

The post 3 Simple Patterns for Tighter MySQL Code appeared first on Scalable Startups.

MySQL Subquery Optimization
+0 Vote Up -0Vote Down
Join 7000 others and follow Sean Hull on twitter @hullsean. MySQL’s optimizer can do a lot of things, but subqueries are not always handled well. Take a look at the IN subquery below. If you see the DEPENDENT SUBQUERY in your explain plan, you may want to take a second look. This will run slow [...]
3 Ways to Optimize for Paging in MySQL
+0 Vote Up -0Vote Down
Join 6100 others and follow Sean Hull on twitter @hullsean. Lots and lots of web applications need to page through information. From customer records, to the albums in your itunes collection. So as web developers and architects, it’s important that we do all this efficiently. Start by looking at how you’re fetching information from your [...]
MySQL for Devs, DBAs and Debutantes
+0 Vote Up -2Vote Down
Join 6500 others and follow Sean Hull on twitter @hullsean. I just received my copy of the 5th Edition of Paul DuBois’ MySQL tomb. Weighing in at 1153 pages, it’s a solid text, with a very thorough introduction to the topic of administering MySQL databases. Buy the book here: MySQL 5th Edition by Paul Dubois [...]
Showing entries 1 to 10 of 107 10 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.