Dilbert readers – Please visit Dilbert.com to read this feature. Due to changes with our feeds, we are now making this RSS feed a link to Dilbert.com.
via Dilbert Daily Strip Comic for July 28, 2013
Installing Apache2 With PHP5 And MySQL Support On Fedora 19 (LAMP)
Installing Apache2 With PHP5 And MySQL Support On Fedora 19 (LAMP)
LAMP is short for Linux, Apache, MySQL, PHP.
This tutorial shows how you can install an Apache2 webserver on a Fedora 19 server with PHP5 support (mod_php) and MySQL support.
via Planet MySQL Installing Apache2 With PHP5 And MySQL Support On Fedora 19 (LAMP)
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?
How to tie your shoes
Five Ways to Make Rope Bracelets
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
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
Today’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
UNIHORN 101 & VADER & UNICORN
SHIT JUST GOT REAL: MAN OF STEEL & MAN OF BATS (SUPERMAN & BATMAN MOVIE!)
via How to Carve Roast Unicorn SHIT JUST GOT REAL: MAN OF STEEL & MAN OF BATS (SUPERMAN & BATMAN MOVIE!)