Re: [ANN] PBXT storage engine version 1.0-Alpha released
learnt On Tue, Mar 18, 2008 at 3:39 PM, Paul McCullagh [EMAIL PROTECTED] wrote: Yes, definitely. Previous versions of PBXT built on Windows, so there can't be much work to get it going. But I don't think I will get around to firing up my Windows VM until after the conference... On Mar 18, 2008, at 8:30 AM, Sebastian Mendel wrote: Paul McCullagh schrieb: Hi All, I have just released the first fully durable version of PBXT. Because of the amount of new code I have reverted PBXT to Alpha status. This version, 1.0-alpha, can be downloaded from: http:// www.primebase.org/download. will there be any Windows builds available sooner or later? -- Sebastian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
Re: binlog sequence # rollover
This is my test 13795620 8.0K -rw-rw 1 mysql mysql 146 Mar 21 17:58 mysql.100 13795622 8.0K -rw-rw 1 mysql mysql 146 Mar 21 17:58 mysql.101 13795623 8.0K -rw-rw 1 mysql mysql 106 Mar 21 17:58 mysql.102 On Thu, Mar 20, 2008 at 10:08 PM, Baron Schwartz [EMAIL PROTECTED] wrote: Hi, On Thu, Mar 20, 2008 at 9:41 AM, Sid Lane [EMAIL PROTECTED] wrote: do binlog sequences just rollover back to 0 w/o a resetlogs? will it just automatically go back to mysqld.00 after mysqld.99? any replication implications? I know it sounds like a stupid question and I'm sure the developers are smart enought to have thought of that but we'll be crossing that threshold in the next 6-8 weeks and I don't need to find out it's a problem the hard way. I'm not sure what happens. But you can test: shut down a test installation, create mysqld.98, edit the mysqld.index file appropriately, and restart. Then see what happens when you run FLUSH LOGS a few times. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
Re: Optimize db update
This does not solve my problem. DatabaseA and DatabaseB are on 2 seperate pc and the only communication that can be use between the two PC is a USB pendrive. Is there another way of copying a table from one Database to another? I don't want to update TableA directly as I want to validate the data before updating so I'll be using a temp table in DatabaseA which will contain the data from TableB. Please advise. Thanks. Velen - Original Message - From: Daniel Brown [EMAIL PROTECTED] To: Velen [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Thursday, March 20, 2008 10:20 PM Subject: Re: Optimize db update On Thu, Mar 20, 2008 at 1:41 PM, Velen [EMAIL PROTECTED] wrote: Actually I am updating TableA in DatabaseA with values from TableB in DatabaseB. Database B is on a stand alone PC. I'm using VB6 to create a .txt file containing data from TableB then using VB6 once more to recronstruct the table in DatabaseA then remove all data which are already in TableA and insert the remaining. [snip!] How can I optimise this process? and What are the alternatives available ? If you don't absolutely need to use VB6, why not use something with native support like PHP? ? function dba_query($sql) { // Simply return the connection resource ID // Select the primary database $dba_conn = mysql_connect('hostname_a','username_a','password_a') or die(mysql_error()); $dba_db = mysql_select_db('database_a',$dba_conn); $r = mysql_query($sql,$dba_conn) or die(mysql_error()); return $r; } function dbb_query($sql) { // Simply return the connection resource ID // Select the secondary database $dbb_conn = mysql_connect('hostname_b','username_b','password_b') or die(mysql_error()); $dbb_db = mysql_select_db('database_b',$dbb_conn); $r = mysql_query($sql,$dbb_conn) or die(mysql_error()); return $r; } $sql = SELECT field1,field2,field3,field4 FROM table_a; $result = dba_query($sql) or die(mysql_error()); while($row = mysql_fetch_array($result)) { $ssql = INSERT INTO table_b(field1,field2,field3,field4) VALUES( '.$row['field1'].', '.$row['field2'].', '.$row['field3'].', '.$row['field4'].' }; dbb_query($ssql) or die(mysql_error()); } ? If you decide to go that route, I recommend subscribing to the PHP-DB list at http://php.net/mailinglists (referred to there as Databases and PHP). You should see a significant gain in performance using a native client as opposed to what you're now using (probably an ODBC DSN, MyODBC, or a JDBC hack). -- /Daniel P. Brown Forensic Services, Senior Unix Engineer 1+ (570-) 362-0283 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Optimize db update
On Fri, Mar 21, 2008 at 9:14 AM, Velen [EMAIL PROTECTED] wrote: This does not solve my problem. DatabaseA and DatabaseB are on 2 seperate pc and the only communication that can be use between the two PC is a USB pendrive. Is there another way of copying a table from one Database to another? Yes, but it won't validate the data. You'd have to find a way of doing that based on what you need to validate. PC 1: mysqldump -u username -p database_name table_name table_name.sql L Copy .sql file to pen drive. PC 2: mysql -u username -p database_name table_name.sql -- /Daniel P. Brown Forensic Services, Senior Unix Engineer 1+ (570-) 362-0283 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Optimize db update
This one is alright but is there an alternative that can be run with the mysql prompt? Thanks. Velen - Original Message - From: Daniel Brown [EMAIL PROTECTED] To: Velen [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Friday, March 21, 2008 6:00 PM Subject: Re: Optimize db update On Fri, Mar 21, 2008 at 9:14 AM, Velen [EMAIL PROTECTED] wrote: This does not solve my problem. DatabaseA and DatabaseB are on 2 seperate pc and the only communication that can be use between the two PC is a USB pendrive. Is there another way of copying a table from one Database to another? Yes, but it won't validate the data. You'd have to find a way of doing that based on what you need to validate. PC 1: mysqldump -u username -p database_name table_name table_name.sql L Copy .sql file to pen drive. PC 2: mysql -u username -p database_name table_name.sql -- /Daniel P. Brown Forensic Services, Senior Unix Engineer 1+ (570-) 362-0283 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Optimize db update
On Fri, Mar 21, 2008 at 10:04 AM, Velen [EMAIL PROTECTED] wrote: This one is alright but is there an alternative that can be run with the mysql prompt? Not to dump a file, but to import, yes. Check out the LOAD DATA INFILE command: http://dev.mysql.com/doc/refman/5.0/en/load-data.html -- /Daniel P. Brown Forensic Services, Senior Unix Engineer 1+ (570-) 362-0283 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: doubt: mysqldump in linux like windows
Hello the process of the restore is painful. i see even in windows, i dont know why made the backup in that way, (i dindt change any option to make the backup in the mysql administrator) if you say that the restore would be painful thank for your time Moon's Father wrote: If you skip the extend insert during mysqldump ,the process of the restore is painful. On Fri, Mar 21, 2008 at 5:05 AM, dr_pompeii [EMAIL PROTECTED] wrote: Hi Rolando thanks for the reply it works, thanks, new command used mysqldump --opt --skip-extended-insert --password=XXX --user=root somedb /home/Someuser/somepath/A.sql but i see one difference from windows /*!4 ALTER TABLE `articulo` DISABLE KEYS */; INSERT INTO `articulo` (`idArticulo`,`descripcion`,`stockactual`,`precioUnitario`,`precioUnitarioVenta`,`totalValorizado`,`xtraTextUnoArticulo`,`xtraNumDosArticulo`,`idLineaCategoria`,`idMedida`) VALUES ('1-15W40','ACEITE EXTRAVIDA X GLN 15W40','0.00','0.00','0.00','0.00','','0.00','300','11'), ('1-P0001','CASCOS DE MOTOS HONDA','0.00','0.00','0.00','0.00','','0.00','300','10'), ('1-P0003','LLANTAS DUNLOP LT 265/75R216','0.00','0.00','0.00','0.00','','0.00','300','10'), ('1-P0014','POLOS HONDA','0.00','0.00','0.00','0.00','','0.00','300','10'), now with the new command already shown i have this way LOCK TABLES `articulo` WRITE; /*!4 ALTER TABLE `articulo` DISABLE KEYS */; INSERT INTO `articulo` VALUES ('1-15W40','ACEITE EXTRAVIDA X GLN 15W40','0.00','0.00','0.00','0.00','','0.00','300','11'); INSERT INTO `articulo` VALUES ('1-CHA01','KIT CHACARERO AZUL (GDFGO,PORTAF,LLANT-DEL/POST)','0.00','0.00','0.00','0.00','','0.00 ','300','14'); INSERT INTO `articulo` VALUES ('1-P0001','CASCOS DE MOTOS HONDA','0.00','0.00','0.00','0.00','','0.00','300','10'); i need like the windows way, thats mean, for the first line for insertion before to insert all rows i need INSERT INTO `articulo` (`idArticulo`,`descripcion`,`stockactual`,`precioUnitario`,`precioUnitarioVenta`,`totalValorizado`,`xtraTextUnoArticulo`,`xtraNumDosArticulo`,`idLineaCategoria`,`idMedida`) VALUES i tried adding --disable-keys but wierd and undesired results regards Rolando Edwards-3 wrote: Use --skip-extended-insert as another mysqldump option -Original Message- From: dr_pompeii [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2008 2:43 PM To: mysql@lists.mysql.com Subject: doubt: mysqldump in linux like windows Hello guys i have this situation in widnows with the mysql administrador i make backup i saw in the x.sql these lines for example /*!4 ALTER TABLE `articulo` DISABLE KEYS */; INSERT INTO `articulo` (`idArticulo`,`descripcion`,`stockactual`,`precioUnitario`,`precioUnitarioVenta`,`totalValorizado`,`xtraTextUnoArticulo`,`xtraNumDosArticulo`,`idLineaCategoria`,`idMedida`) VALUES ('1-15W40','ACEITE EXTRAVIDA X GLN 15W40','0.00','0.00','0.00','0.00','','0.00','300','11'), ('1-CHA01','KIT CHACARERO AZUL (GDFGO,PORTAF,LLANT-DEL/POST)','0.00','0.00','0.00','0.00','','0.00 ','300','14'), ('1-P0001','CASCOS DE MOTOS HONDA','0.00','0.00','0.00','0.00','','0.00','300','10'), ('1-P0003','LLANTAS DUNLOP LT 265/75R216','0.00','0.00','0.00','0.00','','0.00','300','10'), ('1-P0014','POLOS HONDA','0.00','0.00','0.00','0.00','','0.00','300','10'), see pls that each row is written in a unique of line of text now in linux with command in a terminal i do in this way my backups mysqldump --opt --password=XXX --user=root somedb /home/Someuser/somepath/A.sql the backup is done but in this way /*!4 ALTER TABLE `articulo` DISABLE KEYS */; INSERT INTO `articulo` VALUES ('1-15W40','ACEITE EXTRAVIDA X GLN 15W40','0.00','0.00','0.00','0.00','','0.00 ','300','11'),('1-CHA01','KIT CHACARERO AZUL (GDFGO,PORTAF,LLANT-DEL/POST)','0.00','0.00','0.00','0.00','','0.00 ','300','14'),('1-P0001','CASCOS DE how you can see, all the rows appear in one line, dangeous, i dont want this behaviour when i open this file in windows tell me if i try to save this file i will missing some values or rows and in linux the gedit dies :( after to read this http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html mysqldump i tried in this way mysqldump --opt --extended-insert--password=XXX --user=root somedb /home/Someuser/somepath/A.sql with the same undesired results how i can resolve this?? thanks in advanced -- View this message in context: http://www.nabble.com/doubt%3A-mysqldump-in-linux-like-windows-tp16185833p16185833.html Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives:
innodb transaction not works
Hi lists, We are running database with mixed tables myisam and innodb. I know that innodb supports transactions. My server is running with default transaction-isolation=REPEATABLE READ Whenever our cron runs stats updation scripts. It locks whole table and make other sql statements which updates the table waits for long time. How can achieve isolation correctly make other statements proceed without waiting. And my script updates record by record not as bunch. should I use transactional statements like start transaction and commit to achieve ? thanks in advance. Saravanan Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: innodb transaction not works
Hi Saravanan, Please check http://forums.mysql.com/read.php?97,18003,18003 -Raj. -Original Message- From: Saravanan [mailto:[EMAIL PROTECTED] Sent: Friday, March 21, 2008 1:59 PM To: mysql@lists.mysql.com Subject: innodb transaction not works Hi lists, We are running database with mixed tables myisam and innodb. I know that innodb supports transactions. My server is running with default transaction-isolation=REPEATABLE READ Whenever our cron runs stats updation scripts. It locks whole table and make other sql statements which updates the table waits for long time. How can achieve isolation correctly make other statements proceed without waiting. And my script updates record by record not as bunch. should I use transactional statements like start transaction and commit to achieve ? thanks in advance. Saravanan Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
InnoDB Hot Backup
I'm thinking of buying a license for this tool to do a migration from one server to another, but it's been hard for me to find good documentation on it after searching for awhile last night. Is it possible for me to migrate from a 32-bit to a 64-bit system across a network? How long would perceived downtime be? Thanks for any help, Waynn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 64bit to 32bit
I do not foresee any issues or problems with the upgrade or the way you are handling it. MySQL replication should start fine. Just make sure the snapshot of the database is as current as possible so the I/O etc. catches up as quickly as possible (which has nothing to do with your 32/64bit question, I know). Good luck with the upgrade. Sincerely, Craig Huffstetler On Fri, Mar 21, 2008 at 6:44 PM, Ed Wildgoose [EMAIL PROTECTED] wrote: Hi, what issues should I watch out for if I upgrade one machine in my master-master mysql 5.0 replication pair to a 64bit machine (the other remains 32bit)? The main things I am worried about - replication from one to the other breaking in some subtle way The upgrade itself - I intend to simply stop one of the servers, forklift the database files over to the new 64 bit machine and start it up. Any issues with this upgrade procedure..? Thanks Ed W -- MySQL Replication Mailing List For list archives: http://lists.mysql.com/replication To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
Re: InnoDB Hot Backup
Oh, and a followup question that I forgot to ask--what if the two systems have different db schemas? Is it possible to do some sort of mapping between the two? On Fri, Mar 21, 2008 at 1:48 PM, Waynn Lue [EMAIL PROTECTED] wrote: I'm thinking of buying a license for this tool to do a migration from one server to another, but it's been hard for me to find good documentation on it after searching for awhile last night. Is it possible for me to migrate from a 32-bit to a 64-bit system across a network? How long would perceived downtime be? Thanks for any help, Waynn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]