Re: Can mysql handle this load?

2003-07-10 Thread Krasimir_Slaveykov
Hello Adam, Wednesday, July 09, 2003, 4:46:40 PM, you wrote: AG I am writing an attendance system in php for my school. We have a AG little less then 1000 students. For every day of the school year one AG record will be entered into a table for each student representing their AG attendance

Re: stopping innodb engine

2003-07-10 Thread Paul DuBois
At 21:47 + 7/9/03, Gustavo A. Baratto wrote: Greetings, What happens if I use the command below when innodb engine is running? set global have_innodb=0; You can easily find out by trying it. (Go ahead, nothing bad will happen.) I want to stop innodb engine without stopping the whole server

Re: Problem When Mysql runs on a Machine with multiple NIC.

2003-07-10 Thread P Srinivasulu
Paul DuBois [EMAIL PROTECTED] 7/10/2003 10:22:27 AM At 2:30 -0600 7/9/03, P Srinivasulu wrote: When Mysql runs on machine with multiple NIC's. Mysql server takes the IP Address that we specify in the configuration file. This IP Address may or may not be a primary IP Address of that machine. So

Re: Problem When Mysql runs on a Machine with multiple NIC.

2003-07-10 Thread Dominicus Donny
Specify other account(s)? [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] etc... Me fail English? That's unpossible ###___Archon___### - Original Message - From: P Srinivasulu [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, July 10, 2003 2:40 PM Subject:

Re: Faster reindexing

2003-07-10 Thread Florian Weimer
Dathan Vance Pattishall [EMAIL PROTECTED] writes: Maybe increasing #use for when mysql is doing a check or repair set-variable= myisam_sort_buffer_size=64M to a higher value will make the index happen faster on the fly. MySQL doesn't seem to honour this variable. I've set it to

i nned ur help

2003-07-10 Thread chandana
HI , I'll give u my perl codeings . I need to add these out puts to a hash ( array ) , but now already i have added that into a normal array . Could u help me pull those results in to a hash . Actually i'm using perl . #! /usr/bin/perl -w use strict; use DBI; my ($dbh, $sth);

RE: i nned ur help

2003-07-10 Thread Rudy Metzger
Replace the commented lines with: Method 1 (with counter): @array_data = (); ... $array_data[$counter++] = @row; Method 2 (without counter): @array_data = (); # initialize it $array_data[$#array_data] = @row; # put the array into the array Method 3 (with

Re: Can mysql handle this load?

2003-07-10 Thread Heikki Tuuri
Rudy, - Original Message - From: Rudy Metzger [EMAIL PROTECTED] To: Mike Hillyer [EMAIL PROTECTED]; Adam Gerson [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, July 09, 2003 6:47 PM Subject: RE: Can mysql handle this load? ... What the

RE: JOIN within LEFT JOIN

2003-07-10 Thread Rudy Metzger
SELECT ... FROM forms f LEFT JOIN staff_assignments a ON f.form_id = a.form_id LEFT JOIN staff s ON a.staff_id = s.staff_id; Given that left joins are faster in MySQL anyway, this also gives you speed. Cheers /rudy -Original Message- From: MightyData [mailto:[EMAIL PROTECTED]

RE: Why is it better to have a composite key with the largest cardinality 1st?

2003-07-10 Thread Rudy Metzger
Do you mean that your table has a total of 1 rows? If yes, there is (generally) no need to add column b and/or c to the primary key, as this makes the information redundant (already A is unique). If you mean that you table has 4 rows (so 10K A x 2 B x 2 C) and only the combination of

RE: Problem with Temporary Table

2003-07-10 Thread Uttam
ERROR 1044: Access denied for user: '@localhost' to database 'test1' seems like guest login... login with a user having appropriate priviliges. regds, -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 09, 2003 15:07 To: [EMAIL PROTECTED] Subject: Re:

RE: mysql startup script problem

2003-07-10 Thread Rudy Metzger
Actually, mysql is only the client used to connect to mysqld. mysqld does NOT automatically start up when it crashes. But you can use mysqld_safe (or safe_mysqld which is a softlink to former). This script then takes care of logging and restarting the server. Init.d uses mysqld_safe. Cheers /rudy

RE: RESETTING AUTO_INCREMENT

2003-07-10 Thread Rudy Metzger
Or drop and recreate the table (that's actually what truncate is doing) /rudy -Original Message- From: Miguel Perez [mailto:[EMAIL PROTECTED] Sent: woensdag 9 juli 2003 20:08 To: [EMAIL PROTECTED] Subject: RESETTING AUTO_INCREMENT Hi everyone: Does anyone know how to reset the

RE: order of table joins or where clauses relevant?

2003-07-10 Thread Rudy Metzger
The order of tables in the from does NOT make any difference. The optimizer (normally) will rewrite the kwiri to suit its needs. Also the order in the WHERE does not make any difference. You should put all restrictions into the WHERE clause, which is MUCH faster than putting them into the HAVING.

RE: REGEX

2003-07-10 Thread Rudy Metzger
Could you maybe send us your table definition, some example data and an expected output? /rudy -Original Message- From: Doug Wolfgram [mailto:[EMAIL PROTECTED] Sent: donderdag 10 juli 2003 4:53 To: [EMAIL PROTECTED] Subject: REGEX I am familiar with regex in general, but here is what

RE: Faster reindexing

2003-07-10 Thread Rudy Metzger
You should also check myisam_max_extra_sort_file_size and myisam_max_sort_file_size. NOTE: I heard/know that these variables are dependant on each other, however I cannot remember anymore how. It was something that if a is not set, b is not considered. Also check out myisam_repair_threads,

constructing SQL problem

2003-07-10 Thread Krasimir_Slaveykov
Hello , I have a problem with constructing correct SQL. I have tables: TABLE1 wich have FIELD1 and FIELD2 TABLE2 wich have FIELD1 and FIELD2 TABLE3 wich have FIELD1, FIELD2 and FIELD3 I have this SQL: select a.field1, a.field2,

Re: stopping innodb engine

2003-07-10 Thread Gustavo A. Baratto
having the hability to stop the extra engines is a good candidate to go to the todo list. Stopping the server to do a reliable backup is not good solution... The ideal would be a mysql command that read locks all innodb tables, then we can backup the data file and the log files safely...

RE: constructing SQL problem

2003-07-10 Thread Rudy Metzger
SELECT ... FROM TABLE1 a, TABLE2 b, LEFT JOIN TABLE3 c ON a.field1 = c.field1 AND c.field3 != 'string' WHERE a.field1 = b.field1; If field3 in table c can be NULL and you still want to have this record included you have to modify it to ... AND

Re: Error compile mysql-3.23.51

2003-07-10 Thread Egor Egorov
[EMAIL PROTECTED] wrote: Hi All, I success ./configure my mysql-3.23.51, after type make I got this error - libmysql.c: In function `mysql_real_connect': libmysql.c:1325: warning: passing arg 5 of `gethostbyname_r' from

need info. on system requirements of MySQL

2003-07-10 Thread Sasi Bhushan C - CTD, Chennai.
Hi Sir, I need minimum system requirements for installing MySQL server. This is for service definition. Please provide me the info/link from where I can get the info. Thanks, Bhushan. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Moving DB

2003-07-10 Thread Gerald R. Jensen
You didn't say which version of MySQL you are using, or if you are using InnoDB tables. I'll assume you are using MyISAM tables, and are **adding** a drive to the system. 1. Install / mount the new drive so it is available to the O/S and assign it a drive letter. 2. Stop the MySQL Server (in

Re: MySQL performance question..

2003-07-10 Thread Egor Egorov
Keith C. Ivey [EMAIL PROTECTED] wrote: I'm running a server with a Pentium 133 w/32meg ram, 512 pipeline burst, with a wd 512MB HD and I want to store George Bush in our MySQL database. As far as table definitions are concerned, should I use a BLOB or should I store him on disk and make

Re: Error 1044 Error 2003 on 4.0.13 and RH9

2003-07-10 Thread Kevin H. Phillips
Here's the last couple of items from the error log.: Number of processes running now: 0 030707 21:03:37 mysqld restarted 030707 21:03:37 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence

Re: Slow batch load after 500MB

2003-07-10 Thread Egor Egorov
James E Hicks III [EMAIL PROTECTED] wrote: I have encountered an interesting problem using mysql. On both 3.23 and another 4.01 server when I try to batch load a file with sql statements (ex. mysql -u user -p mysql_statements.SQL) and the file is greater that 500MB it never seems to finish.

can't connect

2003-07-10 Thread Brian Zelli
Hello all, I was using Mysql-front to connect to a server running linux. I swapped out my old desktop machine for a new one and now I can't connect. What could I be missing on the new machine? They were both running windows 2000. Brian

RE: Slow batch load after 500MB

2003-07-10 Thread electroteque
check the cpu load sometimes is gets real intensive , so i have found , the cpu's are they -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: Thursday, July 10, 2003 9:55 PM To: [EMAIL PROTECTED] Subject: Re: Slow batch load after 500MB James E Hicks III [EMAIL

Best performance : 32 bit or 64 bit MySQL on Solaris 8

2003-07-10 Thread JOUANNET, Rodolphe
Hi, I've a SunFire V880 (4 proc., 8 Gb RAM) on Solaris 8. Which is the best solution (speed, security, ...) : the 32 bit or the 64 bit MySQL binaries ? Thank's Best regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: replication question

2003-07-10 Thread Victoria Reznichenko
Chris Petersen [EMAIL PROTECTED] wrote: I work for a small (but very fast-growing) company, and we're about to start deploying our new website. Because it has a live inventory setup, and because our internal tools are so integrated with the ecommerce side of things, I figure that replication

RE: Slow batch load after 500MB

2003-07-10 Thread James E Hicks III
Thanks, this problem turned out to be a lack of indexing. I figured this out by writing a little PHP script to read and execute the commands one at a time. I then noticed that the delete from table where table_field = 'value' queries were taking the longest. After indexing table_field all queries

Indexing on replicated databases

2003-07-10 Thread Jeff McKeon
I've got the following replication situation... A -- B -- C All data changes, updates and adds go into DB-A. I work with DB-C and pull all my queries for reporting from that. Would there be any problem with adding new indexes or different indexes to DB-C than exist in DB-A or B? Is there a

2 or more LEFT JOIN?

2003-07-10 Thread Krasimir_Slaveykov
Hello mysql, If I have one main table - Tab1 and 2 or more tables wich are related with Tab1, but Tab2 possibly will have records for each in Tab1 ot possibly not. Tab3-too. So I need to join Tab1 with Tab2 with LEFT JOIN and Tab1 with Tab3 - with LEFT JOIN too. Is that possible? ... and if YES

TRANSACTION... COMMITTED IN MEMORY

2003-07-10 Thread Miguel Perez
Hi everyone: I have the next question I have php script that does a lot of inserts to my tables, the first time I executed the script worked fine and I could see the results and when I did a select the command showed me the right info, but now when I try running again the script all seems is

getting in trouble with multiple insert...

2003-07-10 Thread Michael Schoen
Hi there, i´m actually developing a performance criticial system where I need to index a huge amount of protocoll data. These data are already in a chronological order, so if I push the data one by one in the database I will never need an ORDER BY syntax, `cause mysql already stores the data the

mysqlbinlog suggestion

2003-07-10 Thread Luc Foisy
allowing date range options to the command line would be really neat Luc -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

connect with 'localhost' to a '%' host entry fails with mysql 4.0.13

2003-07-10 Thread Interway Christoph
I have several users in my mysql table, with a % entry as host value. With MySQL 3.x it worked liked a charm when connection from remote (any IP) and/or localhost. But now with MySQL 4.0.13 every connection from localhost gets refused when using '%' or ' ' Is this a feature or a bug in this MySQL

Max_Connections on multiple instances

2003-07-10 Thread Ben Smith
Hello all, We have 3 instances on the same server, prod, test and dev. Is it possible to increase the max_connection limit just for one instance, or would changing the limit effect all 3 ? Many thanks ** For great Emap magazine subscription gift offers visit http://www.emapmagazines.co.uk

Re: 2 or more LEFT JOIN?

2003-07-10 Thread Brent Baisley
Sure you can do that. SELECT * FROM Tab1 LEFT JOIN Tab2 ON Tab1.field1=Tab2.field1 LEFT JOIN Tab3 ON Tab1.field1=Tab3.field1 LEFT JOIN Tab4 ON ... You can mix and match many different joins on many tables. The only problem you really run into is complexity. You could even do something like this:

access denied

2003-07-10 Thread bruno
NEWBIE I have make a mistake using mysqlcc; now, user (mysql,root,bruno) can't acces to databases. I use both mysqlcc phpMyAdmin but the answer is access denied [EMAIL PROTECTED] (Using password:Yes) access denied [EMAIL PROTECTED] (Using password:Yes) Please an help Thanks in advance bruno

MySQL, linux, ia32, 4GB RAM

2003-07-10 Thread Andy Stubbs
Hi, I wonder if anybody here is using MySQL (3.23.56?) on a linux/intel ia32 (e.g., Xeon) with more than 4 GB RAM? Did you find a performance enhancement? With PAE mode on? How does this affect MySQL - being a multithreaded process, is there any benefit in having all that extra memory as

Pull updated Records without a date field?

2003-07-10 Thread Keith Hamilton
Hello, Is there a way to pull all updated records without having a date field in each record? -- Keith -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: char

2003-07-10 Thread Ryan Yagatich
Namor, As Paul said we can make a guess, but more information would be necessary. I would first try looking at this page: http://www.mysql.com/doc/en/Silent_column_changes.html In short, the following could be the cause as to why your columns are being changed: quote * If any

Re: access denied

2003-07-10 Thread Ola Ogunneye
Bruno, I also had the same problem and it irked me for over a week. I followed the instruction on the site and I could not get it to work. The link below was followed to the letter and it did the trick for me. From what you are saying, I would think you are running on Windows...

Re: Pull updated Records without a date field?

2003-07-10 Thread Paul DuBois
At 11:38 -0500 7/10/03, Keith Hamilton wrote: Hello, Is there a way to pull all updated records without having a date field in each record? How do you determine which records have been updated in that case? -- Keith -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL

Re: Pull updated Records without a date field?

2003-07-10 Thread Ryan McDougall
--- Paul DuBois [EMAIL PROTECTED] wrote: At 11:38 -0500 7/10/03, Keith Hamilton wrote: Hello, Is there a way to pull all updated records without having a date field in each record? -- Keith Can't you just do: select field from table where datefield somedate; That way the date

Re: recursive sql statement

2003-07-10 Thread Victoria Reznichenko
Bernhard Schmidt [EMAIL PROTECTED] wrote: sorry for this mysql newbie question, but what means planned for the near future? ist this weeks, months or years away? As to CONNECT BY it means the beginning of the next year. -- For technical support contracts, goto

index question

2003-07-10 Thread Lists - Jump
Ok, don't shoot me for not entirely understanding indexes. Can you build an index across two different tables w/in the same database? I need an index on fields in table a and in table b and I want that index to exist in table a. Is it possible? I'm running 4.0.12. TIA, Charlie -- MySQL

Re: backup / superuser only

2003-07-10 Thread Andreas D. Landmark
On Wednesday 09 July 2003 00:53, Nils Valentin wrote: Hi Rudy, How about changing the port number in my.cnf and restarting the server ? All clients will look on the wrong port number and not be able to connect. That should do it while you take your backup. When finished change the port

Re: Mysql - Dual Xeon or Dual Opteron

2003-07-10 Thread Andreas D. Landmark
On Monday 07 July 2003 15:18, Florian Weimer wrote: Konstantin Yotov [EMAIL PROTECTED] writes: 2x1GHz Intel, 1GB RAM, 40GB WD 7200 8MB cache. We are going to uprade our server but I'am wondering between new Opteron (1.4GHz)and Xeon (2.4). Can't you get a machine for testing before you

Re: Indexing on replicated databases

2003-07-10 Thread Keith C. Ivey
On 10 Jul 2003 at 9:39, Jeff McKeon wrote: I've got the following replication situation... A -- B -- C All data changes, updates and adds go into DB-A. I work with DB-C and pull all my queries for reporting from that. Would there be any problem with adding new indexes or different

What's wrong with this query?

2003-07-10 Thread Chris Boget
I'm beating my head against the wall. I just can't see what's wrong with it; what would be causing the error: SELECT certificate.cert_num, master_info.uid FROM certificate JOIN master_info ON ( certificate.uid = master_info.uid ) LEFT JOIN endorsements ON ( certificate.cert_num =

Compilers

2003-07-10 Thread Michael Conlen
There's been much news lately about various compilers for the Intel platforms after various benchmarks have come out which all disagree. One that I noticed is that the new Intel processors have a math processor that allows vector calculations, which I understand as being able to pass an array

Re: What's wrong with this query?

2003-07-10 Thread Keith C. Ivey
On 10 Jul 2003 at 13:20, Chris Boget wrote: SELECT certificate.cert_num, master_info.uid FROM certificate JOIN master_info ON ( certificate.uid = master_info.uid ) LEFT JOIN endorsements ON ( certificate.cert_num = endorsements.cert_num ) WHERE certificate.active = 1 AND

Re: getting in trouble with multiple insert...

2003-07-10 Thread Egor Egorov
Michael Schoen [EMAIL PROTECTED] wrote: i?m actually developing a performance criticial system where I need to index a huge amount of protocoll data. These data are already in a chronological order, so if I push the data one by one in the database I will never need an ORDER BY syntax,

RE: What's wrong with this query?

2003-07-10 Thread Jennifer Goodie
what would be causing the error: SELECT certificate.cert_num, master_info.uid FROM certificate JOIN master_info ON ( certificate.uid = master_info.uid ) LEFT JOIN endorsements ON ( certificate.cert_num = endorsements.cert_num ) WHERE certificate.active = 1 AND certificate.referred = 0 AND

Re: Mysql - Dual Xeon or Dual Opteron

2003-07-10 Thread William R. Mussatto
On Monday 07 July 2003 15:18, Florian Weimer wrote: Konstantin Yotov [EMAIL PROTECTED] writes: 2x1GHz Intel, 1GB RAM, 40GB WD 7200 8MB cache. We are going to uprade our server but I'am wondering between new Opteron (1.4GHz)and Xeon (2.4). Can't you get a machine for testing before you

Query speed and key optimization

2003-07-10 Thread Wendell Dingus
I've been immersing myself in reading and trying to understand what I can about how keys and indexes work and the flow of a query. Here's an example of one that's not real efficient and I'm not sure if it can be made any more efficient or done some other way to go faster though. I'm guessing a

Re: index question

2003-07-10 Thread Victoria Reznichenko
Lists - Jump [EMAIL PROTECTED] wrote: Ok, don't shoot me for not entirely understanding indexes. Can you build an index across two different tables w/in the same database? I need an index on fields in table a and in table b and I want that index to exist in table a. Is it possible? I'm

Re: Query speed and key optimization

2003-07-10 Thread Brent Baisley
It sounds like you are referring to full text indexing. Whenever you have to put a wild card at the start of a word, you should probably considering using full text indexing. It's easy to implement and the manual pages are fairly informative. On Thursday, July 10, 2003, at 02:41 PM, Wendell

RE: i nned ur help

2003-07-10 Thread Ryan Yagatich
Instead of using arrays, try using hashes directly: ... while (my $hash = $sth-fetchrow_hashref) { while (my ($key, $value) = each(%{$hash})) { print $key = $value\n; } } ... On Thu, 2003-07-10 at 04:58, Rudy Metzger wrote: Replace the commented lines

Re: getting in trouble with multiple insert...

2003-07-10 Thread Brent Baisley
I assume you have your ORDER BY field indexed, but your query may not permit the index to be used for sorting. If you are selecting most of the data set or very large portions of it, you may try using HAVING instead of WHERE for you filter. Then the index can be used for the sort. MySQL will

ORDER BY with Date Format

2003-07-10 Thread Mike At Spy
I am trying to create an order by in a select statement that takes a standard 'date' column in a table and sorts the returned data by the month of that date. Off hand, I tried ORDER BY start_date(m) And I know that is wrong. Anyone have any suggestions? Thanks, -Mike -- MySQL General

Mysql access through ODBC

2003-07-10 Thread Priya Manivannan
Hi, I have a Mysql table which has over 4 records. If i want to access from VB using ODBC connection. will that be good choice related to performance wise. or any other options there. Thanks in advance. Regards priya __ Do you Yahoo!? SBC Yahoo! DSL - Now

AND NOT

2003-07-10 Thread Doug Wolfgram
Is there any easy way to create this type of QUERY? I am trying to get a list of usernames from table A who do NOT have a linked record in Table B. D -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysql - Dual Xeon or Dual Opteron

2003-07-10 Thread Andreas D. Landmark
On Thursday 10 July 2003 20:38, William R. Mussatto wrote: On Monday 07 July 2003 15:18, Florian Weimer wrote: Konstantin Yotov [EMAIL PROTECTED] writes: 2x1GHz Intel, 1GB RAM, 40GB WD 7200 8MB cache. We are going to uprade our server but I'am wondering between new Opteron

Recomended RAM for production server. 3Gb overboard?

2003-07-10 Thread Brad Brad
Hi, I'm looking at buying a new production server, as soon as i mentioned mysql the Dell salesmen started pushing 3-4Gb of ram, i'm not sure if this is excessive though. The OpenBSD server is 2.8Ghz and may have as many as 230 mysql sessions with 14 queries a second, the rest will be sleeping

RE: AND NOT

2003-07-10 Thread Kevin Fries
Yes. Use an exclusive outer join (my term, not official.) SELECT username from tableA left join tableB on tableA.id = tableB.id WHERE tableB.id IS NULL; This will first form an outer join, building a set of rows from tableA, regardless of having a matching record in tableB. Then the WHERE

Re: Recomended RAM for production server. 3Gb overboard?

2003-07-10 Thread Andreas D. Landmark
On Thursday 10 July 2003 22:15, Brad Brad wrote: Hi, I'm looking at buying a new production server, as soon as i mentioned mysql the Dell salesmen started pushing 3-4Gb of ram, i'm not sure if this is excessive though. The OpenBSD server is 2.8Ghz and may have as many as 230 mysql sessions

Re: Recomended RAM for production server. 3Gb overboard?

2003-07-10 Thread colbey
Lord yea... don't get me wrong it would be nice.. but I'd start with say 1GB based on what your doing now.. just make sure the server has lots of slots open for future upgrades if required. (don't let them stick in 256MB sticks taking up 4 slots).. use larger size sticks to keep slots open..

Re: Recomended RAM for production server. 3Gb overboard?

2003-07-10 Thread Florian Weimer
Brad Brad [EMAIL PROTECTED] writes: The OpenBSD server is 2.8Ghz and may have as many as 230 mysql sessions with 14 queries a second, the rest will be sleeping (ftp sessions maintain connection). The db directory is 80mb total, 80 MB? Is this a typo? The old server is seems quite happy

HELP about replication

2003-07-10 Thread trashMan
I've followed the http://www.mysql.com/doc/en/Replication_HOWTO.html but i've this error :-( *** 030710 22:36:43 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log

Re: Can mysql handle this load?

2003-07-10 Thread nospam
why use INT for a date? i am used to do this with my bulletin board, since i need a 1-second resolution and so i can easily use the time() function in php and format the output string with date(), which is also using unix timestamps. but for applications that only need a resolution of 1 day,

Max key length error

2003-07-10 Thread Brian Rivet
Hi I'm new to MySql and I'm trying to set up a database table, and I keep getting an error saying: Max key length is 500 I have looked everywhere I can think of but I can't find an explanation for what is causing the problem so I can fix it, can anyone help me? Thanks, Brian Rivet

Re: Max key length error

2003-07-10 Thread Keith C. Ivey
On 10 Jul 2003 at 16:19, Brian Rivet wrote: Max key length is 500 I have looked everywhere I can think of but I can't find an explanation for what is causing the problem so I can fix it, can anyone help me? Presumably your key length is too long, but since you don't give us any clue about

Max Key Length Error

2003-07-10 Thread Brian Rivet
Sorry, I'm a little new at this, here's the statement: CREATE TABLE `TblUsers` (`UserId` INT(5) UNSIGNED DEFAULT NULL NOT NULL AUTO_INCREMENT, `FirstName` VARCHAR(255) DEFAULT 'unknown' NOT NULL, `LastName` VARCHAR(255) DEFAULT 'unknown' NOT NULL, `UserName` VARCHAR(255) DEFAULT 'unknown' NOT

Re: Max Key Length Error

2003-07-10 Thread Keith C. Ivey
On 10 Jul 2003 at 16:33, Brian Rivet wrote: CREATE TABLE `TblUsers` (`UserId` INT(5) UNSIGNED DEFAULT NULL NOT NULL AUTO_INCREMENT, `FirstName` VARCHAR(255) DEFAULT 'unknown' NOT NULL, `LastName` VARCHAR(255) DEFAULT 'unknown' NOT NULL, `UserName` VARCHAR(255) DEFAULT 'unknown' NOT NULL,

[ANN] MySQL updated in Out-of-the-Box Open Source distribution

2003-07-10 Thread Rod Cope
MySQL 4.0.13 is included in Out-of-the-Box 2.1, an intelligent distribution of over 100 Open Source projects for Java developers on both Linux and Windows. Major changes since Out-of-the-Box 2.0: * Semi-automatic database switching for JBoss and the samples after installation * Support for

MySQL 3 and 4 side by side?

2003-07-10 Thread James B. Wetterau Jr.
I'm trying to get both MySQL 3 and 4 running on the same machine, ideally from RPM packages. The MySQL 4 RPM complains of a conflict with the installed MySQL 3. Can anyone tell me if this installation is possible from RPM's, or will I have to compile MySQL 4? -- MySQL General Mailing List

RE: Recomended RAM for production server. 3Gb overboard?

2003-07-10 Thread Andrew Braithwaite
The db directory is 80mb total handling 14 requests/s with all queries being simple INSERT or SELECT's. 1GB ram should be more than enough for your needs. If you are doing lots of the same kind of selects, I would dedicate a good chunk of that memory to MySQL query caching (maybe 64MB ish).

RE: Pull updated Records without a date field?

2003-07-10 Thread Andrew Braithwaite
Is there a way to pull all updated records without having a date field in each record? No. Generally speaking it's a good idea to have a timestamp field in these oft updated tables to perform just the kind of operation you describe. Cheers, Andrew -Original Message- From: Keith

Turn off log-bin without restarting database

2003-07-10 Thread Ian Collins
I want to turn off replication logging (we have stopped using replication) without shutting down the server. (The only downtime allowed is about 2am, and I needmy sleep). I couldn't see how to do this in the docs. Is it possible? The variables in my /etc/my.cnf are, log-bin server-id=1000

RE: Turn off log-bin without restarting database

2003-07-10 Thread Dathan Vance Pattishall
CHANGE MASTER TO MASTER_LOG_HOST='', MASTER_LOG_POS='', MASTER_LOG_PORT=''; SLAVE STOP; SHOW SLAVE STATUS; ---Original Message- --From: Ian Collins [mailto:[EMAIL PROTECTED] --Sent: Thursday, July 10, 2003 4:59 PM --To: [EMAIL PROTECTED] --Subject: Turn off log-bin without restarting

RE: Turn off log-bin without restarting database

2003-07-10 Thread Andrew Braithwaite
Hi, If you are using unix, comment out those lines and set a cron job for 2am to do the server restart for you... If you're using windows then comment out the lines and set ?schedule? (or whatever the ms equiv is) to do the restart at 2am. Cheers, Andrew -Original Message- From: Ian

RE: MySQL 3 and 4 side by side?

2003-07-10 Thread Andrew Braithwaite
There is a doc on it here: http://mysql.us.themoes.org/doc/en/Installing_many_servers.html (the same page on www.mysql.com/doc seems to have gone missing!!) Cheers, Andrew -Original Message- From: James B. Wetterau Jr. [mailto:[EMAIL PROTECTED] Sent: Thursday 10 July 2003 23:28 To:

RE: ORDER BY with Date Format

2003-07-10 Thread Andrew Braithwaite
Try: order by left(start_date,7) That will order by year then month for a standard date column.. Cheers, Andrew -Original Message- From: Mike At Spy [mailto:[EMAIL PROTECTED] Sent: Thursday 10 July 2003 20:51 To: [EMAIL PROTECTED] Subject: ORDER BY with Date Format I am trying to

ANSI_NULLS and ANSI_WARNINGS

2003-07-10 Thread Jef S
Greetings to all, Using a SELECT Statement, I am trying to pull information from two separate databases. The query is being run from the database entitled NETWORK and the other database is called DB1. The result set will be displayed to a webpage using PHP in a table format. The problem is when

post installation problem

2003-07-10 Thread Nick Keeling
I am a MySQL newbie with a post installation problem. I have Linux Red Hat 9 with MySQL 4.0. After installing MySQL, I can not for the life of me get the mysql daemon to run. My installation directory is /usr/local/mysql but it wants to open a database from /var/lib/mysql. Obviously something is

mysql naming scheme

2003-07-10 Thread renniw one
Hi, In the mysql documentation, a mysql name is said to consist of 'three numbers and a suffix'. However, I have come across mysql versions such 3.23.56a, 4.0.12-nt and have read of versions like 3.23.33-log. The documentation lists -alpha, -beta, -gamma as suffixes. So, are 'a', '-nt' and

What's up with this GATOR crap?

2003-07-10 Thread C. Reeve
Hi, I have noticed recently that every time I go to the MySQL manual page I get prompted to install Gator spyware. If MySQL condones or is going to use spyware, I may have to consider using another database. This may sound extreme, but I do not condone the use of spyware in any form and would

Re: What's up with this GATOR crap?

2003-07-10 Thread Paul DuBois
At 23:43 -0400 7/10/03, C. Reeve wrote: Hi, I have noticed recently that every time I go to the MySQL manual page I get prompted to install Gator spyware. If MySQL condones or is going to use spyware, I may have to consider using another database. This may sound extreme, but I do not condone the

Re: What's up with this GATOR crap?

2003-07-10 Thread Daniel Kasak
C. Reeve wrote: Hi, I have noticed recently that every time I go to the MySQL manual page I get prompted to install Gator spyware. If MySQL condones or is going to use spyware, I may have to consider using another database. This may sound extreme, but I do not condone the use of spyware in any

Re: What's up with this GATOR crap?

2003-07-10 Thread daniel
yes adaware is good , will remove the whole thing , but it quarantines the files goto the quarantine list and remove it there too , i must say is there no such thing as privacy laws ? C. Reeve wrote: Hi, I have noticed recently that every time I go to the MySQL manual page I get prompted to

Re: What's up with this GATOR crap?

2003-07-10 Thread Pete McNeil
I couldn't believe it so I looked. When I load the manual page I _do not_ see any such thing. Something else must be going on. _M At 11:43 PM 7/10/2003 -0400, C. Reeve wrote: Hi, I have noticed recently that every time I go to the MySQL manual page I get prompted to install Gator spyware. If

Re: What's up with this GATOR crap?

2003-07-10 Thread W. D.
At 23:01 7/10/2003, Daniel Kasak, wrote: C. Reeve wrote: I go to the MySQL manual page I get prompted to install Gator spyware. Please remain calm. You must have gotten Gator on your computer all by yourself because it certainly doesn't come with MySQL. Search on Google for 'AdAware'. Download

Complex select statement

2003-07-10 Thread Roy Walker
If anyone could tell me what I am doing wrong here, I would greatly appreaciate it. Have the following tables: table1: id, count table2: id, count, period_count, date, timestamp Trying to do the following; get all rows from table 1 and insert them into table2 while setting period_count to