[EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
hi,
i have problem with automatic setting of variable wait_timeout.
mysql version 4.0.20 (and 4.0.18) on slackware linux.
i've tried to set it in several ways:
1) in startup script as a parameter to mysql_safe:
-O wait_timeout=30
2a) in
Any functions like filter ADO function in PHP? Thanks!
I tested it on with my test data for others PARTITIONED_*_*
tables on v4.1.2 and SELECT worked well.
v4.1.2? Where can I get it?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Dear Sir,
What level of Encryption does MySQL have? I cannot find much security
information from mysql.com.
Thanks,
Joseph
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Leonardo Francalanci [EMAIL PROTECTED] wrote:
I tested it on with my test data for others PARTITIONED_*_*
tables on v4.1.2 and SELECT worked well.
v4.1.2? Where can I get it?
You can install it from development source tree:
There is a particular form of SQL query you can use I believe when you
are adding data to a table and want to include an ID number from another
lookup table but you only know the name reference and not the ID
eg it might be an author table with an author_id and author_name and
you want to enter a
If you check wait_timeout value using mysql command-line client, it
takes value for 'wait_timeout' from 'interactive_timeout' variable
which is 28800 by default.
thanks, now i see.
this behaviour is rather strange, isn't it? why are there two different
variables then? i thought that
On May 21, 2004, at 1:54 AM, [EMAIL PROTECTED] wrote:
What level of Encryption does MySQL have? I cannot find much security
information from mysql.com.
http://dev.mysql.com/doc/mysql/en/Encryption_functions.html
-- greg willits
--
MySQL General Mailing List
For list archives:
v4.1.2? Where can I get it?
You can install it from development source tree:
http://dev.mysql.com/doc/mysql/en/Installing_source_tree.html
or wait when binaries will be available.
I'll wait for binaries...
At the moment even a query like
(SELECT * FROM REGULAR_copy) UNION
Adrian,
You may try this:
INSERT INTO tbl_temp2 (fld_id)
SELECT tbl_temp1.fld_order_id
FROM tbl_temp1 WHERE tbl_temp1.fld_order_id 100;
Best Regards,
Jonathan Chiu
OOCL Logistics
Unit 1, 4/F., Sun Hung Kai Centre, 30 Harbour Road, Wanchai
TEL: 852 . 2990 0174
FAX: 852 . 28249017
hi everybody,
Just a note of a problem I found - to see whether worth reporting this
as a bug, or suggest that someone mention it in the manual.
In short: *when replication fails because 'max_packet_size' is too
small, that failure can corrupt the relay logs*. So even when you fix
the
hi,
I am trying to copy a file stored in longblob column of a table to a longblod
column of another table, can any one tell me what kind of insert statement should i
use for that purpose. 2ndly can any one tell me any built in function in mysql to
download a file from longblob column to
adrian Greeman [EMAIL PROTECTED] wrote:
There is a particular form of SQL query you can use I believe when you
are adding data to a table and want to include an ID number from another
lookup table but you only know the name reference and not the ID
eg it might be an author table with an
We have a set of tables which are losing the cardinality on the first part
of the primary key. A simple CHECK TABLE or ANALYZE table restores the
cardinality. We are running MySQL 4.0.18 on Solaris 8.
*** 1. row ***
Table: UserSessions
After what action are you indexes becoming invalid? Are you running nightly
maintenance? What is the table type?
-Original Message-
From: Jude Insley
To: [EMAIL PROTECTED]
Sent: 5/21/04 6:00 AM
Subject: Index cardinality lost
We have a set of tables which are losing the cardinality on
hi,
i am trying to get german umlauts into my database.
shouldnt be that hard...
i am working on a linux machine with the following
settings
suse 9.0
MySQL-server-4.1.1-1
MySQL-client-4.1.1-0
# locale
LANG=de_DE.UTF-8
LC_CTYPE=de_DE.UTF-8
LC_NUMERIC=de_DE.UTF-8
LC_TIME=de_DE.UTF-8
After what action are you indexes becoming invalid? Are you running nightly
maintenance? What is the table type?
We are not running nightly maintenance but we do run the INSERT DELAYED as
a batch during the night. The loss of cardinality seems to happen after a
number of days but we have not
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Greg Willits wrote:
| On May 21, 2004, at 1:54 AM, [EMAIL PROTECTED] wrote:
|
| What level of Encryption does MySQL have? I cannot find much security
| information from mysql.com.
|
|
| http://dev.mysql.com/doc/mysql/en/Encryption_functions.html
|
| --
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
If you check wait_timeout value using mysql command-line client, it
takes value for 'wait_timeout' from 'interactive_timeout' variable
which is 28800 by default.
thanks, now i see.
this behaviour is rather strange, isn't it? why are there two
Hi,
I have a problem with selecting / ordering by different criteria from
different tables. Maybe this doesn't even work, or there is a much
better way?
I have the following tables which look like this:
table tartist
++--+--+---+---+
| id | name | info | image | genre |
As a preventive maintenance and the handle fragmentation running a nightly
mysqltablecheck may prove to be beneficial.
-Original Message-
From: Jude Insley
To: [EMAIL PROTECTED]
Sent: 5/21/04 7:10 AM
Subject: RE: Index cardinality lost
After what action are you indexes becoming
Hello
I just installed version 4.0 using the installer. Is there supposed to be a
icon on the desktop for starting up MySQL. If so, what is the name of the
executable?
I have nothing in my programs list or on my desktop.
Thanks,
Andrew
--
MySQL General Mailing List
For list archives:
Hi All
I've xml contents in a column of one table. Inside that xml content, I've
sometime an hardcoded link which I needs to change automatically (lets
say:
from host.domain.com/dev to host2.domain.com)
I'm searching how to build the sql statement to do it but I don't
understand
how to do
Leonardo Francalanci [EMAIL PROTECTED] wrote:
v4.1.2? Where can I get it?
You can install it from development source tree:
http://dev.mysql.com/doc/mysql/en/Installing_source_tree.html
or wait when binaries will be available.
I'll wait for binaries...
At the moment even a
Andrew McHorney [EMAIL PROTECTED] wrote on 21/05/2004 15:32:56:
Hello
I just installed version 4.0 using the installer. Is there supposed to be
a
icon on the desktop for starting up MySQL. If so, what is the name of the
executable?
I have nothing in my programs list or on my
Hi,
Signal 11 can also indicate hardawre problems on BSD. Also FreeBSD
might get you more answers quickly as there are more of us running
FreeBSD with MYSQL for some reason. We runn FreBSD w MySQL/Linux
threads on 4.9 and 5.2 and both work just fine.
Ken
- Original Message -
From: RV
One option:
UPDATE table_name
SET col_name = REPLACE(col_name, 'host.domain.com', 'host2.domain.com')
WHERE some_restriction
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 5/21/04 9:23 AM
Subject: question on data manipulation
Hi All
I've xml contents in a
I've xml contents in a column of one table. Inside that xml content, I've
sometime an hardcoded link which I needs to change automatically (lets
say:
from host.domain.com/dev to host2.domain.com)
I'm searching how to build the sql statement to do it but I don't
understand
how to do this
Test it on 4.1.2 and let me know if these queries will crash MySQL server.
Mmh, I'm afraid I will have to wait for binaries...
When do you think 4.1.2 binaries will be available?
Thank you
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
When you connect to a MySQL server remotely (from the C API, in my
case), is your MySQL password sent in clear text?
I've looked but I can find an answer to this question in the
docs...maybe I'm missing it.
Ron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Thank you all for your reply, it works perfectly.
Gael
Victor Pendleton [EMAIL PROTECTED] wrote on 21/05/2004 16.55.23:
One option:
UPDATE table_name
SET col_name = REPLACE(col_name, 'host.domain.com', 'host2.domain.com')
WHERE some_restriction
-Original Message-
From: [EMAIL
I think we all have missed the opportunity to discuss horizontal scaling
when it comes to links vs. blobs. If you store links in the data then you
gain the ability to use edge caches, secondary file servers, web farms,
file farms, network storage and all of those other high-capacity file
On May 21, 2004, at 5:19 AM, Victor Medina wrote:
| On May 21, 2004, at 1:54 AM, [EMAIL PROTECTED] wrote:
|
| What level of Encryption does MySQL have? I cannot find much
security
| information from mysql.com.
||
| http://dev.mysql.com/doc/mysql/en/Encryption_functions.html
|
Any level of SSL
H Bartel wrote:
I have the following tables which look like this:
table tartist
++--+--+---+---+
| id | name | info | image | genre |
++--+--+---+---+
table programm
++--+---++
| id | date | stage | artist |
++--+---++
Leonardo Francalanci [EMAIL PROTECTED] wrote:
Test it on 4.1.2 and let me know if these queries will crash MySQL server.
Mmh, I'm afraid I will have to wait for binaries...
When do you think 4.1.2 binaries will be available?
Probably it will be out next week.
--
For technical support
Hi All,
I already looking for Autocommit within my.ini at documentation and archives
of the list, and not found.
Anybody can help me?
Thanks in advance,
Renato Cramer
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi all,
Just bought a new server, which was supposed to improve the performance of our app.
The new machine has the same OS (Redhat 8), same MySQL (4.0.18), and same my.cnf.
The problem is that this (frequently run) query, actually runs 41% slower!
select * from LEG L, LEG_DETAIL D,
Don't tell me - you upgraded a PIII server to a PIV server?
The cache on the PIV is les than half the size of a PIII.
We've hit this problem with our own apps that by the way they operate cache
a lot of data. A PIII 1.4GHz will match a 2.4 GHz PIV.
Kevin Cowley
RD
Tel: 0118 902 9099 (direct
Sounds like a tmp drive issue to me. Maybe you had reiserfs on your old tmp
partition and now you have ext3 or something like that.
Donny
-Original Message-
From: Charles, Tony (Exchange) [mailto:[EMAIL PROTECTED]
Sent: Friday, May 21, 2004 12:47 PM
To: [EMAIL PROTECTED]
Subject:
At 8:24 -0700 5/21/04, Ron Gilbert wrote:
When you connect to a MySQL server remotely (from the C API, in my
case), is your MySQL password sent in clear text?
No.
I've looked but I can find an answer to this question in the
docs...maybe I'm missing it.
Abubakr wrote:
I am trying to copy a file stored in longblob column of a table to a
longblod column of another table, can any one tell me what kind of
insert statement should i use for that purpose.
You should be able to insert into your upload table with a select from
your testing table.
At 15:14 -0300 5/21/04, Renato Cramer wrote:
I'm using MySQL 4.1.0 and InnoDB tables.
I need set autocommit=0 and want do via option file.
I know what SET AUTOCOMMIT=0 works fine, however I prefer by the option
file.
Is possible?
In 4.1.0, no. You'll be able to do this in 4.1.2. See the
What I was saying was - everything slows down when it gets bigger. However, a lot of
work has been put into database engines to keep them going fast even when they get
big, whereas file systems slow down considerably when they get bigger.
It's not the storing of the link that's the issue.
Hello list,
I'm not sure this is the correc t list I'm writing to, but I hope so. If
not: sorry.
My problem: I'm writing a DB application (with MySQL, of cause) which
uses the new MySQL 5.0 stored procedured. Unfortunately I couldn't find
any samples or documentation for this topic. The
Hi List,
Is there a way to copy a user in the database's mysql database, so that
it will have the same permissions (GRANTs) within the database? Or does
one have to create a different user and then manually modify the
permissions to match the first?
Thanks,
Jim
--
MySQL General Mailing List
Scott Haneda writes:
My trouble is that the data file could be 100,000 lines in length, I have a
few options:
Scott,
I have a 30 million record dataset that I load into MySQL every couple
of months. To do this propitiously I use the 'LOAD DATA INFILE' syntax.
From your description it should
Anyone know of some large sample data sets available for free or $100?
Large = maybe 1KB per row or so, 1,000,000 - 5,000,000 records or so,
something on the order of a couple hundred megabytes.
Sample Data = I don't really care what it is (text based though, no
need for BLOB), just something
Greg Willits wrote:
On May 20, 2004, at 11:08 AM, Sasha Pachev wrote:
Greg Willits wrote:
I have two mysql apps running on the same machine (OS X 10.3.3). A
mysql 3.23.54 on port 14551, and a mysql 4.0.16 on 3306. Each has a
config file specifying the port and a unique socket name in /tmp.
They
In the last episode (May 21), Greg Willits said:
Anyone know of some large sample data sets available for free or $100?
Large = maybe 1KB per row or so, 1,000,000 - 5,000,000 records or
so, something on the order of a couple hundred megabytes.
Sample Data = I don't really care what it is
Jim Nachlin wrote:
Hi List,
Is there a way to copy a user in the database's mysql database, so that
it will have the same permissions (GRANTs) within the database? Or does
one have to create a different user and then manually modify the
permissions to match the first?
Warning - untested, but
Kevin Cowley wrote:
Don't tell me - you upgraded a PIII server to a PIV server?
The cache on the PIV is les than half the size of a PIII.
We've hit this problem with our own apps that by the way they operate cache
a lot of data. A PIII 1.4GHz will match a 2.4 GHz PIV.
Yes, MySQL code is written
Greg Willits wrote:
On May 20, 2004, at 11:08 AM, Sasha Pachev wrote:
Greg Willits wrote:
I have two mysql apps running on the same machine (OS X 10.3.3). A
mysql 3.23.54 on port 14551, and a mysql 4.0.16 on 3306. Each has a
config file specifying the port and a unique socket name in /tmp.
They
Conveyor:
Serial
10
11
Support
SerialCost
1100
1150
10001200
10001250
Accessory
SerialCost
150
175
10001100
10001200
Desired Result
SerialSupportCostAccessoryCost
10250
Got a problem with my fulltext searches. Here is the structure of the table
as displayed in MySQLyog...
Column Information For - robeson_robesondb.robeson_inv
--
Field Type NullKey Default Extra Privileges
What query are you using to search?
With the FullText indexes you have only two match options are possible:
MATCH(specs) AGAINST . . .
and
MATCH(manufacturer) AGAINST . . .
If you're trying to search both at the same time you need a FULLTEXT
index of (specs,manufacturer)
Chris
Robb Kerr wrote:
Thanx Chris. That was it. To save space, I went ahead and dropped the two
separate indexes because they were no longer needed. The only fulltext
search performed on this database includes both fields.
Thanx again,
Robb
On Fri, 21 May 2004 13:42:21 -0700, Chris wrote:
What query are you using
I only sporadically use newsgroups and choose to use the program 40tude
when I do. I greatly appreciate this group and wish to remain subscribed
but am receiving ALL of the posts as emails. How do I change my preferences
on this board so that I only receive posts when I launch 40tude and
Greg Willits wrote:
Greg Willits wrote:
On May 20, 2004, at 11:08 AM, Sasha Pachev wrote:
Greg Willits wrote:
I have two mysql apps running on the same machine (OS X 10.3.3). A
mysql 3.23.54 on port 14551, and a mysql 4.0.16 on 3306. Each has a
config file specifying the port and a unique socket
Forenote: I have no wish to start an OS debate.
Hello,
I'm in the fortunate position of having a dual 2.8GHz Xeon with 4G of
ram and 4 10k SCSI disks (configured in RAID-10) to deploy as a new
MySQL server.
Since I'm a numbers freak, I've been running super-smack on it for the
last few days to
now the really interesting part is: all other (or at least
a lot of other) accented european characters are being
displayed correctly _only_ german umlauts are allways shown
as question marks.
does anybody care to explain and give me a hint on what
to do. i am completely confused.
The
--- [EMAIL PROTECTED] wrote:
What I was saying was - everything slows down when
it gets bigger. However, a lot of work has been put
into database engines to keep them going fast even
when they get big, whereas file systems slow down
considerably when they get bigger.
It's not the storing
Chris Elsworth wrote:
Forenote: I have no wish to start an OS debate.
Hello,
I'm in the fortunate position of having a dual 2.8GHz Xeon with 4G of
ram and 4 10k SCSI disks (configured in RAID-10) to deploy as a new
MySQL server.
Since I'm a numbers freak, I've been running super-smack on it for
On Fri, May 21, 2004 at 05:18:09PM -0600, Sasha Pachev wrote:
It looks like FreeBSD was using only one CPU from your numbers. Try the
test with only 1 thread and a lot of iterations to avoid the influence of
overhead. I know very little about FreeBSD, but one thing I would check is
if the
Luis - you're quite polite so I'll assume that you are ignorant rather than prejudiced.
You have a university email so I'll also assume you're a student who wants to learn.
So here's your lesson for today: Don't judge people by their cover, or by their color,
or by their name, or by their
Hi all,
I'm using mysql 3.23.54 under RedHat9 trying to update a field named
pac_fone in a table named paciente with the value of a field named
ita_fone from a table named italica as follows:
update paciente
SET pac_fone= (select ita_fone
fromitalica
Luis - you're quite polite so I'll assume that you are ignorant rather
th
an prejudiced.
You have a university email so I'll also assume you're a student who
wants to learn.
So here's your lesson for today: Don't judge people by their cover, or
by their color, or by their name, or by their
Some time ago, I posted a question about using HTML in
MySQL tables. For example, if I put the following in a
table cell...
emCowboy State/em (reinforced by logo depicting
cowboy on bucking bronco), emBig Wyoming/em
It will be displayed as...
Cowboy State (reinforced by logo depicting cowboy on
David Blomstrom wrote:
Some time ago, I posted a question about using HTML in
MySQL tables.
Someone suggested this is a bad strategy, asking what
I would do if I later decided to change the italicized
words to bold, for example.
I'm just trying to figure out what the options are, as
well as
On 05/21/04 20:40 Laercio Xisto Braga Cavalcanti spoke:
Hi all,
I'm using mysql 3.23.54 under RedHat9 trying to update a field named
pac_fone in a table named paciente with the value of a field named
ita_fone from a table named italica as follows:
Try more quotes and get the select to work:
select
--- Hassan Schroeder [EMAIL PROTECTED] wrote:
If Cowboy State has a semantic meaning, like
nickname, you might want to think about either
having a field for it or, if it's part of a text
segment that doesn't lend itself to that, use a
semantic tag for it, like `nicknameCowboy
State/nickname,
--- Hassan Schroeder [EMAIL PROTECTED] wrote:
If Cowboy State has a semantic meaning, like
nickname, you might want to think about either
having a field for it or, if it's part of a text
segment that doesn't lend itself to that, use a
semantic tag for it, like `nicknameCowboy
State/nickname,
David Blomstrom wrote:
You mean I can make up a name for a semantic tag,
designating every nicknname nickname or every
emphasized word emphasize, for example?
Yep, XML lets you create your own DTD/schema -- though sometimes it
makes sense to use (or leverage) an existing one.
And is this something
On May 21, 2004, at 9:14 PM, David Blomstrom wrote:
--- Hassan Schroeder [EMAIL PROTECTED] wrote:
If Cowboy State has a semantic meaning, like
nickname, you might want to think about either
having a field for it or, if it's part of a text
segment that doesn't lend itself to that, use a
semantic
73 matches
Mail list logo