Hi my site is getting big now
It has ~6M in the table `chv_images`
When trying to update to version `3.17.0`
I saw that there are some SQL queries that alter the table `chv_images` which had more than 6M will never complete. Event tried with 32 Cores server & max tweak settings.
```
ALTER TABLE `chv_images` ADD `image_is_approved` tinyint(1) NOT NULL DEFAULT '1';
ALTER TABLE `chv_images` ADD `image_is_360` tinyint(1) NOT NULL DEFAULT '0';
```
@Rodolfo
I suggest:
It has ~6M in the table `chv_images`
When trying to update to version `3.17.0`
I saw that there are some SQL queries that alter the table `chv_images` which had more than 6M will never complete. Event tried with 32 Cores server & max tweak settings.
```
ALTER TABLE `chv_images` ADD `image_is_approved` tinyint(1) NOT NULL DEFAULT '1';
ALTER TABLE `chv_images` ADD `image_is_360` tinyint(1) NOT NULL DEFAULT '0';
```
@Rodolfo
I suggest:
- don't touch that (`chv_images`) table, if you need to add any attribute to the images, please create a new table for it. Which only save the ID of the images and value of the new attribute if that images has.
- optimize the dumped queries for the big table https://dba.stackexchange.com/questions/44777/how-to-add-column-to-big-table-in-mysql
- Add a json general purpose column for any extra attribute in the future
Last edited: