Re: Error

> Hi, > > Could somebody tell me what is this? > > SQL select * from users limit 0,25 failed : Got error 127 from table handler > > TIA > > Alex http://www.mysql.com/doc/manual.php?search_query=Got+error+127+from+table+ha ndler&submit=Search&depth=0 jason

Re: How to use JOINS

On Wed, Sep 12, 2001 at 02:13:59AM -0500, Deryck Henson wrote: > > OK, well, mysql has LEFT JOINS, right? OK then, in that case, how > the heck do I use them?! I need to join 14 tables (with the exact > same structure, columns) together and view all of there contents > with a WHERE clause like t

Video game programming????

Hi I was just browsing thru the amazon.com site and just happened to read a customer review on the MySQL (other new riders) book by Paul DuBios and Michael Widenius. It has a wierd review from someone which says "I was extremely dissapointed to say the least. This book doesn't even begin to cove

mySQL on unix vs ODBC

Hi everyone ! We've got a problem: running mySQL on unix(sun) we connect a third party windows software over ODBC. All is nice until a windows path is stored in the db Trying to store "C:\Program Files\3p SW\" I find that it becomes "C:Program Files3p SW". Is it possible, by means of configura

RE: manual

>I have tryed to download the mysql manual.pdf but for some reason I cant. >Would >anyone be able to email me the pdf version? > >[EMAIL PROTECTED] Hi, I think it's around 3MB.. so if say 10 persons would mail it to you you'll get about 30MB in your mailbox.. If you're using M$ IE you might n

Re: Video game programming????

On Wed, Sep 12, 2001 at 01:31:59AM +0530, Nilesh Parmar wrote: > Hi > I was just browsing thru the amazon.com site and just happened to read a > customer review on the MySQL (other new riders) book by Paul DuBios and > Michael Widenius. > It has a wierd review from someone which says > "I was ex

Re: GEMINI Table Type

On Tue, Sep 11, 2001 at 03:29:00PM +0200, Henning Schroeder wrote: > At 11:03 11.09.01, you wrote: > > > does MYSQL.COM has a table type same as GEMINI ( GEMINI > > > >yes. MySQL contains support for BDB and InnoDB tables, that are > >transaction-safe. > > I don´t want to provoke any anger here,

RE: mySQL on unix vs ODBC

Thanks Will, to avoid further misunderstandings - the escape"feature" of backslash" is fully understood. The problem is that the 3d party sw or the myODBC doesn't understand that the inbound text SHOULD HAVE backslash but does exactly whats expected - escape the next char. What I'm asking is - i

OT: Seeking Active Functioning Israeli IRC Servers

Greetings: Sorry for the off-topic. All bookmarked .il irc servers are currently unavailable. If any on the list has an active .il IRC link it would be helpful. (Israeli BBS-es also useful) You can post anonymously from safeweb.com at http://www.dedserius.com/guestbook/ Best Regards, Van s

ERROR 1073: create InnoDB tables!

Hi, I tried create table specify "type=InnoDB". with the following script: >create table objects(uri blob not null, primary key uriIndex (uri(255)), classname blob) type=InnoDB; I'm getting the following error ERROR 1073: BLOB column 'uri' can't be used in key specification with the

MySQL on Mac OS X?

Has anyone had any experience of running MySQL on Mac OS X? If so, how have you found it - is it stable and non-buggy? Also, has anyone had any experience of using both MySQL *and* PHP together on Mac OS X? I would be very interested to hear anyone's thoughts on this, regards Paul

JOINS what is the difference in?

database,sql,query,table Hi, have been told to use joins and after reading the manual a bit I do not know what it is about. I have added couple of examples. Could anyone tell me what difference is in them if any? the MY: is what I have been using and SUGGESTED is what was offered to be inste

Re: Video game programming????

>It has a wierd review from someone which says >"I was extremely dissapointed to say the least. This book doesn't even begin >to cover **video game programming in mySQL**, not even the basics. In fact, >it doesn't cover **video game programming at all**. . blah blah ." >What's video game

Re: Video game programming????

>> I was just browsing thru the amazon.com site and just happened to read a >> customer review on the MySQL (other new riders) book by Paul DuBios and >> Michael Widenius. >Ah, the "Perl and MySQL for the Web" book, I imagine. No, Nilesh does mean the "MySQL" book by New Riders, the one with

Re: MySQL on Mac OS X?

I haven't run mysql personally on my OS X box yet but I do know of some who have and there seems to be a current problem with getting mysql to quit properly. I think that will be fixed with Mac OS X 10.1 which is coming out sometime this month. Other than that go to www.versiontracker.com and

high speed insertion required

Hi everyone~~ I have a program inserting data into myisam tables continuously by queries like "insert into table1 select * from table2". I need an insertion speed about 1,000 entries per second with the average entry length of about 50 bytes. But the actual speed of the insertion is only about

Unable to run Bench Tests...

Placed At : BOM Durga Prasad@SATYAM 09/12/2001 03:25 PM Hi all, I have just installed MySQL 3.23.42-1. using MySQL3.23.42-1.i386.rpm. OS: RH Linux 7.1 glibc:2.2.2.10 gcc: 2.96-81 perl: 5.6.0-12 When i try to install MySQL-bench-3.23.42-1.i386.rpm

Adding in character sets

Is there a way to add support for additional character sets to an existing mysql installation without recompiling? I am currently running mysql 3.23.32 if I do need to recompile should I get the source for 3.23.32 or should I already upgrade to 3.23.42? Thanks, David Suna [EMAIL PROTECTED] [E

RE: Video game programming????

database, sql, query, table database, sql, query, table (I hate 123box.co.uk) Im not gonna go into long discussions of game programming in here. But the reason most people dont use a database backend for most modern games is more a matter of speed than anything else. You cant get an average of

SUPPORT FOR UNICODE

Hi everyone, I am not a user of MYSQL yet, but shall be soon. I needed to know if MYSQL has begun to support UNICODE (UTF- 8) as rest of the RDBMS' have adopted it to meet the language needs of non-english countries. And I am just hoping that amongst so many MYSQL users probably some one wo

MySQL: Unable to save result set

Hello, Starting 2-3 days ago, when we or our users try to access some parts of our site we receive some PHP/SQL, as this: Warning: MySQL: Unable to save result set in /home/bestjobs/public_html/nb/insert_user.php on line 21 We did not change anything in the php scripta or database structure and

MySQL on Mac OS X?

Has anyone had any experience of running MySQL on Mac OS X? If so, how have you found it - is it stable and non-buggy? Also, has anyone had any experience of using both MySQL *and* PHP together on Mac OS X? I would be very interested to hear anyone's thoughts on this, regards Paul -- Paul Grov

Re: mySQL on unix vs ODBC

At 9:10 AM +0100 9/12/01, Peter Gad wrote: >Hi everyone ! > >We've got a problem: >running mySQL on unix(sun) we connect a third party >windows software over ODBC. All is nice until a windows path >is stored in the db > >Trying to store "C:\Program Files\3p SW\" > >I find that it becomes "C:Progra

Problem...

Placed At : BOM Durga Prasad@SATYAM 09/12/2001 05:10 PM Hi all, I have just installed MySQL 3.23.42-1. using MySQL3.23.42-1.i386.rpm. OS: RH Linux 7.1 glibc:2.2.2.10 gcc: 2.96-81 perl: 5.6.0-12 When i try to install MySQL-bench-3.23.42-1.i386.rpm

starting problems. . .

Hi there, I am currently using Slackware 8 (linux) and I have some problems. There is mysql package in the slackware installation, which I installed it but never manage to run it successfully. Everytime I type the following > safe_mysqld and I get the following message: > Starting mysqld dae

Re: How to use JOINS

Merges wont work because they dont allow inserts. But I'll check out UNION. Thanx - Deryck H - http://www.comp-u-exchange.com - Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "Deryck Henson" <[EMAIL PROTECTED]> Cc: "MySQL" <[EMAIL PROTECTED]> Sent: Wednesday, September

RE: starting problems. . .

> I am currently using Slackware 8 (linux) and I have some problems. There > is mysql package in the slackware installation, which I installed it but > never manage to run it successfully. Everytime I type the following > > safe_mysqld > and I get the following message: > > Starting mysqld da

RE: starting problems. . .

I presume that you did run the mysql_install_db first of all?? If so, then check the ownership of the directory where the database lives. This should be mysql:mysql. HAd the same problems till I resolved the ownership issue. Regards, Ian. > -Original Message- > From: Nikolaos Rasidakis

errors

dear all ! i get the following error when i try to insert some values from an application(jetspeed ) in my mysql db [Wed Sep 12 16:49:20 GMT+05:30 2001] -- ERROR -- Exception: java.lang.Error: Error in BasePeer.initTableSchema(TURBINE_USER): Cannot connect to MySQL server on localhost:3

Re: Video game programming????

At 1:31 AM +0530 9/12/01, Nilesh Parmar wrote: >Hi > I was just browsing thru the amazon.com site and just happened to read a >customer review on the MySQL (other new riders) book by Paul DuBios and >Michael Widenius. >It has a wierd review from someone which says >"I was extremely dissapointed

time of selecet statements

I have to measure the time of an select-query. How can i use the benchmark command for doing it? A simple benchmark(10,select field from tbl where key_field=condition) gives me an error. - Before posting, please check: h

Faster mysql

Hello, How I can make my mysql faster ? Can I compile it with special options ? Pozdrawiam, Marcin Pyla (o_ [ Marcin Pyla - Cubbi <[EMAIL PROTECTED]> | <<+ NetArt ISP +>> ] (/

RE: Faster mysql

Look and "making MySQL fly" The hard stuff is where to start. Raid 0 and lost of memory Then yes there are a few things that you can remove when compiling to make things faster depending what you need to do. And then theirs stuff to do in my.cnf Simon -Original Message- From:

RE: Faster mysql

On Wed, 12 Sep 2001, Simon Green wrote: > Look and "making MySQL fly" > The hard stuff is where to start. Raid 0 and lost of memory I used Raid 5 + 1 (hardware) and it gaves only 2 seconds faster... > Then yes there are a few things that you can remove when compiling to make > things faster dep

Understanding problem or bug?

I have 4 tables where the primary key is identical with the primary key of the other tables. Here's my strange result of two queries: select count(*) from tbl_a natural left join tbl_b natural left join tbl_c natural left join tbl_d where where tbl_c.field1=x and tbl_d.field2=y; Result: 7 matching

error 1064

Hi all: I'm trying to import the tables from the dump file via mysqldump testdb < exp and it complaints about the command in the export file: DROP TABLE IF EXISTS db; CREATE TABLE db ( Host char(60) NOT NULL default '', Db char(64) NOT NULL default '', User char(16) NOT NULL default '',

Re: error 1064

Gene Gurevich wrote: > Hi all: > > I'm trying to import the tables from the dump file > via > > mysqldump testdb < exp That should be: mysql testdb < exp > > and it complaints about the command in the export > file: > DROP TABLE IF EXISTS db; > CREATE TABLE db ( > Host char(60) NOT N

Re: error 1064

That's what I used : mysql testdb < exp. Sorry about the typo Gene --- Gerald Clark <[EMAIL PROTECTED]> wrote: > > > Gene Gurevich wrote: > > > Hi all: > > > > I'm trying to import the tables from the dump file > > via > > > > mysqldump testdb < exp > > That should be: > > mysql testdb

Re: starting problems. . .

I had similar problems with sue7.2 i finally got fed up and downloaded the most current binary distribution and followed directions. I am still trying to work out some issues but at least i have a working system XAPHS Chris Bolt wrote: > > > I am currently using Slackware 8 (linux) and I have so

RE: Faster mysql

Steps In Compiling MySQL Use the right compiler Use pgcc = Pentium optimzed gcc on Pentium Strip unnecessary parts Only use character sets you will use Skip BDB tables, replication if you don't need them compile MySQL without support for exceptions (as MySQL does not use C++ exceptions) Simon

Re: Faster mysql

Marcin wrote: >How I can make my mysql faster ? Can I compile it with special options? Check out section 5.5 of the manual. I found there's also some very useful information readily available in the file INSTALL-SOURCE* in the top level of the source directory. I'm not sure whether GCC v3.0 mig

Can't install and run on Windows 2000

Hi I have downloaded MySQL, carefully following the instructiopns in the documentation. I have tried to install it on a Compaq Armarda Laptop running windows 2000. It would appear that some corruption is taking place, even though I have not used a download accelerator. Microsoft Windows 2000 [V

mysql to oracle conversion

Hi. Is there a tool to convert a mysql database to oracle? thanks = __ Do You Yahoo!? Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com --

Re:error in sec index entry update

Brian, the error message means that you updated a secondary key of a row but InnoDB did not find the index entry in the secondary index. The bug may be due to an error in purge, insert buffer, or the buffer pool. I am currently running tests on this and studying it. Could you please run CHECK TA

Re:ERROR 1073: create InnoDB tables!

Hi! You can probably circumvent the problem by adding an extra VARCHAR column where you put the first 255 characters of the blob column. Or maybe you could generate an artificial primary key with auto-increment, for example? Regards, Heikki http://www.innodb.com >Hi, >I tried create table spec

Crash Recovery

I have a table with over 26 million records that experiences a high volume of traffic. Recently, query results became a little screwy; upon investigation it was found that the table and the index were fouled up. The results of an isamchk on the table yielded: Checking ISAM file: /usr8/hydrolo

Re: Problem with 3.23.42

Hi Devin, You need to look into serveral things. Did you run mysql_install_db? If there is an error file in /usr/local/var (it will be servername.domain.err ) read what it says in that file. See http://www.mysql.com/doc/P/o/Post-installation.html Sorry for the delay in responding we here in

Re: error in sec index entry update

Heikki, Here is the output from CHECK TABLE: mysql> check table roster; +--+---+--+--+ | Table| Op| Msg_type | Msg_text | +--+---+--+--+ | webassign.roster | check | status | OK | +--+

Can't get MySQL to use available memory (performance very slow)

Hi there, I'm having trouble configuring MySQL 3.23.36 running on a Sparc/SunOS 5.8 to use the available 1 gig of memory and was wondering if anyone might be able to help find a solution. /usr/ucb/ps -aux gives the stats: USER PID %CPU %MEM SZ RSS TT SSTART TIME COMMAND root

RE: FW: URGENTE - Replication...... - mySql

Sasha, I tried the bug script to send the bug, but didn't have time to go thru the problems (looking for X, then couldn't open on vi). Reading that script I thought I saw "support@.."so I went ahead and send to that list. I knew it was a "paid support" list, but I didn't have any question, only

Re: Can't get MySQL to use available memory (performance very slow)

In the last episode (Sep 12), Joe Kaiping said: > Hi there, > > I'm having trouble configuring MySQL 3.23.36 running on a Sparc/SunOS 5.8 to > use the available 1 gig of memory and was wondering if anyone might be able > to help find a solution. > > /usr/ucb/ps -aux gives the stats: > > USER

Re: error in sec index entry update

Brian, your table seems to get corrupt only temporarily. It suggests I have a bug in the interplay of UPDATE and purge. Probably no need to reimport the table. About keys: there is no need to define the same key as the primary key and a non-primary. Thus the key roster_ is unnecessary. Thanks

RE: Can't get MySQL to use available memory (performance very slow)

Thanks for the quick reply, Dan. The EXPLAIN SELECT for that SELECT outputs: mysql> EXPLAIN SELECT count(id) FROM ind WHERE cust=1 AND email<>''; +---+--+---+--+-+--++--- -+ | table | type | possible_keys | key | key_len | ref | rows | Extr

Copying from one table to another.

Hello, I'm new to MySQL, so forgive my ignorance. I'd like to copy data from one table to another. I have one table I've made from a filemaker database. And one that contains my main data. I want to update the main data from the Main file using the data from the filemaker file. Each row has a

Undefined symbol "strtoll"

I am getting some pretty odd errors from Mysqlit was running, hung up while importing data, and has been fried since. This is the exact error i am getting: # cd /usr/local/mysql # bin/mysqld /usr/libexec/ld-elf.so.1: bin/mysqld: Undefined symbol "strtoll" I would GREATLY appreciate any help

RE: Undefined symbol "strtoll"

Sorry...here is the rest of the info: uname -a= FreeBSD reviews.aspd.net 4.2-RELEASE FreeBSD 4.2-RELEASE #0: Tue Dec 26 18:38:27 GMT 2000 [EMAIL PROTECTED]:/usr/src/sys/compile/FLASH42 i386 ldd did not work, the system told me to use objdump -i

RE: Can't get MySQL to use available memory (performance very slow)

I believe the answer will be for you to create a single index on *just* the cust column. (I assume that a specific cust id occurs only once or a few times in the whole table.) This will allow MySQL to use that index to find the small set of records (quickly) where cust=1, then to screen the email

Re: Copying from one table to another.

I obviously dont know what the error message is but Update tbl1, tbl2 set tbl1.CategoryInTable1 = tbl2.CategoryInTable 2 where ^ |

What have i done? adding new db

Kevin: A database is, in some sense, a container for your tables. It sounds like you want to compose a new container. Thus, To list your databases (containers): mysql> show databases; ... it seems that the list should contain your dbb and mysql, probably also "test". To create a new database (co

Storing binary flags

Dear List, I need to store a set of flags in SQL, as in 20 true or false values. The logical choice seems to be the SET type, but does it use an index? The manual gives an examle where a set is queried with LIKE '%flag%'. That scares me a bit, because the table is going to contain hundredthous

Copying table V.2.0

Kevin thanks for your response. Here are the different errors for each SQl command I enter. Command: update tblSNLC,tblSNOrg set tblSNOrg.OrgSponsor1=tblSNLC.SponsorFull where tblSNOrg.OrgZip=tblSNLC.Zip; Error: Failed to execute SQL : SQL update tblSNLC,tblSNOrg set tblSNOrg.OrgSponsor1=tblSN

mysql++ compilation difficulties

Hi there, I'm experiencing problems with compiling my source that uses mysql++. It compiles ok but in the linking process it prints many warnings and it doesn't produce any output file. When I pass the -c flag to gcc to stop at linking, it looks ok cause it produces a .o file. I have gcc versio

print

I am having a hard time printing Select * from table_1 \p; the result is: -- Select * from table_1 -- . . . But it doesn't print. Anyone? - Before posting, please check

Re: print

At 2:14 PM -0400 9/12/01, Jeremy Morano wrote: >I am having a hard time printing > >Select * from table_1 \p; > > >the result is: > >-- >Select * from table_1 >-- > >. >. >. > >But it doesn't print. > >Anyone? Define what you mean by "print".

where is my binary log file

hi, i have a lamer question: where is my binary log file? i can't find it. i am sure it exists because grows crazy, when i restore a database from dumpfile. i found nothing about binary log in my.cnf. version: mysql 3.23.32-log install path: /usr/local (default) thanx, ati ---

Re: Copying table V.2.0

I think you need a new approach. It appears that update does not support the join you are attempting. It seems that you are trying to update the value for a column from one table with the value of a column from another table. If this is the case, i would use a shell script to first extract

Can someone please help with this?

I hope that someone can please tell me how to fix this. When I try to run IIS Im getting an error WMI ADAP was unable to load the w3ctrs.dll performance library due to an unknown problem within the library: 0x0 Thats just one of several. Im running win2k pro. I have installed PhP and MySQL ... An

Re: FW: URGENTE - Replication...... - mySql

On Wednesday 12 September 2001 10:36, Rodrigo Zerlotti wrote: > Sasha, > I tried the bug script to send the bug, but didn't have time to go thru > the problems (looking for X, then couldn't open on vi). Reading that script > I thought I saw "support@.."so I went ahead and send to that list. > >

Urgent Assistance

Hi group, I am in need of assistance with a database and php query we are trying to achieve. Basically we are have a form where one field searches a field in the mysql database and the other searches for keywords using the MATCH query. What we need to do is for the user to be able to enter a

Comparing Dates

I have a date comparison problem that I'm sure is simple enough but I'm just not experienced enough to figure it out. I simply want to grab every entry in a given table that has been entered within the last three days. I'm using Perl so I first start with a Perl timestamp and convert it to a MySQL

mysql 3.23.42 errors during compile on Solaris

Hi, when I compilling mysql that occur something error below on solaris. Soft Spc. Solaris 8 Mysql 3.23.42 gcc 3.0.1 GNU Make 3.79.1 My steps: gunzip -d -c mysql-3.23.4.tar.gz | tar xvf - cd mysql-3.23.42 CC=gcc CFLAGS="-O3" CXXLD=g++ \ CXX=gcc CXXFLAGS="-O3 -fe

Re: Comparing Dates

| not experienced enough to figure it out. I simply want to grab every entry | in a given table that has been entered within the last three days. select * from yourtable where datefield < date_sub(now(),interval 3 day); see mysql doc: http://www.mysql.com/doc/D/a/Date_and_time_functions.html at

Re: Comparing Dates

>I have a date comparison problem that I'm sure is simple enough but I'm just >not experienced enough to figure it out. I simply want to grab every entry Um. First of all, better code would be: my @now = localtime( ); $now[5] += 1900; $now[4] += 1; $currenttime = sprintf( '%04d%02d%02d%02d%02d%

Re: MySQL: Unable to save result set

That error message is coming from PHP, not from MySQL. PHP generates that error message when, for some reason, the number of fields returned by a MySQL query was greater than zero, but the return from mysql_store_result() or mysql_use_result() was zero or NULL. The PHP code which checks those va

RE: Urgent Assistance

Quite simple: in the PHP script that is called upon submission, you check which field is filled in, and then do your select... the if-then-else statement does not belong into the SQL, but rather in the program querying your database, since that has the business logix... Cheers, Guus > -Orig

mysql install failed on FreeBSD!!

Hi, I am pretty new to mysql and started installing it on freeBSD from usr/ports/. I got the following error. Can somebody help me why it is failing. thanks, siva ===> Installing for mysql-server-3.23.36 ===> mysql-server-3.23.36 depends on executable: mysql - not found ===>Ve

Table Mysqld host doesnt exist

I installed MYSQL on a HPUX 11 machine and I ran the "mysql-test-run" script and everything passed, but when I start mysql up using "bin/safe_mysqld" or "bin/safe_mysql --user=mysql &" I receive this error in the logfile Table 'mysqld.host' doesn't exist Any solutions -- #

Re: mysql to oracle conversion

At 8:31 AM -0700 9/12/01, Gene Gurevich wrote: >Hi. > >Is there a tool to convert a mysql database to oracle? > >thanks Check the Oracle web site. -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www

Renaming Columns...

How??? ALTER TABLE table1 RENAME ??? Tried it, dont work. - Deryck H - http://www.comp-u-exchange.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the l

Re: MySQL on Mac OS X?

At 10:03 AM +0100 9/12/01, Paul Groves wrote: >Has anyone had any experience of running MySQL on Mac OS X? If so, how have >you found it - is it stable and non-buggy? Also, has anyone had any >experience of using both MySQL *and* PHP together on Mac OS X? I would be >very interested to hear anyon

Re: Renaming Columns...

>How??? ALTER TABLE table1 RENAME ??? >Tried it, dont work. That renames the table itself. ALTER TABLE tbl_name CHANGE old_name new_name column_definition where column_definition is how you defined the column when you created it. For example if you have a table CREATE TABLE xyz ( c CHAR(

SV: Renaming Columns...

Rename is for Tables (I think ...I am fresh, too. So fresh that I send it to you privatly. Sorry about that!) ALTER TABLE table1 CHANGE column1 coloum2 varchar(20) not null [or what ever datatype]; gives you what you want. Ann - Original Message - From: Deryck Henson <[EMAI

Error Message: Impossible WHERE clause noticed after reading consttables

I have a table with several fields, the primary key is a CHAR(11) field that does NOT allow NULL values. This field is called rec_key. Now, when I attempt to run the following query: SELECT * FROM table_name WHERE rec_key LIKE 'key_value' it returns NO data.. If I drop EXPLAIN in front of it

Size of DB

Hello, I'm new to MySQL and I was wondering if there was a command that you can issue to see the current size of a mysql database (in kb or MB)? = 'Toine - Before posting, please check: http://www.mysql.com/manual.php (the

MySQL getting backlogged

Right now MySQL is getting really backlogged but I have no idea why. There are 169 concurrently running queries, and 153 of them are in show the status as "Opening tables". A processlist looks something like this (formatted by Status, Seconds query has been running, and query): Opening tables

Designing a recovery plan for MySQL

I got an idea and thought i would ask around about a recovery plan about databases? Currently all i do is dump the databases on to a share on an NT box thru a SMB share from the RH 7.1 Linux DB server. The NT box is a Compaq CL1850 which is 2 Compaq 1850 server with a shared SCSI array. The NT box

mysql@lists.mysql.com

>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category: mysql >Class: >Release:

mysql@lists.mysql.com

>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category: mysql >Class: >Release:

SQL Expert Needed

Hi Guys, here goes.. SELECT count(page_searchwords.word_id) as score, page_data.id, filename, title FROM page_data, pagewords, page_searchwords WHERE (page_searchwords.media_type='static' AND pagewords.id = page_searchwords.word_id AND page_data.id = page_searchwords.id AND LCASE(pagewords.wo

Re: Designing a recovery plan for MySQL

In the last episode (Sep 12), adam said: > I got an idea and thought i would ask around about a recovery plan > about databases? Currently all i do is dump the databases on to a > share on an NT box thru a SMB share from the RH 7.1 Linux DB server. > The NT box is a Compaq CL1850 which is 2 Compaq

Re: my.cnf optimization question ..

On Tue, Sep 11, 2001 at 03:17:47PM -0500, Weslee Bilodeau wrote: > > > They average around 500 connections/second at any given time, two > > > have a master/slave setup. > > > > Connections/sec or Queries/sec? That's a lot of connections per > > second? Can you use persistent connections? It wo

Re: Let's approach stored procedures

On Tue, 11 Sep 2001, Arnulf Kristiansen wrote: | I have just started to look into the stored procedure issue. We will come up with a | definite plan within a short period of time. But does this mean that you won't welcome any other initiative or ideas from other programmers? | | It is true that

Re: Let's approach stored procedures

newbie DB developer question Are stored procedures scripts or compiled code ? James - Original Message - From: "Endre Stølsvik" <[EMAIL PROTECTED]> To: "Arnulf Kristiansen" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, September 13, 2001 5:09 PM Subject: Re: Let's approach s