Posts Categorized: MySQL
Recently we had a question from a customer: What is the hashing algorithm implemented in PASSWORD() ?
Recently I faced an interesting challenge: modify over 26k views on a single mysqld instance. Altering the view one by one was far from an easy task, so a I had to look for an efficient way to do it. Read to find out more.
Sarah Novotny recently posted InnoDB Tablespace Fragmentation – Find it and Fix it, so I thought I would share how I determine MySQL fragmentation. This works for MyISAM and InnoDB tables, and will work whether or not innodb_file_per_table is in use. The basic idea is to compare the size of the file(s) on disk with…