Mystery

The question of what happened last summer to cause an increase in hits for Linux in NetApplications results deepens. A selection of one day’s worth of 1:1000 samples from Wikimedia:
mysql>
mysql> select sum(B) as count from Sheet1 where A like ‘%Linux%’ OR A like ‘%Android%';
+——–+
| count |
+——–+
| 177475 |
+——–+
1 row in set (0.16 sec)

mysql> select sum(b) as count from Sheet1 ;
+———+
| count |
+———+
| 5721270 |
+———+
1 row in set (0.02 sec)

mysql> select sum(B) as count from Sheet1 where A like ‘%Linux%’ AND A like ‘%Android%';
+——-+
| count |
+——-+
| 86217 |
+——-+
1 row in set (0.09 sec)

mysql> select sum(B) as count from Sheet1 where A like ‘%Android%';
+——-+
| count |
+——-+
| 90582 |
+——-+
1 row in set (0.09 sec)
select sum(B) as count from Sheet1 where A like ‘%Linux%';
+——–+
| count |
+——–+
| 173110 |
+——–+
1 row in set (0.09 sec)
mysql> select sum(b) as count from Sheet1 where a like ‘%x11%’ ;
+——-+
| count |
+——-+
| 83819 |
+——-+
1 row in set (0.09 sec)

mysql> select sum(b) as count from Sheet1 where a like ‘%build%’ ;
+——–+
| count |
+——–+
| 106567 |
+——–+
1 row in set (0.08 sec)

There is a possibility some Android devices are being identified as Linux devices. It will take a lot of work to figure out all the User_agents.

mysql> select count(b) as count from Sheet1 ;
+——-+
| count |
+——-+
| 44201 |
+——-+
1 row in set (0.01 sec)

About Robert Pogson

I am a retired teacher in Canada. I taught in the subject areas where I have worked for almost forty years: maths, physics, chemistry and computers. I love hunting, fishing, picking berries and mushrooms, too.
This entry was posted in technology. Bookmark the permalink.

12 Responses to Mystery

  1. Dr Loser says:

    Just to correct that brain-fart:

    mens rea => mens rea

    mens acta => actus reus

    As a bonus, it’s from Edmund Coke:

    actus non facit reum nisi mens sit rea.

    In other words, you ain’t guilty unless you knew you were guilty beforehand.

  2. Dr Loser says:

    @Robert:

    “People taking money to slow things down and to make IT less efficient are criminals/vandals/terrorists.”

    Really?

    I’d be awfully keen to see case law in either the Common or the Criminal area to back that one up.

    It’d be even more fun to examine the difference between mens rea and mens acta.

    “When my clients in Munich began their ground-breaking innovation in attempting to bring the benefits of Debian to the region, M’Lud, they were clearly acting in good faith. The fact that it has been a farcical waste of resources and has resulted in a barely usable system, ten years after they started, is beside the point.

    “My clients acted in good faith, M’Lud. There is no mens rea involved: the mens acta is an unfortunate result of their collective mental incapacity.”

    Yup, that’ll work.

  3. Dr Loser says:

    @Robert:

    Actually, Timothy 1:10 is a bit more nuanced than that.

    But what the heck: go with your prejudices.

  4. oldman says:

    “People taking money to slow things down and to make IT less efficient are criminals/vandals/terrorists.”

    And people proposing the use of less functional software that wastes time and effort are fools to be ignored.

  5. The Bible: “Love of Money is the Root of all Evil.”

    IT is about processing information quickly and efficiently. People taking money to slow things down and to make IT less efficient are criminals/vandals/terrorists.

  6. lpbbear says:

    “It is more of a surprise that a Linux fan site such as the one you link shows only 30% Linux usage, Mr. Bear.”

    Ahhh, even more BS excuses from the “Cult Of Microsoft”. In the Cult’s hive mind any site that isn’t exclusively “One Microsoft Way” is the enemy and perceived as a Linux site. In fact the site is agnostic and is called OS News exactly because the news and info is about all operating systems, not just the crappy one from Redmond. That fact strays from the narrow bigoted little path the twisted little Cult mind can handle so it gets labeled a “Linux site” automatically. Odd that a droid like you hangs out at a real Linux site.

    “I will take the audited financial statements from the many companies who are in business to supply these technologies over the hopes and dreams of you Microsoft haters any day. That is much more meaningful, I think.”

    Since the Cult mind is out of logical comebacks to dispute the numbers shown it automatically shifts into its other usual defense mechanism……MONEY! In the Cult hive mind money is everything, means everything, and justifies everything.

    You’re full of it.

  7. Clarence Moon says:

    Two words, Mr. Koz, “EDGAR Online”! Come back when you understand things a little better.

  8. Kozmcrae says:

    “I will take the audited financial statements from the many companies who are in business to supply these technologies over the hopes and dreams of you Microsoft haters any day.”

    Of course you will Clarence, why don’t you order them up. Let’s look them over together. I know you and your ego have “pull” in that area.

  9. Clarence Moon says:

    It is more of a surprise that a Linux fan site such as the one you link shows only 30% Linux usage, Mr. Bear.

    I will take the audited financial statements from the many companies who are in business to supply these technologies over the hopes and dreams of you Microsoft haters any day. That is much more meaningful, I think.

  10. lpbbear says:

    A few years back the usual suspects used terms like “hobby OS” etc to blow off Linux. Now that its showing consistent gains the “Cult Of Microsoft” say crap like
    “fly specs in the ground pepper shaker” and “the results themselves seem to have no real value to anyone”.

    Whatever BS they try to float the facts are clear, Microsoft steadily dropping, Linux steadily gaining.

    Take note of the charts here at another site.

    http://www.osnews.com/story/25485/OSNews_Browser_OS_Stats_2012

    I’m seeing similar trends locally. More Linux users and Linux aware users and more willingness to drop Mickeysoft for Linux.

    Read it and weep…..losers.

  11. Kozmcrae says:

    “What is the point of all this, Mr. Pogson?”

    It’s like Dark Matter Clarence, it doesn’t show up but it’s there.

  12. Clarence Moon says:

    What is the point of all this, Mr. Pogson? You have conclusively shown that searching for desktop Linux user share is akin to searching for fly specs in the ground pepper shaker. Mis-identification plays a dominant role.

    The method itself is so oblique as to create an even larger question as to the veracity of the results and the results themselves seem to have no real value to anyone,

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>