On Thu, 29 Aug 2002, Dan Nelson wrote:
>
> Please don't hijack threads; you replied to a message titled
> "performance tunning 4.x".
sorry, my fault...
>
> In the last episode (Aug 29), Varshavchick Alexander said:
> > I have a FreeBSD server where I installed mysql 3.23 with linux
> > threads
That optimization is for fields without an index AFAIK.
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.c
*This message was transferred with a trial version of CommuniGate(tm) Pro*
I installed Mac OS X 10.2 this last weekend and since then I've been
having some problems with the security on the MySQL files. I thought
that I had everything fixed, but now when my web users try and update
or insert a
Quote from the "How MySQL Uses Indexes" document:
MySQL 4.0 does another optimisation on LIKE. If you use ... LIKE
"%string%" and string is longer than 3 characters, MySQL will use the
Turbo Boyer-Moore algorithm to initialise the pattern for the string and
then use this pattern
Hi ,
We are getting following message multiple times in mysqldb.err
file:--
020829 13:46:39 Aborted connection 9556 to db: 'storageprofiler' user:
'root' host: `localhost' (Got an error readin
Do you have any copyright / DRM-enable-able content on your machine?
I thought the understanding within the nt administrator community was to boycott
sp3 until M$ revised their EULA to revert ownership back to the organization /
person who paid the money for the hardware it runs on... Sorry; it
I have a problem with MySQL. I am trying to insert data using INFILE, and
it works, except that it ALWAYS stop at 255 (autoindex) and will not go any
further, either by manual insert or textfile insert. I am running MySQL
3.23.38-max-nt on a Windows 2000 Server.
Is this a known issue? something
Hi everyone,
I am running a FreeBSD server with MySQL 3.23
I want to let my virtual users create/drop tables and limit the size of each
table, and also the number of tables they can create.
Can someone please tell me how I can do this?
Is it possible wit applications such as webmin, or phpMyAdmin
I have several large MyISAM tables that are frequently updated by certain
events in the application. I find that the queries get considerably slower
over time, and I run OPTIMIZE TABLE to defragment the datafiles. The user
comments on http://www.mysql.com/doc/en/OPTIMIZE_TABLE.html seem to indic
Sorry everyone,
I must've forgotten to set the password with an 'identified by' clause, or I
needed to grant to *.*:
grant all on *.* to "fred"@"192.168.0.230" identified by 'fred';
it works now. thanks!
Fred
> -Original Message-
> From: Alexander Burbello [mailto:[EMAIL PROTECTED]]
>
This might explain how I lost my secondary IDE controller. I just
unistalled SP3 to resolve my issue.
On Thu, 29 Aug 2002, =?ISO-8859-1?Q?Iikka_Meril=E4inen?= wrote:
> Date: Thu, 29 Aug 2002 23:10:06 +0300 (EEST)
> From: =?ISO-8859-1?Q?Iikka_Meril=E4inen?= <[EMAIL PROTECTED]>
> To: Marc Hus <[
At 16:03 -0400 8/29/02, Philip Mak wrote:
>What are all these rei-bin.* files in this MySQL data directory? Are
>they needed? They're taking up a lot of disk space. They seem to be
>some sort of log.
>
>horderei.aaanime.net.pid rei-bin.008 rei-bin.016
>linkwars
Yeah, I tried that too. About 5 times with each and every version you
have. It worked so wonderful before and I just don't understand why it
wants to act up now :(
Going to be a real pain to have to reformat that server to get it to
work
--Marc Hus
-Original Message-
From: Miguel Angel
Hello,
No problem with my version of mysql.
w2k server sp3 installed while running mysql 3.23.51-max-nt-log.
John
> -Original Message-
> From: Marc Hus [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 29, 2002 12:29 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: MySQL and
Well I just tried that and it keeps saying
The service already exists!
The current server installed: C:/mysql/bin/mysqld-nt.exe
I really don't understand it though, It ran great before the inevetible
Service Pack Upgrade :(
--Marc Hus
-Original Message-
From: [EMAIL PROTECTED] [mailto
At 14:29 29/08/02 -0500, Marc Hus wrote:
Hi,
>Hello,
>
>I have a very strange problem with all of the Windows versions of MySQL.
>I upgraded to Service Pack 3 for Windows 2000 Server and now MySQL will
>not work period. Has anyone ran into this problem and or know of a fix?
Some users had report
Hello.
On Thu 2002-08-29 at 11:38:17 -0700, [EMAIL PROTECTED] wrote:
[...]
> I'm sure I can do this "programmatically" by having my program connect to
> the database using the "root" user/password, but that means embedding the
> password in the program [i.e., viewable with "string..."] so once a
Hello,
Reinstall your MySQL service using mysqld((-max)-nt) --install
SP3 somehow manages to remove the service registration in some cases.
Regards,
Iikka
On Thu, 29 Aug 2002, Marc Hus wrote:
> Hello,
>
> I have a very strange problem with all of the Windows versions of MySQL.
> I upgraded to
What are all these rei-bin.* files in this MySQL data directory? Are
they needed? They're taking up a lot of disk space. They seem to be
some sort of log.
horderei.aaanime.net.pid rei-bin.008 rei-bin.016
linkwars rei-bin.001 rei-bin.009 rei-bin.017
Hello,
I have a very strange problem with all of the Windows versions of MySQL.
I upgraded to Service Pack 3 for Windows 2000 Server and now MySQL will
not work period. Has anyone ran into this problem and or know of a fix?
Marc
Short answer YES you have to have them
why because 2002-08-29 = 1965
-Original Message-
From: Johnny Withers [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 29, 2002 1:30 PM
To: [EMAIL PROTECTED]
Subject: DATES and WHERE
I'm a bit confused here.. dates are not my strong point..
I
I am trying to create a mysql connection pool in Weblogic 6.1 using the
JConnector driver and failing. All I get is "no suitable driver" which
usually means that the URL and properties aren't right for the driver I'm
using. I defined the pool as:
name: MysqlPool
URL: jdbc:mysql//192.168.1.100:330
John Deligiannis wrote:
> Hello,
>
> I have an applet that uses mysql. I have added support for greek
> and for data that are already in mysql, it works fine. When I add
> other from my applet it prints "".
> Another thing is that I construct a table from the resultSet using
> two (String) ve
This is actually a bit of a general-database question, since I'm sure it has
the same or similar repercussions regardless of which RDBMS you use, but I'm
curious: is it possible to "safely" allow users to maintain their own
passwords to a database? [and if so, how?]
I'm sure I can do this "progr
I'm a bit confused here.. dates are not my strong point..
I have a table with a date column in it (DATE datatype)
a few values:
mysql> select dte from images\G
*** 1. row ***
dte: 2002-08-29
*** 2. row ***
I'm having trouble connecting to MySQL using JNDI with Tomcat. I have
deleted my server.xml and started with a fresh copy. First, I made sure I
could connect to MySQL with a regular JDBC connection. Next, I added a
JDBC Realm using MySQL. That works fine. Finally, I added a JDBC resource
and
Something like this:
$site::dbName= 'DBI:mysql:test:10.10.2.20';
for a database called test on 10.10.2.20
Then add the user for the web machine (assuming it's 10.10.2.10) to the
authorized list:
Grant select on test.* to [EMAIL PROTECTED] identified by 'password';
Flush privileges;
Ev
Thank you for your answer. I have to apologise for my bad post(I work 1
week on this problem and it was a desperite try).
I have done what you suggested, but it partly works.
Without "useUnicode=true" I didn't get anything right.
With "useUnicode=true" I did get the data that were already in my
Hi,
Some what it seems to be like store procedure for MySQL you can find on:
http://www.fastflow.it/mylua/
For trigger you don't have alternative.You must write a simple application
which monitoring your Internet Sessions and writing
in MySQL DataBase.
Regards,
Gelu
___
muchas gracias!!
you are a genius.
it's all, I can to continue working
thanks
Sandra
- Original Message -
From: Jed Verity <[EMAIL PROTECTED]>
To: Jorge Martinez <[EMAIL PROTECTED]>; Mary Stickney
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, August 29, 2002 2:08 PM
Subject: Re
I'm doing this in the command line of mysql for linux.
I tried your suggestion and the results was bads.
it assume that I write " a.nombre like '%' " and shows all registers.
any suggestion??
thanks
- Original Message -
From: Mary Stickney <[EMAIL PROTECTED]>
To: Jorge Martinez <[EMAIL
How about
select a.name from table1 a, table2 b where a.name like
concat("%",b.name,"%");
You might want to read chapter 6.3 in the mysql manual:
http://www.mysql.com/doc/en/Functions.html
HTH,
Jed
On the threshold of genius, Jorge Martinez wrote:
> yes, but select a.name from table1 a, table
Hi,
Mary gives you a sugestion about how can you use field(b.name) in this case.
You can try this :
select a.name from table1 a, table2 b where a.name like
CONCAT('%',b.name,'%');
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail addres
Please don't hijack threads; you replied to a message titled
"performance tunning 4.x".
In the last episode (Aug 29), Varshavchick Alexander said:
> I have a FreeBSD server where I installed mysql 3.23 with linux
> threads from a port collection, the procedure was simple enough
> (WITH_LINUXTHRE
In the last episode (Aug 29), John Gruber said:
> I have an application (radius) that is logging network activity to
> MySQL. When a users completes a network session an accounting insert
> query is made for that session showing the session length. The
> application has the functionality to SUM a
ok try this
select a.name from table1 a, table2 b where a.name like
'%'+ b.name + '%';
-Original Message-
From: Jorge Martinez [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 29, 2002 11:48 AM
To: Mary Stickney; [EMAIL PROTECTED]
Subject: RE: like problem
yes, but select a.name fro
yes, but select a.name from table1 a, table2 b where a.name like
'%'b.name'%';
is an error
- Original Message -
From: Mary Stickney <[EMAIL PROTECTED]>
To: Jorge Martinez <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, August 29, 2002 1:26 PM
Subject: RE: like problem
>
> tha
Hi
I need to use the mysql c++ api in combination with gcc 3.0. I have downloaded the
patch but I have trouble applying it. I've tried the patch tool but that did not seem
to understand the patch file.
Is there a solution or do I need to manually change every single file mentioned in the
pat
that would be because b.name is inside the ' ' and it is taken as a
constant.
-Original Message-
From: Jorge Martinez [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 29, 2002 11:10 AM
To: [EMAIL PROTECTED]
Subject: like problem
i need this consult
select a.name from table1 a, table
Hello,
I have an applet that uses mysql. I have added support for greek
and for data that are already in mysql, it works fine. When I add
other from my applet it prints "".
Another thing is that I construct a table from the resultSet using
two (String) vectors. The table headers come out unre
On Tue, 27 Aug 2002, Dean Ellis wrote:
> The annoying thing about it, for me, is that MySQL 4.0 has been perfectly
> stable and perfectly usable for us until 4.0.3, which so far has yet to
> produce a usable client library. I keep pulling from CVS and recompiling,
> hoping that one day soon I
Hello gang,
I have an application (radius) that is logging network activity to MySQL.
When a users completes a network session an accounting insert query is made
for that session showing the session length. The application has the
functionality to SUM all session times for a user and determine i
i need this consult
select a.name from table1 a, table2 b where a.name like '%b.name%';
but i have a problem because Mysql not recognize the value of b.name
-
Before posting, please check:
http://www.mysql.com/manual.php
Yes, both run 3.23.49a
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Mihail Manolov" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, August 29, 2002 3:24 AM
Subject: Re: mysqlhotcopy problem - Segmentation fault
> On Wed, Aug 28, 2002 at 04:50:22PM -04
Hello,
A MySQL developer would be able to answer to these questions more
accurately, but I'll try to answer _logically_. So don't bet a million
dollars on the correctness of my answer.
> >>NOTE: The query cache does not return stale data. When data is modified,
> any relevant entries in the que
Hi,
If i understand well, you wish to use MySQL C API function in VBScript.It's
not possible in this way.
But why you don't wish to use ADO?
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
Hi people,
I have a FreeBSD server where I installed mysql 3.23 with linux threads
from a port collection, the procedure was simple enough
(WITH_LINUXTHREADS=yes make). All my attempts then to build it from
sources were unsuccessfull, however it was not important consdering
that it could be insta
Tobias Eriksson wrote:
> Hi
> I am trying to figure out how to compile embedded MySQL on Windows.
> I read that one should configure using the --with-embedded-server flag,
> but I should also use some script called mysql_config. But I couldn't
> find that script, I have downloaded the source for
>
>Hi,
>
>Start by looking at the MySQL documentation:
>http://www.mysql.com/doc/en/Query_Cache.html
>Read the entire 6.9 section.
>
>It offers quite a bit of information on how the cache operates, how
>you should configure it and so on.
>
>
>Regards,
>Iikka
likka,
I read it too but I h
Hi,
I don't know if this help you too much.
Signal 16 is SIGUSR1.In Linux (and Unix) environment are signals which can
be used like User Defined Signal.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
Hi
I am trying to figure out how to compile embedded MySQL on Windows.
I read that one should configure using the --with-embedded-server flag,
but I should also use some script called mysql_config. But I couldn't
find that script, I have downloaded the source for version 4.0, so I
should have al
> Does anyone know what a signal 16 from a MYSQL thread means ?
>
> 020829 5:56:56 Warning: Got signal 16 from thread 1204584
>
> thanks
>
> Adam
-
Before posting, please check:
http://www.mysql.com/manual.php (the ma
general outline of situation; my office is moving away from microsoft
(resistance is NOT futile!!! go slashdot!), and establishing web-based
customer service systems.
i'm currently establishing a customer table, that links to a contact table.
each customer will be listed once; to be the customer
Chugh,
Thursday, August 29, 2002, 2:18:26 PM, you wrote:
CS> Can we use delete rules such as delete on cascade in MySQL
CS> or I will have ti handle this on the client side?
Yes, you can use ON DELETE CASCADE and ON DELETE SET NULL with InnoDB
tables:
http://www.mysql.com/
Liisa,
Thursday, August 29, 2002, 3:46:09 PM, you wrote:
LK> Description:
LK>problem installing MySQL-3.23.52-1
LK> How-To-Repeat:
LK> shell> rpm -Uvh MySQL-3.23.52-1.i386.rpm
[skip]
LK> ERROR: 1 Can't create/write to file './mysql/db.frm' (Errcode: 13)
[skip]
It's a permission probl
It shoul d be running as user mysql .
Mertens Bram wrote:
>On Wed, 2002-08-28 at 22:19, Keith C. Ivey wrote:
>
>>As it says in the documentation, "If the LOCAL keyword is specified,
>>the file is read from the client host. If LOCAL is not specified, the
>>file must be located on the server."
I've read the info file and the non-existant FAQ file so I've done my
homework. Yet, I can't seem to get this listserv to accept a digest
command; I keep getting bounced.
Does mysql list support receiving by digest?? If so, how?
Thanks!
-Dave
---
From: "borracho 138" <[EMAIL PROTECTED]>
> Many thanks for the reply - nice to know that I'm not the only one with
this
> issue(!)
> Seems like my problem is related to 2 areas:
> - I'm concerned about the lack of memory 'freeing' with the system, but a
> kernel upgrade may fix that
Don't have t
>Description:
problem installing MySQL-3.23.52-1
>How-To-Repeat:
shell> rpm -Uvh MySQL-3.23.52-1.i386.rpm
MySQL
##
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv ta
How many auto_increment fields can I have in a database?
Thanks
ilyas
filter:mysql
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To r
Hi,
Try another tool named "My Database Manager". You can download the site
br.geocities.com/burbello.
Greedings
Alexander
- Original Message -
From: "Fred Tsang" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 29, 2002 7:38 AM
Subject: Connecting to another machine
Hi!
I would like to ask you this for my curiosity:
into mysql 4.02 win32 it exist a cygwin posix emulation layer, it's used for
the client or for the server app?
Cygwin emulation layer it's very slow into win32, can you translate cygwin
calls into direct win32API's (without cygwin)?
TNX
Rober
Dear All!
Can we use delete rules such as delete on cascade in MySQL
or I will have ti handle this on the client side?
Regards
sql, mysql, query
-
Before posting, please check:
http:
martin,
Wednesday, August 28, 2002, 10:12:13 PM, you wrote:
m> Description:
m> I am porting MySQL to Linux/Alpha. On some occasions
m> the CREATE TABLE statement adds ZEROFILL for int(11)
m> fields. If you don't know this problem, let me know
m> so I can try to fix
Mertens,
Wednesday, August 28, 2002, 6:52:12 PM, you wrote:
MB> On Wed, 2002-08-28 at 16:51, Egor Egorov wrote:
>> Put into my.cnf file :
>> [mysql]
>> local-infile=1
>>
>> or start mysql client with --local-infile=1 option.
MB> I tried the first option and it works when use the following comma
Mary,
Wednesday, August 28, 2002, 7:49:22 PM, you wrote:
MS> see my message re--- index problem
MS> ok when I do explain in this , it is not using an index for the
MS> AdminCoverage_writingagents table...
MS> SELECT admincoverage_writingagents.WritingAgentID,
MS> admincoverage_writingagents.Wr
Folks,
I have a question about myCC. I can't connect to a local linux machine (ip
192.168.0.232) for the life of me from my win2k box (ip 192.168.0.232) using
myCC. I've done the following:
GRANT ALL ON test.* TO 'fred'@'192.168.0.230';
FLUSH PRIVILEGES;
but, in my mysql.log I still get:
020
From: "borracho 138" <[EMAIL PROTECTED]>
> I've searched for more information on these issues, without luck.
>
> The system randomly spirals out of control - load avg increases very
> rapidly, resulting in loads of 200-300 in 2/3 minutes. At other times the
> server is fine, handling the busiest
Markus Reger wrote:
>MySQL
>
>: it seems that a user who has grant privilege can grant access to a(his) database to
>another user although this other user doen't exist - in this case the other user is
>newly created! can cause a mess in your usertable when you have a site with some
>database
Hi, I'm using: Tyan m/b, 2x U160 scsi disks, dual Athlon MP CPUs, 2Gb RAM +
2GB swap
RH 7.3, 2.4.18-5smp kernel
MySQL 3.23.51 (MySQL Linux tar.gz) binary used based on the comments on the
download page about gcc 2.96 compiled versions resulting table corruptions,
etc.
I have a couple of question
MySQL
: it seems that a user who has grant privilege can grant access to a(his) database to
:another user although this other user doen't exist - in this case the other user is
:newly created! can cause a mess in your usertable when you have a site with some
:databases to administer
---
Hello
On Thu, 1 Aug 2002, Quinten Steenhuis wrote:
> Has anyone successfully gotten MySQL 4.02 running on Debian? I'm
> running into problems if I use alien to convert the RPMs.
Yep, we're using 4.0.2 on Debian. You may want to grab MySQL .tar.gz
instead of .rpm and install it somewhere into /
I have addressed this problem in the thread "Re: developing clients in C with Dev-C++"
on [EMAIL PROTECTED]
Tor Erling Unander
Trondheim, Norway
==
I am trying to compile a file on windows and build a DLL, this has worked before
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 28 August 2002 22:53, Carlos Oyarzún wrote:
> I´m trying to install mysql-3.23.52 on a machine running RedHat 7.0. I´m
> using the following procedure:
>
> ./configure --prefix=/usr/local/mysql
> make
> make install
>
> The first two com
HI,
I would like to know if there is a program/script that can migrate data
from sybase ASE server to MySQL ???
Just tables - lots and lots of tables (about 12GB of data !!!)
Many Thanks
Tonino
-
Before posting, please check:
On Tue, Aug 27, 2002 at 05:40:48PM -0400, Marc Prewitt wrote:
> I'm trying to put together some statistics on our queries and am wondering
> what percentage of our queries involve a full table scan. The variable
> which kind of tracks this is Handler_read_rnd_next. However, since a
> query may c
On Wed, Aug 28, 2002 at 04:50:22PM -0400, Mihail Manolov wrote:
> I have strange problem - I get Segmentation fault error when I am trying to
> execute mysqlhotcopy.
>
> When I remove the [mysqlhotcopy] section in my /etc/my.cnf
> configuration it works. Meanwhile, on another server it works just
77 matches
Mail list logo
