RE: upgrading mysql
Also see http://dev.mysql.con/doc/refman/5.0/en/mysql-upgrade.html. And make sure you make a backup before you do anything :) -Original Message- From: Tom Worster [mailto:f...@thefsb.org] Sent: Tuesday, January 12, 2010 10:47 AM To: Lawrence Sorrillo; mysql@lists.mysql.com Subject: Re: upgrading mysql How about: 1 shut down the slave, upgrade it, restart it, let it catch up. 2 shut down the master, upgrade it, restart it, let the slave catch up. ? On 1/12/10 12:34 PM, Lawrence Sorrillo sorri...@jlab.org wrote: Hi: I want to upgrade a master and slave server from mysql 4.1 to mysql 5.1. I want to so something like follows: 1. Stop all write access to the master server. 2. Ensure that replication on the slave is caught up to the last change on the master. 3. stop binary logging on the master. 4. stop replication on the slave. 5. dump the master, stop old 4.1 server, start new 5.1 server and reload master dump file under 5.1 server ( binary logging is turned off) 6. dump the slave, stop old 4.1 server, start new 5.1 server and reload slave dump file under 5.1 server. 7. After loading is complete, test then start binary logging on master while still preventing updates to updates. 8. After loading slave, test then start slave (get configs in place and restart server). I am thinking that in this scenario I dont have to bother with recording binlog file names and position etc etc. That both servers will have the same databases abd replication and binary logging will start on the two databases with no data loss and continue forward. Comments? ~Lawrence -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=jgor...@westernwats.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
FW: cache-panel DB issue
I am trying to move my cache into ndb but when I use the ndb engine the query time is 4 min versus myisam which is 7 seconds. This is due to the fact it is doing a full table scan on ndb and an index on myisam. I was hoping someone could help me fix this or at least explain why this is happening. I have included the select statements , the select statement and the explain select for both the ndb and the myisam. Cache database (ndb) Select distinct t0.panelId from cache1 t0, cache2 t1 where t0.panelid=t1.panelid; (282.54 s) CREATE TABLE `panel`.`cache1` ( `panelId` int(11) DEFAULT NULL, KEY `panelid` (`panelId`) ) ENGINE=ndbcluster DEFAULT CHARSET=utf8; CREATE TABLE `panel`.`cache2` ( `panelId` int(11) DEFAULT NULL, KEY `panelid` (`panelId`) ) ENGINE=ndbcluster DEFAULT CHARSET=utf8; Explain select distinct t0.panelId from cache1 t0, cache2 t1 where t0.panelid=t1.panelid; ++-+---+--+---+-+-+- -++-+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | ++-+---+--+---+-+-+- -++-+ | 1 | SIMPLE | t0| ALL | panelid | NULL| NULL| NULL | 534063 | | | 1 | SIMPLE | t1| ref | panelid | panelid | 5 | cache.t0.panelId | 1 | Using where | ++-+---+--+---+-+-+- -++-+ Panel database (myisam) select distinct t0.panelId from cache3 t0, cache4 t1 where t0.panelid=t1.panelid; (6.5 s) CREATE TABLE `panel`.`cache3` ( `panelId` int(11) DEFAULT NULL, KEY `panelid` (`panelId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `panel`.`cache4` ( `panelId` int(11) DEFAULT NULL, KEY `panelid` (`panelId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; explain select distinct t0.panelId from cache3 t0, cache4 t1 where t0.panelid=t1.panelid; ++-+---+---+---+-+-+ --+++ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | ++-+---+---+---+-+-+ --+++ | 1 | SIMPLE | t0| index | panelid | panelid | 5 | NULL | 534053 | Using index; Using temporary | | 1 | SIMPLE | t1| ref | panelid | panelid | 5 | panel.t0.panelId | 1 | Using where; Using index; Distinct | ++-+---+---+---+-+-+ --+++ Thanks Joshua Gordon
Tools on http://www.severalnines.com do not work.
Hi List, I have been trying to use bencher and chkfrag from http://www.severalnines.com. But I continue to receive the following errors../chkfrag: error while loading shared libraries: /usr/local/mysql/lib/libndbclient.so.4: cannot restore segment prot after reloc: permission denied. I am running this with NDB 7.0.6 and the owner of the library is mysql.mysql. Any ideas? Thanks Joshua Gordon.
binlog questions
We outputted the bin log using the following command: mysqlbinlog -v --base64-output=DECODE-ROWS oo-mysql1-bin.87 We then looked in this file and found some odd things. For example there is the below insert statement: ### INSERT INTO panel.history ### SET ### @1=-182667600 (4112299696) ### @7=NULL The table structure for history is: CREATE TABLE `history` ( `historyid` int(11) NOT NULL AUTO_INCREMENT, `panelid` int(11) DEFAULT NULL, `projectid` int(11) DEFAULT NULL, `resultid` int(11) DEFAULT NULL, `pulldate` datetime DEFAULT NULL, `resultdate` datetime DEFAULT NULL, `senddate` datetime DEFAULT NULL, `sendcount` int(11) DEFAULT NULL, `bouncecount` int(11) DEFAULT NULL, `link` char(128) DEFAULT NULL, `projectgroupcode` int(11) DEFAULT NULL, `vendorid` int(10) unsigned DEFAULT NULL, `ipaddress` char(15) DEFAULT NULL, `enddate` datetime DEFAULT NULL, `bloodhoundid` int(10) unsigned DEFAULT NULL, `incentive` int(4) unsigned DEFAULT NULL, PRIMARY KEY (`historyid`), KEY `RESULTDATE` (`resultdate`), KEY `PULLDATE` (`pulldate`), KEY `PANELID_PROJECTID` (`panelid`,`projectid`), KEY `PROJECTGROUPCODE` (`projectgroupcode`), KEY `projectid_vendorid` (`projectid`,`vendorid`), KEY `PROJECTIDb` (`projectid`) USING BTREE, KEY `bloodhoundid` (`bloodhoundid`) ) ENGINE=ndbcluster DEFAULT CHARSET=latin1 So it is trying to put a negative value in for the first column? Then you have stuff like: ### INSERT INTO panel.history ### SET ### @1=1169499418 ### @7=348123-41-35 05:64:02 That looks valid but there is no row in the history table with that historyid so why isn't it there? all in all it seems very inconsistent with the columns it uses and what shows up etc.. any insight would be appreacited thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Sun bought by Oracle
I hope I start getting paid what Oracle DBA's make. -Original Message- From: Arthur Fuller [mailto:fuller.art...@gmail.com] Sent: Tuesday, April 21, 2009 12:04 PM To: russbucket Cc: mysql@lists.mysql.com Subject: Re: Sun bought by Oracle I too am a big entusiast of Sun's VirtualBox, and I hope that nothing goes sideways on this product. A. effects and that is VirtualBox. I've used MySQL for years and hope Oracle does not stop it, but you never know with Ellison encharge! Just my 2 cents. -- -- OpenSUSE 11.1 KDE 4.1.3, Intel DX48BT2 Core 2 Dual E7200. 4 GB DDR III GeForce 8400 GS, 320GB Disc (2) --- Russ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=fuller.art...@gmail.com I know this is the MySQL list but there is another Sun product that this -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Question!
Read the online Manual. -Original Message- From: Jarikre Efemena [mailto:jefem...@yahoo.com] Sent: Monday, March 30, 2009 11:30 PM To: mysql@lists.mysql.com Subject: Question! Dear sir, I am young web developer using PHP Script in designing interactive website. I desire to include Mysql database on my websites. Please, how do I import, upload/export Mysql database to a website server after creating a Mysql user account and a particular database on my local machine? I will be very grateful if comprehensive response is granted to my question. Thank You. Efe Jarikre Nigeria -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org