Hello Everyone
I have been using MySQL on Linux for over two years and am a devoted fan. I
have been using MySQL for very ordinary applications till now.
Now there may be a requirement that we need to build an enterprise
application running on MySQL. The application must be very reliable, very
Hi all,
anyone knows a good method to retrieve 1 random selevted record out of
thouseands?
right now I'm using
select ID from table ORDER BY rand() LIMIT 1
however, this seems like a very slow method, like mysql first organizes a
few thousand records in a random 1 and only returns 1
Any
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
(http://www.ezmlm.org)
Date: Thu, 19 Sep 2002 08:46:10 + (UTC)
From: Chris [EMAIL PROTECTED]
X-X-Sender: [EMAIL PROTECTED]
- Machine A has a crontab running to check the network status every
second. When the network
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
(http://www.ezmlm.org)
X-Sender: [EMAIL PROTECTED]@teton.kitebird.com
Date: Thu, 19 Sep 2002 08:54:55 -0500
From: Paul DuBois [EMAIL PROTECTED]
News-Group: list.mysql
Reply-To: [EMAIL PROTECTED]
At 20:47 -0500 9/18/02,
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
(http://www.ezmlm.org)
From: Iago Sineiro [EMAIL PROTECTED]
Date: Thu, 19 Sep 2002 11:41:15 +0200
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.
Importance:
...
The problem characters are the ASCII backslash and the ASCII tilde -
Good to know, I will eliminate those, although there are still many more
problem characters.
Well, actually, the one-byte backslash and tilde you can leave alone.
They survive intact, they just display differently over
Hi all,
How should i compile a simple MySQL++ file? I tried to
compile simple1.cc file provided in the examples
directory in mysql++-1.7.9. But i failed.
All the *.hh files that will be created when you do
make install are there in mysql++-1.7.9/MYLIB/lib
and mysql++-1.7.9/MYLIB/include
Please tell me how can I get the date and time values
diffently in a single query from 'DateTime' field
and the difference of two DateTime fields in HH:MM:SS
format.
Thanks
shahana
__
Do you Yahoo!?
New DSL Internet Access from SBC Yahoo!
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
(http://www.ezmlm.org)
From: W. Enserink [EMAIL PROTECTED]
Date: Fri, 20 Sep 2002 09:08:53 +0200
anyone knows a good method to retrieve 1 random selevted record out of
thouseands?
right now I'm using
select ID from
Hello mysql Team
I apologise for sending you an error report in this form but the Ultra
SUN on which I tried to compile the mysql database
dose not have (as far as I know) a configured smtp.
So I copied the output of mysql_bug to this e-mail and hoping to deliver
you all the neccessary
Please help me repair table:
___
| |
CREATE TABLE `zinutes` (
`hid` int(10) unsigned NOT NULL default '0',
`tipas` int(10) unsigned NOT NULL default '0',
`msg` text NOT NULL,
Please help me REPAIR TABLE:
___
| |
CREATE TABLE `zinutes` (
`hid` int(10) unsigned NOT NULL default '0',
`tipas` int(10) unsigned NOT NULL default '0',
`msg` text NOT NULL,
I have a message board app I'm using where I'm trying to make the code
faster and more efficient than it is now. At times this board will
generate a lot of new posts to it very very quickly. In one section where
posts are added, after the post is made and inserted into mysql, we need to
get the
i'm sure mysql4.x have wrong algorithm to escape/unescape multibyte chars
a multibyte is escaped while server read it, it maybe a pair of single byte
or a pair of single byte escaped while server read it, it appears as
multibyte
both of these two situation make server unescape incorrectly
i've
Hi
Try
create table tmp_zinutes select * from zinutes;
alter table tmp_zinutes add primary key (id), key hid(hid));
if tmp_zinutes has all rows, then
drop table zinutes;
rename table tmp_zinutes to zinutes;
Be carefull, DO NOT DROP TABLE zinutes unless all data has successfully copied
to
Hi Xuefer,
What are you talking about? A lot of people are using MySQL without any
problems with multibyte characters. Please post a reference URL, with
perhaps a detailed explanation of the problem -- you mentioned you have
brought this to the attention of people already, please post a relevant
Hi!
Shravan Durvasula wrote:
Hi all,
How should i compile a simple MySQL++ file? I tried to
compile simple1.cc file provided in the examples
directory in mysql++-1.7.9. But i failed.
All the *.hh files that will be created when you do
make install are there in mysql++-1.7.9/MYLIB/lib
and
At 9/20/2002, you wrote:
Please help me REPAIR TABLE:
___
| |
CREATE TABLE `zinutes` (
`hid` int(10) unsigned NOT NULL default '0',
`tipas` int(10) unsigned NOT NULL default
Hello,
I have installed MySQL on a PC with Windows NT. As the
MySQL dir is not on c:, I have copied the 'mysql.ini'
file to c:, and I have edited it to MySQL work with
InnoDB tables. All was working fine, but this morning,
when I have tried to startup MySQL with the command
mysqld-max
Ladies and Gentlemen,
after a bigger Query with a SORT BY statement aborted ,
i found out , that my 'sort-buffer'-variable had to be bigger.
Everything worked fine then , but i now read in Paul DuBois
great book , that it is not recommended to make this variable to big.
Please advise me , what
020920 20:32:39 Slave thread: error connecting to master: Unknown MySQL
Server Host '' (2) (107), retry in 60 sec
Im havint this errors when i start my master server, any info on this would
be great!!
--
thanks,
louie
-
You might also consider using two integer type fields - one for the
numerator and another for the denominator. This way storage and recovery are
easy and the mathematics are wide open.
_M
]-Original Message-
]From: MySQL [mailto:[EMAIL PROTECTED]]
]Sent: Thursday, September 19, 2002 7:51
Hello,
I have installed MySQL on a PC with Windows NT. As the
MySQL dir is not on c:, I have copied the 'mysql.ini'
file to c:, and I have edited it to MySQL work with
InnoDB tables. All has been working fine, but this
morning, when I have tried to start up MySQL with the
command mysqld-max
Peter,
Friday, September 20, 2002, 9:20:36 AM, you wrote:
PG The relevant section of my.cnf is:
PG # Uncomment the following if you are using InnoDB tables
PG innodb_data_home_dir = /
PG innodb_data_file_path =
PG data1/ibdata1:100M:autoextend;data2/ibdata2:100M:autoextend;data3/ibdata3:10
PG
tl,
Friday, September 20, 2002, 11:34:26 AM, you wrote:
t | |
t CREATE TABLE `zinutes` (
t `hid` int(10) unsigned NOT NULL default '0',
t `tipas` int(10) unsigned NOT NULL default '0',
t `msg` text NOT NULL,
t `autorius`
speters,
Thursday, September 19, 2002, 10:55:41 PM, you wrote:
samdc If i use a replace query, and there isn't an error, then either
samdc a new row was inserted, or an existing row was updated.
samdc The primary key in the table i'm replacing to is defined as
samdc mprid int not null
Glenn,
Friday, September 20, 2002, 5:27:01 AM, you wrote:
GW I was able to crash MySQL every time with the following -- it is
GW incorrectly formatted I know and I should be using GROUP BY in this
GW particular case
GW When I do the following query:
GW SELECT DISTINCT * FROM CUSTOMER INNER
Art,
Friday, September 20, 2002, 3:48:06 AM, you wrote:
AF Since MySQL does not have views or queries that can be within the database,
AF is there a way to make tables which are subtables of the main table? For
AF example, I have an ID that goes from 0010-10010 to 7000-. I want a table
AF
Chris,
Friday, September 20, 2002, 1:55:39 AM, you wrote:
CT I'm having some trouble with a sizable (but certainly not huge)
CT multi-row insert statement. I can successfully execute the query with
CT up to 7365 rows, but any more and it fails (ERROR 2006: MySQL server has
CT gone away). More
Howdy all!
I've built a page in Dreamweaver MX that uses PHP for scripting. I can get
data out of my mysql database but I need to be able to search for wildcards.
currently it only matches 100% exact queries.
Below is the code that is at the beggining of the PHP page.
---
louie,
Friday, September 20, 2002, 3:24:24 PM, you wrote:
lm 020920 20:32:39 Slave thread: error connecting to master: Unknown MySQL
lm Server Host '' (2) (107), retry in 60 sec
lm Im havint this errors when i start my master server, any info on this would
lm be great!!
What is the
Put a .my.cnf file in root's home directory.
Make it owned by root and mode 400.
Put root's mysql password here, and cron can
run the backup, but nobody except root can read
the .cnf.
[EMAIL PROTECTED] wrote:
i have mysql in redhat and i would liket o automate the backup process..
i would
chown -R mysql.mysql /usr/local/mysql
ROUTLEY, Merrindal (MR) wrote:
Hi all,
I have recently downloaded mysql version 3.23.45 and I am struggling to get it to
start.
Every time I type in ./safe_mysqld the program starts and then shuts down immediately
with the following being written to
One mistake that I see happen a lot in database design is that people
get stuck in visualizing the data in physical terms along with the
labels we attach to them. You should try to think more generically.
Freezer, box, building, tube, etc. are all just labels assigned to
locations. In your
Why don't you use the load data command to import the data in to mysql?
I've done this successfully for about 56,000 records. I currently don't
have a larger data set, so that is definitely not a limit I hit.
Server uname -a:
Darwin localhost 5.5 Darwin Kernel Version 5.5: Thu May 30 14:51:26
Adam,
Thursday, September 19, 2002, 8:33:17 PM, you wrote:
AW Have been trying to connect to a remote MySQL server from Matlab through an
AW ODBC connection, however the error is receive is
AW [TCX][MyODBC]Can't connect to MySQL server on
AW 'server name' (10060)
AW I have searched the docs
Dean,
Monday, September 16, 2002, 7:41:09 PM, you wrote:
DH We're using MySQL 4.0.3-beta-nt. The new documentation for FULLTEXT searching says
that phrases should be inside quotations, as for example:
DH SELECT title FROM booklist WHERE MATCH(title) AGAINST ('+august 2002' IN
BOOLEAN
smudholkar,
Thursday, September 19, 2002, 1:11:18 AM, you wrote:
saadc I saw the information for upgrading MySQL 3.23 to 4.03
saadc regarding altering table types, etc. If I am using the
saadc Windows release can I just install the binaries etc.
saadc over the existing installation?
Yes.
Hi,
ok you have to install both mysql and mysql++.
you need #include sqlplus.h in your sourcecode.
then:
g++ file.c -o file -lm -lmysqlclient -lsqlplus
and if you havent installed in the default_folder
-I/usr/include/mysql -L/usr/lib/mysql
too.
if /usr/include and /usr/lib are your
At 9:09 + 9/20/02, xuefer tinys wrote:
i'm sure mysql4.x have wrong algorithm to escape/unescape multibyte chars
a multibyte is escaped while server read it, it maybe a pair of single byte
or a pair of single byte escaped while server read it, it appears as multibyte
both of these two
At 1:49 -0700 9/20/02, PR wrote:
I have a message board app I'm using where I'm trying to make the code
faster and more efficient than it is now. At times this board will
generate a lot of new posts to it very very quickly. In one section where
posts are added, after the post is made and
Thanks a lot!
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 20, 2002 9:38 AM
To: [EMAIL PROTECTED]
Subject: re: Upgrade from 3.23 to 4.03
smudholkar,
Thursday, September 19, 2002, 1:11:18 AM, you wrote:
saadc I saw the information for
I am working on a multilingual site and trying to figure out how to store
Cyclic (Russian) and text in other languages in a mysql database. When I try
to enter the text what I enter looks like it is getting converted to its
ASCII equivalent. Dose anyone know if there is a way to set up mysql so
All,
Anyone know of a utility that will perform basically a
diff between 2 MySQL tables?
I have a development project I was handed that someone
else started. The project was to extend functionality
of a set of programs and required changes/additions
etc to various database table.
I'm
On Thursday, September 19, 2002, at 10:22 PM, Jacques-Yves Mac wrote:
Hi,
MY_system:= macos 10.2
Darwin kernel version:= 6.0
Mysql server version:= 3.23.52
Mysql server is installed and work great except...
I can't run the mysql executable localted in the bin directory
HI,
Can anyone figure this out ? I have been trying this out for quite some
time. It compiles fine but when I run
root@love(scripts)# ./mysql_install_db
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
yes, when i post a problem, someone told me to give more info
when i post the whole php-script, no response
mysql-4.x unable to handle binary data when using multibyte charset, (maybe
the old mysql-3.x escape/unescape is fine)
file: mysql-4.0.1-alpha/libmysql_r/libmysql.c
in function
In MS SQL, I can do the following statement
select count(*) from table1
go
select count (*) from table2
go
This will return 2 results, with count of each table. How would I do the
same thing in MySQL?
Tim Davis
Sunbelt Systems Concepts, Inc
[EMAIL PROTECTED]
Client/Server Database
Description:
When configuring with the --localstatedir option, any directory
used that is longer than 3 characters has only those 3 characters
used
How-To-Repeat:
compile with the --localstatedir=/abcd or any 4 or more character
directory name
Fix:
José,
Friday, September 20, 2002, 3:37:07 PM, you wrote:
JF I have installed MySQL on a PC with Windows NT. As the
JF MySQL dir is not on c:, I have copied the 'mysql.ini'
If you put option file to the C:/ it should have name my.cnf, not
mysql.ini
JF file to c:, and I have edited it to MySQL
Hi,
I am on the machine 192.168.0 230, and I am trying to connect to the server
on 192.168.0.10.
mysql -h 192.168.0.10 -u username -p
I get back
ERROR 2003: Can't connect to MySQL server on '192.168.0.10' (111)
OK, so I tried to connect to the local server
mysql -h 192.168.0.230 -u username
Ha ha, I changed the remote permissions for the user to 'any host' and now
it works. Doh!
sql
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
I hope you will recognize that what you stated as a problem is _not_
what this thread was about.
You are talking about --
(a) A new (and as yet non-universal) version of MySQL
(b) Only binary data
(c) Conf done by you, which is not standard
Whereas the thread was about simple
Hello,
I have a debian woody (kernel 2.2.16) with mysql 3.23.49,
I try to make a select statement using fulltext indexes like this:
in this case I have no error:
SELECT prodotti.titolo FROM prodotti WHERE MATCH (descriz) AGAINST ('story');
or
SELECT prodotti.titolo FROM prodotti WHERE MATCH
Try this:
CREATE TEMPORARY TABLE TMP SELECT USER() AS UserId
or
CREATE TABLE TMP SELECT USER() AS UserId
and u get:
ERROR 2013: Lost connection to MySQL server during query
running MySQL 4.0.3-Beta-log on RH linux 7.2
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
At 12:25 -0300 9/20/02, Alejandro D. Burne wrote:
Try this:
CREATE TEMPORARY TABLE TMP SELECT USER() AS UserId
or
CREATE TABLE TMP SELECT USER() AS UserId
and u get:
ERROR 2013: Lost connection to MySQL server during query
running MySQL 4.0.3-Beta-log on RH linux 7.2
I get the same result as
At 17:24 +0200 9/20/02, Patrizia De Bella wrote:
Hello,
I have a debian woody (kernel 2.2.16) with mysql 3.23.49,
I try to make a select statement using fulltext indexes like this:
in this case I have no error:
SELECT prodotti.titolo FROM prodotti WHERE MATCH (descriz) AGAINST ('story');
or
I get the following results when doing a SELECT off a single table I have.
What's bizarre is that the index is no longer used when i expand my list of
states to be included.
mysql EXPLAIN SELECT * FROM shipping USE INDEX (state) WHERE state IN
('TN','NY');
mysql, query speed up, sql
_
Sorry I may be bothering you but I was thinking (gosh! this is so bizarre on
me) that may be we can make MySQL SGML compatible. I agree that MYSQL cannot
be manipulated to handle jerarquical information because
hello all,
i have the following selection in my query...
DATE_FORMAT(Images.TIMESTAMP, '%a %b %d at %l:%i %p') as TIME
now, i want to apply LCASE or LOWER to it, but i'm a little unsure how to handle the
syntax with two sets of parentheses.
any insight?
tia,
j
i'm sorry that i've not read through nor understand the whole thread
From: Shashank Tripathi [EMAIL PROTECTED]
To: 'xuefer tinys'
[EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: RE: Japanese Charset
Date: Sat, 21 Sep 2002 00:22:04 +0900
On Friday, September 20, 2002, at 08:09 AM, Richard Fox wrote:
Hi,
I am on the machine 192.168.0 230, and I am trying to connect to the
server
on 192.168.0.10.
mysql -h 192.168.0.10 -u username -p
I get back
ERROR 2003: Can't connect to MySQL server on '192.168.0.10' (111)
OK, so
hi,
have done a succesful update 3.23.36 to 2.23.47 on my mandrake-box 8.2,
but have now that question :
as user root it is possible to login now with mysql -p the
password-question appears, typing in the root-password is okay and I can
see the prompt mysql but as a simple user and doing all the
re-posting multibyte problem.
does anyone have problem with binary data in MySQL-4.x using GBK charset or
any other multibyte charset?
inserting/updating/replacing
the full description is in mysql mailing list archive, sent by me
will not repost full desc until someone have or care this
At 12:39 -0400 9/20/02, Stanley, Jason wrote:
hello all,
i have the following selection in my query...
DATE_FORMAT(Images.TIMESTAMP, '%a %b %d at %l:%i %p') as TIME
now, i want to apply LCASE or LOWER to it, but i'm a little unsure
how to handle the syntax with two sets of parentheses.
The
I have question about mysqld theading.
I understand that mysqld will have one thread per connection, is that
right??
If thru, Can I assign higher priority to perticular
thread/connection/client ?
for example , If we have two clients connected to mysqld using
Thread A and Thread B. ( they
Why don't you use the load data command to import the data in to mysql?
I've done this successfully for about 56,000 records. I currently don't
have a larger data set, so that is definitely not a limit I hit.
The server I need to load data into is replicated: load data with a
local infile
mysql -u root -p
This will enter as user 'root'
-Original Message-
From: hans schneidhofer [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 20, 2002 1:00 PM
To: [EMAIL PROTECTED]
Subject: mysql -p as simple user ?
hi,
have done a succesful update 3.23.36 to 2.23.47 on my
At 12:05 -0500 9/20/02, Naushit Sakarvadia wrote:
I have question about mysqld theading.
I understand that mysqld will have one thread per connection, is that
right??
If thru, Can I assign higher priority to perticular
thread/connection/client ?
No. You can apply priority modifiers to
IT is working as of yesterday.
The problem was that I was granting select, insert, update privileges to the
webuser and the change would not appear in the user table of the mysql
database.
Learn a new one yesterday. I try changing the privileges using the GRANT on
an existing user and they do
I'm trying to use a sql query to determine if an ID exists in any of 3 different
tables in the database. I need to do this in one SQL query (ideally only using the ID
once in the query). I'm using mysql 3.23.47.
Here's an example of a query I came up with:
select count(*) from jobs,
Description:
I wanted to get the rows from table Health for which no match exists in the
table resulting from the inner join of Object and NMID.
I ran these queries in MySQL 3.23 and 4.0 with the same incorrect results.
They all work fine on MS SQL Server 2000 and on DB2 7.2.
With a DBMS
Description:
I support customers running HP-UX11i with Oracle 8i. They are getting
a Solaris box running mySQL from another provider. I have to interface
to this database from my application (C/C++ and Oracle 8i). I have
successfully installed mySQL on a Solaris
try a left join
select count(*) from jobs
left join submissions on
jobs.standard_id=submissions.color_id
where jobs.standard_id=ID_VALUE and submissions.color_id is null
Eddie
-Original Message-
From: Richard Bolen [mailto:[EMAIL PROTECTED]]
Sent: Friday,
Hello,
We have 4000 db and 4000 user (more or less) in MySQL, each db has one user
assigned.
Some times, this is happened more often, show the next error:
ERROR: 1045 'Access denied for user: #8216;username@host#8217; (using password:
YES).
So we kill/restart the mysqld
If it thinks it will retrieve more than a third of the records, the
index will not be used.
[EMAIL PROTECTED] wrote:
I get the following results when doing a SELECT off a single table I have.
What's bizarre is that the index is no longer used when i expand my list of
states to be included.
I have installed MySQL on Windows NT, and I have found
that I need to create the privilege tables. I have
seen in the documentation that I must use the
mysql_install_db.sh script, but I think that it is
intended to use in Linux or Unix, not with Windows.
I say this due to I have not found it
Binary data is binary data.
It doesn't mattrer whether it is GBK or and audio file,
or a jpeg.
If you escape the data properly before inserting it you will get
back the same data you stored.
Your application must display it properly.
xuefer tinys wrote:
re-posting multibyte problem.
does
Hello,
The privilege tables exist already after the install - you don't need to
create them manually afterwards. The root user has no password and can
connect from localhost only.
Best regards,
Iikka
On Fri, 20 Sep 2002, José Fernández wrote:
I have installed MySQL on Windows NT, and I have
Sorry about emailing you directly Eddie. I meant to reply to the list with my last
email.
Anyway - your suggestion worked wonderfully. Many many thanks.
-Original Message-
From: Edward Peloke [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 20, 2002 15:59
To: MySQL Mailing List
Hello,
in a previous answer, you have said me that if install
MySQL on a Windows NT machine, it is not necessary to
create privilege tables with 'mysql_insall_db.sh'.
The problem is this:
I have installed MySQL on a PC with Windows NT. As the
MySQL dir is not on c:, I have copied the
From: Madscientist [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Date: Fri, 20 Sep 2002 08:26:21 -0400
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
Importance: Normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.
X-Declude-Spoolname: D13f214a.SMD
News-Group:
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
(http://www.ezmlm.org)
From: Richard Fox [EMAIL PROTECTED]
Date: Fri, 20 Sep 2002 11:19:37 -0400
X-Priority: 3
X-MSMail-Priority: Normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.
News-Group: list.mysql
Could you pls let me know how to delete duplicate records in a table?
Pls send SQL query.
Thanks!
Abhi
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
From: Abhi [EMAIL PROTECTED]
Could you pls let me know how to delete duplicate records in a table?=20
DELETE FROM my_table WHERE [predicate] LIMIT 1;
---
Rodney Broom
President, R.Broom Consulting
http://www.rbroom.com/
sql
Description: A particular select distinct with three columns
consistently crashes mysqld. This happens with both 4.0.2 and 4.0.3.
How-To-Repeat: This may be somewhat challenging, because the table in
question contains 12 million records, comprising nearly 1GB of data.
Here is the output of
At 15:45 -0700 9/20/02, Robert Coie wrote:
Description: A particular select distinct with three columns
consistently crashes mysqld. This happens with both 4.0.2 and 4.0.3.
There's a SELECT DISTINCT bug that's been fixed in the upcoming 4.0.4
mysql,sql,query
Paul,
Thanks for your reply. I enjoy reading your book very much
It was very much helpful while development of client in C. I am
embedded system engineer so please correct me if I am misssing anything in
this new DBMS world.
So I understand that there is no mechanism to set priority between
Noël,
Browscap.ini is MS Windows browser capabilities file.
It's an IIS thing. So this tells me that you've got a
problem with your IIS setup on the server.
Since you're on Windows, open up the command prompt,
and go to the directory where you installed PHP (ie.
c;\php). Within the command
Hi,
We experienced some interesting things when we upgraded to Mysql-Max
3.23.52 (Red Hat 7.1, 2.4.7-10enterprise). It looked like after a
sustained amount of large disk activity, the whole system would slow to
a crawl and CPU idle % would go down to 0 for about 30 seconds before it
popped
it's true that mysql-4.x process binary data well when not using multi-byte
charset
but mysql-4.x process it differently when using multi-byte
it's only for GBK text escaping, which is not suitable for binary data
that's the key point
if u don't use multi-byte, and mysql-4.x, u will never have
Hi Steven,
Some precisions : after taking a look at my mail, I noticed the very first
time I saw this error was with PHP 4.2.1 and MySQL 4.0.2 (reported on this
list on 27 june 2002).
Regards,
Jocelyn
- Original Message -
From: Steven Roussey [EMAIL PROTECTED]
To: 'Jocelyn Fournier'
92 matches
Mail list logo