Hey,
happy new year and I do have a question what might be the best way to
migrate some different databases to a new central server.
The question came up as I wanted to put our web CMS database on our
newer master/slave mysql installation.
We run red hat el 4 and 5 right now, so the source db is
Benching
Somebody knows why 4.1 is faster than 5.0 mysql versions
Ing. Jaime Fuentes R.
997500459
2421905-2423252
Enviado desde mi BlackBerry de Claro.
-Original Message-
From: Brent Baisley
Date: Tue, 2 Jun 2009 12:32:39
To: Ray
Cc:
Subject: Re: Question about query - can this be d
:56 AM 5/5/2009, dimitar nen4ev wrote:
Hi
I am using Mysql 4.1 on
CPU 2 Xeon 3.0 Ghz + 2 Virtual (Hyperthreads) (I
think it is not using the 2nd processor)
Memory 4GB
I think that the read from the HDD is 50mb per 1 sec, but I am not sure.
I have very big problem with performance,
because the
M 5/5/2009, dimitar nen4ev wrote:
Hi
I am using Mysql 4.1 on
CPU 2 Xeon 3.0 Ghz + 2 Virtual (Hyperthreads) (I
think it is not using the 2nd processor)
Memory 4GB
I think that the read from the HDD is 50mb per 1 sec, but I am not sure.
I have very big problem with performance,
because there are
Hi
I am using Mysql 4.1 on
CPU 2 Xeon 3.0 Ghz + 2 Virtual (Hyperthreads) (I think it is not using the 2nd
processor)
Memory 4GB
I think that the read from the HDD is 50mb per 1 sec, but I am not sure.
I have very big problem with performance, because there are very bad search
queries, but
Hi all,
I'm looking for information about References attribute in Mysql, help me!
thanks in advance.
Bo
mario henriquez wrote:
> hi, i got a problemas in mysql with suse 10 enterprise server, the error:
>
> #1064 - You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for the right syntax to use near ''
> at line 1.
>
> when i treat to create a new d
hi, i got a problemas in mysql with suse 10 enterprise server, the error:
#1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near ''
at line 1.
when i treat to create a new data base, appears this message.
pleas
I recently ran across
http://www.mysql.com/news-and-events/newsletter/2004-01/a000303.html and
thus http://xquark.objectweb.org/. It appears that is will only work with
4.0 and I'm using 4.1.x. I've never installed MySQL, but I could attempt to
install a newer version is something works with
huh. it's a varchar(50) on table1 and a varchar(50) on table2. i
wonder why explain is reporting 150 as key_len?
utf8?
yes. that does make sense.
is there anything else i can investgate?
Do you need utf8? :-)
yes. it's an internationalized application :)
Check your cache hits. I can'
Russell Uman wrote:
Baron Schwartz wrote:
I don't think it will be any better to count distinct values. I think
the query is just slow because the index lookups are slow. Is the
'word' column really 150 bytes?
huh. it's a varchar(50) on table1 and a varchar(50) on table2. i wonder
why exp
Baron Schwartz wrote:
I don't think it will be any better to count distinct values. I think
the query is just slow because the index lookups are slow. Is the
'word' column really 150 bytes?
huh. it's a varchar(50) on table1 and a varchar(50) on table2. i wonder why
explain is reporting 150
I don't think it will be any better to count distinct values. I think
the query is just slow because the index lookups are slow. Is the
'word' column really 150 bytes? That's probably the culprit. How slow
is this, by the way? 370k rows in one table, verifying the
non-existence of index re
There's no "using distinct", but there is "not exists", and in fact no rows are
returned. Slow query log reports "#Query_time: 94 Lock_time: 0 Rows_sent: 0
Rows_examined: 370220"
EXPLAIN:
id select_type table type possible_keys key
key_len ref rows
Hi,
Russell Uman wrote:
howdy.
i trying to find items in one table that don't exist in another.
i'm using a left join with a where clause to do it:
SELECT t1.field, t2.field FROM table1 t1 LEFT JOIN table2 t2 ON t1.word
= t2.word WHERE t2.word IS NULL;
both tables are quite large and the q
howdy.
i trying to find items in one table that don't exist in another.
i'm using a left join with a where clause to do it:
SELECT t1.field, t2.field FROM table1 t1 LEFT JOIN table2 t2 ON t1.word =
t2.word WHERE t2.word IS NULL;
both tables are quite large and the query is quite slow.
the f
hello,
There is something I obviously missed, can't figure out what, since it
seems so simple.
as user root (of mysql),
mysql> use mysql;
I can see :
mysql> select * from columns_priv where User='demandeur' order by Column_name;
and I get :
+--+---+--+---+-
MAIL PROTECTED]>
To: "ViSolve DB Team" <[EMAIL PROTECTED]>
Cc:
Sent: Friday, February 09, 2007 6:54 AM
Subject: Re: revoke SELECT on a column [ MySQL 4.1 ] + column "Comment"
Hello,
thanks again to ViSolve DB Team.
so, it turns out that for MySQL4.1, il will h
Hello,
thanks again to ViSolve DB Team.
so, it turns out that for MySQL4.1, il will have to built a sql file,
built with script (shell or perl).
[ note that so far I use MySQL 4.1 on production
server, and I only test features on MySQL 5 on an other machine linux
Debian].
at last, my LAST
et i=i+1;
end while;
end;
mysql> call g(hide_this_col);
Thanks
ViSolve DB Team.
- Original Message -
From: "Gilles MISSONNIER" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, February 07, 2007 9:26 PM
Subject: Re: revoke SELECT on a column [ MySQL 4.1 ] + column privileg
MISSONNIER" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, February 06, 2007 11:05 PM
Subject: revoke SELECT on a column [ MySQL 4.1 ]
Hello,
In a table [say t100], having 100 columns,
I want to allow the select on all columns but 1.
I tried to do this by granting all columns in the table t100
- Original Message -
From: "Gilles MISSONNIER" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, February 06, 2007 11:05 PM
Subject: revoke SELECT on a column [ MySQL 4.1 ]
Hello,
In a table [say t100], having 100 columns,
I want to allow the select on all columns but 1.
I tried to do t
Hello,
In a table [say t100], having 100 columns,
I want to allow the select on all columns but 1.
I tried to do this by granting all columns in the table t100, of the base,
then revoke SELECT on the column "hide_this",
but this doesn't work.
mysql> GRANT SELECT ON the_base.t100 to 'a_user'@'lo
On Wed, 2006-08-23 at 22:23 +0200, spacemarc wrote:
> Hi,
> I have a query like this:
>
> SELECT table1.*,(
> SELECT COUNT( field2 )
> FROM table2
> WHERE id=10
> ) AS total
> FROM table1
> GROUP BY id
> LIMIT 1
>
> but the subqueries do not work with mysql
ut the subqueries do not work with mysql < 4.1. How can I convert it
(or make to work) in MySQL 3.x, 4.0 possibly in one only query?
thanks
--
http://www.spacemarc.it
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Hi,
I have a query like this:
SELECT table1.*,(
SELECT COUNT( field2 )
FROM table2
WHERE id=10
) AS total
FROM table1
GROUP BY id
LIMIT 1
but the subqueries do not work with mysql < 4.1. How can I convert it
(or make to work) in MySQL 3.x, 4.0 possibly in one only query?
thanks
--
h
Amir Bukhari wrote:
-Original Message-
From: Addison, Mark [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 18, 2006 1:22 PM
To: Amir Bukhari; mysql@lists.mysql.com
Subject: RE: Backup problem from 5.0 to mysql 4.1
From: Amir Bukhari Sent: 18 July 2006 09:23
I have local mysql 5.0
> -Original Message-
> From: Addison, Mark [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 18, 2006 1:22 PM
> To: Amir Bukhari; mysql@lists.mysql.com
> Subject: RE: Backup problem from 5.0 to mysql 4.1
>
> From: Amir Bukhari Sent: 18 July 2006 09:23
> >
From: Amir Bukhari Sent: 18 July 2006 09:23
>
> I have local mysql 5.0 and I have developed an arabic site.
> The database
> encoding is utf8-bin. Localy everything work fine, all arabic text are
> displayed OK.
> Now I want to move it to a server in internet. The server ha
I have local mysql 5.0 and I have developed an arabic site. The database
encoding is utf8-bin. Localy everything work fine, all arabic text are
displayed OK.
Now I want to move it to a server in internet. The server has mysql 4.1 and
as I restored the database there, some special arabic character
Cheers Dan. Exactly what I needed :)
Iain
Dan Trainor wrote:
Iain Conochie wrote:
Afternoon,
Apologies if this has been discussed before, I could not find a
reference of it. So here we go :)
Currently, I have a need to get a mysql 4.0 client to talk to a
mysql 4.1 database. The
Iain Conochie wrote:
Afternoon,
Apologies if this has been discussed before, I could not find a
reference of it. So here we go :)
Currently, I have a need to get a mysql 4.0 client to talk to a mysql
4.1 database. The error message I get is
ERROR 1251: Client does not support
Afternoon,
Apologies if this has been discussed before, I could not find a
reference of it. So here we go :)
Currently, I have a need to get a mysql 4.0 client to talk to a
mysql 4.1 database. The error message I get is
ERROR 1251: Client does not support authentication protocol
erver, as the manual recommends for major
upgrades?
PB
rao
- Original Message -
From: "Peter Brawley" <[EMAIL PROTECTED]>
To: "prathima rao" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, June 19, 2006 6:57 PM
Subject: Re: error in copy data from mysql 4.1 to
er Brawley" <[EMAIL PROTECTED]>
To: "prathima rao" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, June 19, 2006 6:57 PM
Subject: Re: error in copy data from mysql 4.1 to mysql 5.0 server
prathima rao wrote:
hello every one,
i have two mysql servers one is the local server 4.1 and
PROTECTED]>
Cc:
Sent: Monday, June 19, 2006 6:57 PM
Subject: Re: error in copy data from mysql 4.1 to mysql 5.0 server
> prathima rao wrote:
> > hello every one,
> >
> > i have two mysql servers one is the local server 4.1 and one is the
> > centralised serve
prathima rao wrote:
hello every one,
i have two mysql servers one is the local server 4.1 and one is the
centralised server 5.0 . i copy data from 4.1 to 5.0 through a option called
copy database to another server/host - (drop table if exists)
during this process i am not getting the same resu
hello every one,
i have two mysql servers one is the local server 4.1 and one is the
centralised server 5.0 . i copy data from 4.1 to 5.0 through a option called
copy database to another server/host - (drop table if exists)
during this process i am not getting the same resule as i get in 4.1 ie
ctice are the same;
in practice they are not.
On Mon, 29 May 2006, ManojW wrote:
> To: mysql@lists.mysql.com
> From: ManojW <[EMAIL PROTECTED]>
> Subject: Keyword - MySQL 4.1
>
> Dear All,
> While migrating from MySQL 4.0 to MySQL 4.1, I found
> that the database coul
Dear All,
While migrating from MySQL 4.0 to MySQL 4.1, I found that the database
could not be loaded in 4.1 because MySQL 4.1 uses a reserved keyword "div"
that was not "reserved" in 4.0.
Is there anyway to get around the issue?
Thanks in advance.
Manoj
--
MySQL
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I have been unable to use the bk client to update my bk trees. I just
hangs
/usr/local/bin/bk-update bk://mysql.bkbits.net/mysql-4.1 mysql-4.1
I usually run this every 4 hours to keep my local trees up to date. The
process usually completes in a
Is there any way to turn off collation in mysql 4.1? PHPadmin is showing a
new colation dropdown menu which I need to get rid of.
Thanks,
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Which binary did you use, and where did you download it from?
what is the result of "uname -a" ? are they both 64 bit machines?
32-bit machines? where is libstdc++ on both machines? It's possible
one machine has a library linked to another location, or they have
them in different locations. Sp
I have two FC4 computers I believe to be set up identically, I installed
mysql5 in both, the first one made the change without a hitch but the
second refuses to install with the error message:
"./bin/mysqld: error while loading shared libraries: libstdc++.so.5:
cannot open
shared object fil
On Wednesday, 15 February 2006 at 19:38:18 +0700, Ady Wicaksono wrote:
> Dear All
>
> i would like to downgrade from MySQL 5.0.18 to MySQL 4.1.18, I found
> MySQL 5.0.18 makes my application unstable... please help me, since
> currently all table in row=compact format
If you're having this kind of
Moreover,
I found this bug report
http://bugs.mysql.com/bug.php?id=15868
I believe my problem posted in this few days is due to the problem like
this Bug
huge insert/update... and finally MySQL hangand or crash
(sometimes i need to kill -9 mysql-max to kill the "hang")
Ss this
Dear All
i would like to downgrade from MySQL 5.0.18 to MySQL 4.1.18, I found MySQL
5.0.18 makes my application unstable... please help me, since currently
all table in row=compact format
Thank you
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
SQL or PHP related. It might be a Cpanel
problem. If you generate a MySQL 4.1 dump though
Cpanel, your MySQL will be exported in latin1
character set, this way the data in utf8 is damaged
and you get a corrupt database dump. This only happens
with MySQL 4.1. When Cpanel is used with MySQL 4.0,
there is no
--- Gleb Paharenko <[EMAIL PROTECTED]>写道:
>
> You can change the character_set_xxx variables using
> SQL
> queries. I usually put 'SET NAMES' at the beginning
> of my
> scripts.
>
Must i add mysql_query("SET NAMES 'utf8'") before
every occurance of real mysql_query()?
I have added mysql_query
arenko <[EMAIL PROTECTED]>写道:
>
>
>>Hello.
>>
>>From my experience PHP 4.4 works fine with MySQL
>>4.1.
>>What troubles are you getting while restoring utf8
>>database
>>to the server? Please, could you explain more in
>>detail all steps
--- Gleb Paharenko <[EMAIL PROTECTED]>写道:
> Hello.
>
> From my experience PHP 4.4 works fine with MySQL
> 4.1.
> What troubles are you getting while restoring utf8
> database
> to the server? Please, could you explain more in
> detail all steps
> of the resto
Hello.
>From my experience PHP 4.4 works fine with MySQL 4.1.
What troubles are you getting while restoring utf8 database
to the server? Please, could you explain more in detail all steps
of the restoring process. Include information about database
character set as well.
立 周 wrote:
> Dea
Dear list subscribers,
My web hosting server runs PHP 4.4 and MySQL 4.1. But
PHP 4.4 doesn't fully support MySQL 4.1. and i have
problems restoring a utf8 encoded database dumped from
a MySQL 4.0 server to the new 4.1 server. Do i have
any chance to get it working in this setup or sho
sheeri kritzer wrote:
On 11/18/05, Michael Stassen <[EMAIL PROTECTED]> wrote:
Sheeri,
I think you've missed the point. The 4Gb limit is in mysql, not the filesystem.
Mysql effectively doesn't limit tablesize, but the *default* pointer size
limits you to a max of about 4Gb in a MyISAM table.
On 11/18/05, Michael Stassen <[EMAIL PROTECTED]> wrote:
> Sheeri,
>
> I think you've missed the point. The 4Gb limit is in mysql, not the
> filesystem.
> Mysql effectively doesn't limit tablesize, but the *default* pointer size
> limits you to a max of about 4Gb in a MyISAM table. To have a la
sheeri kritzer wrote:
Simon,
If your tables are too big, you want to archive/delete some
information. I certainly cannot guide you on what to delete.
What you describe below isn't going to do anything. From the
documentation (http://dev.mysql.com/doc/refman/5.0/en/create-table.html):
---
Hi,
0. stop the web server or avoid hitting the db !
> 1). Backup everything! :)
the mysqldump should suffice.
> 2). do the alter
The alter does already a create table with new data and then exchance
table. You need 2x the storage space though.
3. do the opposite of 0.
--
Pooly
Webzine Rock
Simon,
If your tables are too big, you want to archive/delete some
information. I certainly cannot guide you on what to delete.
What you describe below isn't going to do anything. From the
documentation (http://dev.mysql.com/doc/refman/5.0/en/create-table.html):
---
Hi There,
We are reaching 4GB with one of our tables (v4.1 on debian sarge) and
are needing to run:
ALTER TABLE tbl_name MAX_ROWS=10 AVG_ROW_LENGTH=nnn;
as per the documentation.. I would be greatful for any input on best
practices to do this, as the database needs to be offline for
3.23.x version which has some
> MyISAM databases (no problem with it) and some InnoDB databases towards
> MySQL 4.1.x? Or have I to do a dump and restore instead of re-use
> databases?
>
> wdyt?
>
--
For technical support contracts, goto https://order.mysql.com/?ref=
Hi all,
A little question...
Can I upgrade directly a server with MySQL 3.23.x version which has some
MyISAM databases (no problem with it) and some InnoDB databases towards
MySQL 4.1.x? Or have I to do a dump and restore instead of re-use databases?
wdyt?
--
Cedric Gavage - [EMAIL PROTECTED
Le jeudi 27 octobre 2005 à 01:12 +0300, Gleb Paharenko a écrit :
> Hello.
>
>
>
> In mysql-5.0.15 it works. Put, say, default_time_zone='+10:00' in
>
> [mysqld] section of your file.
This option works too under MySQL 4.1.11:
[mysqld]
default_time_zone=UTC
mysql> SELECT @@global.time_zone, @@
Hello.
In mysql-5.0.15 it works. Put, say, default_time_zone='+10:00' in
[mysqld] section of your file.
Raphaël 'SurcouF' Bordet wrote:
> Hi,
>
> I want to set up a different timezone that my operating system for MySQL
> upper to 4.1. According to this article[1], timezone system var
Hi,
I want to set up a different timezone that my operating system for MySQL
upper to 4.1. According to this article[1], timezone system variable was
changed since 4.1.3. I'm using mysql 4.1.11a from Debian sarge.
I was tried to set system_time_zone into /etc/mysql/my.cnf
unsuccessfully. The only
Privet!
It works in 5.0.13. But for a pity not in 4.1.14. I've reported
a bug, you may want to add your comments at:
http://bugs.mysql.com/bug.php?id=14153
[EMAIL PROTECTED] mysql-debug-5.0.13-rc-linux-i686-glibc23]$ lmysql
Welcome to the MySQL monitor. Commands end with ; or \g.
You
On Wednesday 19 October 2005 04:34 pm, Mihail Manolov wrote:
> It's the way our code is written, and I just changed the table type and
> began getting this error. We have lots of data to insert into this
> table, therefore the optimal option is to use DELAYED and insert them in
> blocks.
>
> Not s
Jeff Smelser wrote:
I would highly suspect this is a bug.. I would submit one.. unless someone
else knows better..
Not real sure why you really need delayed, archive is suppose to be much
faster on inserts then even myisam.
Jeff
Thanks Jeff!
It's the way our code is written, and I just
Jeff Smelser wrote:
On Wednesday 19 October 2005 01:18 pm, Mihail Manolov wrote:
Apparently ARCHIVE tables do not support INSERT DELAYED. Why?
In documentation
(http://dev.mysql.com/doc/refman/4.1/en/archive-storage-engine.html) it
says that it should be possible.
Example of the error that I
Apparently ARCHIVE tables do not support INSERT DELAYED. Why?
In documentation
(http://dev.mysql.com/doc/refman/4.1/en/archive-storage-engine.html) it
says that it should be possible.
Example of the error that I am getting:
INSERT DELAYED INTO audit_log VALUES
('db','user','549220','address
The Mysql download page says I need to install these libraries if I
am using libc 2.3.x.
I have a couple of questions:
-- do I install them by just copying them to /usr/local/lib?
-- will they play that silly game of running unoptimized code on
AMD processors?
--
Christopher L. Everett
Chief
> The following might also be helpful (not all info in there is
> Opteron-specific):
> http://hashmysql.org/index.php?title=Opteron_HOWTO
Argh - should have read my own entry on that wiki page.
If you use PHP v4.3 (as installed with FC3) then it requires the MySQL v3.23
interface libraries (aka l
hink you need the shared-compat libraries - it appears that they are no
provided on mysql.com
As an alternative, consider using Fedora Core 4 which has Mysql 4.1 in there
natively.
The following might also be helpful (not all info in there is
Opteron-specific):
http://hashmysql.org/index.php?ti
Hello,
I have a Fedora Core 3 installation on an Intel 64bit processor.
I need PHP & MySQL 4.1.
The OS installed is the 64bit version of FC3.
PHP 4.3.9 is installed by FC3, but this has been upgraded to 4.3.11 and
works OK.
I have upgraded MySQL from 3.23 to 4.1 and I have insta
999 | 9.99 | 50.123456 |
+---+---+---+
2 rows in set (0.06 sec)
Looks like while MySQL 4.1 was not changing what was stored in the data but
changing what is inserted into new records to match the proper data tye
definitions.
On 19/9/05 17:49, "Andrew Braithwaite" <[EM
MySQL bug - insert into 'double' column problem
with mysql 4.1
Andrew Braithwaite wrote:
> Hi All,
>
> I have a strange error when trying to insert into a table with 2
> 'double' fields. It inserts into the 1st field OK but fills the 2nd
one
> with nines. See
Andrew Braithwaite wrote:
Hi All,
I have a strange error when trying to insert into a table with 2
'double' fields. It inserts into the 1st field OK but fills the 2nd one
with nines. See below for a complete recreate.
[...]
| lon | double(7,6) | YES | MUL | NULL|
Hello Andrew,
> I have a strange error when trying to insert into a table with 2
> 'double' fields. It inserts into the 1st field OK but fills the 2nd one
> with nines. See below for a complete recreate.
>
> Is this a known problem? Does anyone have a solution?
>
> I'm running standard MySQL bi
Hi All,
I have a strange error when trying to insert into a table with 2
'double' fields. It inserts into the 1st field OK but fills the 2nd one
with nines. See below for a complete recreate.
Is this a known problem? Does anyone have a solution?
I'm running standard MySQL binaries on redhat l
Andrew stolarz wrote:
> Hi folks,
> I just downloaded MySQL 4.1 to see if its a go ahead with our
> application,
> I am doing a tranfser from our current datafile to MySQL, its
> taking about
> 45 min to do this process..
> when I do the same process and transfer to a M$ SQL s
t installing and running. You
> would actually want to set certain variables to one value for your
> bulk insert and then change them for normal use.
>
>
>
> On Aug 18, 2005, at 3:29 PM, Andrew stolarz wrote:
>
> > Hi folks,
> > I just downloaded MySQL 4.1 to see
alling and running. You
would actually want to set certain variables to one value for your
bulk insert and then change them for normal use.
On Aug 18, 2005, at 3:29 PM, Andrew stolarz wrote:
Hi folks,
I just downloaded MySQL 4.1 to see if its a go ahead with our
application,
I
rote:
>
>
> Andrew stolarz < [EMAIL PROTECTED]> wrote on 08/18/2005 03:29:39 PM:
>
>
> > Hi folks,
> > I just downloaded MySQL 4.1 to see if its a go ahead with our
application,
> > I am doing a tranfser from our current datafile to MySQL, its taking
about
CTED]> wrote:
> >
> >
> >
> > Andrew stolarz < [EMAIL PROTECTED]> wrote on 08/18/2005 03:29:39 PM:
> >
> > > Hi folks,
> > > I just downloaded MySQL 4.1 to see if its a go ahead with our
> > application,
> > > I am doing a t
Andrew stolarz <[EMAIL PROTECTED]> wrote on 08/18/2005 03:29:39 PM:
> Hi folks,
> I just downloaded MySQL 4.1 to see if its a go ahead with our
application,
> I am doing a tranfser from our current datafile to MySQL, its taking
about
> 45 min to do this process..
>
Hi folks,
I just downloaded MySQL 4.1 to see if its a go ahead with our application,
I am doing a tranfser from our current datafile to MySQL, its taking about
45 min to do this process..
when I do the same process and transfer to a M$ SQL server, it takes about
2 min max.
is the 4.1 of
gt; but not on the database level:
> "Incorrect usage of DB GRANT and GLOBAL PRIVILEGES"
>
> Has anyone got any idea what EXECUTE should do on a global
> level in MySQL 4.1?
>
> With regards,
>
> Martijn Tonies
> Database Workbench - tool for InterB
> > For some reason, GRANT EXECUTE is possible on the global
> > level, but not on the database level:
> > "Incorrect usage of DB GRANT and GLOBAL PRIVILEGES"
> >
> > Has anyone got any idea what EXECUTE should do on a global
> > level in MySQL 4.
> -Original Message-
> From: Martijn Tonies [mailto:[EMAIL PROTECTED]
> Sent: 12 August 2005 09:40
> To: mysql@lists.mysql.com
> Subject: GRANT EXECUTE in MySQL 4.1
>
> Hi there,
>
> For some reason, GRANT EXECUTE is possible on the global
> level,
Hi there,
For some reason, GRANT EXECUTE is possible on the global level,
but not on the database level:
"Incorrect usage of DB GRANT and GLOBAL PRIVILEGES"
Has anyone got any idea what EXECUTE should do on a global
level in MySQL 4.1?
With regards,
Martijn Tonies
Database Workbench
Privet!
What hardware does your server have? What version of MySQL have you
tested? If key_buffer_size isn't enough for indexes of smacker's table
then performance could go bad (in my my-medium.cnf it is only 16M).
Thread cache gives performance hint for my-large.cnf. Add SQL_NO_CACHE
to q
Hello.
my-large.cnf is twice quicklier, but the description from
my-medium.cnf is approaches (such as a web server).
It is necessary that Mysql worked twice more slowly on a web server?
amd64# uname -r
5.4-STABLE
make WITH_XCHARSET=all BUILD_OPTIMIZED=yes BUILD_STATIC=yes install
Hello.
First read:
http://dev.mysql.com/doc/mysql/en/charset.html
mysqldump could put SET NAMES 'utf8' at the beginning of the dump
file, check it and remove or perform a dump using --set-names=gbk.
Use --defaults-character-set=gbk for mysql client (or put correct
values for character_s
Dear all,
I am a Chinese and using Chinese in my MySQL databases.
On my old server, the version of MySQL is 3.23.58. And my new MySQL is
4.1.7.
On my old server, the MySQL works well with my Chinese contents.
However, after I transfer tables to the new server using:
mysqldump --opt database | m
hi,
if u'r uninstalled the mysql and try to reinstalling
means, try the following.
1.Delete all the corresponding files that are created
by the prev installation after the uninstallation.
2.Install the MySQL again. Now it'll work.
This is due to some configuration prob between the
prev and new
Dear Friends,
Iam trying to install MySQL 4.1.2 in Windows 2003 Server, and on error occurs
when installation try a start de service. The service does not start and
installation don't finish.
I Need a help about it.
Regards for all.
--
MySQL General Mailing List
For list archives: http://l
PM
Subject: Re: MySQL 4.015 Vs MySQL 4.1.x
> Hi,
>
> I'm thinking too about switching to MySQL 4.1.x and if it better to user
> file per table.
>
> How much tables and data have you in your db? And which performance you
have?
>
>
> Best Regards,
> Rafal
>
&
Hi,
I'm thinking too about switching to MySQL 4.1.x and if it better to user
file per table.
How much tables and data have you in your db? And which performance you have?
Best Regards,
Rafal
At 09:53 19.05.2005, ManojW wrote:
Dear All,
I am using MySQL 4.0.15 on a Linux (RH9) for the pa
t use the
database pretty heavily (basically for mathematical modelling purpose etc).
Basically I am very happy with MySQL/InnoDB and I think the developers did
an amazing at that.
With MySQL 4.1.x being stable for a while, I am wondering if I should
upgrade from MySQL 4.0.15 to MySQL 4.1.x?
lt;[EMAIL PROTECTED]>; "Richard Dale" <[EMAIL PROTECTED]>;
Sent: Monday, May 09, 2005 6:39 PM
Subject: RE: Dual Opteron, linux kernels, 64 bit, mysql 4.1, InnoDB
Why not Raid 3 and take advantage of disk write and read performance.
Raid 3 isn't commonly used because it has CPU
NYPL BlackBerry Handheld.
- Original Message -
From: [EMAIL PROTECTED]
Sent: 05/09/2005 09:39 PM
To: "Jeremiah Gowdy" <[EMAIL PROTECTED]>; "Dathan Pattishall" <[EMAIL
PROTECTED]>; "Richard Dale" <[EMAIL PROTECTED]>;
Subject: RE: Dual Opter
1 - 100 of 423 matches
Mail list logo
