Re: Table setup question

Thanks for the help, but I just can't grasp the concept (I'm not even sure I have my table layouts the way they should be to have this work). I'll have to look into this further, but for the time being the way I have it is working. Beauford - Original Message - From: "Adolfo Bello" <[EMAI

RE: Slow performance using 3.23 on RH 8.0

Yeah, I know. At this point we are still in 'proof of concept mode'. At the point we decide to go live I'll buy a copy. I really don't need more than 2-3 concurrent connections so it shouldn't set me back too much. Bottom line is I'm probably 'spending' more on wasted people time than I would on

take one database offline

On a single Linux box w/mysql 3.23.52 I have mysqld running and there are about 20 databases live in the environment. I want to take one of the databases offline but leave mysqld running with the other db's - without interrupting service. I want mysqld to gracefully refresh itself that the databa

RE: Slow performance using 3.23 on RH 8.0

Go for it. Whatever works works. Caveat, MSDN is not an actual license for production use, only development. If you ever get audited and are using it on a production machine, you will have to pay the license. > -Original Message- > From: Ledet, Mike [mailto:[EMAIL PROTECTED]] > Sent: W

RE: Slow performance using 3.23 on RH 8.0

Well, I've got an MSDN subscription so I have access to a legal copy.. the non-unix thing is a downside but there are number of scp command line utilities for Windoze that I can use to move the data back and forth as needed I'm seriously thinking of biting the bullet and going that way. -

Re: Bug Report: Replication in 4.0.5beta

Michael, I have been running tests on 4.0.6 with big insert transactions on Linux. I set max_binlog_size to 2M and max_packet_size to 16M. So far no errors with tables up to 400 MB in size. Looks like MySQL always writes a big transaction as one big block to the current binlog file, and does not

RE: Slow performance using 3.23 on RH 8.0

Don't let this list fool you. SQL Server is a very good product. It is far superior to Mysql in every way except cost and the fact that it doesn't run on unix. > -Original Message- > From: Ledet, Mike [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 04, 2002 5:12 PM > To: 'Adam

RE: Slow performance using 3.23 on RH 8.0

Actually it is hardware Raid 0, not software. I knew about the safety issue but I had been told that from a performance stand-point that Raid 0 was the fastest. I've watched the disk activity on the IDE drive and there is next to none, but I guess it's possible something is going on there. Gnome

Re: General question about rotating growing tables

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 rot

RE: Slow performance using 3.23 on RH 8.0

Good question... I have no idea. I'll change it to 4. -Original Message- From: Adam Nelson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 4:36 PM To: 'Ledet, Mike'; [EMAIL PROTECTED] Subject: RE: Slow performance using 3.23 on RH 8.0 Oh, and what's up with the thread_conc

RE: Slow performance using 3.23 on RH 8.0

I tried your TOP suggestion but didn't see anything out of the ordinary. Swap size was constant (6400 or so) and didn't increase or decrease under load. I'll try the swap-off idea when I get a chance. -Original Message- From: Nikolas Samios [mailto:[EMAIL PROTECTED]] Sent: Wednesday, Dece

Error compiling 3.23.53

Compiling on Solaris 8 x86 - mysql 3.23.53 - gcc version 2.95.2 19991024 (release) CC=gcc CFLAGS="-O3 -fno-omit-frame-pointer" CXX=gcc CXXFLAGS="-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti" ./configure --prefix=/usr/local/mysql-3.23.53 --with-extra-charsets=complex

Windows 98SE tester wanted

I am having problems with MySQL on close down. After much work I think it may be due to the large number of records i am storing and getting (over 100k) Would someone like to verify the problem I am having to make sure it is not my machine somehow. I will send you the app I have written and t

dom

Hello, Is there any DOM persistence API on mysql? I found mysqlxml v 1.2 on sourceforge, and it seems it is the only initiative to store xml documents in mysql. It is very interesting, however, it does not offer a loadXML method, which would facilitate to get xml text documents into mysql tabl

Possible date bug

Hi All, I ran the following commands: DROP TABLE IF EXISTS test_date; CREATE TABLE test_date (test_date datetime); INSERT INTO test_date (test_date) VALUES ('2002-02-31'); SELECT * FROM test_date; I got the following results: mysql> DROP TABLE IF EXISTS test_date; Query OK, 0 rows affected (0.0

RE: Slow performance using 3.23 on RH 8.0

Oh, and what's up with the thread_concurrency being 6? That doesn't make any sense unless you have a tri-processor setup. > -Original Message- > From: Ledet, Mike [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 04, 2002 11:01 AM > To: '[EMAIL PROTECTED]' > Subject: Slow performanc

Re: question about mysql_real_escape_string()

Dear Tom, > when i load a binary file (filesize 49Kb) into a blob field, the function is > ok but when the filesize is 1.8Mb, the function fails and my programs > aborts. The communication buffer (between client and server) is set to 1 MByte by default. You can change this either by starting the

RE: Slow performance using 3.23 on RH 8.0

The first thing I would do is toss the ultra ata drive and just use the scsi drives running raid1, raid0 just isn't safe and hardware raid1 is much faster than you would think. This may seem counter-intuitive, but there are all sorts of bus issues that could be interfering. You may very well have

UPDATE ... SELECT FROM ... :)

I have a table "a" with: ItemID int unsigned not null, CommID int unsigned not null I have a table "b" with: ItemID int unsigned not null I want to move CommID from table "a" to table "b". I've updated my schema to have CommID in "b" as well for now, and changed my code to insert the value in

RE: Table setup question

Let's assume you want the entire albums list which the song "Day and Night" by Billie Holiday is in. SELECT t1.title,t1.artist,t3.name FROM sings t1 INNER JOIN reference t2 ON t1.ids=t2.ids INNER JOIN album t3 ON t2.ida=t3.ida WHERE t1.title='Day and Night' AND t1.artist='Billie Holiday' (or "WHE

RE: Serwer Hardware p4 or pIII ?

I've posted my comments before but the important thing is that P4 is largely unnecessary as it doesn't have instructions that apply to server applications (mostly). So, PIII (dual is quite helpful) the fastest you can get without paying a premium 1 GB ram dual scsi drives (raid 1) This is the sim

RE: Innodb 'devices' / data files

Hi REposting as the 'spam' filter didn't like my mail. Question, If I need to add a data file to the InnoDB setup can I just tack another 'data file' to the innodb_date_file_path setting, restart server and it will be used? Or, is there more involved like dumping data, re-creating ALL the data_fi

Re: Slow performance using 3.23 on RH 8.0

Hi Mike, i'm a newbie in optimizing the inner structure of a db - so i stick to the os-part where i might have a vague clue ;-) did you take a look at the memory / swap-space mysqld used when doing the query? (maybe use TOP (add swap to the view by hitting "f" and then "o"), look at the swapspace

Error: can't create IP socket

whenever I try to start MySQL server... I see this message I'm operating Windows XP Professional... what should I do?? Every Network Protocal was installed... _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http:/

Re: Table setup question

Adolfo, Thanks for the info, but can you elaborate on it, 'cause basically I am just not getting the concept. No way no how can I get these joins to work. mysql> describe songs; (this contains an ID field and the title of the song and the artist.) ++-+--+-+-+-

Re: RES: RES: SQL Select Idea

On Wed, Dec 04, 2002 at 08:55:51AM -0200, Felipe Moreno - MAILING LISTS wrote: >Well, the SQL Query you requested is exatcly the one I'm asking! :-) No; I want to know what you intended for those 10 dates to do. The LIMIT query worked, as posted by someone else, which you quoted. What do you

Re: access->mysql

On Wed, 4 Dec 2002 14:39:01 -, Sandeep Murphy wrote: >method for converting a huge database i hv in Access xp to MySQL ?? > I just wrote a short program in Delphi (using MyODBC) to pull information from an Access MDB and update a MySQL table. Worked fine. I'm sure one could accompli

Re: Journals on MySQL

On Wed, Nov 20, 2002 at 08:14:45PM +0530, Insanely Great wrote: > Can somebody suggest some good English magazines on MySQL ? I write about MySQL a few times a year in Linux Magazine. I also tried to organize a "MySQL Journal" some time back but there were various problems with doing that. Perha

Re: optimize table - how often ?

On Mon, Nov 18, 2002 at 10:14:19PM -0700, Mark Stringham wrote: > Howdy - > > I have heard that periodically optimizing tables can be helpful in the > overall maintenance of the table space in the db. Is this correct and how > often should it be done? Depends how frequently the data in the table

Re: Aggregating function which returns more than one row

Felix, > Is is it possible to write an aggregation function which returns > more than one row? Yes - if I have understood your requirement correctly. It would have been helpful if you had given some idea of the application/what you want to achieve. Here's an example from out of my imagination:

Re: question about mysql_real_escape_string()

On 4 Dec 2002, at 17:29, Tom Roos wrote: > when i load a binary file (filesize 49Kb) into a blob field, the function is > ok but when the filesize is 1.8Mb, the function fails and my programs > aborts. There are two limits you should be concerned about. First a BLOB field has a maximum size o

Re: Serwer Hardware p4 or pIII ?

Having the fastest memory that is available in your system is not as important as having enough memory in your system. Without sufficient memory, you can choke your whole system and bring your server to a crawl (or even crash). Bruce - Original Message - From: "Nicolas MONNET (Tech)"

question about mysql_real_escape_string()

hi does this function handle a binary string of any length or is there some sort of max limit. when i load a binary file (filesize 49Kb) into a blob field, the function is ok but when the filesize is 1.8Mb, the function fails and my programs aborts. using the debugger, the program aborts when

Trigger

Is there an equivilent to a trigger in mySQL? I need to build a cache mechanism for a website and I thought I'd use MySQL for persistance. The problem is that I need it to schedule a cleanup task every 24 hours - to remove old cache records. MS SQL Server provides a trigger for scheduling such t

Re: question about mysql_real_escape_string()

On Wednesday 04 December 2002 16:29, Tom Roos wrote: > hi > > does this function handle a binary string of any length or is there some > sort of max limit. > > when i load a binary file (filesize 49Kb) into a blob field, the function > is ok but when the filesize is 1.8Mb, the function fails and my

RE: Automatically start MySQLServer on RedHat Linux 7.3

I'd suggest installing the MySQL RPMs from the MySQL.com website. They will setup all of the init.d scripts to handle startup/shutdown of the service. Download all the RPMs to a directory on your server, then as root type, rpm -Uvh MySQL*.rpm Then you can stop/start it like this: service mysql (s

Re: question about mysql_real_escape_string()

At 17:29 +0200 12/4/02, Tom Roos wrote: hi does this function handle a binary string of any length or is there some sort of max limit. when i load a binary file (filesize 49Kb) into a blob field, the function is ok but when the filesize is 1.8Mb, the function fails and my programs aborts. usi

RE: MySQL: Select HELP!

select * from processo_arquivos order by DATE desc limit 10 -Original Message- From: Felipe Moreno - MAILING LISTS [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 12:42 PM To: [EMAIL PROTECTED] Subject: MySQL: Select HELP! Importance: High Hi List Users, I want to know i

RE: access->mysql

The only one I found that creates a good schema that only needs minimal massages, and imports all the data correctly is Access-To-MySQL. It's not free though, but they have a trial. Once I went through my access database and removed certain invalid records (some rows had a screwed up primary key in

RE: Replication - if the master fails...

Once server 1 is down you should be able to set server 2 master and then point dns to server 2 and all should be good for server 1 to come back as slave. If you did not set server 2 as slave it would still work as a master the only problem is how to point the questions to server 2! Dynamic DNS? Si

WoW!!!! SQL is something!

I had a problem that required a proper sort of the following: IT66 ITD38 IT68 ITD39 ITD40 IT69 ITD55 ITD56 IT72 ITD57 ITD58 ITD59 ITD60 IT73 ITD73 ITD67 IT74 ITD69 ITD70 IT78 IT79 IT83 ITD71 IT81 ITD75 ITD76 IT84 ITD96 ITD97 ITD98 ITD99 ITD100 ITD101 ITD102 ITD1

RE: Automatically start MySQLServer on RedHat Linux 7.3

To get MySQL to automatically to start at bootup for mode 3: In /etc/rc.d/rc3.d, mv K12mysql to S12mysql. Theodore Reph [EMAIL PROTECTED] -Original Message- From: Ken Morley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 8:31 AM To: '[EMAIL PROTECTED]' Subject: Automatica

Select Problem

Hi all I have a detail table that has multiple records associated with an ID number Both fields are integers E.G. Id Code 4 23 4 27 34 23 34 45 34 28 What I need to find is the Id where the code is 23 and 45 for the

RE: MySQL

En el mio tampoco, pero todo funciona OK. Mandrake 9 y MySQL 4.0.5 Adolfo > -Original Message- > From: Fernando Grijalba [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 04, 2002 11:21 AM > To: MySQL Help > Subject: RE: MySQL > > > En que sistema lo instalaste? > > Yo hice la in

Remote connection is blocked because of many connection errors

I have a problem here. I cannot connect to a particular server remotely at certain times. I get the error remote connection is blocked because of many connection errors. I can login locally on the box. To resolve this problem i would run FLUSH HOST and i can connect remotely. But say about ever

Drop, Create. . .help

I want to do the following: 1-If table x exists, then drop. 2-then, create table x again. Explanation: Table x in (1) has different date parameters than table x in (2). They are called the same name because there is a function that uses that table. Basically, I want to do something like: DROP

mysql port number

How can I tell what port number mysql is running on? I need it for a chat program. :) Thanks, -Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: Installing MySQL on Jaguar?

On Wednesday, December 4, 2002, at 12:50 AM, R. Hannes Niedner wrote: Yes google :-)... I'll have to remember that for the next time I think of asking a simple question on this list! ;-) or download the binary for mac os x from the mysql.com we

re: order by clause with latin5 character set on binary fields

Veysel, Tuesday, December 03, 2002, 6:48:12 PM, you wrote: VHS> I use mySQL 3.23.49 with latin5 character set. At some of my tables I VHS> use binary fields. At normal fields order by clause returns true sorting VHS> but at binary fields I get wrong results. Is there any way to correct VHS> thi

re: re: change the data directory

Julia, Tuesday, December 03, 2002, 10:50:19 PM, you wrote: >> Tuesday, December 03, 2002, 2:24:49 AM, you wrote: >> >> JS> I have just installed the mysql binary on solaris 8. >> JS> I would like have the data go to a different directory than /local/mysql/data. >> JS> How do I get it to do that?

re: updated mysql "load data local..."

Sarah, Wednesday, December 04, 2002, 12:48:15 AM, you wrote: SK> We updated mysql yesterday to 3.23max and have just discovered that "load SK> data local infile ." no longer works unless you enable it somewhere SK> specifically. I've tried starting mysql with the option -local-infile=1 in SK>

RE: access->mysql

I used MySQLFront. It wasn't entirely automatic, but it did a reasonable job. There are some gotchas. Take your time, and be sure to read the notes for using Access and MyODBC with MySQL, if that's how you're going to do it -- some column types are not recommended. You'll want to add a TIMEST

Re: Problem with ADO, MyOLEDB and BigInt columns

i had the same problem too ... also with blob fields ... never solved! please keep me informed. thanks. bye --- Andre Michel Descombes <[EMAIL PROTECTED]> ha scritto: > Hi, > > I am trying to access a third party MySQL table > containing a BigInt field, > using ADO with a MyOLEDB driver. >

Re: General question about rotating growing tables

MySQL can do embedded SQL like that? I'm using 3.23. If so, can the embedded query have a WHERE clause as well (something like WHERE datetime > date_sub(NOW(), interval 1 month). Thx a lot - Original Message - From: "gerald_clark" <[EMAIL PROTECTED]> To: "Qmail List" <[EMAIL PROTECTED]>

RE: Perl DBI or C++ API Help!

Q&D answer in PERL! my ($file); $file = 'database_names'; $cmd = qq!show databases;!; open O, ">cmd" or die "could open cmd - $!"; print O "$cmd\n"; close O; system ("mysql -uusername -ppassword < cmd > $file") == 0 or die "could not do system - $!"; open I, "<$file" or die

Join help.

Hi, Is there a good tutorial somewhere on the join command. No matter what I do it just doesn't work. Obviously I'm doing something wrong, but the MySQL manual just doesn't help at all. TIA - Before posting, please check: h

RE: access->mysql

I saved the email last time this was posted, didn't look into it but someone suggested looking at this site. http://www.intranet2internet.com . Another option was to link the table, not exactly sure of all the steps but maybe create an empty table in mysql with all fields and data types, then set u

RE: Some Basic Questions I can't Find Answers to

I will assume that your hosting service supports MySQL, which most of them do. Also, most of hosting services allow you to administer your database using phpMyAdmin, in which you can create and drop databases and tables, run SQL scripts, etc. I will also recommend you to install Apache in your Wi

Re: Automatically start MySQLServer on RedHat Linux 7.3

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Wed, 4 Dec 2002, Ken Morley wrote: > On my RedHat Linux 7.3 system with MySQL 3.23, I can manually start > mysqld by using the following command: /usr/share/mysql/mysql.server > start. > > I always want the SQL server daemon running, so how ca

Re: Download MySql 4.05 for HP-UX

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 4 Dec 2002, Mike Knox wrote: > I'm trying to download 4.05a-beta for HP-UX 11.00. However I select the > file and go of to the sites to be told i'm trying to download binaries > for HP-UX 10.20. Anyone know where I can get the correct binari

Re: Some Basic Questions I can't Find Answers to

Hello Linda, You said ---> The MySQL database I want to run will be on my web host. Since I don't have the server physically in my possession, is the working method to install MySQL to my machine, develop the routines there, then upload them to my server? You may not need to do this. Check yo

Re: sleeping threads problem

Hi, If you are using mysql_pconnect, your connections will not be closed at the end of the script, even if mysql_close is used. Regards, Jocelyn - Original Message - From: "cristian ditoiu" <[EMAIL PROTECTED]> To: "Dan Nelson" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday

Re: InnoDB: a detailed bug report

Willie, what MySQL version you are running? On what OS? What does SHOW CREATE TABLE tabdocumentoconsultado; print? Have you used an InnoDB version <= 3.23.43 and stored characters with code > 127 in the table? E.g., accent characters? The ordering of such characters in the latin1 charset chang

Re: Automatically start MySQLServer on RedHat Linux 7.3

Ken, Here's one way: >From a terminal window, logged in as root or su, run setup and then select services and you can select mysqld to be automatically started. HTH! Cory sql, mysql, select, query On Wed, 2002-12-04 at 08:31, Ken Morley wrote: > On my RedHat Linux 7.3 system with MySQL 3.23,

Slow performance using 3.23 on RH 8.0

I'm running Mysql 3.23.52 on a Redhat 8.0 installation booting to Gnome. The machine is a dual AMD 1800, 1 gig of ram, one Ultra ATA IDE drive, and 2 18 gig scsi 10,000 RPM drives on a RAID controller running Raid 0. I've got everything except /db on the IDE drive, /db is the only thing on the rai

RE: Serwer Hardware p4 or pIII ?

--- Simon Green <[EMAIL PROTECTED]> wrote: > MySQL uses memory and HDD the most and so processor > speed is not so > important. Well, processor speed is also important, on some of our servers processors are almost 100% occupied. > So I would go with what ever costs me the less. > Also how you OS

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 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

Re: Some Basic Questions I can't Find Answers to

* Linda Carter > I've got two MySQL books that I've just purchased in order to help me > utilize the MySQL on my web host's server. I've been searching them both, > but I still don't have answers to some very basic questions. > > Okay, the MySQL database I want to run will be on my web host. > Sin

re: Delete from sub select

Kittiphum, Wednesday, December 04, 2002, 1:49:08 PM, you wrote: K> This query can find the record in Table1 that not found in Table2 K> SELECT Table1.ID FROM Table1 LEFT JOIN Table2 Using(ID) K> WHERE Table2.ID IS NULL K> and what query that use to delete the record in Table1 that not found K>

re: Problems changing password following installation

Ken, Tuesday, December 03, 2002, 11:21:33 PM, you wrote: KM> I downloaded MySQL 3.23 for my Linux server and installed it using rpm -Uvh KM> *.rpm. KM> The installation went OK and at the end, I was given a "Don't set the root KM> password reminder". KM> Specifically, it tells you to set the pas

RE: Serwer Hardware p4 or pIII ?

On Wed, 2002-12-04 at 15:23, Helmut Apfelholz wrote: > --- Simon Green <[EMAIL PROTECTED]> wrote: > > MySQL uses memory and HDD the most and so processor > > speed is not so > > important. > > Well, processor speed is also important, on some of > our servers processors are almost 100% occupied. I

re: Re: unicode encoding

Steve, Monday, December 02, 2002, 8:55:05 PM, you wrote: SV> Have you got a rough timescale as to when 4.1 will come out? Before this year ends. SV> If not then is there a way to simulate Unicode in MySQL? You can store unicode data in the MySQL database in the 3.23 and 4.0 as well.

re: zeros in TIMESTAMP column when using LOAD DATA INFILE

miked2miked, Wednesday, December 04, 2002, 8:18:04 AM, you wrote: myc> I looked at the MySQL manual and it tells you how to myc> do automatic timestamps in TIMESTAMP columns. I can myc> do that fine if I use INSERT or UPDATE statements from myc> MySQL monitor. However, LOAD DATA INFILE delivers

re: The query analizer locks with a complex query using inner left

martin, Monday, December 02, 2002, 6:13:58 AM, you wrote: ml> joins and nested where clauses. ml> Description: ml> The query analyzer seems to hang while trying to parse/optimize this ml> particular query if there is data in the table. Trying to understand why ml> mysql locked up running

Replication - if the master fails...

We're currently operating 1 MySQL server and are investigating methods for having a primary and secondary server (with the secondary taking over if the primary fails). I know about replication in MySQL, and was thinking of using that to keep the secondary in sync, if the primary should fail, i

Aggregating function which returns more than one row

Is is it possible to write an aggregation function which returns more than one row? Thanks, felix Mysql sql query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

RE: MySQL

En que sistema lo instalaste? Yo hice la instalacion en Red Hat 8.0 y lo instalo en /usr/local/mysql(version infor) y luego tuve que crear un link (/usr/local/mysql) que apuntara a ese directorio. JFernando ** sql ** -Original Message- From: Vicente Valero [mailto:[EMAIL PROTECTED]] Sent

RE: Some Basic Questions I can't Find Answers to

Linda: MySQL is a database and Apache is a webserver. They are two independent applications. To access the MySQL database, you will use CGI programming or JSP. Theodore Reph [EMAIL PROTECTED] -Original Message- From: Linda Carter [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December

Problem with ADO, MyOLEDB and BigInt columns

Hi, I am trying to access a third party MySQL table containing a BigInt field, using ADO with a MyOLEDB driver. The problem is that all this field ever returns are 0's. I tried using ODBC with the Convert BigInt to Int option but then the numbers get truncated. Is there a way around this? Than

access->mysql

Hi, Can anyone please suggest a simple and effective method for converting a huge database i hv in Access xp to MySQL ?? hv tried various methods, including using dsns , a small script available at http://www.cynergi.net/exportsql/ etc.. they all work but not deliver a clean result... any tri

Re: sleeping threads problem

Nope , you haven't read my email . I use PHP and MySql . Php closes mysql connections when the script ends . And the script ends every time a user hits a page . http://www.php.net/manual/en/function.mysql-close.php Quote : 'Using mysql_close() isn't usually necessary, as non-persistent open links a

Automatically start MySQLServer on RedHat Linux 7.3

On my RedHat Linux 7.3 system with MySQL 3.23, I can manually start mysqld by using the following command: /usr/share/mysql/mysql.server start. I always want the SQL server daemon running, so how can I automate the startup? Also, isn't there a way to safely stop the daemon automatically on system

General question about rotating growing tables

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

HANDLER table READ locked ?

How can a query like "HANDLER table READ" on a MyISAM table be locked? I thought the idea of HANDLER table READ was that it couldn't be locked. Kill 1696313 xxx localhost xxx Query 3 Locked HANDLER questions READ FIRST WHERE qid = 290184 LIMIT 1

Re: MYSQL and large fields

* Thomas Spahni > On Tue, 3 Dec 2002, Roger Baklund wrote: > > > * Simon Green > > > A LONGBLOB can store 4294967295 bytes > > > A LONGTEXT can srote 4294967295 bytes > > > > In theory, yes. But not for real. MySQL 3.23.x has a limitation on > > the max_allowed_packet parameter, the max setting is

Some Basic Questions I can't Find Answers to

I've got two MySQL books that I've just purchased in order to help me utilize the MySQL on my web host's server. I've been searching them both, but I still don't have answers to some very basic questions. Okay, the MySQL database I want to run will be on my web host. Since I don't have the server

Herzlich Willkommen in der digitalen Welt! Alles rund um DivX,S-VCD,DVD,Audio...

Sie erhalten diese E-Mail aufgrund einer Eintragung auf unseren Webseiten. Information zur Abbestellung weiter unten ## Hallo [EMAIL PROTECTED], schön das Sie interesse am Thema digitales Video haben und Sich für un

Serwer Hardware p4 or pIII ?

Hi, I am assembling mysql only server. I am planning 2Gb RAM, 4 x 15k SCSI disks. However I cannot decide if I should get 2 p4 processors or 2 tuallatin pIII. I could not find any mysql specif?c benchmarks, that would show which processors I should use. I will be running linux on the server. Cou

Re: relational is relational is relational, but ...

David, Not bang on. A foreign key is a key which is the value of a key from a 'parent' table. In MySQL, if the table and its parent are InnoDB, the db will prevent you from editing the parent key 'out of sync' as you say. PB - > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Hi again,

Re: Serwer Hardware p4 or pIII ?

On Wed, 4 Dec 2002, Helmut Apfelholz wrote: > Hi, > I am assembling mysql only server. I am planning 2Gb > RAM, 4 x 15k SCSI disks. However I cannot decide if I > should get 2 p4 processors or 2 tuallatin pIII. > > I could not find any mysql specif?c benchmarks, that > would show which processors

Re: Core beta test question

> Anybody seen a general page or study guide for the beta test yet? There > used to be a section on the MySQL site > (http://www.mysql.com/training/candguide/sec-core.htm) but its 404 now > and taking the test here in a couple days. Looked around on the site > but the information doesn't seemed

Help With SELECT

I need some help on a select if it is possible. Take for Example the following data. -- | RUSH | FileNumber | PTime | PDate | -- | 1 | 1-1023-001 | 08:00 | 12/04 | | 1 | 1--001 | 06:00 | 12/04 | | 0 | 1-1023-0

RE: Serwer Hardware p4 or pIII ?

MySQL uses memory and HDD the most and so processor speed is not so important. So I would go with what ever costs me the less. Also how you OS works with the processors will be important. What OS are you going to got for? Threads and OS limits will also play a big part with speed. Simon -Orig

mysql select query returns incorrect no of rows

Hi, I m developing a web based application using Tomcat, Struts, JSP, mysql. I m using mysql 3.23.39-max-nt and mysql-connector-java-2.0.14 to access mysql through java 1.3.1. But sometimes the select query on 1 particular table returns less no of rows than the actual. Most of the times it work

ODBC connection with ssl support

Hello. I 'm trying to connect from vb to a mysql 4.0.5 server with ssl support with myodbc 3.51.The problem is that if i change the ssl_type in mysql.user table from nothing to 'ANY' or 'X509' i get the message of wrong password.Does anyone know what i have to do? Thanks. Giannis --

MySQL

Hola, He instalado MySQL 3.23.53a y en numerosos documentos veo referencias a '/usr/local/lib/mysql' cuando dicho directorio en mi sistema no existe, así como a la libreria libmysqlclient.so He hecho algo mal en la instalación? Puedo crear dicho directorio consiguiendo los archivos de algun lugar

InnoDB: a detailed bug report

MySQL generated the following error messages about a corrupted table: / 021127 15:48:01 InnoDB: Started InnoDB: error in sec index entry update in InnoDB: index umDoc table bdatena/tabdocumentoconsultado InnoDB: tuple 0: len 8; hex 6c616e6472616465; asc landrade;; 1: len 4; hex 8

Download MySql 4.05 for HP-UX

Folks I'm trying to download 4.05a-beta for HP-UX 11.00. However I select the file and go of to the sites to be told i'm trying to download binaries for HP-UX 10.20. Anyone know where I can get the correct binaries for 11.00 ? Rgds Mike E-mail: [EMAIL PROTECTED] /mysql sql -

RE: No my.cnf - why?

Taake a look a t /usr/share/mysql (or /usr/share/doc/mysql). You will find some my.cnf templates in there. Adolfo > -Original Message- > From: Vidiot [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 04, 2002 2:40 AM > To: MySQL mail list > Subject: No my.cnf - why? > > > I instal

Re: Storing data or files

On Wed, 4 Dec 2002, tan hai shi wrote: > Hi > > I have doubt what to use to store the following: > 1. If I have html data eg. my long data are here which include > more html tags etc... > Now, I would like this is stored as what it is and would like to do > query like > searching for sp

  1   2   >