New answers tagged percona
Auto increment values are assigned sequentially. In the event there is a rollback or deadlock you will find gaps in the auto inc value. The auto inc is always assigned previous_auto_inc_value+1. If a value is manually bumped you will get another gap in ids according to this rule. If there are gaps you could manually specify a value for a "missing" id but ...
I will update my progress and other stuff I discovered below. Checking /etc/init.d/mysql mySQL starts with this su - mysql -s /bin/sh -c "/usr/bin/mysqld_safe > /dev/null 2>&1 &" The error log showed that 65535 open_files_limit directive was not successful. Simply, mysql user could not set its own limits. Raising ulimit nofiles for all ...
You should put everything on a level playing field. How ? Without proper tuning, it is possible for older versions of MySQL to outrun and outgun new versions. Sep 25, 2013 : Why should I use InnoDB and MySql instead of XtraDB and MariaDB? Mar 26, 2012 : Percona vs MySQL Nov 24, 2011 : Why mysql 5.5 slower than 5.1 (linux,using mysqlslap) Oct 05, 2011 : ...
The basic answer is: No. Do you have a record of the 18-20 digit value somewhere? In another location in your database, on a piece of paper on you desk, etc? If so then use the source information to correct your error. You have not indicated which database software you are using, which can make a difference for many issues.
Top 50 recent answers are included