Re: Surviving MySQL crash

In the last episode (Feb 10), David Logan said: Foo Ji-Haw wrote: Heikki Tuuri wrote: if the OS crashes do not corrupt files, then InnoDB tables would survive an OS crash without a problem. Thanks for the reply Heikki. Let me rephrase my problem: the data remains intact, but I suspect the

Re: Surviving MySQL crash

15 * * * * /usr/local/mysql/bin/mysql -u root -pxx -e 'FLUSH TABLES' This would run a FLUSH TABLES once every hour at 15 minutes past. If you are using Windows, sorry I'm not sure how to do it there. Easier to just set flush_time=900 in my.cnf :) Thanks guys. Will give it a

Migration

Hi Guys, I am migrating a database from mySQL 4.0 to 4.1.16 and have the error ERROR 1064 at line 21: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE `jos_banner` */' at line 20 Could

Re: Migration

I am migrating a database from mySQL 4.0 to 4.1.16 and have the error ERROR 1064 at line 21: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE `jos_banner` */' at line 20 Could anyone

RE: Migration

Sure, I just use mysql db name olddbname.sql Regards, James Dey tel +27 11 704-1945 cell+27 82 785-5102 fax +27 11 388-8907 mail[EMAIL PROTECTED] -Original Message- From: Martijn Tonies [mailto:[EMAIL PROTECTED] Sent: 10 February 2006 11:58 AM To:

I need Query Help

I have a table named table1 structure is ++---+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++---+--+-+-+---+ | name | varchar(50) | NO | PRI | | | | gender |

RE: Surviving MySQL crash

That sounds an even better idea! Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/

For help

hello ！ Has anybody used of Multiple-master replication? How to set up? How to modify the my.cnf file? Thank you very much!!! 　　 [EMAIL PROTECTED] 　　2006-02-10

strange problem ( for me..)

Hi, i have a little mistake during an interrogation... if i do SELECT Cell_line FROM Mutations Where Cell_line='NCI-H63'; it returns a lot of results , all NCIH63 , and this is correct... but if i do : SELECT DISTINCT Cell_line FROM Mutations Where Cell_line='NCI-H63'; it return empty

Problems Starting MySQL

Wondering if anyone can shed some light on a problem I am experiencing. I am running MySQL 4.1 on a Red Hat Enterprise Linux ES release 4 (Nahant Update 2) machine. I have been trying to get the default /etc/init.d/mysqld script to restart the server but I keep running into the same problems.

Re: For help

If you mean a slave that replicates more than one master, that is not possible -- ie, this is not possible: Master1 -- |-- Slave Master 2 - However, if you mean: Master 1 --- Master2 Then all you have to do is set up replication so Master2 is a slave

Re: Multiple many-to-many SELECT

This is where a theoretical education is great. . .Lots of us are self-taught, some of us have had theoretical stuff. I hated theoretical stuff in college and grad school, because I just wanted to sit and make something productive. I'm coming to realize that that kind of education is invaluable.

Re: Innodb table locked on delete

Tables are locked on delete because, like an update, they are changing data. Imagine issuing a REPLACE statement after a DELETE statement. If the DELETE locks the table, then the REPLACE happens AFTER the DELETE, as you wanted. If the DELETE does not lock the table, then it's possible the

Re: I need Query Help

UPDATE `table1` SET `gender` = IF('f'=`gender`, 'm', 'f'); If you have NULL columns you might want to make another sublevel in IF to leave it NULL ! I believe this should do it... you might also take into consideraion removing the possibility of a NULL in the `gender` column... because it allows

Re: Innodb table locked on delete

So where's the row locking? I configure my database with Innodb + READ COMMITED, by this configuration by using autocommit=1, delete should be done on data commited to disk. Other thread should be able to insert/update. CMIIW Tables are locked on delete because, like an update, they are

Re: Connection problem after long idle periods

Michael Lai wrote: David Logan wrote: Michael Lai wrote: I am currently using MySQL 5.0.15 with mysql-connector-java-3.1.11. I can access the database from my JSPs with no problem except for one small issue. After a long delay (usually overnight), when someone first tries to access the

MySQL PDA Synch

hi I have an online registration system made with PHP and MySQL that i would like to make available for use with PDA's. We have a wireless network that covers only certain parts of our area and when the PDA's can connect there will be no problem as I have PDA style sheets set up. When the

Re: Innodb table locked on delete

Innodb is not row-level locking -- it's memory-page-level-locking. A memory page is usually small, so it's almost like row-level locking, but not quite. Perhaps you're running up against that? What does the query log say which queries were running? How do you know it's the delete that's taking

Re: Problems Starting MySQL

Are you running the startup script as root, or is it setuid? -Sheeri On 2/10/06, Rob Lacey [EMAIL PROTECTED] wrote: Wondering if anyone can shed some light on a problem I am experiencing. I am running MySQL 4.1 on a Red Hat Enterprise Linux ES release 4 (Nahant Update 2) machine. I have

RE: Innodb table locked on delete

I have also seen the table locking on deletes and even on large selects with INNODB. I had converted to INNODB strictly for the row level locking that is the biggest selling point of using INNODB. So all the avantages of INNODB that are advertised (ie - row level locking) are mis-represented?

Re: Problems Starting MySQL

Running as root. RobL On Friday 10 February 2006 14:55, sheeri kritzer wrote: Are you running the startup script as root, or is it setuid? -Sheeri On 2/10/06, Rob Lacey [EMAIL PROTECTED] wrote: Wondering if anyone can shed some light on a problem I am experiencing. I am running MySQL

Re: Innodb table locked on delete

Hrm, I could be wrongthe MySQL site says innodb uses row-level locking, and BDB uses page-level locking. But I remember reading that Innodb uses memory page level locking. Am I wrong? At any rate, even if InnoDB is page-level locking, you still get the benefits on a page-level, which is

Re: Migration

James, You're going to need to show us the contents of olddbname.sql. -Sheeri On 2/10/06, James Dey [EMAIL PROTECTED] wrote: Sure, I just use mysql db name olddbname.sql Regards, James Dey tel +27 11 704-1945 cell+27 82 785-5102 fax +27 11 388-8907 mail[EMAIL

Re: Innodb table locked on delete

Innodb is indeed row level locking. You are likely thinking of BDB which uses memory page level locking. gw sheeri kritzer wrote: Innodb is not row-level locking -- it's memory-page-level-locking. A memory page is usually small, so it's almost like row-level locking, but not quite. Perhaps

Re: Migration

Not the whole... maybe it's humongous... some lines above line 20 and some beneath... -- Gabriel PREDA Senior Web Developer On 2/10/06, sheeri kritzer [EMAIL PROTECTED] wrote: James, You're going to need to show us the contents of olddbname.sql. -Sheeri On 2/10/06, James Dey [EMAIL

Re: Innodb table locked on delete

Innodb is not row-level locking -- it's memory-page-level-locking. A memory page is usually small, so it's almost like row-level locking, but not quite. Perhaps you're running up against that? What does the query log say which queries were running? How do you know it's the delete that's

[ANNOUNCE] MySQL Connector/PHP for MySQL 4.1.18 released

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dear MySQL users, MySQL AB announces an updated release of the MySQL Connector/PHP for MySQL and PHP, the Windows downloads for connecting MySQL to PHP, as MySQL AB has released MySQL 4.1.18 [1]. The MySQL Connector/PHP consists of the mysql/mysqli

Re: MySQL PDA Synch

Thoughts, comments and advice very appreciated Adrian, just in case your question is out of scope for this crowd... MySQL have a number of forums and one is 'Embedded MySQL' http://forums.mysql.com/list.php?58 Hope that helps, Imran Chaudhry -- http://www.ImranChaudhry.info MySQL Database

InnoDB and locking

I guess I don't understand this locking stuff. I have a InnoDB table that has one thing in it, a counter. All I want to do is have multiple instances of the code read this counter and increment it. I want to make sure that each one is unique. Here is what I am doing in java:

Re: InnoDB and locking

Patrick Duda [EMAIL PROTECTED] wrote on 10/02/2006 16:28:56: I guess I don't understand this locking stuff. I have a InnoDB table that has one thing in it, a counter. All I want to do is have multiple instances of the code read this counter and increment it. I want to make sure that

Re: question about locking

Patrick, I thought, that if I turned off autocommit I would enter a transaction. Then, by using the select...for update, that I would take and hole a lock on the table. With a transaction-capable table, eg InnoDB, otherwise neither setting autocommit off nor adding FOR UPDATE has any

(Windows ODBC/MySQL Debug) EMERGENCY HELP NEEDED

(OT) (Windows ODBC/MySQL Debug) EMERGENCY HELP NEEDED -- The Scenario: ~~ We out locked out of our door lock database. The database is Sybase Sql Anywhere version 7.0 The software uses a hard

MySQL 5.0.x and Delphi

Hi all! I'm having problems upgrading my database from 4.0.x to 5.0.x, specially with date fields For example with 4.0.x I do: select startDate from TEvent and in my application it is displayed ok(managed with controls), but the same code, same odbc, same control in delphi, etc with mysql 5.0.x

Re: InnoDB and locking

At 10:52 AM 2/10/2006, [EMAIL PROTECTED] wrote: Patrick Duda [EMAIL PROTECTED] wrote on 10/02/2006 16:28:56: I guess I don't understand this locking stuff. I have a InnoDB table that has one thing in it, a counter. All I want to do is have multiple instances of the code read this counter

Re: MySQL 5.0.x and Delphi

Hi, First of all: you're sending a message with an enormous quote of someone elses message, this really is not done on an e-mail list. Start your own topic. I'm having problems upgrading my database from 4.0.x to 5.0.x, specially with date fields For example with 4.0.x I do: select

Re: (Windows ODBC/MySQL Debug) EMERGENCY HELP NEEDED

Michael Joyner wrote: (OT) (Windows ODBC/MySQL Debug) EMERGENCY HELP NEEDED -- The Scenario: ~~ We out locked out of our door lock database. The database is Sybase Sql Anywhere version 7.0

Re: InnoDB and locking

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Patrick Duda wrote: I guess I don't understand this locking stuff. I have a InnoDB table that has one thing in it, a counter. All I want to do is have multiple instances of the code read this counter and increment it. I want to make sure that

Re: (Windows ODBC/MySQL Debug) EMERGENCY HELP NEEDED

gerald_clark wrote: Michael Joyner wrote: (OT) (Windows ODBC/MySQL Debug) EMERGENCY HELP NEEDED -- MyODBC does not connect to Sybase. Correct. Merely trying to use it's debug features to snatch the dba password so that I can get into

Re: InnoDB and locking

At 12:54 PM 2/10/2006, Mark Matthews wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Patrick Duda wrote: I guess I don't understand this locking stuff. I have a InnoDB table that has one thing in it, a counter. All I want to do is have multiple instances of the code read this counter

Re: Multiple many-to-many SELECT

Thanks for the replies guys. I am self-taught and did do a fair amount of reading up on database design before I created my database. I'm not sure, however, that I explained myself clearly enough; the table schemas I provided were supposed to show that I have a do relating table between

Byte Swapping

This might be an unusual question because mysql always stores in little endian for all platforms (if I'm not mistaken). However, I am receiving data from several different platforms (custom boards with various processors) in raw form. I will have stored as a configuration option what endianess

fulltext searches

Hi, I have tried: select title from table where match(title, body) against('IT' in boolean mode); The result was 0 records. I have checked the min word lenght which is allowed with: mysql show variables like '%ft_min_word_len%'; +-+---+ Variable_name | Value |

Migration toolkit

I'm trying to use the Migration Toolkit to migrate a 4.1 system to a 5.0 system. It doesn't appear that it can successfully migrate my usernames and privileges. Is it supposed to be able to and is there anything special I need to do to make it happen? - Thanks

Conditionals in group by

SELECT sum(if(eventtype='click',1,0)) as clicks,sum(if(eventtype='view',1,0)) as view from xy group by somethingelse note the conditional inside the sum. wheres a good source of information on complex statistical queries like this

Re: Byte Swapping

Hi David, This might be an unusual question because mysql always stores in little endian for all platforms (if I'm not mistaken). However, I am receiving data from several different platforms (custom boards with various processors) in raw form. I will have stored as a configuration option

InnoDB per-table-space backup and move

Hi, We'd like to be able to move certain innodb databases between machines (some, but not all). This would help greatly with resyncing slaves and for fast backups. I know that we can create table-spaces on a per-table basis as described here.

Re: Byte Swapping

If I do it in C I need to do a user-defined function correct? Anyway, I am infact storing the data raw. Unfortunately byte swapping before is not an option because I am getting a stream of raw data and storing it in a blob field. Then based on some configuration, I pull parts of the data out of

Re: Migration

Thanks! The line is: /*!4 ALTER TABLE `jos_banner` */; LOCK TABLES `jos_banner` WRITE; INSERT INTO `jos_banner` VALUES (1,1,'banner','OSM 1',0,46,0,'osmbanner1.png ','http://www.opensourcematters.org','2004-07-07$ UNLOCK TABLES; /*!4 ALTER TABLE `jos_banner` ENABLE KEYS */; For the