General Question..

2009-05-21 Thread HINOJO RUELAS ARTURO
Hello all, Hope you are doing well, I have a general question creating foreign keys , I'm creating FK from catalog tables to relation tables with them, when I create a FK in innodb engine on MYSQL a new field with the same name of the FK is created, in this case if I create for example 3 FK

general question

2005-07-28 Thread Octavian Rasnita
Hi, I am using a MySQL database on a web site, and I would like to know what happends if someone searches in the database using a form, but after a few seconds MySQL starts the query, that user hit the Stop button of the browser. Will MySQL continue its searching and also create the cache, or it

Re: general question

2005-07-28 Thread SGreen
Octavian Rasnita [EMAIL PROTECTED] wrote on 07/28/2005 02:18:05 PM: Hi, I am using a MySQL database on a web site, and I would like to know what happends if someone searches in the database using a form, but after a few seconds MySQL starts the query, that user hit the Stop button of the

Re: general question

2005-07-28 Thread Ronan Lucio
Octavian, I am using a MySQL database on a web site, and I would like to know what happends if someone searches in the database using a form, but after a few seconds MySQL starts the query, that user hit the Stop button of the browser. Will MySQL continue its searching and also create the

replication general question

2005-06-23 Thread jabbott
I have two mysql boxes setup. Fast machines, I think they are dual 3ghz with boat loads of ram. They are not real busy servers but they have some pretty good sized tables, one of them with a few million rows. My question is, I have Nagios setup to monitor the seconds behind master on the

Re: replication general question

2005-06-23 Thread Atle Veka
What type of drives to you have on your system? That is often more important than CPU speed. My guess is that there are nightly maintenance crons slowing down disk access. I have never monitored replication via the seconds-behind-master function as we do not use 4.1, so I can't speak for how

Re: replication general question

2005-06-23 Thread jabbott
I don't think network latency would be an issue. This is within a protected network dmz so it has it's own switch. Here is the nagios script stuff. Might be more than what you need but let me know if you are able to use some of it. I have two on the server. first, I have: [EMAIL

Re: replication general question

2005-06-23 Thread Gleb Paharenko
Hello. I haven't heard about periodical MySQL jobs, but Unix boxes usually have some midnight cron jobs (updating of locate database for example). [EMAIL PROTECTED] wrote: I have two mysql boxes setup. Fast machines, I think they are dual 3ghz with boat loads of ram. They are

RE: DBs and developments, general question

2004-08-18 Thread Shayne Paddock
PROTECTED] Sent: Tuesday, August 17, 2004 4:21 PM To: [EMAIL PROTECTED] Subject: DBs and developments, general question Hi list, I am still very much a newbie so here goesI am still a bit shaky on how to connect to dbs and general concepts so please excuse any glaringly wrong statements

DBs and developments, general question

2004-08-17 Thread EWAGW
Hi list, I am still very much a newbie so here goesI am still a bit shaky on how to connect to dbs and general concepts so please excuse any glaringly wrong statements.. If an application is developed in Oracle is there a special language for development with Oracle dbs? I understand

General Question on Upgrading

2004-01-04 Thread [EMAIL PROTECTED]
I got version 3.23.56 of mysql with my redhat installation as an rpm package and now want to upgrade to the latest 4 version. My question is: how I can upgrade my current installation myself without going through the rpm package installer? Thanks, -Jalil -- MySQL General Mailing List For

Re: General Question on Upgrading

2004-01-04 Thread Arne K. Haaje
søndag 04. januar 2004, 22:45, skrev [EMAIL PROTECTED]: I got version 3.23.56 of mysql with my redhat installation as an rpm package and now want to upgrade to the latest 4 version. My question is: how I can upgrade my current installation myself without going through the rpm package

General question about rotating growing tables

2002-12-04 Thread Qmail List
Hello, I have a simple database schema with a table of log entries that grows quickly. Every month I'd like to break last month's entries off into a new table for that (last) month. I know creating new tables within an existing schema is not recommend database design, but in this case it seems to

Re: General question about rotating growing tables

2002-12-04 Thread gerald_clark
How about Create newtable select * from oldtable where conditions_are_met; Qmail List wrote: Hello, I have a simple database schema with a table of log entries that grows quickly. Every month I'd like to break last month's entries off into a new table for that (last) month. I know creating

Re: General question about rotating growing tables

2002-12-04 Thread Qmail List
: [EMAIL PROTECTED] Sent: Wednesday, December 04, 2002 10:49 AM Subject: Re: General question about rotating growing tables How about Create newtable select * from oldtable where conditions_are_met; Qmail List wrote: Hello, I have a simple database schema with a table of log entries that grows

Re: General question about rotating growing tables

2002-12-04 Thread Qmail List
But there would be no way to variably create the newtable table name correct? Thx - Original Message - From: gerald_clark [EMAIL PROTECTED] To: Qmail List [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, December 04, 2002 10:49 AM Subject: Re: General question about rotating

general question

2002-04-20 Thread Paras Mukadam
Why only port 3306 is used by MySQL? Is there some standard used like used for FTP, localhost ports ? Thanks !!! -- Paras - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: general question

2002-04-20 Thread denis
Yes, and it is the same standard used to assign ports -- RFC 1700. Paras Mukadam wrote: Why only port 3306 is used by MySQL? Is there some standard used like used for FTP, localhost ports ? Thanks !!! -- Paras - Before

Re: mySQL++/General Question

2001-12-17 Thread Sinisa Milivojevic
Mike Gleason Jr Couturier writes: Hello all ! I've got 2 questions : Can we insert ASCII characters in an INSERT statement... like INSERT INTO guy(name) VALUES('ascii codes here'); so that the ascii code of a ';' will display a ';' in the database... understand !? And is there a place

mySQL++/General Question

2001-12-16 Thread Mike Gleason Jr Couturier
Hello all ! I've got 2 questions : Can we insert ASCII characters in an INSERT statement... like INSERT INTO guy(name) VALUES('ascii codes here'); so that the ascii code of a ';' will display a ';' in the database... understand !? And is there a place on the net that we can browse all errors

MyODBC General Question

2001-05-08 Thread Greg Cardoza
Good Day: I was just wondering, if I'm using mm.mysql.jdbc-1.2c to connect to a database w/JAVA do I also need MyODBC installed and configured also? Or is mm.mysql.jdbc-1.2c all I need? Thanks alot.. Greg __ Do You Yahoo!? Yahoo! Auctions -