Yup, I'm doing clean tests,lshutdown, and reload mysql each test.
The raid setup is similar, Faster is raid1 with 10k harddisk, slower is raid
10 with 15k.
Metrics show
Old raid
Secuecial writting 1G: 533 mb/s (using dd if=/dev/zero of=1G bs=1024
count=102400)
Secuencial reading 1G: 500 mb/s
New
On Sun, Feb 13, 2011 at 11:40 PM, Andrés Tello wrote:
> I have a test process, which runs in the "old server" in 35 seconds, the new
> server runs the same process in 110.
>
> There is a change of version from mysql 4.1.22 to 5.1.22.
> We were stuck at 5.1.22 because higher version give us anothe
I have a test process, which runs in the "old server" in 35 seconds, the new
server runs the same process in 110.
There is a change of version from mysql 4.1.22 to 5.1.22.
We were stuck at 5.1.22 because higher version give us another issules like
encoding, case sensitivity...
I really belive th
take 25 working days which I do not have at this point.
Does anybody know where I can get hold of a MySQL 5
certification study guide? Even if it is in pdf format or at this stage
even if it has been used before.
I would really appreciate the help with this as I can't
Yes, If it is a password problem.
do a update with password=old_password('xxpasswdxx');
It will work.
If you are facing any other problems, paste it.
On Tue, Apr 13, 2010 at 10:37 PM, Pecas On Line wrote:
> Hello,
>
> I need to have a MySQL 3.x client to be compatible w
Hello,
I need to have a MySQL 3.x client to be compatible with a new MySQL 5.x
server, is it possible?
What do I need to change on my MySQL 5.x server to allow old clients to
work?
Also, what do I need to change to allow old PHP 4.x code to talk to a MySQL
5.x server?
Thanks,
POL.
s
John Daisley
Mobile +44(0)7812 451238
Email j...@butterflysystems.co.uk
Certified MySQL 5 Database Administrator (CMDBA)
Certified MySQL 5 Developer
Cognos BI Developer
---
Sent from HP IPAQ mobile device.
-Original Message-
From: James Dekker
Sent: 14 October 2009
laudio Nanni wrote:
Add -p to your mysqladmin statement to change password and use
'root' as password.
you wanted to give extra grants to root but you just set the
password for r...@localhost.
you don't need to grant anything to root, usually.
cheers
Claudio
On Oct 14, 2009 9:0
you just set the
password for r...@localhost.
you don't need to grant anything to root, usually.
cheers
Claudio
On Oct 14, 2009 9:07 PM, "James Dekker"
wrote:
Hello there,
I have been using MySQL 5 on my OS X Leopard based laptop for
quite some time now...
Didn't h
you don't need to grant anything to root, usually.
cheers
Claudio
On Oct 14, 2009 9:07 PM, "James Dekker"
wrote:
Hello there,
I have been using MySQL 5 on my OS X Leopard based laptop for quite
some time now...
Didn't have a password set and my login was "root&q
kker" wrote:
Hello there,
I have been using MySQL 5 on my OS X Leopard based laptop for quite some
time now...
Didn't have a password set and my login was "root" on localhost.
Downloaded just now the Spring distribution was following the steps to run
the petclinic sample applic
Hello there,
I have been using MySQL 5 on my OS X Leopard based laptop for quite
some time now...
Didn't have a password set and my login was "root" on localhost.
Downloaded just now the Spring distribution was following the steps to
run the petclinic sample applica
>
> Thanks for the response, Peter.
> Yeah, I am aware of this to find it for the tables. However I require to
> find the creation time of a database..
>
> Thanks,
> Uma
>
>
> On 6/3/09, Peter Brawley wrote:
>>
>> >Is there any method to find the CREATION DATE of an EXISTING database and
>> >tab
Is there any method to find the CREATION DATE of an EXISTING database and
tables in MySQL 5.0 or newer versions?
information_schema.tables.create_time for tables.
PB
Uma Bhat wrote:
Hi all !
Is there any method to find the CREATION DATE of an EXISTING database and
tables in MySQL 5.0 or new
Hi all !
Is there any method to find the CREATION DATE of an EXISTING database and
tables in MySQL 5.0 or newer versions?
Thanks,
Uma
ysqld]
> 25276 ? S 0:00 \_ [mysqld]
> 25277 ? S 0:00 \_ [mysqld]
> 25278 ? S 0:00 \_ [mysqld]
> 25279 ? S 0:00 \_ [mysqld]
> 25280 ? S 0:00 \_ [mysqld]
> 25281 ? S 0:03 \_ [mysqld]
> 25282 ? S 0:00 \_ [mysqld]
> 25283 ? S 0:15 \_ [mysqld]
>
> The mysql 5 shows the fol
r server is having hard drive issues and being
> replaced), and I think it's just a mysql 5 startup or config change but I am
> not sure. Our test page shows the queries with the query times, and here is
> just one admin page;
> *mysql4:*
> getting all product infodon
mysql 5.0.45. The whole site is almost
> unusable now (the older server is having hard drive issues and being
> replaced), and I think it's just a mysql 5 startup or config change but I am
> not sure. Our test page shows the queries with the query times, and here is
> just one adm
On Fri, Jan 30, 2009 at 9:32 AM, lance raymond wrote:
> basically I have an old fc5 machine running mysql 4.1 and a
> newer server running centos5 / mysql 5.0.45.
So, different hardware, different OS, different database server...
could be anything. I suggest you run EXPLAIN plans for the slow
qu
lmost
unusable now (the older server is having hard drive issues and being
replaced), and I think it's just a mysql 5 startup or config change but I am
not sure. Our test page shows the queries with the query times, and here is
just one admin page;
*mysql4:*
getting all product infodone (12
mysql 5 shows the following running;
root 10245 0.0 0.0 4472 1092 pts/0 S 23:13 0:00 /bin/sh /usr/bin/mysqld_safe
--defaults-file=/etc/my.cnf --pid-file=/var/run/mysqld/mysqld.pid
--log-error=/var/log/mysqld.log
mysql 10281 5.8 1.1 141544 24028 pts/0 Sl 23:13 0:19 /usr/libexec/mysqld
--defaults-file
cc
Subject
com_* status variables seem to
I have been trying to compute query cache utilization in mysql 5 but cannot
because the com_select status variable is always 1 when I start a new mysql
session. This probably holds for all the com_* variables and maybe others,
but I've only been working with com_select. They're supp
Hi
I am just wondering if anyone is running MySQL Database on a fairly busy
Website running on FreeBSD AMD64 7-stabble with PHP+Apache?
I am going to build a server for couple of websites having traffic 5 million
per month...
Any comments?
--
Thanks!
BR / vj
[EMAIL PROTECTED] wrote:
> Hello to All,
>
> Would you mind to help as the title of mail ?
>
> Thanks !
>
> Edward.
>
What problems are you having?
Have you read the Manual yet?
I'd suggest going with a real operating system (linux) which keeps patches
updated quicker...
Wolf
--
My
Yes, I did and what happens is that the 'xxx' becomes appended to the
next line and the line after that asks the user for the password
(which also fails).
The way I got it working was this:
mysql -u root -p
Kindest regards,
Unnsse
On Feb 25, 2008, at 8:34 AM, fire9 wrote:
Unnsse Khan 写道
Hello there,
I am running OS X Leopard on an Intel based iMac machine...
Followed the instructions to a T and everything works as described in:
http://hivelogic.com/articles/installing-mysql-on-mac-os-x/
Now, after running MySQL using launchd, when I try to login using:
mysql -u root
I get t
Hello there,
I am running OS X Leopard on an Intel based iMac machine...
Followed the instructions to a T and everything works as described in:
http://hivelogic.com/articles/installing-mysql-on-mac-os-x/
Now, after running MySQL using launchd, when I try to login using:
mysql -u root
I get t
Does it also fix the problem with the MySQL 5 Admin GUI (located in
System Preferences) or does one have to use launchd manually every-
time from the command line?
-Unnsse
On Feb 11, 2008, at 8:28 PM, Grant Limberg wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I found this a while
PROTECTED]
On Feb 11, 2008, at 6:34 PM, Unnsse Khan wrote:
Hello there,
I am having problems running MySQL 5 on OS X Leopard...
Nothing happens when I try to start MySQL in System Preferences.
From the command line, this is the error I receive (when trying to
start MySQL):
ERROR 2002 (HY000
Hello there,
I am having problems running MySQL 5 on OS X Leopard...
Nothing happens when I try to start MySQL in System Preferences.
From the command line, this is the error I receive (when trying to
start MySQL):
ERROR 2002 (HY000): Can't connect to local MySQL server through s
Never tried it with version 3 only 4.1 but it has a --compatible switch
with a version 3.23 switch see command line --help so I assume the mysql
guys are allowing you to dump 3.23. Try dumping it without the switch as
you will be restoring to 5.0. The idea is to make sure the restore is
done us
> Make sure you use the mysqldump from version 5 and not version 3. Also
> recheck all your application queries once you have restored the data the
> list of changes SQL syntax might haunt you.
But can I use '/usr/local/mysql5/bin/mysqldump' to dump data of MySQL 3?
--
MySQL General Mailing List
ll upgrades (mysql 3 -> 4) but I
don't know what is the problem of this, I prefer the basic: dump and
restore.
So you're suggesting to:
- install MySQL 5 from sources on '/usr/local/mysql5' without starting it
- dump data from MySQL 3
- stop MySQL 3
- start MySQL 5
- restor
one dump on old database, stop the
> old and restore on newer database.
>
> Just copy the datafiles can work on small upgrades (mysql 3 -> 4) but I
> don't know what is the problem of this, I prefer the basic: dump and
> restore.
So you're suggesting to:
- install MySQL
On Wed, 2007-11-07 at 10:22 +0100, thomas Armstrong wrote:
> Hi.
Hello,
> Working on Linux, I've got installed MySQL 3.23.58, but I'm
> experiencing some problems. For instance, I suffer "too many
> connections" error but I cann't set 'max_connections' parameter to a
> value bigger than 250.
..
Hi.
Working on Linux, I've got installed MySQL 3.23.58, but I'm
experiencing some problems. For instance, I suffer "too many
connections" error but I cann't set 'max_connections' parameter to a
value bigger than 250.
I decided to migrate to MySQL 5.0, and I've got some questions:
- I installed My
Login to mysql
Perform this on the table
ALTER TABLE tbl-name MODIFY COLUMN Rating varchar(10);
Then recreate the ODBC link in OpenOffice
Give it a try.
Colleen Beamer <[EMAIL PROTECTED]> wrote:
Hi,
I apologize for posting here, because I only use MySQL at a very basic
level
Hi,
I apologize for posting here, because I only use MySQL at a very basic
level - I wanted to create an Access-like database and found that I
could use Open Office with an ODBC connection to a MySQL database to do
what I wanted.
Up to this point all has been fine. However, I just upgraded to My
Looking for a MySQL 5 DBA with linux experience to work with me for a
large company on Long Island New York. Good salary/benefits etc. We're
doing a lot of cutting edge stuff with replication as well as other
areas. Feel free to call me or drop me an email with a resume if you
know anyone.
Hello,
Je peux lire des Français, mais l'écriture qu'il n'est pas comme facile.
Ainsi j'emploie des poissons de Babel pour traduire ceci
d'anglais-français. Ainsi, mes excuses s'il la grammaire est totalement
erroné.
Très intéressant. Je devinerais que le problème s'est produit dans le
tra
Hello,
j'ai 2 machines Linux debian etch, avec MySQL 5.0.32
J'ai un problème d'affichage sur l'une des machines :
j'ai créé la même table et chargé le même fichier data
dans une base sur chaque machine, et l'affichage est différent.
Je ne vois pas oú est la différence...
my.cnf idem
locale idem
Peter Brawley wrote:
Amer
>I'm having no luck getting MySQL 5 installed under Windows 2000
Professional.
>The service does not start, either automatically on bootup, or
manually. Reading
>through the manual does not address the issue, at least that I could
find.
From %m
Peter Brawley wrote:
Amer
>I'm having no luck getting MySQL 5 installed under Windows 2000
Professional.
>The service does not start, either automatically on bootup, or
manually. Reading
>through the manual does not address the issue, at least that I could
find.
From %m
Amer
>I'm having no luck getting MySQL 5 installed under Windows 2000
Professional.
>The service does not start, either automatically on bootup, or
manually. Reading
>through the manual does not address the issue, at least that I could
find.
From %mysql_home%\bin try running
I'm having no luck getting MySQL 5 installed under Windows 2000
Professional. The service does not start, either automatically on
bootup, or manually. Reading through the manual does not address the
issue, at least that I could find.
There isn't a previous version on the system -
Hi,
Is there any configuration to be setup to get each query of a stored
procedure, called by a client, in the mysql-slow.log or mysql.log? For
the moment, I just have the stored procedure call in the log file, but I
need to trace every SQL statement of this stored procedure.
# Time: 07060
D]>
To:
Sent: Tuesday, January 23, 2007 11:59 AM
Subject: Urgent - MySQL 5 - mysqld using a lot of memory consistently
Hello all,
Recently we upgraded from MySQL 4.1.11 to MySQL 5.0.22. The queries are
taking a lot of time to execute in the newer version. The queries which were
executing within 1
D_SUBJECT`),
KEY `FLD_WORKFLOW_TYPE` (`FLD_WORKFLOW_TYPE`),
KEY `FLD_PRODUCT_ID` (`FLD_PRODUCT_ID`),
KEY `FLD_SUB_CONTACT_ID` (`FLD_SUB_CONTACT_ID`),
KEY `FLD_ESCALATED_FLAG` (`FLD_ESCALATED_FLAG`),
KEY `FLD_BOUNCED_MAIL_FLAG` (`FLD_BOUNCED_MAIL_FLAG`)
) ENGINE=InnoDB DEFAULT CHARSET=lat
: FLD_MSG_ID
key_len: 4
ref: tallydb.TFMM.FLD_MSG_ID
rows: 1
Extra: Using where
- Original Message -
*From:* Alex Arul <[EMAIL PROTECTED]>
*To:* Ratheesh K J <[EMAIL PROTECTED]>
*Sent:* Tuesday, January 23, 2007 11:57 AM
*Subject:*
age -
From: Alex Arul
To: Ratheesh K J
Sent: Tuesday, January 23, 2007 11:57 AM
Subject: Re: Urgent - MySQL 5 - mysqld using a lot of memory consistently
you threads connected is 38 but your thread cache has only 8. So please do
bump it up. Also generate explain plan on both versio
is
being used which is a new concept in MySQL 5. My initial doubt was on this but
now when I checked top it shows that mysqld is consistently using 59% of Memory
and 25% of cpu even when there is no load.
the SHOW STATUS command in mysql shows:
Threads_created21863
te:
>On 1/1/07, mos wrote:
>>Is there a problem with InnoDb scaling with multi-processor CPU's?
>>Apparently after reading the Tweakers.net article, with only 40
>>simultaneous users the performance of MySQL 5 will collapse.
>>
>>
http://www.mysqlperfo
On 1/1/07, mos wrote:
At 12:49 PM 1/1/2007, Jochem van Dieten wrote:
>On 1/1/07, mos wrote:
http://www.mysqlperformanceblog.com/2006/11/30/interesting-mysql-and-postgresql-benchmarks/
http://tweakers.net/reviews/649/6
Has this been fixed?
As the article on the MySQL Performance Blog mention
At 12:49 PM 1/1/2007, Jochem van Dieten wrote:
On 1/1/07, mos wrote:
Is there a problem with InnoDb scaling with multi-processor CPU's?
Apparently after reading the Tweakers.net article, with only 40
simultaneous users the performance of MySQL 5 will collapse.
On 1/1/07, mos wrote:
Is there a problem with InnoDb scaling with multi-processor CPU's?
Apparently after reading the Tweakers.net article, with only 40
simultaneous users the performance of MySQL 5 will collapse.
http://www.mysqlperformanceblog.com/2006/11/30/interesting-mysql-and-postg
Is there a problem with InnoDb scaling with multi-processor CPU's?
Apparently after reading the Tweakers.net article, with only 40
simultaneous users the performance of MySQL 5 will collapse.
http://www.mysqlperformanceblog.com/2006/11/30/interesting-mysql-and-postgresql-benchmarks/
l) fine
the Mysql-4.1+apache+php4.
I tried fine Mysql 5. on the same debian machine.
Now I want to use mysql 5. through web/php4
Then I run into problem, like :
Warning: mysql_connect(): Can't connect to local MySQL server through
socket '/var/run/mysqld/mysqld.sock' (2) in
/var/www
On 13 Dec 2006 at 18:59, Gilles MISSONNIER wrote:
> Hello,
> I use Debian Linux, and I could install (with apt-get install) fine
> the Mysql-4.1+apache+php4.
>
> I tried fine Mysql 5. on the same debian machine.
>
> Now I want to use mysql 5. through web/php4
>
> Th
Hello,
I use Debian Linux, and I could install (with apt-get install) fine
the Mysql-4.1+apache+php4.
I tried fine Mysql 5. on the same debian machine.
Now I want to use mysql 5. through web/php4
Then I run into problem, like :
Warning: mysql_connect(): Can't connect to local MySQL s
mos wrote:
Phil,
FabForce doesn't work with MySQL 5 because of the new password
encryption. Fabforce never lets me connect to a database. I suppose I
could revert back to the old PW mgt scheme but that may weaken the security.
There was an earlier post on this list which disc
At 09:58 AM 12/8/2006, you wrote:
mos,
I'm looking for a free, perhaps open source, case tool for MySQL 5.x.
(Older MySQL 4.0 case tools may not work because of the changes to pw
security in 4.1 and later)
I tried MySQL Workbench 1.1.5 alpha but I keep getting errors "The
follo
Ysgrifennodd Philip Mather:
http://fabforce.net/dbdesigner4/ ...is pretty funky and meets the
requirements.
Phil
But had, the last time I looked, been discontinued in favour of MySQL
Workbench.
Have you (the OP, that is) tried to sort out why MySQL Workbench isn't
playing? I have it on my
mos,
I'm looking for a free, perhaps open source, case tool for MySQL 5.x.
(Older MySQL 4.0 case tools may not work because of the changes to pw
security in 4.1 and later)
I tried MySQL Workbench 1.1.5 alpha but I keep getting errors "The
following error occurred while launching
I'm looking for a free, perhaps open source, case tool for MySQL 5.x.
(Older MySQL 4.0 case tools may not work because of the changes to pw
security in 4.1 and later)
I tried MySQL Workbench 1.1.5 alpha but I keep getting errors "The
following error occurred while launching the obj
If you don't understand the title of this announcement then you're
probably not exactly the target group I'm aiming at, but still I'd like
to inform you about a new MySQL Press book that's just hit the shelves
of the bookstores: Das offizielle MySQL 5 Handbuch. As you m
On Tue, Oct 31, 2006 at 08:58:04PM +0300, Ahmad Al-Twaijiry wrote:
> is it possible that one of my script process will select the same data
> that the other process is selecting or updating ? or if I run a second
> process of my script it will not be able to read/write anything until
> the first sc
Hi everyone
I have a PHP script that will run every minute and do a lot of SELECT
and UPDATE statments
All my tables are InnoDB and I'm using PHP 5 and POD class (
http://php.net/pod ) to connect to mysql, in my script I start the
transaction (using method beginTransaction() ) in the beginning o
Hello,
Did you try to convert the .lib file to a GCC .a library ? See
http://mingw.org/mingwfaq.shtml#faq-msvcdll
If reimp doesn't work, you can try pexports and dlltool. I have an old
batch file I used for older MySQL versions at
http://athanatos.free.fr/EXE/implib.bat
[EMAIL PROTECTED]
Hello,
I'm trying to compile some C code with the simple following code (dev-c++):
#include
#include
#include
#include
int main(int argc, char *argv[])
{
MYSQL * mysql_con = NULL;
mysql_con = mysql_init(mysql_con);
return 0;
}
As the result, i obtain this :
gcc.exe -D__DEBUG__ main.
Dan,
Cheers for doing the translating, I'm one of those beardy types they
keep locked in a dark room writing search engines so my English isn't
spectacular ;^)
As Rolando points out your file system may place a limit on the
number of files or directories, but to my knowledge XFS has no su
That does make sense, John.
What Philip is saying is that you might run into problems with one of
the tables used to keep track of tables and databases, before you run
into problems with any hard coded limit of MySQL itself.
The OS and the hardware will impose some (rather generous)
restrictions
AM GMT-0500 US/Eastern
Subject: Re: How many databases does MySQL 5 support?
John M.Brown schrieb:
> Thanks for the info, but my question is how many databases, not so much how
> many rows per table or how big the database can be... I mean, how many
> "create database ABC" c
John M.Brown schrieb:
Thanks for the info, but my question is how many databases, not so much how many rows per table or how
big the database can be... I mean, how many "create database ABC" can I do
before MySQL says "sorry, you can't have more than X databases".
Say I create 1000 empty MySQL
Thanks for the info, but my question is how many databases, not so much how
many rows per table or how big the database can be... I mean, how many "create
database ABC" can I do before MySQL says "sorry, you can't have
more than X databases".
Say I create 1000 empty MySQL databases (meaning no
John,
How many databases does a single instance of MySQL Server 5.x support?
I suspect you'll get a bit of a , with a 64bit machine there's
a limit of 4.2 billion rows per table and with an XFS file system 8EB
per table, there's a join limit specified somewhere but I don't think
there's an
I've looked as many places as I can think of and can't find a direct answer to
my question:
How many databases does a single instance of MySQL Server 5.x support?
Is this because there is no logical limit?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsub
I want to write a sp return paging of recordset.
CREATE PROCEDURE `sp_GetJobsDetails`(Page INT, PageSize INT)
BEGIN
DECLARE RecordBegin INT;
DECLARE tmpPageSize INT;
SET RecordBegin = Page * PageSize - PageSize;
SET tmpPageSize = PageSize + 1;
SELECT JOB_ID
He's dropping the table just prior to running the problematic query,
so I don't think optimizing the destination table will make a
difference. Optimizing the source might speed it up a little, but
he's looking at a difference of 2 minutes to 74 minutes if I'm
understanding correctly when simply S
mos wrote:
I have a simple query in MySQL 5.0.24:
insert into table1 (col1) select distinct col1 from bigtable;
that will run for 1:14:18. Both tables are MyISAM and table1 was just
created with 2 columns and is empty.
The "select distinct col1 from bigtable" takes only 2 minutes to run
At 09:37 PM 10/6/2006, Dan Buettner wrote:
Mike, was this a straight software upgrade on the same box? Any
settings changes?
Dan
Hi Dan,
When I installed MySQL 5.0 I used the My.ini for dedicated server
and edited it to use my old settings. I also noticed if I had InnoDb turned
on,
Mike, was this a straight software upgrade on the same box? Any
settings changes?
Dan
On 10/6/06, mos <[EMAIL PROTECTED]> wrote:
I have a simple query in MySQL 5.0.24:
insert into table1 (col1) select distinct col1 from bigtable;
that will run for 1:14:18. Both tables are MyISAM and table1 w
I have a simple query in MySQL 5.0.24:
insert into table1 (col1) select distinct col1 from bigtable;
that will run for 1:14:18. Both tables are MyISAM and table1 was just
created with 2 columns and is empty.
The "select distinct col1 from bigtable" takes only 2 minutes to run if I
run it by
have any better stack trace info, but the debug
version didn't generate anything. Has anyone else encountered
such a problem with Solaris 8 and mysql 5.x? I dug around online
and couldn't find any mention of such a problem.
-chris
--
MySQL General Mailing List
For list archives: http:/
Can someone tell me where I can find the source code files whit th
user authentication in it? I want to see if I can integrate LDAP
authentication myself.
_
Express yourself instantly with MSN Messenger! Download today - it's FREE!
Good day,
After a whole day of researching I finally found an answer for Ms Access not
displaying the columns of more than one table in a MySQL 5 view...
The bugfix was posted in a mysql forum here:
http://forums.mysql.com/read.php?65,52721,100434#msg-100434
which contains a link to a download
Simo Sentissi schrieb:
Hello there
I just finished installing mysql 5 on my linux server and I reset the root
password as an initial post-install setting.
now that i try to connnect from other machines in the network I always get a
message similar to the following:
C:\Documents and Settings
Hello there
I just finished installing mysql 5 on my linux server and I reset the root
password as an initial post-install setting.
now that i try to connnect from other machines in the network I always get a
message similar to the following:
C:\Documents and Settings\msentissi>mysql -u r
Well I have the book you mentioned below - it is VERY good
IMHO. Goes into alot of detail on how to design tables the
right way. Covers normalisation and optimisation techniques
for the server itself. These guys really know what they are
talking about.
I also have Beginning PHP & MySQL 5
TED]
> Sent: Friday, June 09, 2006 2:16 PM
> To: mysql@lists.mysql.com
> Subject: Books on MySQL 5
>
> As always, thanks ahead of time for all responses.
>
> The company I work for is currently looking at getting
> literature on MySQL 5, more specifically, what'
As always, thanks ahead of time for all responses.
The company I work for is currently looking at getting literature on MySQL 5,
more specifically, what's different in new MySQL features from the SQL
standard. By this I mean things such as Stored Procedures, Foreign Keys, and
anything e
Hi all, hate to ask a question that probably has a really obvious answer, but
does anyone know of the existence of a mysql 5.1 yum repo that I can point my
FC5 box at?
--
brendan bouffler
Architect, HPC & New Technology
APJ ESS Competency Lab
x: Sydney, Australia, v: +61 404 097 837 mtb: 2003
Hi,
i've noticed similar behaviour as we upgraded to mysql 5.0.
The query optimizer seems to been "optimized" a little too much :-\
-Original Message-
From: Szymon Kosok [mailto:[EMAIL PROTECTED]
Sent: Saturday, May 27, 2006 5:42 PM
Cc: mysql@lists.mysql.com
Subje
Hello again,
SELECT shout_avatar, shout_own, timestamp, tekst, imie, pseudo, wiek,
City, Country, plec, wlosy_kol, gra_gwiazdy.id, gra_gm.gid AS gm FROM
gra_shoutbox INNER JOIN (gra_gwiazdy) ON (gra_gwiazdy.id =
gra_shoutbox.gid) INNER JOIN (swiat_miasta) ON (swiat_miasta.CityId =
gra_gwiazdy.mi
Hello,
I've posted this on Gentoo forums, but I'll try here too. :)
I've made upgrade of MySQL to latest 5.0.x version. Now, when I access my
site MySQL CPU usage is about 100%, and site is unaccessible. :( I've
checked SHOW PROCESSLIST and this query take lng time to execute:
SELECT shout_a
You have to change the delimiter you use, otherwise MySQL treats the ;
as the end of the line and processes the commands. When I tried to
run your trigger (with the standard delimiter of ;) I got:
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your
Hi all!
server version: 5.0.18
I attempted to create a trigger with statement and update, it does like
this:
CREATE TRIGGER update_trans AFTER UPDATE ON main_trans
FOR EACH ROW
BEGIN
IF OLD.trans_status='INITIAL' and OLD.trans_state='INITIAL' THEN
update trans set trans_status=NEW.trans_status, t
Thanks to Ing. Edwin Cruz and George Law for pointing me in the right
direction, as previous messages in this thread indicate. phpMyAdmin now
working great with MySQL 5.0.
Have a loot on this:
http://dev.mysql.com/doc/refman/5.0/en/old-client.html
try a search for "old_password"
--
Amer
Have a loot on this:
http://dev.mysql.com/doc/refman/5.0/en/old-client.html
Regards!
-Mensaje original-
De: Amer Neely [mailto:[EMAIL PROTECTED]
Enviado el: Miércoles, 10 de Mayo de 2006 12:39 p.m.
Para: MySQL List
Asunto: MySQL 5 / phpMyAdmin
I've finally got MySQL 5.0 going
try a search for "old_password"
-Original Message-
From: Amer Neely [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 10, 2006 1:39 PM
To: MySQL List
Subject: MySQL 5 / phpMyAdmin
I've finally got MySQL 5.0 going on my Win2K machine, but phpMyAdmin
2.8.0.3 is now givi
1 - 100 of 265 matches
Mail list logo