-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Sat, 4 Sep 2004, Paul DuBois wrote:
Yes, it works for me, but we shouldn't have to do that, right?
Right. I'm trying to gather information about the problem so it can be
fixed.
Sorry about that - I uploaded mysql-4.1.4a-gamma.tar.gz
Hi all
just a simple question ! what is bulk update anyway ?
I already googling aroung , and cant find satisfying answer
I'm interesting in it because my application use intensively
update/insert/select
real-timely .. i think this 'bulk update' can improve
perfomance/throughput
also an example
From: [EMAIL PROTECTED]
Date: Sun, 5 Sep 2004 22:39:39 -0500 (CDT)
Subject: Re: Storing foreign characters in DB
I am not using 3.xx versions anymore, but if I remember correctly they
only allow a limited control for setting character sets.
In order to be able to give you any advice you
Sun, Jennifer [EMAIL PROTECTED] wrote:
l consuming all my RAM and swap and being killed with error=20
'VM: kill=
ing process mysql
__alloc_pages: 0-order allocation failed (gfp=3D0x1d2/=
0)'
I would like to find a startup parameter either for client or serv=
er to limit per thread memory
Michael Winston [EMAIL PROTECTED] wrote:
Okay, so the first thing to try is obviously enlarge the
max_connections.
Have you tried this?
Yes. It's set to 400 (a number we will never reach unless there's some
sort of logjam). max_connect_errors is set to 200.
Is it a webserver backend
Tucker, Gabriel [EMAIL PROTECTED] wrote:
I have been searching the archives and was unable to find an answer.
I need the ability to backup MySQL instances directly to a tape device.
Currently, I run a mysqldump to disk and have legato pick up the file. =
As I get to some larger
Osmin Castillo [EMAIL PROTECTED] wrote:
I'm having some problems connecting to the server under Winx XP with
the openssl certificates. Checking the have_openssl variable says
YES. When i try to connect with a user with the REQUIRE SSL grant I
can't loggin and receive this error: ERROR 1045:
Danesh Daroui [EMAIL PROTECTED] wrote:
I have installed Server, Client, Benhcmark, Share, Embeded and =
Compact-Share RPMs version 4.1 on a Fedora2 system. The have been =
installed successfully but when I type:
Shell mysql -u root
it says that it can not open socket and I think it is
[EMAIL PROTECTED] wrote:
I have been using mysql 3.23.58, and I want to upgrade to 4.0.20. My question is
this: after I run the script to upgrade the grant tables to support the new
privilgeges, can I then revert back to 3.23.58 seamlessly or will I need to readjust
the grant tables.
zzapper [EMAIL PROTECTED] wrote:
Is it possible to have undeletable/unmodifiable records in a table of otherwise
modifiable
deleteable createable records?
At present I do it at the Update/Delete level where I have clauses which prevent
certain records
being changed. I suppose I could
Stuart Felenstein [EMAIL PROTECTED] wrote:
InnoDB free: 10240 kB
Does this mean the actual space provided for the
records it can hold ?
Approximately.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net
Hi Everyone. My problem is that i want to create 2 instances of a
sub-query. For Example:
SELECT DISTINCT V4.* FROM (SELECT v2.* FROM cell v1,cell v2 WHERE v1.name
= 'reviews' AND v2.sal = v1.sal ) v3 , v4
This query will gives an error as V4 is not allowed, i.e. not more than 1
instance of a
Andrew Wheeler [EMAIL PROTECTED] wrote:
I am not sure that this is the correct list. I did not
see any list that seemed more appropriate.
I have RedHat 8:
gcc-3.2-7
You'd better take the binary distribution from www.mysql.com
Compiling MySQL is absolutely not a configure; make; make
Igor Zinkovsky [EMAIL PROTECTED] wrote:
error log:
040902 21:47:53 mysqld started
040902 21:47:53 [ERROR] Warning: Asked for 196608 thread stack, but got
126976
/usr/sbin/mysqld: Can't create/write to file '/root/tmp/ibezxsoi'
(Errcode:
13)
mysql does not have permission to write to
Ari, what's the result of
mysql -N -e SHOW VARIABLES; | grep 'ft_min_word_len'
? Default is 4 but you need to reduce this to 3 (or even to 2, if you
want to match first_name against('Al')).
Regards, Thomas Spahni
On Sun, 5 Sep 2004, Ari Denison wrote:
Hello list -
I'm trying to do a
MySQL 4.0.14
Trying to run a select statement on field (varchar)
containing values (e.g. ':', '/', '\') returns blank
recordset although records exist.
select * from table1 where field1 =
'c:\folder\filename.extension'
Is there any particular rule to follow. I inserted
the same row twice and
Hello, I have a strong need/desire to use group_concat but I don't/can't run
4.1 right now. There is MyGroupConcat
http://www.codeproject.com/useritems/MyGroupConcat.asp
And I have no problem creating a .so on FreeBSD but I have a server running
OSX and I'm not familiar with shared code on
A Z [EMAIL PROTECTED] wrote:
Trying to run a select statement on field (varchar)
containing values (e.g. ':', '/', '\') returns blank
recordset although records exist.
select * from table1 where field1 =
'c:\folder\filename.extension'
try
select * from table1 where field1 =
Dave Dyer [EMAIL PROTECTED] wrote:
Before I post it as a bug, perhaps someone can explain why
this query is not optimized to use the index (it has to examine all 287k rows).
mysql explain SELECT MAX(changed) FROM archived_stats where changed0;
| table | type | possible_keys | key
bayufa [EMAIL PROTECTED] wrote:
also an example how to do a bulk update/insert would be nice :)
insert into tralivali (field1,field2) values
(1,2),
(3,4),
('smoke','on'),
('the','water);
--
For technical support contracts, goto
- Original Message -
From: Ari Denison [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, September 06, 2004 1:15 AM
Subject: Full Text Stopwords
Hello list -
I'm trying to do a full text search for the the string May using
the following query:
SELECT * FROM students WHERE
Ladies, gentlemen,
Upscene Productions is happy to announce the next
version of the popular database development tool:
Database Workbench 2.5.0 has been released today!
Download a trial at: http://www.upscene.com
Features and fixes: http://www.upscene.com/news/20040906.htm
Database Workbench
- Original Message -
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, September 06, 2004 1:21 PM
Subject: Re: MySQL 4.1.4 RPM Distribution startup problem
error log:
040902 21:47:53 mysqld started
040902 21:47:53 [ERROR] Warning: Asked for 196608 thread
Hello,
I would like to limit database sizes on my server on a per user basis.
I haven't really found any information about this in the manual, neither
in the list archive or on the web.
Is there a way to do this?
If mysql doesn't support this natively, is there maybe a third party
patch?
I have seen people dump the database with mysqldump and then use a cpio
command to write the files to the tape device...
-Erich-
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: Monday, September 06, 2004 4:35 AM
To: [EMAIL PROTECTED]
Subject: Re: Backing up
Ari Denison wrote:
Hello list -
I'm trying to do a full text search for the the string May using
the following query:
SELECT * FROM students WHERE MATCH(first_name) AGAINST(May);
There are a number of students in that table wit the first_name of May.
And, yes, I've removed may from the
Well, actually, there are 2.878 Meg rows, or 2878k.
What's happening is that it's using the index to find all of the rows where
changed 0, then scanning for the maximum. If you just look for the
maximum, then discard it if it's not greater than 0, it will be much faster.
The following with
[EMAIL PROTECTED] wrote:
Hello,
I have two questions:
1. I have a table defined as follows
*
create table MATABLE (
ID INTEGER not null,
FK INTEGERnot null,
We have built an alternative save restore process. First we take all of the
.frm files and build
select * into outfile '/path/tablename.txt' from tablename
statements. We also dump the structure only and put it in the same
directory. This runs much faster than myysqldump and every
Michael Stassen wrote:
Amer Neely wrote:
Both scripts, which reside in the same directory on the server, are
run through the web browser. And they do access the same database, and
the same tables.
So, same web server, same mysql server, same connection settings. Good.
Does phpmyadmin connect
the ft_min_word_length is now set to 3. That did the trick. Many thanks.
I forgot to mention that I need to be able to perform boolean searches
on the first_name field.
If it's possible to do boolean searching on a normal index, should I be
doing that instead of using a fullttext?
Thanks for
Ari Denison wrote:
the ft_min_word_length is now set to 3. That did the trick. Many thanks.
I forgot to mention that I need to be able to perform boolean searches
on the first_name field.
If it's possible to do boolean searching on a normal index, should I be
doing that instead of using a
John Nichel wrote:
Hi, I'm trying to select data from a couple of tables with the same
query. Easy right? Well it's driving me crazy. I'm passing an integer
via an html form, using php to grab it, and insert it into the query
(albumSongs.albumID = 1), to where I want to grab all the data
Sticking with the May example... I would like to be able to return
results for only students named May or Maya, but not Mayra,
Jessica-May, or Maylita.
The other example would be simple wild cards. Something like steve*
returns steve, steven, cody-steven, Stevenmikel, steve-allen.
Thanks for
What do you do in the situation where your data has spaces in it?
Since select into outfile space seperates columns, any columns you
have with spaces in the data will not import correctly. Exampl:
mysql create table t (name varchar(100), address varchar(100));
Query OK, 0 rows affected (0.01 sec)
Not sure whether this is applicable to your version of mysql, or to PHP.
I had the same problem using Macromedia's Coldfusion, and adding this:
useUnicode=truecharacterEncoding=UTF-8
to the db connection string solved the problem
chris
-Original Message-
From: MySQL [mailto:[EMAIL
Hello
I'm getting a segmentation fault in the mysql function mysql_real_escape_string
and I don't have a clue why. What am I missing?
#include mysql.h /* Headers for MySQL usage */
#include stdio.h
#include stdlib.h
#include string.h
// #define INSERT_STATEMENT INSERT INTO patient
Is there a way to create a linked mysql table?
I have one master database, which has a table of data I would like to use
with three other projects,
I want to try to avoid copying the data between three databases, or putting
everything in one database,
(which could have data protection problems).
Michael Stassen wrote:
Amer Neely wrote:
Both scripts, which reside in the same directory on the server, are
run through the web browser. And they do access the same database, and
the same tables.
So, same web server, same mysql server, same connection settings. Good.
Does phpmyadmin connect
At 01:50 PM 9/4/2004, you wrote:
This is an issue I have seen many people ask over the last year or two,
but I can't say I've ever seen a comprehensive answer (searched the
archives heavily, too).
I realize there are no binaries available directly from MySQL with OpenSSL
support compiled in. I
Hello. My dilemma is: which of the two is more complex(i mean the time
complexity)
1 single join of n tables having t tuples each amounting to t^n tuples
preceded by one Select * statement; OR
n joins of 2 tables having t tuples each amounting to n*t^2 tuples
n Select * statements
Question :::
If my company wants to get the best-performing fastest platform for a
MySQL server, what would it be these days? Opteron? Dual? Quad?
And on a related note...
If a 64-bit CPU, then I'm assuming it would need an operating system
designed for that 64-bit CPU, to get best performance, right?
I
Hi,
I'm trying to upgrade my mysql 4.1.0 to 4.1.4
For this purpose I've uninstalled the server and client
and after installing the new version I've had this error on the log
040902 21:47:53 mysqld started
040902 21:47:53 [ERROR] Warning: Asked for 196608 thread stack, but got
126976
Despite
did you get an answer to your problem yet? If not I may be able to help..
Andrew
From: Jeff McKeon [mailto:[EMAIL PROTECTED]
Sent: Fri 03/09/2004 15:29
To: [EMAIL PROTECTED]
Subject: Slave replication problem
Hello all,
We had a power outage this morning
Hi keep getting this error ERROR 1017: Can't find file: *.MYI.
What i did is simple , archived all the database files et placed them on a new
server (i should have done a dump)
Now i can do a desc of all the table but i can't select any data from my
tables.
Is there any way to recreate all
Hey Rob,
If all the databases are on the same server you can point to every table
just with DB_name.Tablename if you have the permissions.
Best Regards
Alejandro
-Mensaje original-
De: Rob Keeling [mailto:[EMAIL PROTECTED]
Enviado el: Lunes, 06 de Septiembre de 2004 01:22 p.m.
Para:
Your index files appear to have disappeared during your archive. You
can rebuild them though. Have a look at the Table Maintenance and
Crash Recovery section of the manual:
http://dev.mysql.com/doc/mysql/en/Table_maintenance.html
Pay particular attention to the REPAIR TABLE syntax. That will
I would prefer that 'jdoe'@'192.168.%' not be able to grant DELETE to
other users...but I do want him to be able to grant SELECT. Is that
possible?
- - - - - - - - - - - - - - - - - - - -
GRANT SHOW DATABASES ON *.* TO 'jdoe'@'192.168.%' IDENTIFIED BY 'uhoh';
GRANT SELECT, INSERT, UPDATE
ON
- Original Message -
From: Mark C. Stafford [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Monday, September 06, 2004 6:42 PM
Subject: Without grant option?
I would prefer that 'jdoe'@'192.168.%' not be able to grant DELETE to
other users...but I do want him to be able to
Sure, simply write two grants:
GRANT SELECT, INSERT, UPDATE
ON test.* TO 'jdoe'@'192.168.%' WITH GRANT OPTION;
GRANT DELETE
ON test.* TO 'jdoe'@'192.168.%';
Rhino
Thanks, Rhino...but the only difference between what you suggest and
what I did seems to be where the linefeed appears in
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Bill, et al --
...and then Bill Easton said...
%
% Well, actually, there are 2.878 Meg rows, or 2878k.
FYI, you're both right. Americans write numbers as x,xxx,xxx.xx while
Europeans typically write them as x.xxx.xxx,xx (dot as thousands
separator
- Original Message -
From: Mark C. Stafford [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Monday, September 06, 2004 7:11 PM
Subject: Re: Without grant option?
Sure, simply write two grants:
GRANT SELECT, INSERT, UPDATE
ON test.* TO 'jdoe'@'192.168.%' WITH GRANT
On September 6, 2004 18:33, V. M. Brasseur wrote:
Your index files appear to have disappeared during your archive. You
can rebuild them though. Have a look at the Table Maintenance and
Crash Recovery section of the manual:
http://dev.mysql.com/doc/mysql/en/Table_maintenance.html
Pay
On Mon, 6 Sep 2004 19:53:17 -0400, Rhino [EMAIL PROTECTED] wrote:
I just assumed it might work the
same in MySQL.
That's where I started as well, Rhino. Here is a simplified version
what I did, line for line:
mysql /* never heard of him, right? */
- SHOW GRANTS FOR 'jdoe'@'192.168.%';
Ari Denison wrote:
Sticking with the May example... I would like to be able to return
results for only students named May or Maya, but not Mayra, Jessica-May,
or Maylita.
With a definite list, you can
SELECT * FROM students WHERE first_name IN ('May', 'Maya');
This would use a simple index on
- Original Message -
From: Mark C. Stafford [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Monday, September 06, 2004 11:11 PM
Subject: Re: Without grant option?
On Mon, 6 Sep 2004 19:53:17 -0400, Rhino [EMAIL PROTECTED] wrote:
I just assumed it might work the
same in
Rhino wrote:
snip
Regardless of what appears in the Grant tables, do the permissions work the
way you want them to if you give the privileges the way I suggested? I gave
some privileges to a new userid yesterday (in MySQL) and found that the User
table showed the userid but had all the grant
Mark C. Stafford wrote:
On Mon, 6 Sep 2004 19:53:17 -0400, Rhino [EMAIL PROTECTED] wrote:
I just assumed it might work the
same in MySQL.
That's where I started as well, Rhino. Here is a simplified version
what I did, line for line:
mysql /* never heard of him, right? */
- SHOW GRANTS FOR
Hello all.
We're having a few problems with mysql, innodb seems to be stalling and
then causing a restarts at random times. I've looked through some of the
old posts and seen stuff similar to this with causes ranging from
incorrect memory setting to kernel problems.
So I was hoping that
59 matches
Mail list logo