>
> GRANT INSERT, DELETE, UPDATE, SELECT ON *.* TO @'%'
> IDENTIFIED BY ''; FLUSH PRIVILEGES;
>
yes. no diffrence. Specifying '%' or no host doesn't work for me.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTEC
"GRANT insert,delete,update,select on phonewatch.* to [EMAIL PROTECTED] identified by
''" works.
"GRANT insert,delete,update,select on phonewatch.* to datatal identified by
''" do not.
Can someone please test this and verify if it's a bug?
> -Ursprungligt meddelande-
> Från: Nathaniel M
yes, its gone in 4.0.16
> -Ursprungligt meddelande-
> Från: Victoria Reznichenko [mailto:[EMAIL PROTECTED]
> Skickat: den 23 oktober 2003 21:12
> Till: [EMAIL PROTECTED]
> Ämne: Re: Tablecrash
>
>
> "Datatal AB - Gauffin, Jonas" <[EMAIL PROTECTED]> wrote:
> >
> > I got a table that cra
On Tue, Oct 21, 2003 at 05:22:07PM -0400, Gabriel Ricard wrote:
> Someone recently asked about Gemini tables on this list and it got me
> curious about what ever happened to that technology... NuSphere still
> seems to exist, and they still sell their PHPEd product along with the
> "NuSphere Tec
How to save binary files to mysql ? I want to save *.exe whole in a binary files,
after that I want to save it to mysql. thanks
-
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
On Thu, Oct 23, 2003 at 07:30:55PM +0200, Angel Todorov wrote:
> Hello list,
>
> Can you tell me when approximately is the 5.0 version of MySQL going
> to be released? Thanks.
Probably not. MySQL doesn't have a fixed release schedule.
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, L
I am relatively new to mysql, latex, and linux in
general. I have created a small table of about one
hundred entries that I would like to print out as a
table in a latex document. The form of the latex file
needs to be something like:
"field1 & field2 & field3 \\ \hline"
As I am a novice please pro
hi..
i'm currently learning mysql and interesting to
constraint, relational and check function.
could anyone give some example please ?
any help is appreciated.
thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EM
I have a field in the table, call it 'stuff', and it contains a list
of values that are comma separated. i.e. 'Books,DVDs,Video
Tapes,CDs'
I want to SELECT out all records that have an item. I know IN works
the other way, so is there something that will get what I want like
this:
SELECT * FROM
hi , and thanks for your answer,
> On Mon, Oct 20, 2003 at 07:03:37PM +0200, Benjamin KRIEF wrote:
>> the problem is that it's quite impossible to fine tune the load between
>> the servers , and my slave is a bit too busy , so the replication thread
>> is becoming very slow , and sometimes , i can
Hello,
one more idea, use something like this [ i hope it's correct :) ]
SELECT
content.row_id AS row_id,
content.app_id AS app_id,
CASE s1.field_id
when 69 then "niche",
when 70 then "type",
when 71 then "title",
when 72 then "descr
Hello,
I think I have found a bug in the MySQL 4.1.1 C Binding API with inserting
NULL values using the bind API. Can someone please send me an address that
I can send a test case to the MySQL development staff so they can take a
look at it?
Alternatively can someone tell me if this is the appro
Have you tried:
GRANT INSERT, DELETE, UPDATE, SELECT ON *.* TO @'%'
IDENTIFIED BY '';
FLUSH PRIVILEGES;
On Thu, 2003-10-23 at 21:03, Nathaniel Mallet wrote:
> I was having the same problems trying to get a user added to a new DB, so
> here's are the commands I used:
>
> GRANT INSERT, DELETE, UPD
I was having the same problems trying to get a user added to a new DB, so
here's are the commands I used:
GRANT INSERT, DELETE, UPDATE, SELECT ON *.* TO @localhost IDENTIFIED
BY '';
FLUSH PRIVILEGES;
where and are whatever you need it to be.
I've never had much luck with % as host, so specify
Thanks everyone for your input, I'll try the ramdisk idea, I read about
someone else who tried that and had some success. Beyond, that I'm gonna
take the long route and redesign the database to be a bit more
conventional.
Thanks!
Matt
On Thu, 2003-10-23 at 20:28, Peter Buri wrote:
> Hello,
>
> a
Hi, i have this form that goes directly.. to a database. I have some clients
who dont use english. If they enter on a form a special russion or chinese
character will mysql translate it properly?
-- -
Louie Miranda
http://www.axishift.com
--
MySQL General Mailing List
For list archives: http:
Hello,
as i see you use one table to store all the data, but the cohesive data are
split into 15! different rows.
I think to get the best performance you shoud redesign your tabel.
Use at last first normal form [1NF], if the app_id is uniq this can be the
primary key [which will speed up the quer
At 02:05 PM 10/23/2003, you wrote:
Hey All-
I am trying to improve the speed of a website and was wondering if
anyone had any ways I can rewrite these queries so that they actually
run with some descent speed.
Its a really nasty query and I'm not sure where to start, I'd like to
now have to redo t
Hi Trevor,
I think that query might work as-is in MySQL 4.1. However, the current
production version doesn't support subqueries. Your query can be
rewritten with a join like this I think:
SELECT C.*, COUNT(*) AS LINK_COUNT FROM Categories C
INNER JOIN Links L ON (L.CAT_ID=C.CAT_ID AND L.LINK_APPR
Hi
This query used to work with an Access database:
SELECT *, (SELECT COUNT (*) FROM Links WHERE Links.CAT_ID =
Categories.CAT_ID AND LINK_APPROVED = 'Yes') AS LINK_COUNT FROM
Categories ORDER BY CAT_NAME ASC
Now that we've upgraded to MySQL, the same ASP script returns this
error:
ADO
Glancing at the query, I'm already under the impression that it should
be broken up into multiple queries and code should be used to simulate
the behavior. I find that this method is faster for mysql and a bit more
portable for developers in my opinion.
Other then what is stated above I would have
Hey All-
I am trying to improve the speed of a website and was wondering if
anyone had any ways I can rewrite these queries so that they actually
run with some descent speed.
Its a really nasty query and I'm not sure where to start, I'd like to
now have to redo the tables and I already put some i
(Sorry for the last email, it's not complete).
Hello Heikki,
Sorry, but I didn't understand the concept of tablespace applied. It's
different from Oracle, right?
AFAIK, tablespace is utilized to logically group "tables" into one (or more)
files.
And to group "indexes" into another files...
But
Hi Group,
I am looking for the data modelling tool which should incorporate the
generalization/specialization feature of database design. Does anyone know better tool
for it? So far i have tried datanamic and case studio but none of them has above
mentioned feature.
Thanks
Hardik Doshi
-
Hello Heikki,
I didn't understand the concept of tablespaces utilized,
- Original Message -
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, October 22, 2003 12:00 PM
Subject: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1
>
Hi Sergei,
More full-text questions from me since I just noticed your code and doc
changes. :-)
What does this new WITH QUERY EXPANSION syntax do? More relevant
results? More flexible? Faster? Is it for NLQ, boolean, or both (since
both ft_[nlq | boolean]_search.c are changed)? Does it have somet
At 02:37 PM 10/23/2003, you wrote:
I thought I read a message on this list that said you can't use full text
indexes with InnoDB yet. Can anyone confirm that?
- Gabriel
On Thursday, October 23, 2003, at 11:50 AM, Travis Reeder wrote:
I'm sure this has been asked before, but after seeing some b
Thanks. I was thinking about using stunnel.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 23, 2003 3:41 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: ODBC Encryption?
What you've seen is what you get. None.
Try tunneling through
At 09:54 AM 10/23/2003, Andrew Braithwaite wrote:
Hi,
Does anyone know of any good mysql tutorials online that would suit someone
who has a computer science degree but knows nothing about MySQL.
Pointers will be most welcome.
Cheers,
Andrew
Andrew,
Try one of these MySQL tutorials:
http://www.m
What you've seen is what you get. None.
Try tunneling through SSH. Try this link to learn more:
http://www.cs.kuleuven.ac.be/system/security/ssh/tunnel.shtml
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTE
I thought I read a message on this list that said you can't use full
text indexes with InnoDB yet. Can anyone confirm that?
- Gabriel
On Thursday, October 23, 2003, at 11:50 AM, Travis Reeder wrote:
I'm sure this has been asked before, but after seeing some benchmarks,
it looks like using inn
It's actually "Cartesian Product", the result of a query like select * from
table1, table2; where you get all the virtual tuples (rows or relations)
that represent the set of each tuple in table1 coupled with each tuple in
table2. I good way to get all possible combinations of the records fro
FYI, PHP will automatically convert the data type to an integer if to
use increment it like that. Just like if you had $var = 123; and then
did $var .= "foo" it would be converted into the string "123foo". If
you're still unable to change the value of $myrow, then I would consult
the PHP mailin
"Will Tyburczy" <[EMAIL PROTECTED]> wrote:
>
> I've unable to load data from files into existing tables. When I give the command:
> mysqlimport [database] [filename] I keep getting the following error.
>
> mysqlimport: Error: Can't get stat of '[filename]' (Errcode: 13), when using table:
> [ta
Check file permissions.
The file must be readable by the user 'mysql'.
Will Tyburczy wrote:
I've unable to load data from files into existing tables. When I give the command: mysqlimport [database] [filename] I keep getting the following error.
mysqlimport: Error: Can't get stat of '[filename]' (
Are you sure you don't have any errors in your SQL? Maybe your query
returns a karthesian product - and this might kill your J2EE
application.
Check out your slow-log - the query is probably there.
--
Per Andreas Buer
Thanks for your response Per. Yes, the query is at my slow-log, I already
know
"Datatal AB - Gauffin, Jonas" <[EMAIL PROTECTED]> wrote:
>
> I got a table that crashes everytime that I use "delete from
> hvd_layout_settings"
>
> This is a infinite loop:
>
> while (1)
> {
> check table hvd_layout_settings = table ok
> delete from hvd_layout_settings
> check table hvd_layout
I've unable to load data from files into existing tables. When I give the command:
mysqlimport [database] [filename] I keep getting the following error.
mysqlimport: Error: Can't get stat of '[filename]' (Errcode: 13), when using table:
[table]
I get a similar error when trying to use LOAD DAT
On Wednesday, Oct 22, 2003, at 14:21 Europe/Brussels, Harald Fuchs
wrote:
In article <[EMAIL PROTECTED]>,
Jerry Rocteur <[EMAIL PROTECTED]> writes:
Hi,
I'm reading MySQL by Paul DuBois
When I run dump_members.pl I get:
Use of uninitialized value in join or string at ./dump_members.pl line
35.
On Wednesday, Oct 22, 2003, at 14:21 Europe/Brussels, Harald Fuchs
wrote:
In article <[EMAIL PROTECTED]>,
Jerry Rocteur <[EMAIL PROTECTED]> writes:
Hi,
I'm reading MySQL by Paul DuBois
When I run dump_members.pl I get:
Use of uninitialized value in join or string at ./dump_members.pl line
35.
Oh, sorry about that. I think I read it a bit too quickly...
You can't that I'm aware of, besides getting the table list and using an
external script to loop through them.
But, of course, I definitely could be wrong.
Chris
-Original Message-
From: Patricia LaRue [mailto:[EMAIL PROTECTED
"Filip Rachunek" <[EMAIL PROTECTED]> writes:
> Hello,
> can somebody tell me what the status "Writing to net" returned by "show
> processlist" exactly mean? I've tried to find it in MySQL documentation but
> either it's not there or I missed it.
> I am asking because this status is usually shown w
Chris:
Your syntax and all documented syntax is for querying column names in just one table.
My question is "How do I search for a specific column name in ALL tables?
Chris <[EMAIL PROTECTED]> wrote: SHOW COLUMNS FROM table_name LIKE 'Identifier';
should work.
It's all in here, jsut search t
This site:
http://www.everydaysoftware.biz
Has a complete MySql and Html development environment running on the browser
site itself, with debug, edit, run capability.
To gain access to the development environment, click Develop on the left from
of the opening page.
The environment is writ
SHOW COLUMNS FROM table_name LIKE 'Identifier'; should work.
It's all in here, jsut search the page for SHOW COLUMNS:
http://www.mysql.com/doc/en/Show_database_info.html
Chris
-Original Message-
From: Patricia LaRue [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 23, 2003 11:02 AM
To:
I have a database with about 40 tables that contains 'object data'.
These objects are loaded from files, so have an associated file.
Different files can contain the same object and be 'loaded'
simultaneously, but there can only be one instance of any object
at any one time. The active object is de
In Oracle it looks like this:
SELECT table_name
FROM all_tables
WHERE column_name = 'Identifier'
Does anybody know if this is possible in MySQL and if so, what's the syntax? I can't
find anything in the documentation that allows me to search for a specific column in
all tables.
Thank you,
Patr
Hello list,
Can you tell me when approximately is the 5.0 version of MySQL going
to be released? Thanks.
--
Best regards,
Angel mailto:[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://li
In the last episode (Oct 24), Chris Nolan said:
> The answer is actually quite simple!
>
> There are a few reasons:
>
> 1. Features.
>
> Each table type has something over the other. While InnoDB has transactions,
> foreign keys, hot backup capabilities, consistant read and better write
> concu
The answer is actually quite simple!
There are a few reasons:
1. Features.
Each table type has something over the other. While InnoDB has transactions,
foreign keys, hot backup capabilities, consistant read and better write
concurrency (for many situations), MyISAM has FULLTEXT indexes, the
opt
Hello,
I developed a small C client on RH Linux 7 with MySql 3.xx.
In the past I upgraded to RH 9 and MySql 4.0.12 and the program doesn'l link.
It give a linker error:
undefined reference to `__gxx_personality_v0'
in every mysql_* function i call.
How can I solve this problem?
Santino
--
MySQL
Well I probably can tweak the queries, but there are a LOT of them. It
is for http://www.ecommstats.com so we get a TON of requests that have
to processed with probably ~20 queries (selects, inserts, updates), then
there is a maintenance program that runs every few minutes to clean
things up a
I'm sure this has been asked before, but after seeing some benchmarks,
it looks like using innodb is a no brainer. Just want to know why you
wouldn't use innodb?
Travis
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EM
Hi
Have you tried using mysql_connect instead of mysql_pconnect? Does it make
any difference?
Rory McKinley
Nebula Solutions
+27 82 857 2391
[EMAIL PROTECTED]
"There are 10 kinds of people in this world,
those who understand binary and those who don't" (Unknown)
- Original Message -
From
New to SQL or new just to MySQL?
-Original Message-
From: Andrew Braithwaite [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 23, 2003 10:54 AM
To: [EMAIL PROTECTED]
Subject: Online Tutorials for beginners
Hi,
Does anyone know of any good mysql tutorials online that would suit someone
"Tuncay Baskan (Yaz.Muh.-Proje Gel.ve Uyg.Gr.)" <[EMAIL PROTECTED]> wrote:
> When I run LOAD DATA it sometimes notices that there were some warnings. For example;
>
> mysql> LOAD DATA LOCAL INFILE './2003-01/MKR_OCAK.txt' INTO TABLE quantis_mkr;
> Query OK, 271392 rows affected (4 min 2.95 sec)
>
Wednesday, October 22, 2003, 11:23:45 AM, Pey Ling wrote:
PL> Hi, thanks for your prompt reply and articles.
PL> Emmm... If i have a static IP, i can set this [EMAIL PROTECTED], am I
PL> right?
Yes.
PL> what is the different between [EMAIL PROTECTED] and [EMAIL PROTECTED]
[EMAIL PROTECTED] me
i implemented a very simple subquery using 'IN' and i
get the same message
"Dissertation] ERROR 1235: This version of MySQL
doesn't yet support 'LIMIT & IN/ALL/ANY/SOME
subquery'"
other subqueries DO work, but i cant get one to work
with 'IN'
__
I may be missing something, but wouldn't a substring(bigdata, 0,instring("--header
end--")) suffice? Of course, my syntax is all kinds of wrong... but you get the
idea...
> -Original Message-
> From: Jan Magnusson [mailto:[EMAIL PROTECTED]
> Sent: Thursday, October 23, 2003 10:56 AM
> T
I think he is looking for a way to just retrieve some data prior to a
specific (although dynamic) point of the full data saved in a longtext
datatype column.
Like retrieving just the header of email messages saved with attachments etc
in a longtext column.
Perhaps having that header data saved in
Hi,
Does anyone know of any good mysql tutorials online that would suit someone
who has a computer science degree but knows nothing about MySQL.
Pointers will be most welcome.
Cheers,
Andrew
Sql, query
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscri
Can you tell us, when you plan to release 4.1.1 version ?
A few weeks ago, Heikki guess was: ...before Nov 15th, 2003.
And how it looks now ?
Best regards,
ML
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTE
I don't understand well. Are you looking for the MAX value of a column? Or
its data size?
Thanks
Emery
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 23, 2003 12:21
Subject: making specific query for big data
> Hello all..
>
> so
> Is it p
It does,
I executed the following and it worked:
SELECT * FROM table1
WHERE (field1, field2) IN (SELECT field1, field2 FROM table2)
I think your problem is that you used constants (1,2,3) instead of using
fields.
Also I don't know if the fields don't need to be of the same type.
I just need to ch
Well, once they are avialable, triggers and/or stored procedures may be your answer,
however, most trigger design (don't know about MySQL's forthcoming implementation)
won't let you modify the same table on an update or insert, as you could end up in an
infinite loop very easily.
For now, I th
Hi Rob,
Definitely trying to do a value swap.
Regards,
David
--- Rob <[EMAIL PROTECTED]> wrote: > Are you
trying to do a value swap or are you just
> updating? If you are
> updating you could simply do
>
> UPDATE table
> SET DEFG = 11,
> HIKJ = 12
>
> -Original Message-
> From: Mumba
Hi,
Is there any way to automatically update several rows
as a result of a change to information being changed
in another row in the same table?
|--|---|
| NAME | VALUE |
|--|---|
| ABCD | 10|
| DEFG | 12|
| HIJK | 11|
|--|---|
So if I changed DEFG to 11, how
http://www.dbmail.org
Curtis
On Wednesday 22 October 2003 13:29, the council of elders heard Apollo
(Carmel Entertainment) mumble incoherently:
> I was wondering if there is an opensource mail server (IMAP, not
> POP) that would keep all the messages in a MySQL database, not in a
> regular file
Have you tried casting the $myrow element to integer e.g
$increase = (int)$myrow['first'] + 1;
I think PHP will return the field as text by default and hence the addition
will fail..
Rory McKinley
Nebula Solutions
+27 82 857 2391
[EMAIL PROTECTED]
"There are 10 kinds of people in this world
> > I know I can issue "show tables" to give me a list of
> tables from the
> > current database, how can I do the same thing with
> temporary tables?
> > That is, is there a command to list the current temporary tables?
>
> You can't.
RATS!!!
Jeff
> -Original Message-
> From: Egor
At the moment MySql indexes only plain text.
You have to convert your document to text and then insert the text
into the column.
Santino
At 9:50 +0200 23-10-2003, Jan-Erik Öhman wrote:
Hi,
has anybody done full-text indexing of pdf and word documents stored in TEXT
columns?
I could find no refere
Hello all..
so
Is it possible to do this:
make query on mysql
ask to select from blabla where bigdata=
but tell to get only all data before --header end-- string into it
so it will give in result only strings what are found before --header end--
becouse after this string goes very big data
Ok.
I'm stumped. If I'm reading the manual correctly, you were right about not
hving to specify the host..the only difference between your version and the
manual is that they use single quotes around the user name but I can't see
how that makes any difference. I normally just specfiy hosts because
it works if I specify the host. Why doesn't % work as host?
> -Ursprungligt meddelande-
> Från: Rory McKinley [mailto:[EMAIL PROTECTED]
> Skickat: den 23 oktober 2003 11:56
> Till: Datatal AB - Gauffin, Jonas
> Ämne: Re: GRANT problem
>
>
> thinking.
>
> In one of your follow up po
in version 4.1 states it supports subqueries like
SELECT * FROM t1 WHERE (1,2,3) IN (SELECT a,b,c FROM
t2);
it doesn't support 'IN'
[Dissertation] ERROR 1235: This version of MySQL
doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
___
> Not sure if this will help - in your GRANT statement do you
> not need to specify a host for the user e.g. GRANT.. to
> datatal @ your_host_name.?.
>
>
GRANT uses % as host if none is specified.
% = all hosts.
any other ideas?
--
MySQL General Mailing List
For list archives: http://
Hi Jonas
Not sure if this will help - in your GRANT statement do you not need to
specify a host for the user e.g. GRANT.. to datatal @
your_host_name.?.
Rory McKinley
Nebula Solutions
+27 82 857 2391
[EMAIL PROTECTED]
"There are 10 kinds of people in this world,
those who understand bina
Note that REPLACE deletes before inserting!! Very dangerous.
If you cannot use UPDATE ON DULICATE KEY UPDATE ...
then do the following:
You will need o send two queries to the server:
INSERT IGNORE INTO tbl ..;
UPDATE tbl SET ..;
Explanation:
- the first query will try to insert the r
yep. but that does only apply when using INSERT INTO, right?
GRANT should do that by itself?
anyway, it didn't help. didn't help to restart mysqld either.
mysql> select * from db where user='datatal';
+--++-+-+-+-+-+-
My application is designed to avoid concurency rows locking. It means that I
should never access two rows at the same time during a transaction. I also
get an error messgage when I insert a row. Here is the error message I get:
java.sql.SQLException: General error, message from server: "Deadlock
Maybe I am stating the obvious but instead of typing
mysql -username root -p
try :
mysql -u root -p
HTH
Rory McKinley
Nebula Solutions
+27 82 857 2391
[EMAIL PROTECTED]
"There are 10 kinds of people in this world,
those who understand binary and those who don't" (Unknown)
- Original Message
Additional info:
the user is added to mysql.user with no privileges.
the user is added to mysql.db with insert,update,delete,select privileges on
phonewatch db.
When I try to connect to the db, "C:\mysql\bin\mysql phonewatch -h ts2test -u datatal
-pMYPASSWORD", I get "ERROR 1045: Access denied
"Jeff McKeon" <[EMAIL PROTECTED]> wrote:
> I know I can issue "show tables" to give me a list of tables from the
> current database, how can I do the same thing with temporary tables?
> That is, is there a command to list the current temporary tables?
You can't.
--
For technical support contra
Hi,
has anybody done full-text indexing of pdf and word documents stored in TEXT
columns?
I could find no reference to which documents formats that are supported by
MySQL.
I know that DB2, Oracle and SQL Server have restrictions on supported
document formats, so I asume that there are restrictio
"William IT" <[EMAIL PROTECTED]> wrote:
> I try convert this MS SQL Statement but an error occurs:
>
> UPDATE a SET a.ACCOUNT_CODE=b.ACCOUNT_CODE
> FROM a,b
> WHERE a.ACCODE=b.ACCOUNT_OLD
>
> Is there any syntax doing same as above?
>
Yes. From v4.0.4 you can do:
UPDATE a, b
On Mon, Oct 20, 2003 at 07:03:37PM +0200, Benjamin KRIEF wrote:
> hi guys,
>
> i've just finished implementing replication on 2 production servers.
[snip]
> the problem is that it's quite impossible to fine tune the load between
> the servers , and my slave is a bit too busy , so the replication
On Tue, Oct 21, 2003 at 10:13:55AM -0700, Greg(Bear) Casad wrote:
>
> All installations of mysql I have run ps -fax will show about 5
> mysql proccess running, even at idle.
mysql or mysqld?
> I compiled on a Redhat 9 box, it did find pthreads however ps
> -fax show 1 mysqld process running.
Hi list,
I've just a crazy problem with Mysql 4.0.15
(mysql-standard-4.0.15-pc-linux-i686.tar.gz).
I have 2 user, root and Dstats.
With root, i can do all i want (create database, create table ...).
With Dstats i can't create table in a database.
My Grant :
grant all privileges on Dstats_Stats.*
On Tue, Oct 21, 2003 at 08:59:31PM -0600, Travis Reeder wrote:
> It seems mostly to be mysql pinned, not the app. like 99% mysql until
> all data is processed and keeps going up when data coming in is more
> than can be processed.
So MySQL is using 99% of the CPU?
Any idea why? Are you doing
I try convert this MS SQL Statement but an error occurs:
UPDATE a SET a.ACCOUNT_CODE=b.ACCOUNT_CODE
FROM a,b
WHERE a.ACCODE=b.ACCOUNT_OLD
Is there any syntax doing same as above?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysq
Hi list,
I think i've found a little bug in MySQL 4.0.15
(mysql-standard-4.0.15-pc-linux-i686.tar.gz)
Description :
Here's my error log :
Warning: thr_alarm queue is full
Warning: thr_alarm queue is full
[...]
How To Repeat :
Here's my conf file :
[client]
port= 3306
socket
Hello,
I have a broken table (all the INSERTs cause error 'Duplicate entry for key
1: '). When I run 'REPAIR TABLE tablename' it repairs table fine,
but after the short period of thme since the repair process has been run,
other mysql cliens start receiving the error "Too many connections". It
sto
Hello
I've created an account by using:
GRANT insert,update,select,delete on phonewatch.* to datatal identified by 'MYPASSWORD'
I cant connect(mysql.exe or myodbc) to the db with the new account, and I did not
receive any errormessages when creating the account. Have I forgot something?
Med vän
On Thu, Oct 23, 2003 at 08:48:04AM +0200, Angel Todorov wrote:
> Hello list,
>
> What is the current replication implementation in mysql: sync or
> async or both are supported?
It's async in 3.23, 4.0, 4.1, and 5.0.
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<
94 matches
Mail list logo
