Ollie: Rows is ~1.1 million and size 1.2GB. Field is varchar255 allows null :/ it has to be done – will it lock the table?
Emenaha: Would like to know which/who is responsible for creating a table in the db with another collation than the one as given example: WordPress basic use is utf8mb4_unicode_ci and a plugin creates latin1_swedish_ci, is it the server or a plugin?
Surrett: Unless a ch****t is explicitly defined on table create, the server will default to its default of the database.
Manross: DysonReturns: “In most cases, ALTER TABLE makes a temporary copy of the original table. MySQL waits for other operations that are modifying the table, then proceeds. It incorporates the alteration into the copy, deletes the original table, and renames the new one. While ALTER TABLE is executing, the original table is readable by other sessions with the exception noted shortly. Updates and writes to the table that begin after the ALTER TA
Manross: DysonReturns: https://dev.mysql.com/doc/refman/5.6/en/alter-table.html
Yarn: Those should point out what your DB default is. if it ISNT utf8mb4 then your software specified it in the background.
Acuff: General settings in phpMyAdmin shows Server connection collation: utf8_general_ci so if not forced by code a plugin actualy should use that and not the latin1 or do I understand some totally wrong?
Piggs: Can/does using different collations in one db have real performance impact, and if so is converting to one kind collation usefull or just creating problems?
Varieur: _Zodiac: what do you think collations do?
Nusser: Taking care for correct use/translting characters?
Gianopoulos: Oh, please enlight me if possible
Varieur: _Zodiac: before you can answer that question, read about the difference between ch****ts and collations.
Ruiloba: Which i’m not sure whether that translates into: Secondary non-unique, secondary indexes on on non-fulltext columns doesn’t lock your table for reads/writes.
Melchert: And thats what i need to know
Roman: Varieur: so if I understand/read well, it is on install mysql to take care it uses the correctwished collation in our case we need at least utf8mb4_unicode above latin1_swedish because of the use German extra charactersumlauten ‘ë’
Reznicek: Varieur: addon utf8mb4characterset above the latin1characterset
Varieur: _Zodiac: collation has no effect on storage.
Combee: Okay, but if it is about the characterset my understanding is correct now?
Varieur: _Zodiac: ch****ts affect storage, yes.
Essency: Varieur: sorry for still asking again/more . is it wise to recompile a running database to use correct characterset oor will it ´just´ cause more problems?
Bahl: I’m running a ~20GB MySQL server that want to add slave replication to. It is not replicated today. Should I generally be worried about potantial added overhead due to slave-replication disregarding over the write trafic
Geno: How can I run a set of commands as root when I only have access via the webapps MySQL user?
Varieur: _Zodiac: what does recompiling a database mean?
Varieur: NginUS: ask for the root user p***word?
Schwenke: Varieur: I think that’s when you rebuild the application from source
Varieur: NginUS: what does that mean?
Derego: Varieur: Ihave a support request in, just trying to save some time while I wait for them to reopen for business- they’re around the world & closed when Im awake
Varieur: Hint: it’s a bit meaningless in the context of his question.
Varieur: NginUS: I think you’re missing the point.
Mattiello: Varieur: Packages from the repo are whats referred to as ‘binary’, which means theyre precompiled
Varieur: NginUS: you’re missing the point, yes.
Whipple: Varieur: to set the default to utf8mb4 i need to add/edit my.cnf but to change it for an existing db it isnt wise I always thought, and therefore need to rebuild it?!