Oracle Certified Professional, MySQL 5.6 Database Administrator

Hi when will be the exam "Oracle Certified Professional, MySQL 5.6 Database Administrator" for MySQL 5.7? Lukas

Re: get row inserted time or modified time

Hi you should do that in your App with Triggers and an audit table. You will see timestamps also in binary log (in case you enabled that) On Tue, Jun 2, 2015 at 11:28 AM, Selvam Gce wrote: > Is there any way to get row inserted time or modified time in my mysql > table? Thanks & Regards, > Sel

mysqlcheck downtime > 30 minutes for Java web application

Hi I read in "MySQL, Fifth Edition" by Paul DuBois that we should do a regular mysqlcheck. We have all InnoDB tables. As far as I unterstand the tables get read and write locked during mysqlcheck. The database will grow 100x in size, at the moment only initial load. It means big downtime. $ ti

career advice - Excel Expert and MySQL SQL specialist

Hi I passed Oracle SQL Expert and working on MySQL 5.6 developer exam. I work 5% of my job with SQL but I am searching for a full time SQL job. http://shop.oreilly.com/product/0790145363466.do Is the Excel exam (Microsoft Office Specialist - MOS) useful for getting a junior SQL pro job? What do

Re: DBA: please review my.cnf [for Java Hibernate application] and give suggestions

Hi it's also a Tomcat application server. Not dedicated MySQL instance. On Wed, Feb 12, 2014 at 11:28 AM, Adarsh Sharma wrote: > Is it a standalone DB server or Application is also hosted on top of it. > > You can give 50-70% of RAM to memory parameters like > Innodb_buffer_pool_size ( Innodb )

Re: DBA: please review my.cnf [for Java Hibernate application] and give suggestions

Hi Antonio all tables use InnoDB. The size is 27 GB (not yet in prod). I guess in prod it will be fast 80GB. thanks On Wed, Feb 12, 2014 at 10:28 AM, Antonio Fernández Pérez < antoniofernan...@fabergames.com> wrote: > Hi Lukas, > > What is your default engine? In MySQL there are a lot of param

DBA: please review my.cnf [for Java Hibernate application] and give suggestions

Hi We will use a Java application which uses Hibernate for DB calls. The vendor didn't made recommendations howto configure MySQL. The application is not yet in production. MySQL is new to me, I previously used Oracle DB. The vendor provided a guide howto configure Oracle. This is our my.conf $

MySQL 5.0.0 [2003] vs. MySQL 5.6 [2013] from a SQL and SQL/PSM developer viewpoint

Hi Are there big changes between MySQL 5.0.0 vs. MySQL 5.6? I am only interested in developer changes (not admin) Can I use development books for MySQL 5.0.0 [2003] and use the code an recent MariaDB and MySQL releases?

Oracle Certified Professional, MySQL 5.6 Developer [1Z0-882]

Hi is the book "Oracle Database 11g and MySQL 5.6 Developer Handbook from Michael McLaughlin" a good preparation for new dev exam 1Z0-882? Will I pass when understand and know everything in this book? Lukas

uncertain future of Oracle MySQL exams [1Z0-871, 1Z0-872, 1Z0-873, 1Z0-874]

Hi I am now responsible for LAMP applications. I worked previously with Oracle 11g. It seems that those exams are an "easy win" for me. I guess my preparation effort is about 60 hours. 1Z0-871 MySQL 5 Developer Certified Professional Exam, Part I 1Z0-872 MySQL 5 Developer Certified Professional E