Gary
Does your php code use persistent connections?
mysql_pconnect() rather than mysql_connect() ?
If so, that would ramp up the CPU usage fairly quickly, AFAIAA.
Just a thought
Terry
--Original Message-
Hi all
Is there anybody out there who has managed to successfully
Dan
What you may be looking for (and I had to hunt around to find it myself!)
is
myisamchk -eis table_name
Hope that helps - just because you don't get an answer doesn't mean we
don't care - it probably means we don't know.
Terry
--Original Message-
Ok
From the manual:
REPLACE(str,from_str,to_str)
Returns the string str with all occurrences of the string from_str replaced
by
the string to_str:
mysql SELECT REPLACE('www.mysql.com', 'w', 'Ww');
- 'WwWwWw.mysql.com'
This function is multi-byte safe.
Terry Spencer
Haigh Consultancy Services
+44
As far as I'm aware, in php you can only do one statement per call.
Terry
--Original Message-
Hi there,
When i try to do the following in PHP I get errors. Is this not
permitted or is this due to a setting somewhere? Can i do only one SQL
statement per call
.
With the help of EXPLAIN, you can see when you must add indexes to tables to
get a faster SELECT that uses indexes to find the records.
http://www.mysql.com/doc/en/EXPLAIN.html
Terry Spencer
Haigh Consultancy Services
+44 (0)2073007329
www.haigh-cs.co.uk
-Original Message-
From: Paul
. it happens even on freebsd 5.0
regards,
terry
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
this error?
Thanks
Terry
Terry Spencer
Haigh Consultancy Services
+44 (0)2073007329
www.haigh-cs.co.uk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
anti-virus system (http://www.grisoft.com).Version: 6.0.491 / Virus
Database: 290 - Release Date: 18/6/2003
Terry
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
found, so why not?
Cheers
Terry
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Yes
--Original Message-
Hi,
I have written a program that creates statments for me, and sometimes I
end
with
SELECT..WHERE number IN(1)
instead of
SELECT... WHERE number IN(1,2,3,4)
would number IN(1) works,
for the moment i have no mean to test it, it is why
Vielen Dank, Mark
Cheers
Terry
--Original Message-
Use source filename from the mysql command line
Start mysql in the bin directory, switch to the db in use via use
dbname
and run the command source path_to_filefilename
Or read the manual section 3.6 Using mysql
, ends with
a 'SQL query error' or similar.
Help, please, I'm not used to this command-line stuff!
Terry Riley
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
, none of these appear. Is this normal?
I had some neat things going on a navigation bar using $REQUEST_URI, but
now can't use them.
If I'm on the wrong list with this, please forgive me.
Cheers
Terry
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
, but you may have to do two
separate queries for this - one to determine the row count, then another
two-parter, using your random number in the first SQL (LIMIT) statement,
with a UNION SQL statement to a similar query for the rest.
Does that help?
Terry
--
MySQL General Mailing List
For list
Scott
--Original Message-
What would be the most efficient query to determine the number of rows?
Probably something like
SELECT COUNT(*) AS rectotal FROM table ?
Cheers
Terry
PS - better to reply direct to list rather than individual, as you seem to
have done
Great!Didn't know you could do that.
Cheers
Terry
--Original Message-
I think I found another answer to my own question. FYI a good way to
return
results in a random order
SELECT user FROM table ORDER BY RAND()
--
MySQL General Mailing List
For list archives
can locate documentation on the constraints on referring to the target
table in the FROM clause. Can anyone point me to any?
In my example the rows the select is the select are not being updated. Is
there anyways to perform this type of statement?
Thanks.
Terry
--
MySQL General Mailing List
appreciated.
Im using 4.1.
Thanks
Terry
-Original Message-
From: Mike Hillyer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 28, 2003 2:53 PM
To: Terry Spencer; [EMAIL PROTECTED]
Subject: RE: Update in select
Subqueries are only available in MySQL 4.1. However, you should be able
to write
Hi, I have a question. I know that the code in libmysqld is for the
http://www.mysql.com/doc/en/libmysqld.html Embedded MySQL Server
Library.
Would anyone mind to direct me where I can find what the folder libmysql
and libmysql_r for?
Thanks
Terry
or any book that will talk about
the C code of the MySQL(not the query language). In other word, are there
any resourse that I can find that give me an overview of the files in MySQL?
Thank you so much
Sincerely
Terry
_
Protect
-D_THREAD_SAFE -I/usr/local/include/pthread/linuxthreads -L/usr/local/lib -llthre
ad -llgcc_r'
of course alter those to match your paths etc
it should help
regards,
terry
SQL
-Original Message-
From: Sumit Mittal [mailto:[EMAIL PROTECTED]
Sent: Friday, March 14, 2003 5:10 AM
Is there a webpage or something I can read about creating a script that can be ran
from mysql prompt with the ./ . My script doesn't seem to work, even though
it looks like legal sql to me. I am running this under win98.
Terry
Is there an easy way to see If and how much data I have written into a blob?
sql...tomakefilterhappy
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
MyODBC works fine,
but what to do if you have hundreds of tables?=20
its painful job, maybe theres some
easier way to do that ?
regards,
terry
sql
-
Before posting, please check:
http://www.mysql.com/manual.php
be possibly wrong with the query?
how can i make it work in mysql ?
thanx in advance,
terry
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
I dont know why it happens,
bu i found that using connect() instead of pconnect()
solves the problem till its fixed
regards,
terry
SQL
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
I want to give read access to all users on the localhost for a specific mysql table, I
have tried the following:
grant select on database.table to %@localhost;
grant select on database.table to %@localhost;
grant select on database.table to @localhost;
None seem to work, what is the correct
?
Terry
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL
.
they all start but do not accept incoming connections.
please help,
terry
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
?)
*Updated the /usr/local/etc/dbxdrivers.conf with
libraryname=libsqlmy23.so.1
Now when I try to connect to the msql server I get a Unable to load
libsqlmy23.so.1. Did I do something wrong? Did I skip a step?
Terry
to no avail.
what else can i do to debug the problem or resolve the issue ?
regards,
terry
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
Setup a user level my.cnf file and make sure the data dir isn't overriden by
the other levels of my.cnf
Just a theory, I haven't tested it !
-Original Message-
From: Info [mailto:[EMAIL PROTECTED]]
Sent: 11 July 2002 15:17
To: [EMAIL PROTECTED]
Subject: Re: creating database
sql,query
some other stuff.
If zombie processes stay in the process list for a long time,
then you have a problem probably with parent process.
Someone correct me if I'm wrong.
Regards,
Terry
-
Before posting, please check:
http
If the OS is the same on each server (including patches just to make sure)
and the MySQL version is the same, then yes, you can simply copy the data
directories from one server to another
Make sure you FLUSH everything first and take MySQL off-line.
-Original Message-
From: Todd Cary
I'm in the UK and I can get to it okay !!!
Perhaps something has changed on your PC/Network ???
-Original Message-
From: Peter Lovatt [mailto:[EMAIL PROTECTED]]
Sent: 02 July 2002 10:45
To: [EMAIL PROTECTED]
Subject: RE: fulltext searching
Hi
If anybody from mysql is listening /
Yes, I agree sub-queries should be the highest priority with the next
release judging from the e-mails going around at the moment.
This was the first problem I found in my first day using MySQL. I don't
understand with all the versions that have been released of MySQL since 1996
why they
! i can make linux either master or slave with no
problems at all.
this is really strange...
regards,
terry
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
? ...
regards,
terry
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL
sources:
/opt/mysql/libexec/mysqld, Version: 3.23.49-log, started with:
Tcp port: 3306 Unix socket: /tmp/mysql.sock
2 win2k machines: mysql installed by installer:
MySql, Version: 3.23.49-max-debug-log, started with:
Tcp port: 3306 Unix socket: /tmp/mysql.sock
best regards,
terry
| error| 0 when updateing keyfile |
| gbook.ksiegi | check | error| Corrupt |
+--+---+--+--+
2 rows in set (0.01 sec)
what can i do about it ?
thanks in advance,
terry
Hello all,
Are there any system_table which I can to do a pure SELECT command to get the same
results that MySql SHOW command, in the same way that Oracle DB ?
Thanks..
-
Before posting, please check:
from server, apparent
master shutdown: (0)
what am i doing possible wrong ?
please help,
terry
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
hi,
i have mysql compiled with cygwin with gcc version 2.95.3
you can fetch installed version from
http://www3.ibt.com.pl/mysql.tar.gz
it is prepared to be installed in /opt in cygwin's directory structure
best regards,
terry
-Original Message-
From: Yegor N. Bryukhov [mailto
Hello all,
I am testing MySql Max 4.0.1 alpha. I have configured innodb tablespace and created
the two manual tables example.
But when I try to do a mysqldump to re-create the tables on another DB or 'SHOW CREATE
TABLE child', NO-FOREIGN key information is gathered on results.
However 'SHOW
data recovery
with update logs and repair scripts. Can you please direct me to the
URL (s) where that information is housed.
Thank you for any assistance you can provide.
TGW
--
Terry Westry
Computer Consultant I, Architecture
Information Technology Telecommunications
Fort IRC Building
First, if there is an FAQ or installation documentation please direct me
there and I'll review before requesting assistance.
If there is neither, I am unable to successfully run mysqlgui on the
following platform: Sun Ultra 10 running Solaris 8 with current
Recommended installed, mysql version
What does this error mean?? Any help would be appreciated
!--database mysql query relational--
Terry Shipclark
Technical Support Representitave/Cati Operator
[EMAIL PROTECTED]
tel. 416-445-9800 ext 2093
www.bbm.ca
database,sql,query
Why does this statement not work
LOAD DATA INFILE 'intervext.txt' into table intvext
(intid,priphone,cellphone,pager,bdmonth,bdday,datehired,Notes)
FIELDS TERMINATED BY ';'
ENCLOSED BY ''
LINES TERMINATED BY '\n';
I also tried it like this
that my_int=21.3 isn't correct in some
cases and I should at least get a warning and even better be able
to force MySQL to reject this as incorrect.
TIA
--
=
Terry Gliedt [EMAIL PROTECTED] http://www.hps.com/~tpg/
Biostatistics
authors) ..
Still stuck .. :-/
Thanks,
Terry
-Original Message-
From: Rene Tegel [mailto:[EMAIL PROTECTED]]
Sent: Saturday, April 28, 2001 6:36 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL (3.23) connection bombardment question ..
just realised it:
another
boxes work out fine ...
-Terry
Hi,
I have a problem, my database has reached Linux Redhat 7.1
max file size. (2147483647 Bytes). Does eny one know what i
can do to make a lager database. (lager
filesystem)
Thanks
Erik Dhiin
(incase the local raid, which is a year or so old is too slow .. )
Any ideas?
Thanks,
Terry Katz
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
On Sun, 22 Apr 2001, Sinisa Milivojevic wrote:
Wm Terry writes:
I seem to have a problem similar to others, but none of the suggested
solutions seem to solve it. It's the standard "undefined reference to
`compress'" while using MySQL++. What am I missing. Many solution
I solved my own problem. A simple switch in the order of the libraries
listed in the link command did the trick.
gcc -static metamgrd.o sock.o cfgfile.o cfgitem.o err.o -o ./metamgrd \
-lstdc++ -L/usr/lib/mysql -lmysqlclient -lz -lsqlplus
On Sun, 22 Apr 2001, William Dan Terry wrote:
On Sun
I seem to have a problem similar to others, but none of the suggested
solutions seem to solve it. It's the standard "undefined reference to
`compress'" while using MySQL++. What am I missing. Many solutions
appear to address libmysqlclient. So I'm not sure if the problem is
MySQL or MySQL++
I know that www.yahoo.com uses it somewhere... but I can't remember where I read that
(probably on this list a while ago)
- Original Message -
From: "Anthony R. J. Ball" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, March 30, 2001 12:48 PM
Subject: Need examples of companies
I cannot get F1 to show any help on the main display. I cannot even
determine why it does not. I have the help_file set in every variation
of .cnf .ini and .opt file I can find. No luck.
What is correct way to get help to be useable?
TIA,
W. Terry Lincoln
Senior Engineer/Consultant
100
file via ftp
so she can do it. Any help would be really appreciated!!! Let me know if
i need to provide more info...
Thanks,
Terry
Does anybody know if this amount of memory usage is normal? (taken from *top*)
PID USER PRI NI SIZE SWAP RSS SHARE LC STAT %CPU %MEM TIME COMMAND
677 root 90 19228 0 18M 15801S 0.0
2.1 0:07 mysqld
679 root 9
??? I d/l mysql-3.23.34-pc-linux-gnu-i686.tar.gz any
ideas what i've done wrong???
Thanks very much,
terry
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
as always. But at least now I am confused on a higher level!
Terry
--
__
Terry Babbey
Technical Support Specialist
Lambton College, Sarnia, Ontario, Canada
I notice some of you compile with gcc as you C-compiler (CC) and
C++-compiler (CXX). Configure generates an error message for me when I
try to do this. Can anyone help me with this?
Thanks,
Terry
--
__
Terry Babbey
Technical Support
ons.
gnumake[3]: *** [sql_acl.o] Error 1
gnumake[3]: Leaving directory `/usr/local/mysql/mysql-3.23.33/sql'
gnumake[2]: *** [all-recursive] Error 1
gnumake[2]: Leaving directory `/usr/local/mysql/mysql-3.23.33/sql'
gnumake[1]: *** [all-recursive] Error 1
Peter Pentchev wrote:
On Fri, Mar 02
That should help.
!! I strongly suggest you use gnu "make" and use the "--with-low-memory"
option. I have a sun UltraSparcII with dual CPU's and 512MB RAM that still
couldn't manage to compile the sql_yacc.cc
Good luck!!
Terry Babbey wrote:
Here is my config
149: checking for unistd.h
configure:8188: checking for getpagesize
configure:8216: gcc -o conftest -O6 -DDBUG_OFF conftest.c -lm
-lpthread -lmach -lexc 15
configure:8241: checking for working mmap
configure:8389: gcc -o conftest -O6 -DDBUG_OFF conftest.c -lm
-l
A mistake I made for a long time with MATCH AGAINST is to not include it in the WHERE
clause
eg I did
SELECT ID,MATCH Q,A AGAINST ("This") AS Score FROM faq
instead of
SELECT ID,MATCH Q,A AGAINST ("This") AS Score FROM faq WHERE MATCH Q,A AGAINST ("This")
The latter will give much better
-
From: "Noor Dawod" [EMAIL PROTECTED]
To: "Jason Terry" [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, February 13, 2001 9:23 AM
Subject: RE: TEXT's are giving us headaches!
Hi
Hmm, this seems to me like redundant code.. if you're holding info in
Score, and not usi
Just a side note... you can do JOINs on tables from different databases on the same
mySQL server
eg
SELECT t1.UserName FROM db1.table AS t1, db2.anothertable AS t2 WHERE t1.UserName =
t2.UserName
As for database layout... I would go with what makes the most sense... If having 84
tables in
I have a need for a SELECT query...
I don't really want any of the data from the select...
Rather I need the size of the data
basically I need
SELECT sum(length(*)) FROM MyDB WHERE MyDB.Something LIKE 'this%'
-
Before
101 - 169 of 169 matches
Mail list logo