diff options
| author | Pjotr Prins | 2023-03-10 02:15:07 -0600 |
|---|---|---|
| committer | Pjotr Prins | 2023-03-10 02:15:07 -0600 |
| commit | c838b707690bbf53578af13ed51129e97aba6dc3 (patch) | |
| tree | d9b12a7e2c869a5075c82809be0c8a5f88449430 /issues/systems/mariadb | |
| parent | 2ab7382abd441204898696f2e78d1c9b7bc735fa (diff) | |
| download | gn-gemtext-c838b707690bbf53578af13ed51129e97aba6dc3.tar.gz | |
innodb: auto_increment issues
Diffstat (limited to 'issues/systems/mariadb')
| -rw-r--r-- | issues/systems/mariadb/move-to-innodb.gmi | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/issues/systems/mariadb/move-to-innodb.gmi b/issues/systems/mariadb/move-to-innodb.gmi index 315ffac..d521483 100644 --- a/issues/systems/mariadb/move-to-innodb.gmi +++ b/issues/systems/mariadb/move-to-innodb.gmi @@ -1093,6 +1093,13 @@ alter table TempData add primary key (Id); show create table TempData; ``` +Some tables showed problems with AUTO_INCREMENT. Simply redefine the column without the attribute: + +``` +ALTER TABLE Chr_Length CHANGE Id Id smallint(5) UNSIGNED NOT NULL; +``` + + ## Disk space I needed more disk space to move the largest tables note the new SSD disk is twice as slow as the old SSD: |