Hello,
since I moved to another dedicated server 1-2 months ago I'm
experiencing big problems with mysql.
Normally the server works fine for a website under heavy load but
after a week or so it hangs in a locked table forever and thus
preventig other processes to access it. Then I have to shut
Hello mysql,
I have two tables - articles_en and articles_ru.
Its fields is 'article', 'author', 'text'.
The difference is - field 'text' in articles_en has english
text of article and field 'text' in articles_ru has russian text of
article. Fields 'article' and 'author' are
Chua Choon Keng [EMAIL PROTECTED] wrote:
What about using binlog-do-db=database_name
option? In this case only updates will be logged if
the current database is database_name
What if I only wish to replicate a few tables of a
database? Using binlog-do-db=database_name does
limit to this
Robert Montgomery [EMAIL PROTECTED] wrote:
I recently upgraded to mysql 4.0.18. In the past you
could set the option safe-show-databases and that
allowed users to list databases, but only those they
have permissions to see. It seems that this 4.0.18
will only allow users to see ALL
Hiep Ho [EMAIL PROTECTED] wrote:
i have problem adding user to mysql. I can create a database and there is no
problem however I got this ERROR 1047: Unknown command when I tried to add
new user. I don't think I have this problem before.
I run this command
GRANT ALL ON *.* TO usename
Dear Victoria Reznichenko,
Thanks for reply.
Could you tell me from where I can get patch to fix
this bug.
or I have to use Mysql 4.0/Mysql 5.0
with regards,
Udbhav Shah
=
Thinking is the Assets
Enterprise is the Way
Hard Work is the Solution
- Ignited Minds
nullevent [EMAIL PROTECTED] wrote:
I have two tables - articles_en and articles_ru.
Its fields is 'article', 'author', 'text'.
The difference is - field 'text' in articles_en has english
text of article and field 'text' in articles_ru has russian text of
article. Fields 'article'
-Original Message-
From: rajesh k [mailto:[EMAIL PROTECTED]
Sent: 23 March 2004 14:36
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Newbie - dependencies Same problem --Plz giv the solution !!
Robb + ( ME TOO )- still in jail :-(
Plz get me out of the jail
j'ai le red hat 9 et j'ai télécharger mysql-3.23.58-pc-linux-i686.tar.gz
j'ai crée le repertoir /usr/local/src et j'ai fais
gunzip mysql-3.23.58-pc-linux-i686.tar.gz
tar xvf mysql-3.23.58-pc-linux-i686.tar.gz
cd mysql-3.23.58-pc-linux-i686
./configure --prefix=/usr/local/mysql
mais ca donnée
Hello,
Am Mittwoch, 24. März 2004 11:01 schrieb sanaâ Aitouchen:
j'ai le red hat 9 et j'ai télécharger
mysql-3.23.58-pc-linux-i686.tar.gz j'ai crée le repertoir
/usr/local/src et j'ai fais
gunzip mysql-3.23.58-pc-linux-i686.tar.gz
tar xvf mysql-3.23.58-pc-linux-i686.tar.gz
cd
Hello colleagues,
I knew there's an option to have a row level locking rather than a table
level one, the innodb_locks_unsafe_for_binlog
I knew also that this option makes the binary logs unsafe
I'd like to know if the whole replication mechanism becomes unsafe in
this case
and then what's the
Hi,
j'ai le red hat 9 et j'ai télécharger mysql-3.23.58-pc-linux-i686.tar.gz
j'ai crée le repertoir /usr/local/src et j'ai fais
gunzip mysql-3.23.58-pc-linux-i686.tar.gz
tar xvf mysql-3.23.58-pc-linux-i686.tar.gz
cd mysql-3.23.58-pc-linux-i686
./configure --prefix=/usr/local/mysql
mais ca
JOHN MEYER [EMAIL PROTECTED] wrote:
Is there a way to do a SQL Select and get a record without specifying the
primary key. Example. I have two tables CANDLE and VOTIVES. Can I define
a select that says SELECT * FROM TABLE WHERE PRIMARY_KEY=...
No, You can't.
Only if PRIMARY or UNIQUE
Bonjour,
For the benefit of the group I will translate the French part of my text :-)
Le tarball que vous avez telecharge est en fait le binaire executable de MySQL
pas les sources. Donc vous n'avez pas a executer configure sur celui-ci.
The tarball that you have downloaded is in fact the
So I can do something like SELECT * FROM . $tablename . WHERE _rowid=
$id (I'm using PHP and the primary key is a unique integer column in each of
the tables).
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: Primary keys
Date: Wed, 24 Mar 2004 13:28:58 +0200
JOHN MEYER
Hello,
Further to my MERGE table query the other day, I've now put it into
action and it seems to be working fine. However I'm noticing that
INSERT LOW_PRIORITY statements are blocking when there are SELECTs
running.
Does anyone know if concurrent inserts work with MERGE tables? Are
there any
On Wed, Mar 24, 2004 at 01:23:53PM +, Chris Elsworth wrote:
I'm wondering if specifying LOW_PRIORITY disables concurrent inserts
explicitly, so I'll try removing that and see if anything improves,
but in the meantime, if anyone has any advice, please share :)
Ignore that bit. Found the
Hi,
I'm trying to compile mysql 4.0.18 with icc 8.0 on RH AS 3u1. I'm
including my last configuration for compiling and how it died- I've
tried about a million other ways- this seems to come the closest to
compiling normally but dies with an internal error(looks like intel's
fault not yours).
4.0.18 is the latest stable!
On Tue, 2004-03-23 at 19:08, [EMAIL PROTECTED] wrote:
Hi,
A quick question, which is the most stable version of mysql to run on a very busy
and commercial website(s)?
4.0 or is 4.1 stable enough?
Thanks,
-R.A
--
Hi!
just add old-passwords to the mysqld section of your mysql server and
recreate the users, it should work just fine!, mysql 4 and up has a new
auth mecanism
Best Regards
On Wed, 2004-03-24 at 00:10, Lokesh wrote:
Gordon wrote:
A few weeks ago I download the windows version for 5.0.0 and
Hi!
On Wed, 2004-03-24 at 09:51, Yonah Russ wrote:
Hi,
I'm trying to compile mysql 4.0.18 with icc 8.0 on RH AS 3u1. I'm
8
GUAO! nice!, let us know how faster it is with the Intel compiler, just
curious! =)
fyi- there is a problem with the configure/libtool script when you don't
compile
Yes, that is the point, there must be a way to view the structure of .frm
files,
I can't believe no one has ever written a utility for this.
if not, its about time! :)
I can't even find any documentation as to the internal structure of .frm files,
there were some vague references going back to
Victor Medina wrote:
Hi!
On Wed, 2004-03-24 at 09:51, Yonah Russ wrote:
Hi,
I'm trying to compile mysql 4.0.18 with icc 8.0 on RH AS 3u1. I'm
8
GUAO! nice!, let us know how faster it is with the Intel compiler, just
curious! =)
An ad in one of the Linux magazines I leaf through on
Victor Medina wrote:
8
must probably no one here uses the Intel compiler since it is paid =(
actually there is a free non-commercial license version here:
http://www.intel.com/software/products/compilers/clin/noncom.htm
which is how I happen to have it
yonah
it dies with this error:
IPO
this is what you are looking for:
http://www.intel.com/software/products/global/techtopics/mysql.pdf
according to intel- mysql ab provided all the performance data- much
more than 20% performance boost sometimes.
I'll be darned if their compiler flags work- maybe with 4.1 (apparently
that's
Hi all,
I have a table of users which contains a lot of information, and also a
column called membershiptype which can either be 0, 1, or 2. This table is
used a lot in various searches, and all results should be ordered by
membership type, but the order should not be 0-1-2, but instead 1-2-0.
It's my understanding that MySQL does not currently compile with the
Intel compiler - it's too gcc-specific, and icc is not 100%
gcc-compatible. I seem to remember seeing this in the on-line
documentation somewhere, but I can't remember where.
Tim
--
Dr Tim Cutts
Informatics Systems Group
Victor Medina wrote:
it dies with this error:
IPO Warning: unresolved : rl_attempted_completion_function
Referenced in ipo_icc5X7oE4.o
IPO Warning: unresolved : rl_completion_entry_function
8
Ncurses devel and the readline libriries must be installed for the
client to compile
On 25 Mar 2004, at 01:14, Chris Nolan wrote:
An ad in one of the Linux magazines I leaf through on occassion showed
some pretty noticable improvements (in the order of 20% in some
cases), but I'm betting that these were crafted test cases, as we all
know that MySQL's two main storage engines
Does the where clause contain the order by columns? If not, then you will have
a filesort no matter what.
On Wed, 24 Mar 2004, Henrik Schröder wrote:
Hi all,
I have a table of users which contains a lot of information, and also a
column called membershiptype which can either be 0, 1, or 2.
Hi,
This a error to install Mysql 4.1in HP-UX
10.20
040324 12:01:50 mysqld started
Warning: One can only use the --user switch if running as root
InnoDB: No valid checkpoint found.
InnoDB: If this error appears when you are creating an InnoDB database,
InnoDB: the problem may be that during
From: Henrik Schröder [EMAIL PROTECTED]
used a lot in various searches, and all results should be ordered by
membership type, but the order should not be 0-1-2, but instead 1-2-0.
One thing you could do (not very neat IMHO) is to JOIN this query with a
table that contains membershiptype and a
Udbhav Shah [EMAIL PROTECTED] wrote:
Dear Victoria Reznichenko,
Thanks for reply.
Could you tell me from where I can get patch to fix
this bug.
or I have to use Mysql 4.0/Mysql 5.0
You can install latest available version, including the bugfix, from the development
source tree:
Let me rephrase my statement. Does the index being used include the order by
columns? If not, the optimizer will not be able to perform both row selection
and row ordering in the same pass.
On Wed, 24 Mar 2004, Victor Pendleton wrote:
Does the where clause contain the order by columns? If not,
Egor Egorov [EMAIL PROTECTED] wrote:
Chua Choon Keng [EMAIL PROTECTED] wrote:
What about using binlog-do-db=database_name
option? In this case only updates will be logged if
the current database is database_name
What if I only wish to replicate a few tables of a
database? Using
On Wed, 24 Mar 2004 15:47:46 +0100, Henrik Schröder wrote:
I have a table of users which contains a lot of information, and
also a column called membershiptype which can either be 0, 1, or 2.
This table is used a lot in various searches, and all results
should be ordered by membership type,
i have download the rpm MySQL-3.23.58-1.i386.rpm, and i install it without
any problems, but when i wont to use Snort en mode NIDS, i use output mysql
in the snort .conf and with this command :
snort -dev -l ./log -h @ip
it gaves me this error:
Error:if this build of snort was obtained as a
On Wed, 2004-03-24 at 10:57, Yonah Russ wrote:
8
make[2]: Leaving directory `/moat-files/mysql-4.0.18/client'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/moat-files/mysql-4.0.18'
make: *** [all] Error 2
any ideas what I'm missing?
thanks
yonah
---8
Something is
no problem-
its a fresh install of RH AS 3u1 (basically the same setup as rh 9)-
minimal installation with one or two rpms from the cds added afterwards
the mysql source tarball is upacked in /moat-files/mysql-4.0.18/
here is my ld.so.conf if it helps
/usr/kerberos/lib
/usr/X11R6/lib
I don't think it does right now, but that can always be taken care of later.
Assuming that the query uses one index that contains all the where-columns
and the orderby-columns, having an ORDER BY that sorts on expressions is
still the biggest problem, right?
/Henrik
-Original Message-
Thanks, I'll have to try that to see if it's faster.
Adding another column as someone else suggested is too complex in comparison
because it forces a bigger code change, and I don't really want that.
Changing one SELECT-statement is enough...
/Henrik
-Original Message-
From: Jigal van
JOHN MEYER [EMAIL PROTECTED] wrote:
So I can do something like SELECT * FROM . $tablename . WHERE _rowid=
$id (I'm using PHP and the primary key is a unique integer column in each of
the tables).
Yes. For example:
mysql CREATE TABLE t1(id int NOT NULL PRIMARY KEY);
Query OK, 0 rows
You are correct.
On Wed, 24 Mar 2004, Henrik Schröder wrote:
I don't think it does right now, but that can always be taken care of later.
Assuming that the query uses one index that contains all the where-columns
and the orderby-columns, having an ORDER BY that sorts on expressions is
still
I assume you are just trying to make things more readable. As far as I
know, MySQL does not support custom sort orders, except when a field is
an enum or a set. Even then, that's not a custom order since your still
sorting on the underlying values.
You could do something like this for
Hi,
you could try something like:
INSERT INTO articles_multi(article,author,text_ru,text_en )
SELECT e.article,e.authoer,r.text,e.text
FROM articles_en e, articles_ru r
WHERE e.article = r.article
AND e.author = r.article
/Johan
nullevent wrote:
Hello mysql,
I have two tables -
I have a series of tables that were created by:
CREATE TABLE ifInOctets (
id int(11) NOT NULL default '0',
dtime datetime NOT NULL default '-00-00 00:00:00',
counter bigint(20) NOT NULL default '0',
KEY ifInOctets_idx (dtime)
);
When I
The optimizer is informing you that `it` believes a table scan is more
efficient than using an index due to the resultset size.
On Wed,
24 Mar 2004, Jack Coxen wrote:
I have a series of tables that were created by:
CREATE TABLE ifInOctets (
id int(11) NOT NULL default '0',
Not sure if this is the place to post this but...
I'm trying to build super-smack-1.2 on freebsd 4.9 w/ MySQL 4.0.18 and am
running into the following problems. Below are configure, make and gmake
output:
[EMAIL PROTECTED] /usr/local/src/build/super-smack-1.2$ ./configure --with-mysql
creating
Hello,
I am urgently trying to restore a mysql database that was corrupted when
upgrading from OSX 10.3.2 to 10.3.3. I have tried downloading MySQL 4.0.14
and coping the original data files for the db into the appropriate data
directory, but the datetime fields are still corrupted. Does anyone
Dan,
Try the following
(0) Make sure you have the .frm files backed up
(1) If you have foo.frm, delete foo.* from the data directory, then create
a new MyISAM table. Doesn't matter what's in it. E.g., create table foo (x
int).
(2) Copy your saved .frm file back instead of the one just
Great! Thanks for the help.
Here is some more info, in case it's helpful- these are all the compile
warnings from the make:
my_thr_init.c(67): warning #266: function declared implicitly
pthread_mutexattr_setkind_np(my_fast_mutexattr,PTHREAD_MUTEX_ADAPTIVE_NP);
^
...
icc: Command line
Is their a way of using
insert into newtablename select * from oldtablename where ID=xxx
But with an aditional column in newtablename
V!nay
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I need to get totals for the data in my database. I stumbled upon the
WITH ROLLUP modifier
(http://www.mysql.com/doc/en/GROUP-BY-Modifiers.html) and it appears to
be exactly what I'm looking for, except for the fact that when I try to
use it I get the following message:
This version of
Is there a way of changing what it believes? The resultset size is only a
few thousand lines.
And, btw, why does it believe that a table scan is more efficient than using
an index?
Jack
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 24,
At 10:19 -0800 3/24/04, Craig Gardner wrote:
I need to get totals for the data in my database. I stumbled upon
the WITH ROLLUP modifier
(http://www.mysql.com/doc/en/GROUP-BY-Modifiers.html) and it appears
to be exactly what I'm looking for, except for the fact that when I
try to use it I get
I've installed MySQL and started the server with:
mysqld_safe
I've confirmed the server is running with:
ps -ef | grep mysql
and
mysqladmin status
--
I'm trying to connect using:
shell mysql -u root -p
It says 'command not found' - I find the mysql command location and
Optimizers work on a thirty percent rule. If the resultset will contain thirty
percent of the table then a table scan will be performed. If you want to
`force` the use of an index you can use the `USE INDEX index-name` syntax.
You also should look at your query. You have three criteria in your
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
This error should be logged. Do you have a file called hostname.err
in your
directory?
Yes I have a file called hostname.err and that error is not in it.
From: Paul DuBois [mailto:[EMAIL PROTECTED]
The error log is for messages pertaining
At 13:24 -0500 3/24/04, Kevin Carpenter wrote:
I've installed MySQL and started the server with:
mysqld_safe
I've confirmed the server is running with:
ps -ef | grep mysql
and
mysqladmin status
---
I'm trying to connect using:
shell mysql -u root -p
It says 'command not
I tried using 'USE INDEX' and 'BETWEEN' but it didn't change anything.
EXPLAIN SELECT counter, UNIX_TIMESTAMP(dtime) FROM ifInOctets_137
USE INDEX (dtime) WHERE id=2809 AND dtime BETWEEN FROM_UNIXTIME(107397)
AND FROM_UNIXTIME(1076734799) ORDER BY dtime;
At 12:40 -0600 3/24/04, Daniel Gaddis wrote:
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
This error should be logged. Do you have a file called hostname.err
in your
directory?
Yes I have a file called hostname.err and that error is not in it.
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Hello Jack,
Wednesday, March 24, 2004, 6:50:45 PM, you wrote:
JC I tried using 'USE INDEX' and 'BETWEEN' but it didn't change anything.
JC EXPLAIN SELECT counter, UNIX_TIMESTAMP(dtime) FROM ifInOctets_137
JC USE INDEX (dtime) WHERE id=2809 AND dtime BETWEEN FROM_UNIXTIME(107397)
JC AND
Very straightforward if the new column is NULLable OR has a deterministic
value, e.g.
INSERT INTO newtable (col1, col2)
SELECT col1, 1 FROM oldtable WHERE ID = xxx
Or if NULLable:
INSERT INTO newtable (col1)
SELECT col1 FROM oldtable WHERE ID = xxx
Equally you could populate 'col2' from an
The index is on dtime only. I've done some testing and dual-column indexes
using id and dtime are significantly faster. However, I'm not one of the
developers of this package - RTG. I have reported the speed increase to
them, though.
In the meantime, I'm trying to run a standard system so I'm
Hi List,
Ok, I'm a moron... problem solved:
Should have been:
grant CREATE TEMPORARY TABLES ...
and not
grant Create_tmp_table_priv ...
Well atleast this is now in the archives for search engines to pick up on...
I swear I sat there for 10 minutes thinking Should I clutter the list
Hi!
OK, i have installed a fresh RH9 (i had the cd's here, altough i use a
SuSE 9 and Debian). I downloaded a fresh copy of mysql 4.0.18 and 4.1
(just to try).
I installed a complete develompent environment (gcc, bison, yacc, m4,
etc etc) and it compiles cleanly, again; with gcc, I will
Henrik Schröder wrote:
Hi all,
I have a table of users which contains a lot of information, and also a
column called membershiptype which can either be 0, 1, or 2. This table is
used a lot in various searches, and all results should be ordered by
membership type, but the order should not be
Hi,
I would like to know the latest version of MySQL that was qualified on
Unixware 2.1.3.
Thanks,
Raghu Udupa
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
From: Paul DuBois [mailto:[EMAIL PROTECTED]
I suppose you could consider it such, but on the other hand, it's not
the
sort of error that prevents the server from running or processing
other
queries. In any case, logging it to the error log isn't going to help
the client know what is going
Can you do:
SELECT
IF(membershiptype = 0, 3, membershiptype) AS s1
FROM...
ORDER BY s1
Shouldn't that work? Basically if mtype is 0 return 3 otherwise return
the membership type... and sort by that field.
lemme know if that works or if I'm dead wrong ;)
Henrik Schröder wrote:
Hi all,
Consider the following schema and data:
CREATE TABLE person (pid INTEGER, name CHAR(5));
CREATE TABLE phone (pid INTEGER, num CHAR(10));
INSERT INTO PERSON VALUES (1, 'Bob');
INSERT INTO PERSON VALUES (2, 'Jane');
INSERT INTO PHONE VALUES (1, '12345');
INSERT INTO PHONE VALUES (1, '23456');
From: Paul DuBois [mailto:[EMAIL PROTECTED]
I don't understand that second sentence, but you can submit
feature requests at http://bugs.mysql.com/
For example, I would like the error log to look something like...
MySQL: ready for connections.
Version: '4.0.18-max-nt-log' socket: '' port:
Jack
you must have a compound index in your table:
ALTER Table ifInOctets_137 add INDEX i_id_dtime(id,dtime);
In your SELECT statement, change
USE INDEX (dtime)
to
USE INDEX (i_id_dtime)
Let us know how it works.
David
-Original Message-
From: Jack Coxen [mailto:[EMAIL
On 22 Mar 2004, at 18:24, Tim Cutts wrote:
Some users' code is causing MySQL's memory use to explode. By the
time we reach about 200 simultaneous connections, the MySQL server is
using 8GB of virtual memory, and then falls over (the machine is an
AlphaServer ES45 with 8 GB of physical memory,
On Wed, 24 Mar 2004, Raghu Udupa wrote:
I would like to know the latest version of MySQL that was qualified on
Unixware 2.1.3.
The last version I tested was MySQL-3.22.X. It would compile and run.
You may be able to get recent version of MySQL to work. You will need to
edit configure.in to
I'm not a big mysql expert but I think mysql has some buffers which it
keeps per connection
here are some examples (from mysql website):
/
/If you have complex queries |sort_buffer_size| and |tmp_table_size| are
likely to be very important. Values will depend on the query complexity
and
Hello Gurus,
Anyone have any ideas as to how I should handle a case of the following
error?
040324 21:02:05 Slave I/O thread: connected to master
mailto:'[EMAIL PROTECTED]:3306' '[EMAIL PROTECTED]:3306', replication
started in log 'saturn2-bin.051' at position 442744915
040324 21:02:05 Error
News-
I have compiled mysql 4.1.1-alpha with the icc compiler using the
options intel reported in their case study pdf.
specifically '-O3 -ip -unroll2'
The compilation was pretty ugly and threw up a lot of warnings.
I'm benchmarking now and I'll let you know what comes out of it.
yonah
Yonah
Right now, we are planning to install MySQL 4.0.17-standard (latest
production version) on Solaris and Linux servers. We may want to access
MySQL from unixware 2.1.3 nodes.
If we install mySQL 3.22.X on Unixware nodes, will I be able to access MySQL
db server running 4.0.17 on Solaris/Linux
When running mysql from the command line (Putty terminal) and trying to do
some updates the updates fail. First the query I am running -
mysql update warranty_temp, warranty_old set
warranty_old.OwnerName=warranty_temp.OwnerName where
warranty_old.WarrantyID between 75 and 100 AND
Is there any way to have a single select statement that can do a join
across two databases on the same server?
Thanks
select
db1.table.field, db2.table.field
where
db1.table.someotherfield = db2.table.someotherfield
Peter
-Original Message-
From: Ed Reed [mailto:[EMAIL PROTECTED]
Sent: 24 March 2004 23:45
To: [EMAIL PROTECTED]
Subject: Query across two databases on the same server
Is there
At 16:51 -0500 3/24/04, Raghu Udupa wrote:
Right now, we are planning to install MySQL 4.0.17-standard (latest
production version) on Solaris and Linux servers. We may want to access
MySQL from unixware 2.1.3 nodes.
Latest 4.0.x version is 4.0.18.
If we install mySQL 3.22.X on Unixware nodes,
[EMAIL PROTECTED] wrote:
Hello,
since I moved to another dedicated server 1-2 months ago I'm
experiencing big problems with mysql.
Normally the server works fine for a website under heavy load but
after a week or so it hangs in a locked table forever and thus
preventig other processes to access
[EMAIL PROTECTED] wrote:
Not sure if this is the place to post this but...
I'm trying to build super-smack-1.2 on freebsd 4.9 w/ MySQL 4.0.18 and am
running into the following problems. Below are configure, make and gmake
output:
[EMAIL PROTECTED] /usr/local/src/build/super-smack-1.2$ ./configure
Hi
I have problem with a Query.
It does not recognize EXISTS.
My version is MySQL 4.0.11a-gamma
The query is:
SELECT U.usu_id, U.usu_login
FROM cva_usuario U
WHERE NOT EXISTS (SELECT * FROM cva_grupo_usuario GU WHERE GU.usu_id=U
usu_id Where GU.gru_id=4)
Help please.
I have a rather heavily loaded server, which I would like to tweak a
little more performance out of. It currently is binlogging although
there is no slave yet. Does the process of bin logging take significant
resources? It's putting out about 1GB log per day, the IO load on the
disks isn't too
At 21:44 -0400 3/24/04, WebMaster Informática007 wrote:
Hi
I have problem with a Query.
It does not recognize EXISTS.
My version is MySQL 4.0.11a-gamma
Subqueries are supported beginning with MySQL 4.1.0.
http://www.mysql.com/doc/en/Subqueries.html
J'ai réinstaller le site web de notre association qui a été réalisé avec
SPIP 1.6 sur un serveur dédié . J'ai du changer l'emplacement et le nom
de la base de donnée et je n'arrive plus a rentrer dans le site. Si je
vai a l'adresse suivante : http://www.ligue-echo.org/ecrire/
Je reçois le
At 17:55 -0800 3/24/04, Jim Richardson wrote:
I have a rather heavily loaded server, which I would like to tweak a
little more performance out of. It currently is binlogging although
there is no slave yet. Does the process of bin logging take significant
resources? It's putting out about 1GB log
On Wed, Mar 24, 2004 at 08:21:15PM -0600, Paul DuBois wrote:
At 17:55 -0800 3/24/04, Jim Richardson wrote:
I have a rather heavily loaded server, which I would like to tweak a
little more performance out of. It currently is binlogging although
there is no slave yet. Does the process of bin logging
Not using perl or php I came up with:
mysqlshow -u user --status db_name | awk -F| '{print $2,$5}' | grep -i pattern
Is there a query to do the same thing?
_
Douglas Denault
[EMAIL PROTECTED]
Voice: 301-469-8766
Fax: 301-469-0601
--
MySQL General Mailing List
For list archives:
I install (mysql control center) over the w2k server when I try connect the mysql
this message is show
[EMAIL PROTECTED]:3306] ERROR 1130: Host '217.219.201.2' is not allowed to connect to
this MySQL server”
please help me.
Thank you
-
Do you
Jigal van Hemert wrote:
The continuing saga:
Can't connect to MySQL server on '192.168.13.205' (4)
Our sysadmin has been searching in the sources of the MySQL client and came
up with this:
The errormessage (4) is probably (only place where this error could be
found) raised by this fragment in
A Z wrote:
here we go:
explain select * from properties where reference like
'%2332'
The above query cannot use the index on reference in either MyISAM or InnoDB
case. However, with MyISAM it will hurt less because you are scanning a plain
data file instead of a B-tree.
Suggestion for a
Paul DuBois wrote:
At 21:44 -0400 3/24/04, WebMaster Informática007 wrote:
Hi
I have problem with a Query.
It does not recognize EXISTS.
My version is MySQL 4.0.11a-gamma
Subqueries are supported beginning with MySQL 4.1.0.
http://www.mysql.com/doc/en/Subqueries.html
Stanton, Brian wrote:
Shortly after the MySQL 4.0 line went to production, I upgraded to mysql
4.0.12. Since then my slave has been getting corrupted tables 2 to 3 times
every month. I've also seen this problem in mysql 4.0.13. When I run a
check table on the table in question it gives the
John McCaskey wrote:
The master pushes data to the slave as soon as it has executed the query
itself. It is not a periodic push, but an asyncrounous push as soon as
data is ready to be sent. So the gap would only be as great as the
latency between your two servers.
If the servers are
Matt Sturtz wrote:
Hello--
We're using Red Hat's cluster manager (RH AS 2.1, MySQL 4.0.16 RPM). Due
to a problem within the cluster software that we're working on with Red
Hat, the cluster fails over from one node to the other sometimes when it
shouldn't (one node will reboot, services will fail
Tim Cutts wrote:
On 22 Mar 2004, at 18:24, Tim Cutts wrote:
Some users' code is causing MySQL's memory use to explode. By the
time we reach about 200 simultaneous connections, the MySQL server is
using 8GB of virtual memory, and then falls over (the machine is an
AlphaServer ES45 with 8 GB of
1 - 100 of 103 matches
Mail list logo
