Archive for June 27th, 2010

Logitech Devices on Ubuntu Linux (and others)

A friend presented me with an issue a while back where certain buttons on his Logitech keyboard, specifically the zoom bar, didn’t work properly under Ubuntu. After some searching, I found a site that codes Linux drivers for these devices, and directed him to it. They have drivers for Debian, CentOS, Fedora, Mandriva, Mint, RedHat, Suse, and Ubuntu. The full list of supported devices is below.

After testing, he came up with a set of instructions (originally posted at another site) and I have rewritten them here in a [hopefully] more accurate process.

  1. Head over to HIDPoint
  2. Fill in the requested information on the download page (mouse/keyboard/OS/etc…), you can ignore the email field if you wish and select download. Make sure you select correctly if you’re using a 64-bit or non-64-bit OS.
  3. On the next screen, select the link “Download Now“, and save the file to your hard drive.
  4. Navigate to wherever you downloaded the file to.
  5. Right click on the file, and go to Properties > Permissions and check the box for execute.
  6. Double click on the file and select “Run In Terminal“. Type “Y” then hit “Enter”.
  7. Follow all on screen prompts.
  8. After Installation is complete, you will need to reboot.

Supported devices:

Keyboards: Mice: Mice:
  • Logitech Comfort Keyboard
  • Logitech Cordless Desktop
  • Logitech Cordless Elite
  • Logitech Cordless Ultra-Flat
  • Logitech DiNova
  • Logitech diNovo Edge
  • Logitech diNovo Mini
  • Logitech EasyCall Keyboard
  • Logitech EX 100 Keyboard
  • Logitech EX 110 Series
  • Logitech LX 300 Keyboard
  • Logitech LX 500/501 Keyboard
  • Logitech LX 710 Keyboard
  • Logitech Media Keyboard
  • Logitech Media Keyboard Elite
  • Logitech MX 3000 Keyboard
  • Logitech MX 3200 Keyboard
  • Logitech MX 5000 Keyboard
  • Logitech MX5500
  • Logitech Numeric Pad
  • Logitech S510 Keyboard
  • Logitech S520 Keyboard
  • Logitech Wave Corded
  • Logitech Illuminated Keyboard
  • Logitech Wave Cordless
  • Logitech Cordless Click!
  • Logitech Cordless Click! Plus
  • Logitech Cordless Mini Optical Mouse
  • Logitech Cordless Mouse
  • Logitech Cordless Mouse for NoteBook
  • Logitech Cordless Optical
  • Logitech Cordless Optical TrackMan
  • Logitech Cordless TrackMan Wheel
  • Dell BT Travel Mouse
  • Dell BT/XPS M2010 Mouse
  • Logitech diNovo Edge
  • Logitech G1 Optical Mouse
  • Logitech G3 Laser Mouse
  • Logitech G3/MX518 Optical
  • Logitech G5 Laser Mouse
  • Logitech G7 Cordless Laser
  • Logitech Laser Corded Mouse
  • Logitech Laser Tiltwheel Mouse
  • Logitech LX3 Optical Mouse
  • Logitech LX5 Cordless
  • Logitech LX6 Cordless Optical
  • Logitech LX7 Cordless Laser
  • Logitech LX7 Cordless Optical
  • Logitech LX8 Cordless Laser
  • Logitech Marble Mouse
  • Logitech Media Play Cordless
  • Logitech MX 1000 for Bluetooth
  • Logitech MX 518 Optical Mouse
  • Logitech MX 600 Cordless Mouse
  • Logitech MX Air
  • Logitech MX Revolution
  • Logitech MX Revolution Bluetooth
  • Logitech MX1000 Laser
  • Logitech MX1100 Laser
  • Logitech MX310 Corded
  • Logitech MX320/RX1000 Laser Mouse
  • Logitech MX400 Laser Mouse
  • Logitech MX510 mouse
  • Logitech MX600 Cordless Laser
  • Logitech MX610 Laser Cordless
  • Logitech MX610 Left-Handed
  • Logitech MX620 Laser Cordless
  • Logitech MX700 Cordless Optical
  • Logitech MX900 Cordless
  • Logitech NX80
  • Logitech Optical Tilt-Wheel Mouse
  • Logitech Optical Wheel Mouse
  • Logitech Optical Workstation Mouse
  • Logitech RX250 mouse
  • Logitech RX300
  • Logitech RX650 Cordless Optical
  • Logitech TrackMan Wheel
  • Logitech UltraX Optical Mouse
  • Logitech USB Optical Wheel Mouse
  • Logitech V200 Cordless
  • Logitech V220 Cordless Optical
  • Logitech V270 Bluetooth Mouse
  • Logitech V320 Cordless Optical
  • Logitech V400 Laser Cordless Mouse
  • Logitech V450 Laser Cordless Mouse
  • Logitech V450 Laser Mouse
  • Logitech V470 Bluetooth enabled Mouse
  • Logitech V500 Cordless
  • Logitech V550 Nano
  • Logitech VX Nano
  • Logitech VX Revolution
  • Logitech Wheel Mouse
  • Logitech Workstation Mouse

, , , , , , , ,

Leave a comment

Beware of poorly-written CMS plugins.

CMS systems like WordPress, Drupal, Joomla, etc are rife with plug-ins and modules you can add for extra functionality, but it’s really hard to tell the load that some of those add-ons place on your system and database. When you want to have a website that won’t collapse under load (or take the server down with it) it’s important to have well-written plug-ins. Many times we install things assuming without knowing the impact they can have. Especially in the case of shared hosting where everyone shares a server, it’s important to play nice — or face the possibility of having your hosting account suspended because you put too heavy of a load on the system.

I got to experience both sides of this first hand. Some time back I had my Drupal site hosted on my own machine. In searching for a decent chat room, I found the Drupal chat room module. It was easy to install and set up, and I had a few friends joining in to give me feedback on it. After 3 or 4 people joined, it started to get really laggy. I took a look at the server and saw that it was literally drilling a hole in the SQL server. The amount of queries and load that it was producing was just unbelievable. So I disabled it. Lesson learned.

Last night while I was making some changes here, I noticed a lot of issues with pages taking forever to load, lost connections to the MySQL server, etc. Since I’m on shared hosting, the first thing I thought of was “maybe the server is having an issue?”

So I checked server status: Nothing.

I let it go and kept making edits to my pages, but noticed the problem was getting worse instead of better. I checked server status again; nothing. I thought: There has to be a problem somewhere. So I looked through my cPanel and found an icon that I thought might give me a clue: CPU Throttling.

What you see below on the left side of the red line is what I saw (I took the screenshot 15 hours after I started working the issue so I would have a clear before-and-after).

BlueHost uses a unique CPU throttling approach, not primarily to control CPU/RAM usage, but to control scripts which pound on the SQL database and make time-consuming queries. If the database gets pounded too hard, it becomes a major issue for everyone on the server. So they throttle access to the database for load spikes, and that keeps everyone happy. They say that a throttle of 500 sec/hour is acceptable, and you shouldn’t see any slowdown from it. Obviously my problem was way beyond that.

I was obviously having an issue with some script, and it needed to be fixed immediately. Since they make log files available to you for “Slow SQL queries”, I took a read through them. I saw here and there 1.3, 1.5, 1.8 seconds… not terrible. Then I saw the issues. I had SQL queries that were running 3, 4, 5, 6, even up to 8 seconds each. You know what? It wasn’t even this site. It was the feeds module I had added to another site.

So I weighed the benefit I was seeing to the site (which was zero) and went ahead and started purging the data and disabled the modules. This took a few hours (because of the already throttled connection state), and when I was done I let it idle for an hour and made sure I was no worse off than before I had started. It was nearly 3am, so off to bed I went.

I woke up this morning and immediately checked the CPU throttling chart. Not only was I under the 500sec/hr target, I was less than half of it.

screenshot-1

The worse part of this is that I was almost never aware of the issue. It wasn’t until I stated making bulk edits that I noticed there was a problem.

This does happen to be a system that only BlueHost offers. My only request might be that I could have gotten alerted via email when the load spike shot up so I could have been aware of the issue rather than having to find it out myself. But in any case, I saw it, I took care of it, and all is well.

Have an experience with a script that negatively impacted your CMS or server platform? Please share it below…

, , , ,

Leave a comment