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 someone
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 '
Rhino wrote:
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 columns se
- 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
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 f
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.%';
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
>
> P
- 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.%'
-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
> 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 app
- 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
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 test.
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 w
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:
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
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 an
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 tha
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 k
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 :::
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
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 to
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).
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 /* Headers for MySQL usage */
#include
#include
#include
// #define INSERT_STATEMENT "INSERT INTO patient (idno,first,last,medrec)
VALUES(NULL,?,?,
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=true&characterEncoding=UTF-8
to the db connection string solved the problem
chris
-Original Message-
From: MySQL [mailto:[EMAIL PROT
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)
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 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 from
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 fulltte
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 the
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 to
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 t
[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,
con
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 Inn
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 st
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 directly
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?
Thanks.
- 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: Ask
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: "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 stu
"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 https://order.mysql.com
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 changed>0;
> | table | type | possible_key
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 = 'c:\\f
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 thi
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 r
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
"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 n
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
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 sub
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 http://www.ensi
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 suppo
[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.
"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 thi
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: "ERRO
"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
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 webs
"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 th
> 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 advi
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 ho
58 matches
Mail list logo
