Z-Car

Ramblings about everything from Cars to Computers

Z-Car
  • 1993 Mazda RX-7 CYM
  • 1997 Mazda Miata
  • A Day at Summit Point – 5/17/1997
  • Datsun 240Z show in PA – 5/25/1998
  • Frederick Air Show – 8/18/2003
  • Gary’s House of Z
  • LilyPon’s British Car Day June 1,2008
  • Lockheed F-117 Nighthawk
  • Mazda RX-7 crash at Summit Point
  • Mikoyan-Gurevich MiG-17
  • Northrop Grumman B-2 Spirit
  • R/C Flying 2008
  • Rockwell B-1 Lancer
  • Rockwell International Space Shuttle
  • Steven F. Udvar-Hazy Center – National Air and Space Museum
  • Sukhoi PAK FA T-50
  • Westminster Airshow 2008

MySQL – ORDER BY does not sort data properly…

By Prodromus December 28, 2010 Errors, MySQL, Optimization 4 Comments
MySQL – ORDER BY does not sort data properly…

Imagine a developer working late at night trying to complete some simple queries for a report due the next day.  No matter what she does, the resulting query will just…

Read more

Top My.CNF Optimizations for Innodb

By Prodromus August 20, 2010 MySQL, Optimization No Comments
Top My.CNF Optimizations for Innodb

These are the four parameters which will have the most affect on the performance of MySQL 5.1x and Innodb.   If you are suffering from poor performance, try changing the…

Read more

Show Processlist and Show Full Processlist – MySQL Tip

By Prodromus August 19, 2010 MySQL No Comments
Show Processlist and Show Full Processlist – MySQL Tip

Everyone knows that using the MySQL command Show Processlist will display all current connections, like the following : mysql> show processlist; show processlist; +—-+————-+—————–+——+———+——+———————————-+——————+ | Id | User | Host…

Read more

MySQL – Should you put an index on a Boolean field to help query performance?

By Prodromus June 14, 2010 MySQL, Query Optimization 2 Comments
MySQL – Should you put an index on a Boolean field to help query performance?

I am often asked if it makes sense to place an index on a Boolean field in order to improve query performance.  In general, because a boolean value can only…

Read more

MySQL – SQL Injection, and how to Prevent it

By Prodromus June 11, 2010 MySQL, Scripting No Comments
MySQL – SQL Injection, and how to Prevent it

SQL injection vulnerabilities are often been described as the most serious threat for Web applications, regardless of what language they are written in . Web applications that are vulnerable to…

Read more

MySQL – Disabling Binary Logging for INSERT and UPDATE

By Prodromus June 2, 2010 MySQL, Replication 1 Comment
MySQL – Disabling Binary Logging for INSERT and UPDATE

I have run into many situations where there would be a benefit to not replicate a large INSERT or UPDATE from the MASTER to SLAVE in order to not block…

Read more

  • « Previous
  • Rainbow of Tesla Roadsters – Pot of Gold at end?Rainbow of Tesla Roadsters – Pot of Gold at end?
  • Infiniti G35x Belt ReplacementInfiniti G35x Belt Replacement
  • Lockheed Martin F-22 RaptorLockheed Martin F-22 Raptor

Recent Posts

  • 2005 Laser Blue Lotus Elise for Sale
  • 2011 MacBook Pro GPU Failure – A software fix to disable GPU
  • Unable to renew using LetsEncrypt Certbot-Auto with CRON – Fail
  • Installing LetsEncrypt Certbot on Amazon Linux Server
  • Upgrade your Miata’s headlights with Hella H4 halogen bulbs, Cibie eCode projectors, and a relay kit.

Pages

  • 1993 Mazda RX-7 CYM
  • 1997 Mazda Miata
  • A Day at Summit Point – 5/17/1997
  • Datsun 240Z show in PA – 5/25/1998
  • Frederick Air Show – 8/18/2003
  • Gary’s House of Z
  • LilyPon’s British Car Day June 1,2008
  • Lockheed F-117 Nighthawk
  • Mazda RX-7 crash at Summit Point
  • Mikoyan-Gurevich MiG-17
  • Northrop Grumman B-2 Spirit
  • R/C Flying 2008
  • Rockwell B-1 Lancer
  • Rockwell International Space Shuttle
  • Steven F. Udvar-Hazy Center – National Air and Space Museum
  • Sukhoi PAK FA T-50
  • Westminster Airshow 2008

Copyright © 2022 Z-Car | Theme by: Theme Horse | Powered by: WordPress