Is the table you 're talking about critical ?
If not, you could use type=HEAP for it, so every access will be done in
memory.
Marc.
-Message d'origine-
De : Jim Richardson [mailto:[EMAIL PROTECTED]
Envoye : jeudi 25 mars 2004 04:17
A : [EMAIL PROTECTED]
Objet : Re: Speeding up MySQL serv
Tim,
- Original Message -
From: "Sasha Pachev" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Thursday, March 25, 2004 7:04 AM
Subject: Re: Mystifying mysqld memory usage explosion
> Tim Cutts wrote:
> >
> > On 22 Mar 2004, at 18:24, Tim Cutts wrote:
> >
> >>
> >> Some us
Marc Boorshtein wrote:
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
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
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
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 disconnected
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 follo
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
http://www.mysql.com/doc/
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 workaro
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
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 Yaho
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: http:/
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
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 pe
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 messag
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
http://www.mysql.com/doc/en/Nutshell_4
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 bad.
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.
[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
[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 it
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, will
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
Is there any way to have a single select statement that can do a join
across two databases on the same server?
Thanks
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 warranty_tem
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 server
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 Ru
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
'[EMAIL PROTECTED]:3306', replication
started in log 'saturn2-bin.051' at position 442744915
040324 21:02:05 Error in Log_event::read_log_event():
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 availab
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
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,
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
> 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
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');
INSER
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,
> 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 go
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]
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 0-1-2
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 download
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 wit
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,
I hate to bother the list with what should be a simple question but I've been unable
to get this
to work or find anything on mysql.com or google.
I need to grant :
Create_tmp_table_priv
on a particular database.
As root (mysql user) I tried :
grant Create_tmp_table_priv on mydatabas
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 expr
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> A
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 .err
in your
directory?
Yes I have a file called .err and that error is not in it.
From: Paul DuBois [mailto:[EMAIL PROTECTED]
The error log i
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 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 foun
> From: Victor Pendleton [mailto:[EMAIL PROTECTED]
> This error should be logged. Do you have a file called .err
in your
directory?
Yes I have a file called .err and that error is not in it.
> From: Paul DuBois [mailto:[EMAIL PROTECTED]
> The error log is for messages pertaining to problems
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 ` syntax.
You also should look at your query. You have three criteria in your where clause
i
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 con
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
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, 2004
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 MyS
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]
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 wa
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 created
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
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 ca
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
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 r
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 - articles_
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 readabili
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
> s
"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 O
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
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-
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
/usr/local
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<
So
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 bi
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
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?
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,
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 tr
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 an
Hi,
This a error to install Mysql 4.1 in 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
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
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
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
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
Wel
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.
Cur
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 what
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
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
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 ve
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
> com
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.
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,
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).
D
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 th
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 c
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
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 eex
"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
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
>
>
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 m
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 mysql-3.2
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 l'erre
-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
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 'ar
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
__
"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
1 - 100 of 104 matches
Mail list logo
