OrdaSoft forum
Welcome, Guest
Please Login or Register.    Lost Password?
utf8mb4_unicode_ci Collation - issues (0 viewing) 
SEF Translate component support
Go to bottom Favoured: 0
TOPIC: utf8mb4_unicode_ci Collation - issues
#44598
joomleb (User)
Expert Boarder
Posts: 131
graphgraph
User Offline Click here to see the profile of this user
Re:utf8mb4_unicode_ci Collation - issues 2 Weeks, 1 Day ago Karma: 0  
Hi Andrew,
okay, server still is running on: 10.1.40-MariaDB-cll-lve (Storage Engine: MyISAM) that has a 1000 characters limit
I'm a little bit lost during the index recreation:
- without limit photos.app.goo.gl/NVp3ay9VfhKMDB9S8
- or by setting the 765 limit photos.app.goo.gl/8MJ4M3NNZGVovrPK9

I'm having back errors. Sure I'm missing something
Please, Do you have suggestions for me to point me on the right way for the indexes recreation ?
 
Logged Logged  
  The administrator has disabled public write access.
#44602
admin (Admin)
Admin
Posts: 7128
graph
User Offline Click here to see the profile of this user
Re:utf8mb4_unicode_ci Collation - issues 2 Weeks, 1 Day ago Karma: 84  
As me see you will need fill field "Key Block size" but you try change field size,
or to field size you will need set: URL_size*4 + lang_size*4 < 1000

Regards
OrdaSoft team
 
Logged Logged  
  The administrator has disabled public write access.
#44607
joomleb (User)
Expert Boarder
Posts: 131
graphgraph
User Offline Click here to see the profile of this user
Re:utf8mb4_unicode_ci Collation - issues 2 Weeks ago Karma: 0  
Hi Andrew,
I made some tests on recreating Indexes. So, I'm running on PHP 7.3.24 + MariaDB 10.3.24

A - Without adding index limit photos.app.goo.gl/rXEbkvR1EqVAYADj8 I have back a #1071 error
But, as far as I know, Maria 10.3.24 has been built on MySQL 5.7 and the prefix limitation should be 3072 and not 1000 (or 767)
stackoverflow.com/questions/1814532/1071...ength-is-767-bytes#:~:text=34%20Answers&text=767%20bytes%20is%20the%20stated,been%20increased%20to%203072%20bytes
Please, What am I missing ?

B - If I add the index with the Key Block Size to 1000: photos.app.goo.gl/Y9axQb3HGsqMP42TA
I have back the same #1071 error

C - If I add the Index with Sizes:
photos.app.goo.gl/H8QwoHEfvPaiHyPM9
I have back the same #1089 error

D - If I add just the URL limit in this way: 1000 - (55*4) / 4 = 195
photos.app.goo.gl/bN6nYp184bJxDfqK8
The limit it has accepted, Is this the right way ?

All your suggestions are welcome! Many thanks!
 
Logged Logged  
  The administrator has disabled public write access.
#44609
admin (Admin)
Admin
Posts: 7128
graph
User Offline Click here to see the profile of this user
Re:utf8mb4_unicode_ci Collation - issues 1 Week, 6 Days ago Karma: 84  
Hi

A - Without adding index limit
May be best way ask this here
mariadb.com/kb/en/+questions/

D - If I add just the URL limit in this way: 1000 - (55*4) / 4 = 195
If when for URL - you will set 196 - and you will see same error again - so your way most right.

Regards
Andrew
 
Logged Logged  
  The administrator has disabled public write access.
#44614
joomleb (User)
Expert Boarder
Posts: 131
graphgraph
User Offline Click here to see the profile of this user
Re:utf8mb4_unicode_ci Collation - issues 1 Week, 5 Days ago Karma: 0  
Hi Andrew,
I made some tests and investigated it. I'm going to share the information with you:

A - Yes, I'm running on PHP 7.3.24 + MariaDB 10.3.24 built on MySQL 5.7 (5.7.7 I think)) and the prefix limitation should be 3072 and not 1000 (or 767). But there was a MyISAM related bug that should have been fixed with MariaDB 10.4.3:
- jira.mariadb.org/browse/MDEV-18061
- jira.mariadb.org/browse/MDEV-371
So, right now whem MyISAM I have to add the limit, while in case of InnoDB no

D - Yes, I confirm you that it is working in that way...
 
Logged Logged  
 
Last Edit: 2020/11/22 20:02 By joomleb.
  The administrator has disabled public write access.
#44624
admin (Admin)
Admin
Posts: 7128
graph
User Offline Click here to see the profile of this user
Re:utf8mb4_unicode_ci Collation - issues 1 Week, 2 Days ago Karma: 84  
Hello

Thank you !!

Regards
Andrew
OrdaSoft team
 
Logged Logged  
  The administrator has disabled public write access.
Go to top
What are you looking for?
Anti-spam question: How many head has a typical person?