sorted by: recent | see :
popular
Content Tagged Show
YouTube - Trac Trac - Fito Páez - Rio de Janeiro - 11/09/2008
Moxie Mo Show #23 - Fall TV, Flight Simulator and More!
SHOW STATUS WHERE?.
Note: This article is about the WHERE extension to SHOW. I specifically use SHOW STATUS as an example, but WHERE is an extension to many SHOW statements.
Often DBAs will assess the health of a system by looking at some of the status variables returned by SHOW GLOBAL STATUS (specifying GLOBAL is important; remember that SHOW STATUS is the same as SHOW SESSION STATUS).
There are many status variables that SHOW GLOBAL STATUS returns. (SHOW GLOBAL STATUS on a Windows machine, MySQL version 5.0.67 returned 249, 5.1.22 returned 256 and 6.0.6-alpha returned 295 status variables!). I have used the SHOW STATUS LIKE syntax to help give me the output I really want, particularly when I forget the exact names of the status variables I am looking for.
But I did not know of a way to perform SHOW STATUS NOT LIKE or have any other means of filtering the information. Until today, when I was reading up on SHOW STATUS.
(more…)
Creative SQL: How to Easily SHOW GRANTS for Many Users
Scenario: Someone wants to know which of the over 50 MySQL users have certain privileges.
There are many ways to solve this problem. Some of these scenarios are tedious and repetitious, others take no time at all.
The issue, of course, lies in what the “certain” privileges are. If it is “who has the SUPER privilege?” then a simple
SELECT user,host FROM mysql.user WHERE Super_priv='Y';
is sufficient. If it is “who has write access to the foo database”, you might write:
SELECT user,host FROM db WHERE Db='foo' AND Select_priv='Y';
but that only shows who explicitly has read permissions on that database; it does not include those who have global read permissions. The full query would be:
(more…)
Collection of Laser Pointer HOWTOs and DIYs!
Collection of Laser Pointer HOWTOs and DIYs!
Here’s a great collection of Laser Pointer HOWTOs and DIYs over at HackNMod.
- Learn how to make your own home laser show for dirt cheap.
- Make a laser projector with a custom stand.
- Kipkay has a few videos on how to create burning red and blue lasers.
- Make a wicked sweet laser blaster gun.
- Use a laser as a long distance listening device.
- Last but not least, build your own laser surveillance system.
via hacknmod
Brought to you by: Zedomax.com
Collection of Laser Pointer HOWTOs and DIYs!