Hi
user
Admin Login:
Username:
Password:
Name:
Troubleshooting performance problems in MySQL
--client
fosdem
--show
fosdem_2014
--room UA2114 7811 --force
Next: 5 ProxySQL : High Availability and High Performance Proxy for MySQL
show more...
Marks
Author(s):
Maciej Dobrzanski
Location
UA2.114 (Baudoux)
Date
feb Sat 01
Days Raw Files
Start
16:35
First Raw Start
16:34
Duration
00:30:00
Offset
0:00:16
End
17:05
Last Raw End
17:08
Chapters
00:00
Total cuts_time
28 min.
https://fosdem.org/2014/schedule/event/trouble_mysql/
raw-playlist
raw-mp4-playlist
encoded-files-playlist
public
mp4
svg
png
assets
release.pdf
Troubleshooting_performance_problems_in_MySQL.json
logs
Admin:
episode
episode list
cut list
raw files day
marks day
marks day
image_files
State:
---------
borked
edit
encode
push to queue
post
richard
review 1
email
review 2
make public
tweet
to-miror
conf
done
Locked:
clear this to unlock
Locked by:
user/process that locked.
Start:
initially scheduled time from master, adjusted to match reality
Duration:
length in hh:mm:ss
Name:
Video Title (shows in video search results)
Emails:
email(s) of the presenter(s)
Released:
has someone authorised pubication
Unknown
Yes
No
Normalise:
Channelcopy:
m=mono, 01=copy left to right, 10=right to left, 00=ignore.
Thumbnail:
filename.png
Description:
markdown
<p>It is a typical day at work when suddenly someone notices that the application loads slow. They immediately switch to complaining about database performance and demand that you find the problem and fix it. But how to verify the problem is really with the database? What are the common symptoms and where to look for them? And how to isolate the culprit?</p> <p>The session will discuss the practical approach to troubleshooting performance problems in MySQL: where to start the investigation, what information to look at and how to interpret it. I will also be talking about useful tools and preparing the environment for effective troubleshooting.</p>
Comment:
production notes
Audio seems low.
2014-02-01/15_34_44.dv
Apply:
16:34:44 - 16:39:31 ( 00:04:47 )
S:
16:34:44 -
E:
16:39:31
D:
00:04:47
show more...
vlc ~/Videos/veyepar/fosdem/fosdem_2014/dv/UA2114/2014-02-01/15_34_44.dv :start-time=00.0 --audio-desync=0
Raw File
Cut List
16:34:44
seconds: 0.0
Wall: 16:34:44
Duration
00:04:47
16:39:31
seconds: 0.0
Wall: 16:34:44
Comments:
mp4
mp4.m3u
dv.m3u
Split:
Sequence:
:
delete
2014-02-01/15_39_32.dv
Apply:
16:39:32 - 17:08:01 ( 00:28:29 )
S:
16:39:32 -
E:
17:08:01
D:
00:28:29
(
Start:
0:00:00) (
End:
00:28:29)
show more...
vlc ~/Videos/veyepar/fosdem/fosdem_2014/dv/UA2114/2014-02-01/15_39_32.dv :start-time=00.0 --audio-desync=0
Raw File
Cut List
16:39:32
seconds: 0.0
Wall: 16:39:32
Duration
00:28:29
17:08:01
seconds: 1709.0
Wall: 17:08:01
Comments:
mp4
mp4.m3u
dv.m3u
Split:
Sequence:
:
delete
Rf filename:
root is .../show/dv/location/, example: 2013-03-13/13:13:30.dv
Sequence:
get this:
check and save to add this
2014-02-01/15_34_44.dv
2014-02-01/15_39_32.dv
Veyepar
Video Eyeball Processor and Review