Percona's MySQL & InnoDB performance and scalability blog
…with a single VARCHAR column named “value”. OK, sounds easy enough: mysql: SHOW CREATE TABLE innodb_myisam_stopword\G *************************** 1. row *************************** Table: innodb_…_INDEX causing me issues, I tried adding a second column to the table which was an integer PK, and in …
… cause problems to Hibernate and other ORM based applications which often like to update all columns whenever they have changed or not: mysql> set foreign_key_checks=1; Query OK, 0 rows affected (0.00 sec) mysql… column child table is referencing and have it of proper type and indexed): mysql> set foreign_key_checks=0; Query OK, 0 rows…
… do not specify default value. MySQL will assign empty string as default default value for varchar column. This however does not work… altered. (in cleanup) Error copying rows from `sbtest`.`sbtest` to `sbtest`.`_sbtest_new`: Copying rows caused a MySQL error 1364: Level: Warning Code: 1364…
… Log is the MySQL log which records changes to tables in the database. FlexCDC reads the binary log to determine what rows have changed… possible to set up a dedicated MySQL slave which has log_slave_updates=1 and binlog_format=row to process SBR changes from a MySQL… change logs contain three additional metadata columns: dml_type, uow_id and fv$server_id. These columns represent the type of change…
…to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’G *************************** 1. row *************************** Name: ontime_fact Engine: InnoDB Version: 10 Row…
… is because the incremental refresh method must examine only those rows related to the ones which changed since the last time the… not useful, simply ignore this column. It is used to prevent wide innodb primary keys on the MV. mysql> select mview$pk as… take long to refresh: mysql> call flexviews.refresh( -> flexviews.get_id(‘demo’, -> ‘dashboard_customer_sales’),’BOTH’,NULL); Query OK, 0 rows affected (7…
… the primary key. Therefore if we want to extract the rows data we need to identify which of those two indexes is the… log. mysql (employees) > CREATE TABLE innodb_table_monitor (id int) ENGINE=InnoDB; TABLE: name employees/salaries, id 18, flags 1, columns 7…_date, salary, to_date); Query OK, 3 rows affected (0.01 sec) Records: 3 Deleted: 0 Skipped: 0 Warnings: 0 mysql (employees) > select…
… a webinar entitled “Building a highly scaleable distributed row, document or column store with MySQL and Shard-Query” The first part of this… the techniques employed by Shard-Query to implement a distributed MySQL database. The focus will then proceed to the types of distributed (massively…
…”and some text”, and (2) same two varchar columns needed some double characters changed to single one so “Picasso” becomes “Picaso”, “…two MySQL functions I wrote to do the job – ltrim_junk_mysql() and remove_dups_mysql(). Although processing single row seemed to be instantaneous, we needed to…
… block this is not going to work and MySQL will need to scan keyblock from the start uncompressing keys to find matching key value… use key compression for character column type but not for numerical and other column types. Also according to my tests it looks there…’ve created simple table with 100.000 rows with columns. And I set id=c to keep it simple: CREATE TABLE `t1` ( `id…
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.