Mysql 5.6, Centos 7 and errno: 24 - Too many open files - Again

2016-11-30 Thread Götz Reinicke - IT Koordinator
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 /e

Precautions to not run out of disk space?

2016-06-21 Thread Götz Reinicke - IT Koordinator
Hi, we recently had a software bug who wrote gigs of data to our database in a loop and finally filled the whole system. O.K. we could serverside use a separate partition/storage for the database directory, but I was wondering is mysql has a feature/option to set some sort of "minimum disk free"

Best practice migrating mysql 4.1.x -> 5.0.x with mixed innodb myisam tables

2011-01-05 Thread Götz Reinicke - IT-Koordinator
db have to be identically? Thanks a lot for any hint or suggestion! Best regards . Götz -- Götz Reinicke IT-Koordinator Tel. +49 7141 969 420 Fax +49 7141 969 55 420 E-Mail goetz.reini...@filmakademie.de Filmakademie Baden-Württemberg GmbH Akademiehof 10 71638 Ludwigsburg www.fi

Re: how to setup replication - MySQL 5.0.x - Migration and new databases

2010-06-10 Thread Götz Reinicke - IT-Koordinator
Am 08.06.10 12:05, schrieb Rob Wultsch: > On Mon, Jun 7, 2010 at 11:59 PM, Götz Reinicke - IT-Koordinator > wrote: >> Hi, >> >> we do have different LAMP systems and recently I started to put some >> mysql databases on one, new master server. (RedHat, Fredora, MySQL

how to setup replication - MySQL 5.0.x - Migration and new databases

2010-06-07 Thread Götz Reinicke - IT-Koordinator
bases to the master after sucessfully running a master-slave-setup? Will the new database be copied/created on the slave automatically? Or do I have to create tham twice? Thanks for any comments and sugesstions. Best Regards, Götz -- Götz Reinicke IT-Koordinator Tel. +49 7141 969 420 F

migrating a 32bit installation to a 64bit host - copy or export/import?

2009-12-16 Thread Götz Reinicke - IT-Koordinator
r should I export the dbs and than import tham? Best regards, Götz -- Götz Reinicke IT-Koordinator Tel. +49 7141 969 420 Fax +49 7141 969 55 420 E-Mail goetz.reini...@filmakademie.de Filmakademie Baden-Württemberg GmbH Akademiehof 10 71638 Ludwigsburg www.filmakademie.de Eintragung A

Re: AW: Virtual servers, Raid 10 or Raid 01 - your opinions?

2009-11-25 Thread Götz Reinicke - IT-Koordinator
majk.sko...@eventim.de schrieb: >> -Ursprüngliche Nachricht- >> Von: Götz Reinicke - IT-Koordinator >> [mailto:goetz.reini...@filmakademie.de] >> Gesendet: Mittwoch, 25. November 2009 12:05 >> An: mysql@lists.mysql.com >> Betreff: Virtual servers

Virtual servers, Raid 10 or Raid 01 - your opinions?

2009-11-25 Thread Götz Reinicke - IT-Koordinator
ual servers. What RAID would be the better choice? 10 or 01? What do you think? Thanks for any suggestions and best regards, Götz -- Götz Reinicke IT-Koordinator Tel. +49 7141 969 420 Fax +49 7141 969 55 420 E-Mail goetz.reini...@filmakademie.de Filmakademie Baden-Württemberg GmbH