Re: Fw: Server-Client

2003-07-23 Thread Veysel Harun Sahin
I could not understand what you try to do. But generally mysql runs on a server machine and the clients connect to it. Every client program you write can connect to mysql server seperately. If you want and need you can also write a server program too. But you have to be more clear about your

ip address why shows diff. ?

2003-07-23 Thread Neeraj Vasudeva
Hello, I have loaded MYSQL Version 4.0.12, and also loaded MySQL Control Centre 0.8.10-beta, on Win 98 Now when i go to command prompt and issue the command as mysql show processlist; ++--++---+-+--+---+--+ | Id | User | Host

MySQL tables performance question

2003-07-23 Thread Marek Lewczuk
Hello, I have a table where misc data are stored. Right now this table has about 30 columns, but for sure it will be more in the near future. So I wonder how the big number (50-100) of table's columns affect for MySQL DB performance. Maybe it's better to create more tables rather than more table's

Re: ip address why shows diff. ?

2003-07-23 Thread Egor Egorov
Neeraj Vasudeva [EMAIL PROTECTED] wrote: I have loaded MYSQL Version 4.0.12, and also loaded MySQL Control Centre 0.8.10-beta, on Win 98 Now when i go to command prompt and issue the command as mysql show processlist;

selec using first letter

2003-07-23 Thread W. Enserink
hi all, i have this table filled with names. Does anybody know how I can write a select statement which selects all names starting with a certain letter in the alphabet or a strane sign like [0...9 )(*[EMAIL PROTECTED]|?/,.] ??? any tips or help are most welcome! Regards Wilbert Enserink

RE: select using first letter

2003-07-23 Thread Willemse, Trevor
Hi Using the Square brackets with the characters within it and then a wildcard after the closing square bracket works except for looking for special square brackets. hi all, i have this table filled with names. Does anybody know how I can write a select statement which selects all names

Introduction

2003-07-23 Thread Daniel Glenfield
Hi all, hope I can learn a lot from this mailing list! _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus -- MySQL General Mailing List For list archives:

problem with mysql-crashes

2003-07-23 Thread thomas-lists
Hey folks, before posting to the bugs-list I would like to try it here to get some help :). Every now and then MySQL-4.0.13 crashes on my Dual-Athlon-MP-machine. Its not reproducible nor I know a query which does it. (The log shows that at the end, so no query :-( : Trying to get some variables.

Re: selec using first letter

2003-07-23 Thread Michael Satterwhite
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wednesday 23 July 2003 03:59, W. Enserink wrote: hi all, i have this table filled with names. Does anybody know how I can write a select statement which selects all names starting with a certain letter in the alphabet or a strane sign like

Re: mysql_install_db crash

2003-07-23 Thread Doruk Fisek
Hi, Tue, 22 Jul 2003 18:15:59 -0700 (PDT) tarihinde MySQL [EMAIL PROTECTED] soyle yazdi: DF I am compiling MySQL 4.0.14 with GCC 3.2.3, Glibc 2.3.1 and Linux DF 2.4.21 on a x86. ... DF CFLAGS=-O2 -march=athlon CXX=gcc CXXFLAGS=-march=athlon -O2 DF-felide-constructors ./configure

Full-Text for InnoDB Unicode

2003-07-23 Thread Marek Lewczuk
As far I remember full-text doesn't work with utf-8. Anybody knows the estimated time when it will be supported ?? I next few months 4.1 version will be ready to use (I hope so...) and I wish to use utf-8 charsets, but very important issue is full-text search. I'm also curious with InnoDB support

MySQL on a website

2003-07-23 Thread Daniel Glenfield
Hi, I'd like to create a website with a MySQL database to store soccer players details like goals scroed for the season. I want to use it to update my fantasy soccer team through this season, does anyone know of a free host that provides MySQL? Or even better, does anyone have experience of

Re: Succeeded!!!Two Servers on Windows and ONE my.ini file

2003-07-23 Thread Primaria Falticeni
Hello, Your solution has succeeded. Thank you very much. All the servers are running well! Iulian Teodosiu, Economist/Analyst Programmer, Primaria Falticeni, Falticeni Town, Romania, Europe - Original Message - From: Primaria Falticeni [EMAIL PROTECTED] To: MySQL LIST [EMAIL

Re: MySQL on a website

2003-07-23 Thread awards
Hi, I doubt you will find free host for MySQL because you seem to use ASP, which is really not commun and i have not seen many host (paid host) provide ASP may be i have looked at the wrong place. Anyhow if you decide to use php then you will have more chance to find free host with MySQL, I

RE: Can run two versions of MySQL in Windows 2000?

2003-07-23 Thread Degan, George E, JR, MGSVC
I'm sorry, I'm very new at this. I only downloaded the live version last week. Where do I find the setting you are referring to? By attempt to run the servers, perhaps this is a correct answer to your question: I am only using this for learning purposes. I am hoping to attain new skills and

Re: MySQL on a website

2003-07-23 Thread Daniel Glenfield
For the database/ASP link I created on our intranet all I did was drop an Access database onto the server, and use the address in the ASP code (actually I didn't need to - it was all local). Can I not simply FTP upload the MySQL database to a regular website (that supports ASP) and access it

Contribution: dump_grants

2003-07-23 Thread Francesc Guasch
http://www.etsetb.upc.es/download/sources/dump_grants/ DESCRIPTION This tool dumps the permissions granted to the users of the MySQL database. It also could print a report of dangerous grants. USAGE Dump Grants will retrieve the permissions granted as sql commands and will store it in a flat

Database Admin

2003-07-23 Thread Ratmil Torres
Hi, I just installed MySQL. Does anybody know where to manage the databases, create, edit and delete tables? Thanks.

**Checking For Modified Rows**

2003-07-23 Thread Kevin Gale
Hi. I need to replicate data (approx. 10,000 records) from a mySQL database into a different (non mySQl) database automatically on a regular basis. I have no control over the mySQL server (apart from allowing ODBC access) so I cannot modify any tables or enable replication etc... My initial

update query using inner join on same table

2003-07-23 Thread Jonathan Patton
Hi, I have a query that runs in Microsoft Access against my mysql database just fine. It is: UPDATE discussion_categories AS discussion_categories_1 INNER JOIN discussion_categories ON discussion_categories_1.parent_1_text = discussion_categories.name SET discussion_categories_1.parent_1

Re: problem with mysql-crashes

2003-07-23 Thread Lenz Grimmer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Wed, 23 Jul 2003 [EMAIL PROTECTED] wrote: before posting to the bugs-list I would like to try it here to get some help :). Every now and then MySQL-4.0.13 crashes on my Dual-Athlon-MP-machine. Is that a self-compiled binary or one of

Re: Database Admin

2003-07-23 Thread Yves Goergen
there must be a binary called 'mysql' ('mysql.exe' on windows). call it, best from the computer where you have installed mysql on: mysql -uroot (if it's not in the PATH: /usr/local/mysql/bin/mysql (i think) or c:\programme\mysql\bin\mysql.exe) now you can enter SQL commands like CREATE

Re: MySQL on a website

2003-07-23 Thread Martin Gainty
get a broadband connection and host the website yourself Martin - Original Message - From: awards [EMAIL PROTECTED] To: Daniel Glenfield [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 4:23 AM Subject: Re: MySQL on a website Hi, I doubt you will find free host for

Re: problem with mysql-crashes

2003-07-23 Thread Thomas Seifert
Hi Lenz, thanks a lot for your reply! Is that a self-compiled binary or one of ours? It are the MySQL-4.0.13-MAX-RPMs from your site. Not very helpful. Does this occur under high load only? Yeah I know, otherwise I would have tried to generate a reproducible testcase with a given query or

Word index

2003-07-23 Thread Garon Jocelyn
I would like to know if there is a way of building an index on all the words of a column. We want to have an alphabetical search on all the words of a description of a product. So, how I treat this index when I change a part of the content of this specific column where I want a word index.

RE: Word index

2003-07-23 Thread Rob
Mysql column type of full text. Check the docs at http://www.mysql.com/doc/en/Fulltext_Search.html -Original Message- From: Garon Jocelyn [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 11:07 PM To: [EMAIL PROTECTED] Subject: Word index I would like to know if there is a way

Re: MySQL on a website

2003-07-23 Thread Daniel Glenfield
Thanks for your help everyone! From: Martin Gainty [EMAIL PROTECTED] To: awards [EMAIL PROTECTED], Daniel Glenfield [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: MySQL on a website Date: Wed, 23 Jul 2003 08:57:54 -0700 get a broadband connection and host the website yourself Martin -

Re: MySQL tables performance question

2003-07-23 Thread Brent Baisley
If you are going to be needing to add columns and/or tables, you should probably rethink your data model. I'm not sure what data you are tracking, but perhaps you can consolidate it a bit more. Make your columns into rows with a row type field. A simple example would be tracking phone numbers.

RE: update query using inner join on same table

2003-07-23 Thread Jonathan Patton
I answered my own question, this works for joining a table on itself and doing an update query: update discussion_categories discussion_categories1, discussion_categories set discussion_categories1.parent_1 = discussion_categories.category_id where

mysqldump isn't working anymore

2003-07-23 Thread Jake Johnson
Hello, I have been backing up my db with the mysql dump command and it no longer works. This is an example of the command I was running... mysqldump -u dbuser -p -C mydb out.sql but returns this -- MySQL dump 8.21 -- -- Host: localhostDatabase: mydb

How do I show column names in php?

2003-07-23 Thread Jake Johnson
I am using php and mysql and I want to show the column names. How do I go about doing this without hardcoding the headers in my php? Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid

Is it possible to protect MySQL database on a Win2k laptop?

2003-07-23 Thread mos
I want to put a MySQL 4.1 database on a Win2k laptop but the problem is it contains confidential client information. It has to be Window because applications accessing the database are written in Windows. The problem is laptops do get stolen quite often, even when running on someone's

Re: mysqldump isn't working anymore

2003-07-23 Thread gerald_clark
Did you try the -q option? Jake Johnson wrote: Hello, I have been backing up my db with the mysql dump command and it no longer works. This is an example of the command I was running... mysqldump -u dbuser -p -C mydb out.sql but returns this -- MySQL dump 8.21 -- -- Host: localhost

Re: Database Admin

2003-07-23 Thread Darian Johnson
There is a nice GUI on the MySQL site called MySQL Command Center. Follow this link http://www.mysql.com/products/mysqlcc/ Ratmil Torres [EMAIL PROTECTED] wrote:Hi, I just installed MySQL. Does anybody know where to manage the databases, create, edit and delete tables? Thanks.

Re: JDBC 3.08 nightly snapshot from 7/23/2003

2003-07-23 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Nils Valentin wrote: Hi MySQL Fans ;-), Is it possible that the 3.08 series allows to connect to 4.0.14 versions but not to the 4.1 alpha-versions ? I get belows error when tryig to connect from DbVisualizer which was working fine until a

symlink of tables

2003-07-23 Thread MD Raziuddin Haqqani
Hi, Is there any way to create a symlink of table in two different databases which belongs to the same user. It will be great help if I get the solution for above mention task. Regards, Haq

RE: What is a good benchmark?

2003-07-23 Thread Bryan Koenig
On my p4 2gig mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 |

Re: How do I show column names in php?

2003-07-23 Thread Yves Goergen
you want to show the column names of WHAT? if you want to get those of a previous SELECT..., there's a special function for that. here's some code from my mysql admin module: $fields = array(); while ($meta = mysql_fetch_field($result)) { array_push($fields, $meta-name); } if you want to

Re: update query using inner join on same table

2003-07-23 Thread Victoria Reznichenko
Jonathan Patton [EMAIL PROTECTED] wrote: I have a query that runs in Microsoft Access against my mysql database just fine. It is: UPDATE discussion_categories AS discussion_categories_1 INNER JOIN discussion_categories ON discussion_categories_1.parent_1_text =

Re: How do I show column names in php?

2003-07-23 Thread Jackson Miller
Try: $result = mysql_query(SHOW COLUMNS FROM table_name); while ($row = mysql_fetch_array($result)) { foreach ($row as $key=value) { echo $key = $value; } } -Jackson On Wednesday 23 July 2003 9:32, Jake Johnson wrote: I am using php and mysql and I want to show the column

RE: What is a good benchmark?

2003-07-23 Thread John Griffin
On my 1.8GHz p4 with 512Gig of RAM I get: mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 |

Re: What is a good benchmark?

2003-07-23 Thread Yves Goergen
Celeron 733 Windows 2000 MySQL 3.23.56-nt 1.63s 1.58s 1.58s Athlon 1GHz Debian 3 inside VMWare 3 (WinXP) MySQL 4.0.14 1.21s 1.22s 1.18s -yves -Ursprüngliche Nachricht- Von: Bryan Koenig [EMAIL PROTECTED] An: [EMAIL PROTECTED] Gesendet: Mittwoch, 23. Juli 2003 16:45 Betreff: RE:

RE: What is a good benchmark?

2003-07-23 Thread Hubbard, Dan
On my 2 * 2.8Ghz 2GB RAM, Redhat 8: mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 |

RE: What is a good benchmark?

2003-07-23 Thread John May
Xserve 1ghz - 1.08 sec G3 333mhz - 2.78 sec - John On my p4 2gig mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |

Re: What is a good benchmark?

2003-07-23 Thread Jim Dickenson
On my 1Ghz Mac PowerBook with 1GB RAM using version 4.0.13 with OS 10.2.6 mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |

Re: mysqldump isn't working anymore

2003-07-23 Thread Jake Johnson
Still the same problem, but I am still able to select from the DB using mysql. Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance

RES: What is a good benchmark?

2003-07-23 Thread julio
Hello Guys, I have Risc/AlphaServer ES40 with processor EV6 500mhz running RedHat 7.2/Mysql. Could you please send me Bench test ? I like to try tks, Julio -Mensagem original- De: Bryan Koenig [mailto:[EMAIL PROTECTED] Enviada em: quarta-feira, 23 de julho de 2003 11:46 Para: [EMAIL

Selecting Date Time field, difference in minutes

2003-07-23 Thread C.F. Scheidecker Antunes
Hello all, I wonder if is there any way to select from a table all the records which has a Date Field that is at least five minutes old? In other words, I have a table with a date field and I need to select all the records that are older than five minutes, has their date field updated before

Fwd: Mysql primary, foriegn and composite keys. Please advise

2003-07-23 Thread Girish Agarwal
Note: forwarded message attached. __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com---BeginMessage--- Hi All, I have a database consisting of 2 tables. patient_info ( Patient Information

RES: What is a good benchmark?

2003-07-23 Thread julio
Hello Guys, AlphaServer EV6 processor 500mhz/1Gm memory with Linux mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |

Didn't find any fields in table 't_table'???

2003-07-23 Thread Jake Johnson
How do I fix this error? My tables have data. Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts. -- MySQL General Mailing

Re: **Checking For Modified Rows**

2003-07-23 Thread James Moe
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 23 Jul 2003 13:27:53 +0100, Kevin Gale wrote: I need to replicate data (approx. 10,000 records) from a mySQL database into a different (non mySQl) database automatically on a regular basis. I have no control over the mySQL server (apart from

mysqlcc not coming up in Windows XP

2003-07-23 Thread Scott Pippin
I am trying to run MySQLcc(0.9.2) on Windows XP. When I try to bring it up I get an hourglass for a second, then nothing happens. Has anyone had similar issues or any ideas as to what could cause this? Thanks (mysql, query) Scott Pippin [EMAIL PROTECTED]

RE: Can run two versions of MySQL in Windows 2000?

2003-07-23 Thread Paul DuBois
At 6:32 -0500 7/23/03, Degan, George E, JR, MGSVC wrote: I'm sorry, I'm very new at this. I only downloaded the live version last week. Where do I find the setting you are referring to? By attempt to run the servers, perhaps this is a correct answer to your question: I am only using this for

Create Temporary Table

2003-07-23 Thread Russell R Snella
Hello, Mysql Version 4.0.11a-gamma When I try and run the following query create temporary table russ1 as select rcust.* from rcust; and I receive the error message: Error Code : 1044 Access denied for user: '[EMAIL PROTECTED]' to database 'customer' (0 ms taken) I can run the

Re: What is a good benchmark?

2003-07-23 Thread Chris Knipe
+--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (1.91 sec) PIII 850, with 1GB Ram. -

Re: RES: What is a good benchmark?

2003-07-23 Thread NTLUG
snip On my p4 2gig mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 |

Re: Bookmarks

2003-07-23 Thread Paul DuBois
At 8:45 +0500 7/23/03, Shahid M. Syed wrote: Hello Does any version (production or future) of mysql supports Bookmarks? What is Bookmark capability in a database context? Regards Shahid M. Syed Karachi, Pakistan http://members.tripod.com/shahid_syed -- Paul DuBois, Senior Technical Writer

EXPLAIN - Question..

2003-07-23 Thread Tom O'Neill \(MySQL User\)
Hello everyone. I have copied the results from and explain on a query that I want to use. And I am wondering if anyone could tell me if these results are bad or good? If everything below is coming up garbled for you I will basically I am using 7 tables and the rows for 6 of the seven are 1 and

RE: What is a good benchmark?

2003-07-23 Thread Mark Graves
On my P3 600MHz 256MB RAM, Redhat 8: 1 row in set (2.01 sec) Hubbard, Dan [EMAIL PROTECTED] 07/23/03 11:39AM On my 2 * 2.8Ghz 2GB RAM, Redhat 8: mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) |

RE: What is a good benchmark?

2003-07-23 Thread artem
personal Win98 Duron650 128MB Mysql 4.0.13 - 1.37 sec busy server Redhat 7.0 Celeron 333 380MB Mysql 3.23.54 - 3.11 sec -Original Message- From: Jake Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 5:34 PM To: Mysql Subject: What is a good benchmark? I ran

RE: What is a good benchmark?

2003-07-23 Thread Christopher Knight
1 row in set (0.54 sec) 2x Athlon2100 2GB Ram Linux 2.4.20 -Original Message- From: Jake Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 9:34 AM To: Mysql Subject: What is a good benchmark? I ran this benchmark on my pIII 500 and was wondering what everyone else was

RE: Database Admin

2003-07-23 Thread Freddie Sorensen
Ratmil Check out the free dbTools at http://www.dbtools.com.br/EN/ Freddie -Original Message- From: Ratmil Torres [mailto:[EMAIL PROTECTED] Sent: Mittwoch, 23. Juli 2003 14:22 To: [EMAIL PROTECTED] Hi, I just installed MySQL. Does anybody know where to manage the databases, create,

RE: Can run two versions of MySQL in Windows 2000?

2003-07-23 Thread Degan, George E, JR, MGSVC
SETUP Windows 2000, Version 5.0 (build 2195, Service Pack 2) (In case it matters, I have about 20 GB available on my 40GB hard drive and 192MB of RAM) SETTINGS Prior to attempting to put on the second server, I wasn't using any options, which was logging me in as [EMAIL PROTECTED] (or more

Re: What is a good benchmark?

2003-07-23 Thread Andrew Edwards
Is it me or do these dual athlons seem rather responsive! I use mySQL 4.0.13 running on FreeBSD 4.8. Pentium 4 2.8Ghz 2GB DDR400 1 row in set (0.7 sec) | (0.68 sec) | (0.68 sec) Andrew. - Original Message - From: Christopher Knight [EMAIL PROTECTED] To: Mysql [EMAIL PROTECTED] Sent:

Re: What is a good benchmark?

2003-07-23 Thread David Griffiths
Dual P3 933, 2 gig RAM, IDE RAID-5 +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (1.40

Difficult count query?

2003-07-23 Thread motorpsychkill
I have two tables: bc_post and bc_message. This is what I have so far: select bc_post.*, count(bc_message.message_to) responses from bc_post left join bc_message on bc_post.post_id = bc_message.message_topostid where bc_post.post_status = '1' and bc_post.user_id = '1' group by bc_post.post_id

RE: Difficult count query?--nevermind, I found the answer...

2003-07-23 Thread motorpsychkill
select bc_post.*, count(bc_message.message_to) responses from bc_post left join bc_message on bc_post.post_id = bc_message.message_topostid and bc_post.user_id = bc_message.message_to where bc_post.post_status = '1' and bc_post.user_id = '1' group by bc_post.post_id -Original Message-

RE: What is a good benchmark?

2003-07-23 Thread Andrew Braithwaite
I get the following on dual Athlon MP 1666MHz 1GB RAM which is 40% cpu loaded mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |

RE: What is a good benchmark?

2003-07-23 Thread Christopher Knight
Is it me or do these dual athlons seem rather responsive! Yay!! I win (so far... heh)! I ran it on one of our servers (not idle... running apache w/ CGIs and db calls ~ 140,000 scripts/day ) We are using as many tricks as we can. 0. mysql 4.0 binary from mysql.com 1. we set the

mysql stops processing

2003-07-23 Thread Joe Shear
Hi, Has anyone ever had any problems with MySQL w/ all InnoDB tables just stop processing queries? There doesn't seem to be any pattern to it, it happens at times of relatively high load (load avg of 4 on a dual proc) but the CPUs still have plenty of idle time, and the disks aren't maxing out.

Re-attaching DB to mysql

2003-07-23 Thread Henrik Schmiediche
Hello, I have a backup of a mysql v3.0.18 DB. I need to extract one of the DB's from that backup and place it into my current production v4.0.14 mysql DB. Can this be done? How? Sincerely, - Henrik -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

RE: Can run two versions of MySQL in Windows 2000?

2003-07-23 Thread Paul DuBois
At 13:01 -0500 7/23/03, Degan, George E, JR, MGSVC wrote: SETUP Windows 2000, Version 5.0 (build 2195, Service Pack 2) (In case it matters, I have about 20 GB available on my 40GB hard drive and 192MB of RAM) SETTINGS Prior to attempting to put on the second server, I wasn't using any options,

RE: mysql stops processing

2003-07-23 Thread Andrew Braithwaite
Hi, I don't know what type of applications are using your database but if I had to guess at the problem, I would guess that you have a very slow query which runs every now and again that is locking up certain tables/records causing all the other queries to queue up and eventually running out of

Re: What is a good benchmark?

2003-07-23 Thread Gustavo A. Baratto
I got disappointing results compared with the ones posted here:with a dual xeon 2Ghz, 2GB ram, freebsd 5.1, mysql mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) |

RE: Re-attaching DB to mysql

2003-07-23 Thread Andrew Braithwaite
Is the backup a mysqldump or a copy of the data files? Andrew -Original Message- From: Henrik Schmiediche [mailto:[EMAIL PROTECTED] Sent: Wednesday 23 July 2003 19:48 To: 'Mysql' Subject: Re-attaching DB to mysql Hello, I have a backup of a mysql v3.0.18 DB. I need to extract

RE: What is a good benchmark?

2003-07-23 Thread mos
At 01:45 PM 7/23/2003, you wrote: Is it me or do these dual athlons seem rather responsive! Yay!! I win (so far... heh)! Beat you by a nose. (Of course I had to run it 2 or 3 times to shave a couple hundreds of a second off the times)g A single P4 2.4 Ghz 1g RAM running MySQL 4.1.0 Alpha running

RE: Re-attaching DB to mysql

2003-07-23 Thread Henrik Schmiediche
Copy of the data files :-( - Henrik -Original Message- From: Andrew Braithwaite [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 2:04 PM To: 'Henrik Schmiediche'; 'Mysql' Subject: RE: Re-attaching DB to mysql Is the backup a mysqldump or a copy of the data files? Andrew

Is it necessary to compress tables?

2003-07-23 Thread Jim McAtee
Does MySQL automatically handle deleted row cleanup, or is it necessary to periodically do this manually for tables with a lot of deletions? If it's manual, what are the SQL commands to do this? Also, what happens when changes are made to a field definition? From, say, int to smallint, or

RE: Can run two versions of MySQL in Windows 2000?

2003-07-23 Thread Degan, George E, JR, MGSVC
My responses are parenthesied in the text below. -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 2:56 PM To: Degan, George E, JR, MGSVC Cc: [EMAIL PROTECTED] Subject: RE: Can run two versions of MySQL in Windows 2000? At 13:01 -0500

error loading mod_auth_mysql

2003-07-23 Thread Colin Prince
Hi All, I am running mysql-3.23.52 on OS X (10.2.6) and I'd like to install the mod_auth_mysql module for a job I'm working on that used it under a different platform. I compiled the module using: apxs -c -D APACHE1 -L/usr/local/mysql/lib/ -I/usr/include/mysql/ -lmysqlclient -lm -lz

RE: mysql stops processing

2003-07-23 Thread Joe Shear
hi, We're pretty careful about preventing that. Also, no queries are moving forward, no inserts, updates, or selects, even the ones on tables that are only a mixture of inserts and selects. joe On Wed, 2003-07-23 at 12:02, Andrew Braithwaite wrote: Hi, I don't know what type of

HELP WITH mySQL!!!

2003-07-23 Thread Michael C. Podlesny
UGHH HELP!! I need to write a sql statement that will take the data from my table and use it as column headers. For example, If I have a field named GoLiveDate and a field called Qty and a field called Cars: Cars | Qty | GoLiveDate == CarA | 5 | 7/21/2003 CarA | 10

Re: mysql stops processing

2003-07-23 Thread Heikki Tuuri
Joe, - Original Message - From: Joe Shear [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, July 23, 2003 10:40 PM Subject: RE: mysql stops processing hi, We're pretty careful about preventing that. Also, no queries are moving forward, no inserts, updates, or

RE: Re-attaching DB to mysql

2003-07-23 Thread Andrew Braithwaite
Hi, If that backup uses the old .ISD .ISM architecture then I would install an old version of MySQL, copy these files into the data dir of that installation and mysqldump them to a file ready for import into your new MySQL v4 install. I'm not aware of any scripts to just munge the old style

Re: mysql stops processing

2003-07-23 Thread Joe Shear
Unfortunately, we haven't been able to connect to the database because of the maxed out connections. This happens so fast that the maxed out connections is usually the first sign. I've been hesitant to start the monitor, since this has only been happening once every couple days. It's been

RE: Re-attaching DB to mysql

2003-07-23 Thread Henrik Schmiediche
Thanks for the reply. I started a mysql v3 on a new system with the old backup data directory and type: mysqldump -p henrik henrik.sql This dumps the DB? To restore, I move henrik.sql to the current 4.0.14 server and type: mysql -p henrik henrik.sql except it complains the DB does

RE: Re-attaching DB to mysql

2003-07-23 Thread Andrew Braithwaite
And from the MySQL docs: --clip MySQL Version 3.23 supports tables of the new MyISAM type and the old ISAM type. You don't have to convert your old tables to use these with Version 3.23. By default, all new tables will be created with type MyISAM (unless you start mysqld with the

large mysql/innodb databases

2003-07-23 Thread Joe Shear
I was wondering if anyone had any experience with setting up large and fairly high performance databases. We are looking at setting up databases with each machine having somewhere between 500 gigs and 2 terabytes along with a slave box and we'd like to backup everything to tape at a minimum of

Re: mysql stops processing

2003-07-23 Thread Heikki Tuuri
Joe, - Original Message - From: Joe Shear [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 11:03 PM Subject: Re: mysql stops processing Unfortunately, we haven't been able to connect to the database because of the maxed out

RE: Re-attaching DB to mysql

2003-07-23 Thread Andrew Braithwaite
The mysqldump you use doesn't include the create databease so you'll need to create the henrik DB on the new install. If you keep running it over and over, it will keep inserting the same records over and over again and you'll end up with duplicates. The thing to do is start with an empty db (call

Re: mysql stops processing

2003-07-23 Thread Joe Shear
On Wed, 2003-07-23 at 13:11, Heikki Tuuri wrote: Joe, - Original Message - From: Joe Shear [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 11:03 PM Subject: Re: mysql stops processing Unfortunately, we haven't been

RE: mysql stops processing

2003-07-23 Thread Andrew Braithwaite
Hi, I believe that MySQL v4 has a superuser privilege level that keeps a connection available even when the regular connections are all used up just for diagnosis/killing etc... May want to try that to get your processlist too. Cheers, Andrew -Original Message- From: Joe Shear

Re: mysql stops processing

2003-07-23 Thread Heikki Tuuri
Joe, - Original Message - From: Joe Shear [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 11:23 PM Subject: Re: mysql stops processing On Wed, 2003-07-23 at 13:11, Heikki Tuuri wrote: Joe, - Original Message -

Re: large mysql/innodb databases

2003-07-23 Thread mos
At 03:08 PM 7/23/2003, you wrote: I was wondering if anyone had any experience with setting up large and fairly high performance databases. We are looking at setting up databases with each machine having somewhere between 500 gigs and 2 terabytes along with a slave box and we'd like to backup

RE: large mysql/innodb databases

2003-07-23 Thread Andrew Braithwaite
Hi, We have similar numbers here. A couple of questions: - are they logfiles that could be rolled over on a daily basis or are they constantly updated huge tables? - is the type of backup you want incremental or a daily/weekly snapshot one? - do you have a requirement for the speed of

Restrict UPDATE without WHERE

2003-07-23 Thread Mohammad Khan
Is there any way to restrict UPDATE without a WHERE clause? Mohammad Khan Software Engineer Legal Computer Solutions, Inc. 107 Union Wharf Boston, MA 02109 http://www.lextranet.com (617) 227-4469 x 212

Re: Didn't find any fields in table 't_table'???

2003-07-23 Thread gerald_clark
Jake Johnson wrote: How do I fix this error? My tables have data. But they probably are not owned by mysql. Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on

Master/Master Asynchronous replication

2003-07-23 Thread Joe Gainey
Currently we have a web based application that is mostly reads (4:1 r/w). It is using a single MySQL database server. Is there any way to have two database servers in a master/master configuration such that writes to either database server are replicated to eachother. Basically even

RE: large mysql/innodb databases

2003-07-23 Thread Joe Shear
The data is constantly updated. There are 3 or 4 huge tables, and several smaller tables. We would love to have an incremental solution that is *guaranteed* to be correct, but we haven't found a way to do that, so what we've been thing is we'd do a complete snapshot once a week, and do

  1   2   >