…. Then, a startup script becomes a nightmare. Finally, if the box on which the script is supposed to …_mgmd #!/bin/bash /usr/bin/nohup /usr/local/mysql/libexec/ndb_mgmd > /dev/null & while [ 1 ] do /…s it. For my part, I configured Pacemaker by dumping the cib in xml format, editing and reloading. …
Post: Pacemaker, please meet NDB Cluster or using Pacemaker/Heartbeat to start a NDB Cluster
May 19, 2010 By 10 Comments
Comment: Can we improve MySQL variable handling ?
February 19, 2012 By 8 Comments
The mysql-test-run.pl script does something similar, which is to dump the contents of GLOBAL_VARIABLES before and after a test run. In this case, this dump could be done in init_file, so it would work… that was changed at runtime if we compare with a dump taken right before shutdown.
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
… table I am getting: mysql> check table test; ERROR 2013 (HY000): Lost connection to MySQL server during query mysql> check table test; +———–+——-+———-+———-+ | Table… to look into it more later. Another alternative is to dump table with MySQLDump and load it back. It is all… but fetch data to the script instead make sure to use LIMIT or PK Rangers when MySQL crashes you will not get…
Comment: Why MySQL could be slow with large tables ?
July 6, 2007 By 141 Comments
… using some scripts to manipulate the resultant csv to a partially de-normalised state and then loading them into the MySQL server…, dumping it into a sqlite DB and do the joins there, thereby minimising load on the main server or even the mysql… it is, right now, I’m exploring the option of dumping the data into users’s PC into SQLite and doing…
Comment: Dangerous command
May 20, 2008 By 9 Comments
… need to release software on schedule. After being burned with MySQL 5.0 quality there was a swing to making solid… was just dropped. Seriously I think it is a shame MySQL does not have this feature even in 5.1 – it… the dump – write a script as many people have, if you just store tables in MySQL database you can simply use little script to…
Comment: MySQL - to use or not to use
May 29, 2007 By 10 Comments
… many new and great featured, mostly those the guys claiming MySQL is a “toy database” used as argument. This with Subqueries… hard way is that you should dump and restore the tables, rather than letting the upgrade script upgrade them, it seemed to be far slower and raised innodb tablespace size severely. The reasons for the upgrade where: – MySQL…
Post: Alternatives of PHP ?
September 9, 2006 By 28 Comments
When I loaded GigaBytes of XMLs into mysql database with PHP script, I was thinking about PHP alternatives. Why do I need… – I’m just tired of debugging with ‘echo’ and ‘var_dump‘ 3. Unpredictable memory consumption – it’s easy in processing of… refresh my mind. List of my requirements: – Stable binding to MySQL, support of new protocol with prepared statement is necessary. – good…
Comment: Why you can't rely on a replica for disaster recovery
August 1, 2010 By 25 Comments
… slave, which we then turn off replication and take a dump of nightly. We’ve been toying with the idea of… a cronjob script that toggles replication in some sort of estimated manner. But until they add that feature to MySQL proper, it…
