Tag Archives: MySQL

LinuxCon 2010 Just for Fun Poll Results explained

Posted by on August 12, 2010 No comments

The results of the “Just for Fun” Poll  linux.com community have just been released.  You may be wondering what some of those weird names actually mean, so here goes a short guide for those, like myself, who are not up to date with it all.


Best new Kernel Feature

  1. Btrfs: is a new copy on write filesystem for Linux aimed at implementing advanced features while focusing on fault tolerance, repair and easy administration. Initially developed by Oracle, Btrfs is licensed under the GPL and open for contribution from anyone.

    Linux has a wealth of filesystems to choose from, but we are facing a number of challenges with scaling to the large storage subsystems that are becoming common in today’s data centers. Filesystems need to scale in their ability to address and manage large storage, and also in their ability to detect, repair and tolerate errors in the data stored on disk. [extracted from https://btrfs.wiki.kernel.org/index.php/Main_Page ]

  2. Dynamic Tracing: Dynamic event tracing is one of the newest feature on perf/ftrace. This allows users to dynamically add/remove additional trace-events with various arguments in the kernel. This feature consists of kprobe-based event tracer and ‘perf-probe’ user-space command which helps users to find probe points easily from source code by analyzing kernel debuginfo.  Extracted from http://events.linuxfoundation.org/lfcs2010/tracing
  3. LogFS: is a Linux log-structured and scalable flash filesystem, intended for use on large devices of flash memory. It is written by Jörn Engel and in part sponsored by the CE Linux Forum. [extracted from http://en.wikipedia.org/wiki/LogFS ]
  4. Ceph Filesystem: Ceph is a distributed network file system designed to provide excellent performance, reliability, and scalability. [ extracted from http://ceph.newdream.net/about/ ]


Read more »

Technorati Tags: , , , , , , , , , , , , , , , , , , , , , ,

Error 1062 – Duplicate entry ’2147483647′ for key 1

Posted by on July 10, 2009 4 comments

CRE Loaded was giving me the error  1062 – Duplicate entry ’2147483647′ for key 1 – when trying to add a new product.

Cause: for some unexplained reason the auto_increment ID field on Table “products” has gone up to 2147483647 which is apparently the maximum number of rows permitted in an INT column.

Fix:

  1. Go to your phpMyadmin interface
  2. Backup your database (make sure you know how to restore it if needed)
  3. Browse the products table (select to sort the fields by Descending order)
  4. The top item should now have the ID = 2147483647
  5. Change the ID to a number up from the previous item (e.g.: Previous was ID = 301, than change the ID = 2147483647 to 302)
  6. Repeat same process with table “product_to_categories”
  7. Return to table “products”
  8. Select the SQL tab
  9. run the following SQL Query :  ALTER TABLE products AUTO_INCREMENT=303   (note that 303 is the next number up from the example on step 5, you should use the next number up in your situation)

It worked perfectly for me, hope this helps.

Technorati Tags: , , , ,

Oracle to own MySQL

Posted by on April 21, 2009 No comments

Sun and Oracle today announced a definitive agreement for Oracle to acquire Sun for $9.50 per share in cash. The Sun Board of Directors has unanimously approved the transaction. It is anticipated to close this summer. This news comes as a shock after IBM recently failed to reach an agreement with Sun Microsystems.

What’s the future of MySQL now that the world’s largest commercial proprietary database vendor will soon be owning the world’s largest open source database project?

With the acquisition due to take place this summer, Oracle will own not just MySQL but also the Java Platform, Open Office, VirtualBox, Open Solaris … what will happen with these applications, specially OpenOffice?

Related blogs: ZDNet and Linux Magazine

Technorati Tags: , , , , ,