Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
MySQL – ohMyGOD
Search
Michal Wiglasz
November 28, 2013
1
260
MySQL – ohMyGOD
Krátký talk v rámci listopadováho PyVa v Koločavě.
Michal Wiglasz
November 28, 2013
Tweet
Share
More Decks by Michal Wiglasz
See All by Michal Wiglasz
Prudce inteligentní talk o umělé inteligenci
kacer
0
140
Projekt SFC
kacer
0
170
Featured
See All Featured
Let's Do A Bunch of Simple Stuff to Make Websites Faster
chriscoyier
507
140k
Imperfection Machines: The Place of Print at Facebook
scottboms
267
13k
The Success of Rails: Ensuring Growth for the Next 100 Years
eileencodes
45
7.5k
How to train your dragon (web standard)
notwaldorf
95
6.1k
RailsConf & Balkan Ruby 2019: The Past, Present, and Future of Rails at GitHub
eileencodes
138
34k
Evolution of real-time – Irina Nazarova, EuRuKo, 2024
irinanazarova
8
820
[RailsConf 2023] Rails as a piece of cake
palkan
55
5.7k
Practical Orchestrator
shlominoach
189
11k
Scaling GitHub
holman
460
140k
Into the Great Unknown - MozCon
thekraken
40
1.9k
Build The Right Thing And Hit Your Dates
maggiecrowley
36
2.8k
The Language of Interfaces
destraynor
158
25k
Transcript
Michal Wiglasz @kacer
Kotva první Regulární výrazy
Regulární výrazy SELECT * FROM articles WHERE title LIKE "%mysql
5.0%"; SELECT * FROM articles WHERE title REGEX "mysql 5\.0";
Regulární výrazy SELECT * FROM articles WHERE title LIKE "%mysql
5.0%"; OK, 150 results. SELECT * FROM articles WHERE title REGEX "mysql 5\.0"; OK, 0 results.
Regulární výrazy REGEX + multibyte = case-sensitive Vždy. Nahlášeno v
roce 2007. Oprava = poznámka v dokumentaci.
None
Regulární výrazy (asi) jediné řešení SELECT * FROM articles WHERE
title REGEX "[mM][yY][sS][qQ][lL] 5\.0";
Kotva druhá ALTER TABLE
ALTER TABLE ALTER TABLE huge_table ADD INDEX some_column (some_column);
ALTER TABLE Copying to tmp table
None
ALTER TABLE řešení InnoDB plugin Proč mít jednu implementaci, když
můžeme mít dvě.
ALTER TABLE ALTER TABLE huge_table ADD FOREIGN KEY (some_column) REFERENCES
small_table(id);
ALTER TABLE Copying to tmp table
ALTER TABLE ALTER TABLE huge_table DROP FOREIGN KEY some_key; ALTER
TABLE huge_table DROP some_column;
ALTER TABLE Copying to tmp table Copying to tmp table
Kotva třetí utf8
utf8 INSERT INTO comments (text) VALUES ("Mám rád ❄ a
rád stavím "); ☃ Warning. SELECT * FROM comments; "Mám rád "
None
utf8 řešení utf8mb4 Proč mít jednu implementaci, když můžeme mít
dvě.
utf8mb4 • Sehnat • Zkompilovat • ALTER TABLE • OPTIMIZE
TABLE • REPAIR TABLE • Pak to snad bude fungovat...
utf8mb4 INSERT INTO comments (text) VALUES ("MySQL je "); Warning.
SELECT * FROM comments; "Mysql je ????"
utf8mb4 USE NAMES utf8mb4;
Michal Wiglasz @kacer