You upgraded to > 5.1 but did you turn on performance_schema?

If you’ve upgraded from MySQL 5.1 to a newer version (5.5?  5.6? 5.7?)  Mark Leith shows you why you should turn on performance_schema. Roland Bouman gave us Common_Schema to help improve the SQL user experience.   Mark now lets us look inward at the IO latency to improve the system.
Mark has developed a great set of views and procedures to work with performance_schema that can give you things like:
A list all statements who’s average runtime, in microseconds, are the top 5% slowest
statements that use have done a full table scans
Find indexes that have had no events against them (and hence, no usage)
Show the top disk IO consumers by bytes usage by file
You’ll need to start mysql with the command line –performance_schema option or add performance_schema=on to your my.cnf and restart the server.  Then download the lattest 5.5 or 5.6 code from Mark’s page and import it.
 mysql < ps_helper_56.sql
Now you’re ready to learn things like:
mysql> SELECT * FROM statements_with_errors_or_warnings;
+——————————————————————-+————+——–+———–+———-+————-+———————————-+
| query | exec_count | errors | error_pct | warnings | warning_pct | digest |
+——————————————————————-+————+——–+———–+———-+————-+———————————-+
| CREATE PROCEDURE currently_ena … w_instruments BOOLEAN DEFAULT | 2 | 2 | 100.0000 | 0 | 0.0000 | ad6024cfc2db562ae268b25e65ef27c0 |
| CREATE PROCEDURE currently_ena … ents WHERE enabled = ? ; END | 2 | 1 | 50.0000 | 0 | 0.0000 | 4aac3ab9521a432ff03313a69cfcc58f |
| CREATE PROCEDURE currently_enabled ( BOOLEAN show_instruments | 1 | 1 | 100.0000 | 0 | 0.0000 | c6df6711da3d1a26bc136dc8b354f6eb |
| CREATE PROCEDURE disable_backg … d = ? WHERE TYPE = ? ; END IF | 1 | 1 | 100.0000 | 0 | 0.0000 | 12e0392402780424c736c9555bcc9703 |
| DROP PROCEDURE IF EXISTS currently_enabled | 12 | 0 | 0.0000 | 6 | 50.0000 | 44cc7e655d08f430e0dd8f3110ed816c |
| DROP PROCEDURE IF EXISTS disable_background_threads | 3 | 0 | 0.0000 | 2 | 66.6667 | 0153b7158dae80672bda6181c73f172c |
| CREATE SCHEMA IF NOT EXISTS ps_helper | 2 | 0 | 0.0000 | 1 | 50.0000 | a12cabd32d1507c758c71478075f5290 |
+——————————————————————-+————+——–+———–+———-+————-+———————————-+
 
 
 
 
 
 
 
Tweet

via Planet MySQL You upgraded to > 5.1 but did you turn on performance_schema?

6 Months Free of Amazon Student

Attention college students, Amazon.com is offering their Amazon Student program free for 6 months! By providing your school .edu email address, you will receive six  months of FREE Two-Day Shipping with Amazon Prime on eligible purchases, and will automatically continue receiving Amazon Prime benefits at a cost of $39 a year Read More

The post 6 Months Free of Amazon Student appeared first on Columbus on the Cheap.

via Columbus on the Cheap 6 Months Free of Amazon Student

SanDisk debuts new line of wireless memory storage devices

TS200x0~cms_posts-7702621852-Flash-Drive.png

Sandisk has announced its new Connect line of wireless flash memory storage devices, including the SanDisk Connect Wireless Flash Drive and SanDisk Connect Wireless Media Drive. SanDisk says its Wireless Flash Drive allows for wireless connectivity from a smartphone, tablet or computer without an Internet connection. It’s available in 16GB or 32GB capacities, priced at $49.99 and $59.99 respectively. Click through for more details on our sister site, connect.dpreview.com.

via News: Digital Photography Review (dpreview.com) SanDisk debuts new line of wireless memory storage devices

How To Stop 3D Printing’s Race To The Bottom

Image (1) 4d_ultrasound_3d_printing.jpg for post 68424Today’s big news, courtesy of Quartz, is about the expiration of laser sintering patents that will change the face of 3D printing in 2014. In short, the reason “good” 3D printers – namely the ones that create solid, injection-molded style pieces – aren’t cheap or readily available is that older 3D printing companies have held the laser sintering process hostage. For example, the Form One printer by Form Labs infringes on these patents even though they detail a printer that uses a laser to fuse fine powder to create an object and the Form One uses a liquid.

via TechCrunch How To Stop 3D Printing’s Race To The Bottom