Re: Materialized Views

2013-06-23 Thread Rafael Valenzuela
Ok Thanks El 23/06/2013 21:13, "Reindl Harald" escribió: > > > Am 23.06.2013 20:59, schrieb Bruce Ferrell: > > On 06/23/2013 11:18 AM, Rafael Valenzuela wrote: > >> Hi All, > >> I have a question about the materialized views , i remember in the DBA > >> course my trainer said me. In Mysql doesn't

Re: Materialized Views

2013-06-23 Thread Reindl Harald
Am 23.06.2013 20:59, schrieb Bruce Ferrell: > On 06/23/2013 11:18 AM, Rafael Valenzuela wrote: >> Hi All, >> I have a question about the materialized views , i remember in the DBA >> course my trainer said me. In Mysql doesn't exist this type views like >> Oracle. But My boss think the opposite.

Re: Materialized Views

2013-06-23 Thread Bruce Ferrell
On 06/23/2013 11:18 AM, Rafael Valenzuela wrote: Hi All, I have a question about the materialized views , i remember in the DBA course my trainer said me. In Mysql doesn't exist this type views like Oracle. But My boss think the opposite. In the new version has this type of view? and the difere

Re: Materialized Views

2013-06-23 Thread Bruce Ferrell
On 06/23/2013 11:18 AM, Rafael Valenzuela wrote: Hi All, I have a question about the materialized views , i remember in the DBA course my trainer said me. In Mysql doesn't exist this type views like Oracle. But My boss think the opposite. In the new version has this type of view? and the difere

Materialized Views

2013-06-23 Thread Rafael Valenzuela
Hi All, I have a question about the materialized views , i remember in the DBA course my trainer said me. In Mysql doesn't exist this type views like Oracle. But My boss think the opposite. In the new version has this type of view? and the diferences the differences between views Mysql and Oracl

UPDATE_TIME for InnoDB in MySQL 5.7

2013-06-23 Thread Dotan Cohen
The MySQL 5.7 changelog mentions: "Beginning with MySQL 5.7.2, UPDATE_TIME displays a timestamp value for the last UPDATE, INSERT, or DELETE performed on InnoDB tables. Previously, UPDATE_TIME displayed a NULL value for InnoDB tables. For MVCC, the timestamp value reflects the COMMIT time, which is