Approach number 1 is correct. There was no truncation: MEDIUMTEXT is bigger … the data type as necessary to ensure that the new column is long enough to store as many characters as the original column.” [followed by a complete explanation of why TEXT coverts to…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
…, implicit relationship to parent”> <column name=”id” primaryKey=”true”> column> <column name=”parent_id”>
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… between 47000 and 50000 with no movies, but your random number generator picks values in that range with equal frequency as… tradeoff of this solution is that it requires storing another column, and reinitializing the sequence after making certain insert/update/delete… matter, and it would have to match the order of columns in the index. Example: WHERE (last_name, first_name) = (‘Karwin…
Comment: Be careful when joining on CONCAT
May 24, 2013 By 16 Comments
…. I need to calculate IBAN from bank number+acc.number+sufix country number (3 separate columns that by design can only be separate). And cast or convert isn’t doing proper job with a number…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… master_port=10002; mysql> start slave; # And then check the number of records from the t table s1> select count(*) from… 3d3871d1-c3ae-11e2-b986-0800272864ba:4 ? A ‘Last_Executed_GTID’ column would have been useful. In our case we can check…
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
… polls: “What is the maximum number of columns in MySQL?” and “What is the minimum maximum number of columns in MySQL?”. Before you read… to working out the maximum number of columns in a MySQL table. So what’s the maximum number of columns in a MySQL table… for a table with 2,829 columns. I believe this to be the maximum number of columns you can create. If you try…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… | 4 | +———-+——+———————+———-+——+——-+———+ SYS_COLUMNS Table SYS_COLUMNS stores fields names and type information of the table. CREATE TABLE `SYS_COLUMNS` ( `TABLE_ID… NULL/NOT NULL properties etc. `LEN` is the maximum number of bytes a field uses to store a …
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… (Teemu Ollakka). Standard MySQL port would be used when port number wasn’t explicitly defined in the wsrep_node_incoming_address…). Parallel applying would fail in case mixed CHAR and VARCHAR columns would be used in foreign key definitions. Bug fixed #1100496… fixed #1164992 (Alex Yurchenko). Percona-XtraDB-Cluster-galera package version number didn’t match the wsrep_provider_version one. Bug fixed…
Comment: TMP_TABLE_SIZE and MAX_HEAP_TABLE_SIZE
April 4, 2013 By 17 Comments
… number of disk-based temporary tables Note! BLOB and TEXT columns are not allow in memory tables. If you are using these columns…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… transactions for you. However, each autocommit is retried only the number of times specified by this variable (default is 1 retry… schema In Example 2, above, how above moving the ‘joined’ column to the users_groups table so we don’t need…
