veyepar: Troubleshooting performance problems in MySQL

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:
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
Normalise:
Channelcopy:	m=mono, 01=copy left to right, 10=right to left, 00=ignore.
Thumbnail:	filename.png
Description:	<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> markdown
Comment:	Audio seems low. production notes

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