MySQL Cluster: Generating Partition Reports

If you're using MySQL Cluster and have recently added a nodegroup, you can use the following code to generate a report of what tables are currently partitioned across the nodes as you apply ALTER ONLINE TABLE ... REORGANIZE PARTITION to them to get them partitioned:

select count(p.table_name) as partitions, p.table_schema, p.table_name from tables t join partitions p on (t.table_schema=p.table_schema and t.table_name=p.table_name) where t.engine='ndbcluster' group by p.table_schema, p.table_name order by partitions desc;

You'll get a nice clean report of all your tables, what schema they belong to, and how many partitions they have. Use in combination with my method of finding the largest tables in MySQL and you'll ensure smooth growth of your cluster!

Find Largest Tables in MySQL

If you're trying to find what tables in your MySQL deployment are consuming the most amount of space, you can use the following query to find this information directly from the information schema.

SELECT CONCAT(table_schema, '.', table_name), CONCAT(ROUND(table_rows / 1000000, 2), 'M') rows, CONCAT(ROUND(data_length / ( 1024 * 1024 * 1024 ), 2), 'G') DATA, CONCAT(ROUND(index_length / ( 1024 * 1024 * 1024 ), 2), 'G') idx, CONCAT(ROUND(( data_length + index_length ) / ( 1024 * 1024 * 1024 ), 2), 'G') total_size, ROUND(index_length / data_length, 2) idxfrac, engine FROM information_schema.TABLES ORDER BY data_length + index_length DESC LIMIT 25;

You'll get a list of the top 25 tables by total size (index size + data size), how many rows they have, and the engine they are using to be stored. Being able to see what engine is being used is especially helpful when running MySQL Cluster.

Auto-Dim Your Display at Night [Linux]

If you're at all like me, you often find yourself tapping away late at night on some project that you just need to hammer out those last few lines before you get to bed. Inevitably, that just doesn't happen.

So, I came up with the following solution subtly remind me that I really should be going to sleep (or hey, at least make the LCD easier on my eyes while I'm working!):

Edit the crontab for your root user using crontab -e. Add the following:
0 22 * * * echo -n "0" > /proc/acpi/video/VGA/LCD0/brightness # dims LCD to 0% at 10 PM
0 7 * * * echo -n "100" > /proc/acpi/video/VGA/LCD0/brightness # brightens LCD to 100% at 7 AM (all-nighter time!)


You can test either of these commands from the command line directly; you'll also need to make sure the path to your LCD's brightness setting is correct.

Fixing Textareas with Padding

Ever run into an issue where you need a <textarea> to have a width of 100% and some non-zero padding?

Use this:


textarea {
    -webkit-box-sizing: border-box; /* Safari/Chrome, other WebKit */
    -moz-box-sizing: border-box; /* Firefox, other Gecko */
    box-sizing: border-box; /* Opera/IE 8+ */
}


Problem solved.

Why Programmers Should Learn to Program

Display Foursquare Badges in Chyrp without using Javascript

If you notice, I currently display my Foursquare badges over in the right hand side. I'm not sure about how long I'll display them specifically, so here's a screenshot:

I recently received an email inquiring about how I accomplished this. Well, since I use Chyrp, here's how I did it:

1. In includes/controller/Main.php, add the following, somewhere around line 715 (immediately after $this->context["sql_queries"] =& SQL::current()->queries;):
   // BEGIN Foursquare Badges
   $cURL = curl_init();
   curl_setopt($cURL, CURLOPT_URL, "http://api.foursquare.com/v1/user.json?badges=1");

   curl_setopt($cURL, CURLOPT_HEADER, 0);
   curl_setopt($cURL, CURLOPT_RETURNTRANSFER, 1);
   curl_setopt($cURL, CURLOPT_HTTPAUTH, CURLAUTH_BASIC);
   curl_setopt($cURL, CURLOPT_USERPWD, "your@email.com:your_password_here");

   $strPage = curl_exec($cURL);
   curl_close($cURL);

   $foursquare = json_decode($strPage);

   $badges = $foursquare->user->badges;

   foreach ($badges as $badge) {
$this->context['foursquare_badges'] .= '<img src="'.$badge->icon.'" title="'.$badge->description.'" />';
}
// END Foursquare Badges

2. In themes/your_theme_name/content/sidebar.twig, wherever you want to display your foursquare tags, simply add:
   <div>
   <h1>Foursquare Badges</h1>
   $foursquare_badges
   </div></code>

   You can display this wherever you like, in any part of your Chyrp template.