Tuesday Jun 01, 2010

Chapter 2. Why you get wrong data of "Methods for searching errors in SQL application"

Translation of Chapter 2 of Methods for searching errors in SQL application just posted.



Chapter 2. Why you get wrong data.



We learned how to find the problem query.



We already examined 2 examples of syntax error and one example of logic
error. But do include these examples every possibilyty of analysing of
any problem query? Of course, not! Although, strictly say, every error
in the query can be reduced to one of these subtypes.



In this chapter we discuss what else can we do with problem query.



Syntax errors are trivial, therefore we would not study them more.



One of most frequent problems is SELECT query which returns wrong data. This can happen because a number of reasons.



Lets look at easiest - in terms of solving - one.


You can find rest of the chapter here.


As always comments and translation corrections are highly appreciated.

Wednesday May 26, 2010

Methods for searching errors in SQL application

Some time ago I wrote in Russian language guide for finding errors in SQL application.

To be honest I wrote it having personal aim to have a text which I can easily use refer in case of user questions about how to find particular thing. But this makes less sense having no English version. So now I started to translate it to English and publish. Introduction and first chapter are ready.

You can find it at http://sql-error.microbecal.com/en/index.html  Comments and corrections of mistakes are welcome here.

Wednesday Oct 14, 2009

Presentation from PHPConf 2009

October, 8 I did master-class about catching error in SQL application at PHPConf 2009. Who speaks Russian can get slides here: pdf and odp.

There were several things which were interesting for me during my talk.

First is interaction with audience of different educational (or better to say MySQL practice) level. I should make a note for feature how to solve moments when 1/3 of audience listens carefully and is just right for the talk, another 1/3 knows things I am talking at the moment already and last 1/3 needs explanations of basic things such as what is difference between table-level and row-level locks. Probably I should create list of things user should know before attend the talk.

It was surprising how many people don't use SHOW ENGINE INNODB STATUS and InnoDB Monitor! And I had very little information about these topics in my talk.

Last thing was my expectation about classroom with desks and people with laptops on it. I saw no desks and 1-2 laptops for more than 50 people. Next time I should create interactive program without need of laptop. Like quiz or so.

About

Working blog of Sveta Smirnova - MySQL Senior Principal Support Engineer working in Bugs Analysis Support Group

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today