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, > Selvam | Linkedin
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. $ time mysqlcheck --all-databases [...] real29m41.449s user0m0.019s sys 0m0.015s mysql> SELECT table_schema "Data Base Name", SUM( data_length + index_length) / 1024 / 1024 -> "Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema ; ++--+ | Data Base Name | Data Base Size in MB | ++--+ | imzweffefr | 38420.97170544 | | information_schema | 0.00781250 | | mysql | 0.63046169 | ++--+ 3 rows in set (5.86 sec) You all do mysqlcheck? Is it really mandatory? What's the risk if I don't do it regularly?
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 you think? Lukas
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 ) and key_cache ( Myisam ) for mysql > tables. > > Below link : http://mysql.rjweb.org/doc.php/memory will give you a brief > idea. > > Thanks >
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 parameters that > configure the engine behaviour. Depends on the engine, I suggest you to add > some parameters or others. > > Also it's important to know the size of your data. Your configuration is > minimal and by default is not optimal. > > Regards, > > Antonio. > >
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 $ cat /etc/my.cnf [mysqld] datadir=/opt/pprd/mysql socket=/var/lib/mysql/mysql.sock user=mysql max_allowed_packet=10M query_cache_size = 8388608 table_open_cache=256 tmp_table_size=67108864 log_bin = /opt/pprd/log/mysql-bin.log log_bin_index = /opt/pprd/log/mysql-bin.index expire_logs_days= 5 max_binlog_size = 100M binlog_format = row [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid $ rpm -qa mysql mysql-5.1.66-1.el6_3.x86_64 $ free -m total used free sharedbuffers cached Mem: 32241 31610630 0240 27209 -/+ buffers/cache: 4161 28080 Swap: 2047 74 1973 $ cat /etc/redhat-release Red Hat Enterprise Linux Server release 6.1 (Santiago) did we miss an inportant option? What config options do you use? the DDL is provided by vendor and we are not allowed to change it (for example indexes). I personly like if the MySQL behaves like a out-of-tbe-box Oracle 11g db.
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 Exam, Part II 1Z0-873 MySQL 5 Database Administrator Certified Professional Exam, Part I 1Z0-874 MySQL 5 Database Administrator Certified Professional Exam, Part II My concern is about the future of MySQL and the MySQL certifications. - it seems the exams didn't change since 2005 - Linux distributions ship MariaDB (not MySQL) - Oracle Press don't publish an official study guide - MySQL OCP exams are simpler than other OCP exams (for example Oracle 11g) what do you think?