Re: Mysql 5.6, Centos 7 and errno: 24 - Too many open files - Again
Am 01.12.2016 um 08:26 schrieb Götz Reinicke - IT Koordinator: it happend again and I can't fix it, may be someone has a working solution and information on that: surely -> man systemd LimitNOFILE=infinity LimitMEMLOCK=infinity OOMScoreAdjust=-1000 I installed the most recent mysql 5.6 community on a server and do get a lot of "errno: 24 - Too many open files". There are suggestions to increase the open_files_limit, change/add that to /etc/security/limits.conf and modify the systemd script by hand /etc/security/limits.conf don't matter /etc/systemd/system/servicename.service.d/ is your friend https://www.freedesktop.org/software/systemd/man/systemd-system.conf.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Mysql 5.6, Centos 7 and errno: 24 - Too many open files - Again
Hi, it happend again and I can't fix it, may be someone has a working solution and information on that: I installed the most recent mysql 5.6 community on a server and do get a lot of "errno: 24 - Too many open files". There are suggestions to increase the open_files_limit, change/add that to /etc/security/limits.conf and modify the systemd script by hand. Depending on how you start mysql (restart, or at systemboot time ...) the limit get set or not. Question: Is that may be a known bug or something? the old topic is here: http://grokbase.com/t/centos/centos/154x78377b/mysql-5-6-centos-7-and-errno-24-too-many-open-files Regards . Götz smime.p7s Description: S/MIME Cryptographic Signature
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
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?
Re: MySQL 5.0.0 [2003] vs. MySQL 5.6 [2013] from a SQL and SQL/PSM developer viewpoint
Am 07.01.2014 13:48, schrieb Lukas Lehner: 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? clearly yes the *other direction* may be problematic in case of unsupported features in old version - hence you can even use 3.0 books signature.asc Description: OpenPGP digital signature
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
Oracle Launches New MySQL 5.6 Certifications
Older MySQL Exams to Retire https://blogs.oracle.com/certification/entry/0875_01 regards, m -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: how to get the levels of a table or a index in Mysql 5.6?
On 08.07.2013 04:23, 李炜(平安科技数据库技术支持部) wrote: how to get the levels of a table or a index in Mysql 5.6? Level? What is level supposed to be in that context? Cardinality? Or something completely different? /me confused ... -- Hartmut Holzgraefe hart...@skysql.com Principal Support Engineer (EMEA) SkySQL AB - http://www.skysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
RE: how to get the levels of a table or a index in Mysql 5.6?
Or maybe the number of levels in the BTree? Rule of Thumb: logarithm base 100 -Original Message- From: Hartmut Holzgraefe [mailto:hart...@skysql.com] Sent: Monday, July 08, 2013 6:38 AM To: mysql@lists.mysql.com Subject: Re: how to get the levels of a table or a index in Mysql 5.6? On 08.07.2013 04:23, 李炜(平安科技数据库技术支持部) wrote: how to get the levels of a table or a index in Mysql 5.6? Level? What is level supposed to be in that context? Cardinality? Or something completely different? /me confused ... -- Hartmut Holzgraefe hart...@skysql.com Principal Support Engineer (EMEA) SkySQL AB - http://www.skysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
答复: how to get the levels of a table or a index in Mysql 5.6?
The level is the height of a B-tree table or a B-tree index in mysql 5.6. My question is how to get the height(blevel) of a B-tree table or a B-tree index in mysql 5.6? Thanks. In oracle database,we can use the following statement to query the blevel of a index select index_name,blevel from dba_indexes; -Original Message- RE: how to get the levels of a table or a index in Mysql 5.6? Or maybe the number of levels in the BTree? Rule of Thumb: logarithm base 100 -Original Message- From: Hartmut Holzgraefe [mailto:hart...@skysql.com] Sent: Monday, July 08, 2013 6:38 AM To: mysql@lists.mysql.com Subject: Re: how to get the levels of a table or a index in Mysql 5.6? On 08.07.2013 04:23, 李炜(平安科技数据库技术支持部) wrote: how to get the levels of a table or a index in Mysql 5.6? Level? What is level supposed to be in that context? Cardinality? Or something completely different? /me confused ... -- Hartmut Holzgraefe hart...@skysql.com Principal Support Engineer (EMEA) SkySQL AB - http://www.skysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql The information in this email is confidential and may be legally privileged. If you have received this email in error or are not the intended recipient, please immediately notify the sender and delete this message from your computer. Any use, distribution, or copying of this email other than by the intended recipient is strictly prohibited. All messages sent to and from us may be monitored to ensure compliance with internal policies and to protect our business. Emails are not secure and cannot be guaranteed to be error free as they can be intercepted, amended, lost or destroyed, or contain viruses. Anyone who communicates with us by email is taken to accept these risks. 收发邮件者请注意: 本邮件含保密信息,若误收本邮件,请务必通知发送人并直接删去,不得使用、传播或复制本邮件。 进出邮件均受到本公司合规监控。邮件可能发生被截留、被修改、丢失、被破坏或包含计算机病毒等不安全情况。
how to get the levels of a table or a index in Mysql 5.6?
Hi how to get the levels of a table or a index in Mysql 5.6? thanks The information in this email is confidential and may be legally privileged. If you have received this email in error or are not the intended recipient, please immediately notify the sender and delete this message from your computer. Any use, distribution, or copying of this email other than by the intended recipient is strictly prohibited. All messages sent to and from us may be monitored to ensure compliance with internal policies and to protect our business. Emails are not secure and cannot be guaranteed to be error free as they can be intercepted, amended, lost or destroyed, or contain viruses. Anyone who communicates with us by email is taken to accept these risks. 收发邮件者请注意: 本邮件含保密信息,若误收本邮件,请务必通知发送人并直接删去,不得使用、传播或复制本邮件。 进出邮件均受到本公司合规监控。邮件可能发生被截留、被修改、丢失、被破坏或包含计算机病毒等不安全情况。
Editing existing Trigger MySQL 5.6
Hi, Using Workbench with MySQL 5.6 how do I edit a existing Trigger. Do I need to DROP the Trigger and create a new one ? If that is the case how can you run start command in a live environment ? Thanks Neil
Re: Editing existing Trigger MySQL 5.6
2013/05/29 10:39 +0100, Neil Tompkins Using Workbench with MySQL 5.6 how do I edit a existing Trigger. Do I need to DROP the Trigger and create a new one ? If that is the case how can you run start command in a live environment ? Whatever appearance Workbench adds (I do not know it), replacing a simple trigger looks something like this: DROP TRIGGER IF EXISTS tr; CREATE TRIGGER tr ...; . What do you mean by 'start'? The Windows command-line command? START SLAVE? START TRANSACTION? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
MySQL 5.6
Hi Does anyone know when the production release of MySQL 5.6 will be out ? Thanks Neil
Re: MySQL 5.6
在 2011-09-29四的 21:29 +0100,Tompkins Neil写道: Hi Does anyone know when the production release of MySQL 5.6 will be out ? Thanks Neil no idea,maybe you could find some useful info from http://forge.mysql.com/wiki/Development_Cycle. -- Best regards, Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**) Using Gmail? Please read this important notice: http://www.fsf.org/campaigns/jstrap/gmail?10073. signature.asc Description: This is a digitally signed message part