Different Table type between MASTER and SLAVE

Hello. I'm build a system aka of Shopping mall.(I think most of queies will be SELECT) For performance, MySQL will run on replication. I need TRANSACTIONs to manages orders and payment. So, Master's Table type is InnoDB. But I think that InnoDB is slower than MyISAM. (InnoDB's row level locking

Re: Newbie: MySQL + Java + web?

Brynley wrote: Anyhow - basically it appears he writes some Java code that contains a MySQL query (which I'm still not sure how is done - but I think I can nut it out) and then calls that piece of Java code from within the browser (via HTML) - it is this part that has me bamboozled. Seach

table relations

Hi everybody, I have a question about table relations and I would like you to help me. I have two tables in one server. The first tables has the following fiels: music_id; title; artist_id; chords The second one: artist_id; artist_name; country How can I JOIN this tables?? (I'm working in PHP,

libwrap ignores entry in hosts.allow

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I'm using mysql-3.23.51 compiled with libwrap support. If hosts.{allow,deny} have similar to the following structure: hosts.allow: #start of hosts.allow mysqld: ALL #end of hosts.allow hosts.deny: #start of hosts.deny ALL: ALL #end of

Question - SELECT

How do I correct this SQL code: 2 tables there, and I want to add one conditon to item receive lcopen : id, bank, unit_price_us, order_cbm lcreceive: id, amount_us, due_date SELECT lcopen.bank, SUM(lcopen.unit_price_us*lcopen.order_cbm) * 7.8 AS open, # SUM(lcreceive.amount_us) where

built in commands are atomic, right?

Hi there, This is probably a rather foolish question, but I can't find a definitive answer anywhere in the docs and I don't like assumptions... Are all built in mysql commands atomic? In particular, is replace atomic. In the docs it says that it deletes the entry if it exists then inserts it,

Re: Different Table type between MASTER and SLAVE

Yes, this shouldn't be a problem. Master on InnoDB Slaves on MyIsam. Only after a commit on the master does it get replicated to the slave. Regards P.Murali Placed At : Heo, Jungsu [EMAIL PROTECTED] on 01/03/2003 01:37:50 PM To: [EMAIL

Help!

I am currently using Mysql version 1.4 for Windows 2000, and I cannot connect to my database via phpMyAdmin. I have run mysql and was able to type Use SAMDB--my database and it worked. But when I type the following grant all to theedge2k@flatman identified by 'mysql password'; It comes back and

Re: Foreign Key problem? in MySQL 4.0.7

Haisam, - Original Message - From: Haisam K. Ido [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Friday, January 03, 2003 2:01 AM Subject: Re: Foreign Key problem? in MySQL 4.0.7 Heikki: Do you mean the PRIMARY KEY order? UNIQUE KEY keyword(id,groupname,gid),

Re: MySQL Source tar.gz files

On Thu, 2 Jan 2003, Tyler wrote: Ok, I've got gunzip and tar, and every time I try (multiple versions) of your source .tar.gz file, I get: (when running 'tar -zxf mysql-3.23.54a.tar.gz') gzip: stdin: not in gzip format (when running 'gunzip mysql-3.23.54a.tar.gz') gunzip:

Re: Different Table type between MASTER and SLAVE

Yes, this shouldn't be a problem. Master on InnoDB Slaves on MyIsam. Only after a commit on the master does it get replicated to the slave. Regards P.Murali Placed At : Heo, Jungsu [EMAIL PROTECTED] on 01/03/2003 01:37:50 PM To: [EMAIL

Re: FAQ hosting site [FAQTS.COM]

Hi, Can I strongly suggest there be a link from the MySQL documentation page to: http://www.faqts.com/knowledge_base/index.phtml/fid/52 It is the MySQL section of FAQTS.com which, IMHO, is the best online FAQ site. Thanks for the pointer - I've added link to this to our documentation page

mysql_init

I'm currently writing a shared library on Solaris. When I add mysql_init(mysql) to the code and run the parent process, it bombs out. Unfortunately I don't have the source for the parent process so it could be quite hard to debug. Is there any issues with using the C api with shared libraries??

MySQL Help Needed Please

Hi guys, I'm new here and need help. I'm installing MySQL on FreeBSD 4.7. I actually had/have MySQL installed but when I'm trying to run it says: error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)' Check that mysqld is running and that the socket: '/tmp/mysql.sock'

MySQL-3.23 and gcc-2.96

Hi, on the website http://www.mysql.com/downloads/mysql-3.23.html there is hint to a problem with gcc-2.96. Within the changelog of RedHat gcc-2.96-113.i386.rpm I found: - * Sat Jul 15 2000 Jakub Jelinek [EMAIL PROTECTED] - Put Richard Henderson's mysql compilation fix

Re: strange behaviour

Hi Wash, Please see ntoes on this page for explanations. http://jeremy.zawodny.com/blog/archives/000203.html#000203 Next please upgrade to 3.23.54 as this does contain some fixes that should help including a compile option for broken real path. Here are my compile flags, I don't recommend -O3

re: table relations

On Friday 03 January 2003 11:57, Nuno Lopes wrote: I have a question about table relations and I would like you to help me. I have two tables in one server. The first tables has the following fiels: music_id; title; artist_id; chords The second one: artist_id; artist_name; country How can I

re: user updates trace

On Thursday 02 January 2003 10:13, Natale Babbo wrote: anyone knows how to get the history of updates of a user? ... i mean ... in my database i have a lot of users with different privileges. what i need is to reach all the insert, update and delete queries executed by one user. is it

re: Help!

On Friday 03 January 2003 13:18, Gman wrote: I am currently using Mysql version 1.4 for Windows 2000, and I cannot connect to my database via phpMyAdmin. I have run mysql and was able to type Use SAMDB--my database and it worked. But when I type the following grant all to theedge2k@flatman

inserting records into database with utf8 char-set

Hello, I am attempting to insert a string in utf-8 to a text field using DBI but mysql does preserve the original char_et but rather changes it, does any one have any idea why? I am working with Mysql 3.23.36 DBI-1.30 Thanks Dana

Question - SELECT

How do I correct this SQL code: I want to add one conditon to item receive lcopen : id, bank, unit_price_us, order_cbm lcreceive: id, amount_us, due_date SELECT lcopen.bank, SUM(lcopen.unit_price_us*lcopen.order_cbm) * 7.8 AS open, # SUM(lcreceive.amount_us) where lcreceive.due_date

Cannot download MySQL Connector/J from www.mysql.com

I am using IE5 and Windows 2000. I am trying to download the Type 4 JDBC driver for MySQL for a MySQL/Java/Linux project from the link http://www.mysql.com/downloads/api-jdbc-stable.html. The download I get as a result is about 45KB. However, it is not recognised by tar or gzip utilities as a

Re: user updates trace

Egor Egorov wrote: ... i mean ... in my database i have a lot of users with different privileges. what i need is to reach all the insert, update and delete queries executed by one user. is it possible? Nope. A good question might be whether the TODO includes auditing of this kind.

optimizing big table

hello, i have a table with 29 million rows (1,6 Go) with maritime distances inside working on mysql 3.23.52-Max on a dual xeon 800Mhz 1Go mem example : los angeles rotterdam 7728 Nmvia panama and english channel los angeles rotterdam 13456 Nm via cape horn and

Re: MySQL Help Needed Please

Anton, check the hostname.err and hostname.log files in your data directory. Then check permissions. My sock file looks like: srwxrwxrwx1 mysqldaemon 0 Dez 30 19:12 mysql.sock and finally check for your socket= /tmp/mysql.sock entries in /etc/my.cnf and

What MySQL is

Suggestion page: What MySQL is; layman style (unless one exists I haven't seen). Something like: MySQL is a back-end database program. It stores data for your programs and allows you to interface with that data using SQL commands (see reference manual). MySQL has a command-line interface

Question - SELECT

How do I correct this SQL code: 2 tables there, and I want to add one conditon to item receive lcopen : id, bank, unit_price_us, order_cbm lcreceive: id, amount_us, due_date SELECT lcopen.bank, SUM(lcopen.unit_price_us*lcopen.order_cbm) * 7.8 AS open, # SUM(lcreceive.amount_us) where

Re: Cannot download MySQL Connector/J from www.mysql.com

On Fri, 3 Jan 2003, Richard Mayebo wrote: I am using IE5 and Windows 2000. I am trying to download the Type 4 JDBC driver for MySQL for a MySQL/Java/Linux project from the link http://www.mysql.com/downloads/api-jdbc-stable.html. The download I get as a result is about 45KB. However, it is

re: Is it a bug

On Tuesday 31 December 2002 10:21, Walter Procopio wrote: I have installed mysql max 4.0.4 beta on a Suse (ver. 8.0) linux server and I have created a database with this schema: [skip] And I try to execute this query: SELECTecoras.rstda, ecotes.rstes, ecoras.rsart, ecoras.rsimm,

re: How to use HANDLER statement with primary key ?

On Wednesday 01 January 2003 15:28, Jocelyn Fournier wrote: I'm trying to use to following HANDLER syntax : HANDLER tbl_name READ index_name=(value1); However I fail since I don't know what is 'index_name' for a PRIMARY KEY (I already tried PRIMARY, `PRIMARY KEY`, and the column name

RE: Cannot download MySQL Connector/J from www.mysql.com

Thomas, Thanks - I got it now. Regards, Richard. -Original Message- From: Thomas Spahni [mailto:[EMAIL PROTECTED]] Sent: Friday, January 03, 2003 6:52 PM To: Richard Mayebo Cc: '[EMAIL PROTECTED]' Subject: Re: Cannot download MySQL Connector/J from www.mysql.com On Fri, 3 Jan 2003,

Re: What MySQL is

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Michael, et al -- ...and then Michael T. Babcock said... % % Suggestion page: What MySQL is; layman style (unless one exists I % haven't seen). Good idea. Maybe a what it isn't as well. I'd like to suggest that this be part of the now-nascent

Re: Replication and the function now()

Remi, n Fri, Jan 03, 2003 at 10:56:21AM -0500, Remi Lanteigne wrote: I would like to know if there is a way of telling mysql to transfer the value of the function now() in it's replication, as it is now (from what I see in the binlog file) mysql passes the now() to the slave instead of the

Replication and the function now()

I would like to know if there is a way of telling mysql to transfer the value of the function now() in it's replication, as it is now (from what I see in the binlog file) mysql passes the now() to the slave instead of the value, this causes a difference in my 2 databases. Thank you in advance.

Info: Using MySQL as Mutex

Just as an FYI to fellow developpers out there (feeling generous today): How many times have you written a semaphore locking system for your programs and worried they weren't thread-safe, or wished you didn't have to? Well, if you're feeling especially lazy (as I often do) and you have MySQL

changing database location

Hi All Right now I have all my MySQL database files getting stored in /var/lib/mysql/ If I want to change that to another location, say, /home/mysql or something else, how do I do it? Thanks Aman - Before posting, please check:

INNER JOIN problem

I hope someone can help. I have a table that has serveral records with the same name but unique datestamps. I need to show only the records with the latest datestamp associated with them. I am enclosing the sql that I am working with in hopes that someone can see the problem that I can't. I

AIX 4.3.3 and gethostbyaddr_r() [again?]

I'm trying to move our webserver with MySQL 3.22.32 from a slow AIX 4330-09 box to a somewhat faster one with 4330-10. Though not heavily used, the 3.22.32 has worked like a charm for several years in a chroot:ed environment. It seems that we've forgotten to update the libraries (e.g.

RE: Info: Using MySQL as Mutex

Yup, MySQL works quite well as a lock server; we've been using it as such for years. I would suggest looking at the get_lock() function specifically. It's designed to do exactly what you're looking for, and it won't require knowledge of any tables or rows. Cheers. -Dana -Original

Re: Replication and the function now()

Remi, Michael, On Fri, Jan 03, 2003 at 11:39:44AM -0500, Michael T. Babcock wrote: Fred van Engen wrote: SET TIMESTAMP=1039489014; Each time with the current timestamp of course. I haven't checked if it is actually used by the slave however. If it is used, I would imagine its for

RE: What MySQL is

take out the last two sentences. scares people away. suggest last sentence: MySql's CLI tools give you full access and control to all the the power of MySQL. If you prefer a visual tool to manage your data in MySQL, like Access Paradox tools see the downloads/links page, as you learn MySQL's

comparision in the datetime field

Hi All I have a datetime field in one of my tables in the MySQL database. Can I do something like return all records between two certain dates, say between Nov 02, 2002 and Nov 07, 2002. Thanks Aman - Before posting, please

Can't lock file (errno: 13) - don't understand this one on win32

Group, Here is the problem. I have my mysql databases set up on one windoze 2000 box on d drive with the main folder on C drive using junction to create a symbolic link ( Unix so much easier! ) so as to make the sys admin happier. I have a perl script on another box that accesses this database

Continual Database Corruption

Hello, Sorry if this has been covered, but I've searched the archives with no results. I have 2 identical servers running mysql 3.23.54a on RedHat linux 7.2 (custom kernel 2.4.17). One is running as master, one slave using mysql internal replication. The primary server has a database where one

unixOBDC

Hi everybody I use MySQL 3.23.52/linux Mandrake 9.0 Installing SQLEditor-2.1.3 (CBD-Common-2.1.3-3.i386.rpm) error:failed dependencies: unixODBC is needed by CBC-Common-2.1.3-3 Installing UnixODBC-mysql-2.2.3-1.i386.rpm error: failed dependencies odbc is needed by UnixODBC-mysql-2.2.3-1 Please

Re: table relations

Nuno Lopes Try this: SELECT music_id, title, artist_name, country FROM music_table, artist_table WHERE music_table.artist_id = artist_table.artist_id AND country LIKE 'desired country' Anderson Ataides Em Sex 03 Jan 2003 07:57, you wrote: Hi everybody, I have a question about table

Re: unixOBDC

On 3 Jan 2003, bruno peracchio wrote: I use MySQL 3.23.52/linux Mandrake 9.0 Installing SQLEditor-2.1.3 (CBD-Common-2.1.3-3.i386.rpm) error:failed dependencies: unixODBC is needed by CBC-Common-2.1.3-3 Installing UnixODBC-mysql-2.2.3-1.i386.rpm error: failed dependencies odbc is needed by

RE: Can Expect scripts interact with mysql ?

Hi : I try it but could not get it to work. Here is part of my scripts: exp_internal -f error_file.txt 0 spawn bash expect *$ send /cygdrive/c/mysql/bin/mysql -u root -p test\r expect Enter password: send \r expect *mysql spawn bash parent: waiting for sync byte parent: telling child to

Re: changing database location

shutdown mysql, move all the files in your current data directory to the new location in your my.cnf file (ie. unix: /etc/my.cnf) [mysqld] datadir=/my --- all data files are in /my - hcir On Friday, January 3, 2003, at 07:56 AM, aman raheja wrote: Hi All Right now I have all my MySQL

Re: Select Date Help

Thanks everyone for their help! Max Clark [EMAIL PROTECTED] wrote in message av2eai$8he$[EMAIL PROTECTED]">news:av2eai$8he$[EMAIL PROTECTED]... Hi all, I have a DATE column (CCYY-MM-DD), I would like to do a query like this: select * from table where date = '2003-01' What additional

LOAD DATA LOCAL

Hi, (I posted this question once before in a Re: that everyone seems to have missed ;-) I use 4.0.7-max-nt on a Win2K box, and whatever I do, I cannot use LOAD DATA LOCAL (keep getting error 1148). I tried: - Starting the server with --local-infile=1, and with --local-infile. - Starting the

RE: Can Expect scripts interact with mysql ?

At 11:37 -0800 1/3/03, Paul Choy wrote: Paul Choy writes: Hi : I am trying to run Expect scripts to interact with mysql. So far I cannot get it to work here is the list of log I got.Does anyone know how to interact Ex pect scripts with mysql. What am I missing ? I've done it, but I

Re: LOAD DATA LOCAL

I posted the same question two weeks ago. The only suggestion was to add flags to the my.cnf file: [mysqld] local-infile=1 [mysql] local-infile=1 But this didn't work. I've tried using the flags on startup of MySQL as shown in the manual but this fails as well. We were running 3.23.49. I

Re: built in commands are atomic, right?

Kathryn, - Original Message - From: Kathryn Cassidy [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Friday, January 03, 2003 1:14 PM Subject: built in commands are atomic, right? Hi there, This is probably a rather foolish question, but I can't find a definitive answer

RE: Can Expect scripts interact with mysql ?

Hi : I try your scripts except changing the spawn directory but still does not work. I wonder is it because my mysql is window version and I am running the Expect scripts in the Cygwin environment.Here is the output below. It looks like Expect is not getting the feedback from mysql output.It

Re: configuring MySQL

Ok, I finally got a src version of MySQL that worked. Now, i've got another problem. I FINALLY found this termcap library, I guess it's part of Emacs. SO, I installed Emacs. I even checked that termcap.c was in the /src directory. Now, I still get this error when configuring MySQL: checking for

Re: configuring MySQL

[EMAIL PROTECTED] wrote: Ok, I finally got a src version of MySQL that worked. Now, i've got another problem. I FINALLY found this termcap library, I guess it's part of Emacs. SO, I installed Emacs. I even checked that termcap.c was in the /src directory. Now, I still get this error when

Re: Can Expect scripts interact with mysql ?

Paul Choy writes: Hi : I try your scripts except changing the spawn directory but still does not wor k. I wonder is it because my mysql is window version and I am running the Exp ect scripts in the Cygwin environment.Here is the output below. It looks like Expect is not getting the

auto increment question

Hello, I have a table with an ID column and a viewed column. I would like the viewed column to increment by one each time the row is updated. Stats === ID views is this possible? -k sql, query - Before posting, please

Re: Info: Using MySQL as Mutex

On Fri, Jan 03, 2003 at 11:10:38AM -0600, Dana Diederich wrote: Yup, MySQL works quite well as a lock server; we've been using it as such for years. Yeah, do we. I would suggest looking at the get_lock() function specifically. It's designed to do exactly what you're looking for, and it

can't use MySQL control center 0.8.7-alpha update Chinese

Hi, I can't use MySQL control center 0.8.7-alpha to insert records with fields of Chinese GB2312 characters. The updated execution result is something like ?20, I use varchar. I run it on IIS, Chinese windows2000 professtional with service pack3. But when I use console insert record

Re: auto increment question

At 15:28 -0800 1/3/03, Kevin wrote: Hello, I have a table with an ID column and a viewed column. I would like the viewed column to increment by one each time the row is updated. Stats === ID views is this possible? Sure. Since you're updating the row anyway, set the column value to one

RE: auto increment question

It sounds to me that a trigger would help, but mysql doesn't has them yet. Adolfo -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Friday, January 03, 2003 8:04 PM To: Kevin; [EMAIL PROTECTED] Subject: Re: auto increment question At 15:28 -0800 1/3/03,

RE: auto increment question

It sounds to me that a trigger would help, but mysql doesn't has them yet. Adolfo -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Friday, January 03, 2003 8:04 PM To: Kevin; [EMAIL PROTECTED] Subject: Re: auto increment question At 15:28 -0800 1/3/03,

Order by does not use an index when it should.

Hello, I am trying to get a sort to use an index. The query is very simple: select nr from mytable where col1='const' and col2='another const' and col3='YA const' order by nr; The explain gives me:

RE: Question - SELECT

Thanks for your help, but I just want /* this condition */ lcreceive.due_date current_date /* affect to */ SUM(lcreceive.amount_us) /* and not */ SUM(lcopen.unit_price_us*lcopen.order_cbm) * 7.8 AS open Terence --- Christensen, Dave [EMAIL PROTECTED] ªº¶l¥ó¤º®e¡G SELECTlcopen.bank,

MySQL cant add or del usign VC++ with ADO

i cant add or del the MySQL database using Ado with VC++6.. anyone done this b4? pls help.. Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the

Re: Order by does not use an index when it should.

harm, Your order by will not use your weg_2 index because, as you stated, weg_2 index is on (col1, col2, col3, nr) as a group so it wont be used for the individual columns as you need try to create a separate index on just the nr column, that should be used by the orderby clause. This way your

MySQL problems with VC++ n Ado

i cant add record to MySQL using VC++6 with Ado.. i can del record but i cant move forwrd.. it will have a error stating tat Query-based update failed because the row to update cannot be found. - Before posting, please