I installed mysql 5.1 to windows 7 using mysql-5.1.73-winx64.msi and got
confused on how to relocate the datadir.
my basedir was F:/MySQL and datadir was F:/MySQL/data
It works fine and I'm trying to relocate the datadir:
(0) stop mysql service
(1) copy F:/MySQL/data to F:/DBData/MySQL/data
(2
Am 01.01.2014 23:30, schrieb Elim Qiu:
I installed mysql 5.1 to windows 7 using mysql-5.1.73-winx64.msi and got
confused on how to relocate the datadir.
my basedir was F:/MySQL and datadir was F:/MySQL/data
It works fine and I'm trying to relocate the datadir:
(0) stop mysql service
Good day all
I am hoping someone can assist me in the following.
One of our servers were running mysql 5.0 still and as part of
a phased upgrade route we have upgraded to version 5.1.
However since the upgrade, the query below gives us an error
stating that the syntax
Hi Machiel,
On 8/11/2013 20:04, Machiel Richards wrote:
Good day all
I am hoping someone can assist me in the following.
One of our servers were running mysql 5.0 still and as part of
a phased upgrade route we have upgraded to version 5.1.
However since the upgrade,
- Original Message -
From: Machiel Richards machiel.richa...@gmail.com
ERROR 1064 (42000): 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 'GROUP BY t.AccountID,
I suspect your query has never
Happiness, that gave me what I was looking for. Thank you Johan.
I have tested the option you gave me but my brackets was in the wrong place.
On 08/11/2013 13:23, Johan De Meersman wrote:
- Original Message -
From: Machiel Richards machiel.richa...@gmail.com
ERROR 1064 (42000):
Hi Jesper
I was just discussing this with the development manager now and the
following was noted.
- The query was written for mysql 4.0 originally and it seems
that in version 5.0 they had enabled some legacy support stuff ( I am
not too familiar with this as it is before my
: Alex Keda [mailto:ad...@lissyara.su]
Sent: Thursday, February 14, 2013 9:36 PM
To: mysql@lists.mysql.com
Subject: MySQL 5.1: incorrect arithmetic calculation
bkp0# mysql h5000_bill
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1643184
Server version
15.02.2013 15:07, Alex Keda пишет:
OK. But, how about:
mysql SELECT 365 * 1.67 * ( 1 - 0.10);
+--+
| 365 * 1.67 * ( 1 - 0.10) |
+--+
| 548.5950 |
+--+
1 row in set (0.00 sec)
mysql
??
sorry, I'm too many
- Original Message -
From: Alex Keda ad...@lissyara.su
mysql SELECT SUM(`Amount`*`Cost`*(1-`Discont`)) as `Summ` FROM
`WorksCompliteAgregate` WHERE (`ContractID` = 10369 AND `Month` = 497);
Based off the select you printed, this comes to EXACTLY 548.595 for the first
row and 0
15.02.2013 14:43, Johan De Meersman пишет:
- Original Message -
From: Alex Keda ad...@lissyara.su
mysql SELECT SUM(`Amount`*`Cost`*(1-`Discont`)) as `Summ` FROM
`WorksCompliteAgregate` WHERE (`ContractID` = 10369 AND `Month` = 497);
Based off the select you printed, this comes to
- Original Message -
From: Alex Keda ad...@lissyara.su
To: mysql@lists.mysql.com
Sent: Friday, 15 February, 2013 12:16:18 PM
Subject: Re: MySQL 5.1: incorrect arithmetic calculation
sorry, I'm too many work... =)
Heh :-) I was thinking, why would that not be correct? It's exactly
From: Alex Keda ad...@lissyara.su
To: mysql@lists.mysql.com;
Sent: 6:37 Piątek 2013-02-15
Subject: MySQL 5.1: incorrect arithmetic calculation
( ... cut ...)
but, my desktop calculator gives the result 548.60
1. your desktop calculator is wrong
2. correct result is 548.595, variations
bkp0# mysql h5000_bill
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1643184
Server version: 5.1.68-log FreeBSD port: mysql-server-5.1.68
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of
Hi all,
I've got some semi-general questions on the topics in the title. What I'm
looking for is more in the line of theory than query specifics. I am but a
poor peasant boy.
What I have is an application that makes heavy use of views. If I understand
views correctly (and I may not), views
At first blush, your problem would appear to concern the lack of index-use.
That's where I would begin my investigation. It might be painstaking, but
I would do something like this:
For each view
Look at the Join(s) and see what columns are being joined
Look at the tables and see what
eBay once developed a patch for pooled threads, on top of 5.0, to resolve this
kind of issue so they can support 10k+ sessions(massive amount of application
need to talk to those mysql).
Not sure whether they are merged into main version though.
Best regards
Zhuchao
在
- Original Message -
From: Reindl Harald h.rei...@thelounge.net
even if you have enough memory why will you throw it away for a
unusual connection count instead use the RAm for innodb-buffer-pool,
query-cache, key-buffers?
Maybe the application doesn't have support for connection
Am 14.04.2011 11:50, schrieb Johan De Meersman:
- Original Message -
From: Reindl Harald h.rei...@thelounge.net
even if you have enough memory why will you throw it away for a
unusual connection count instead use the RAm for innodb-buffer-pool,
query-cache, key-buffers?
Maybe the
Hey All,
Can anyone provide some guidance as to what the practical connection limits
to MySQL 5.1/5.5 are under linux?
We're running a ruby on rails application that establishes 50 to 100
connections to our database upon startup resulting in around 1,000
persistent db connections. I've been
Am 13.04.2011 23:50, schrieb Jeff Lee:
Hey All,
Can anyone provide some guidance as to what the practical connection limits
to MySQL 5.1/5.5 are under linux?
We're running a ruby on rails application that establishes 50 to 100
connections to our database upon startup resulting in around
: Practical connection limits MySQL 5.1/5.5
Am 13.04.2011 23:50, schrieb Jeff Lee:
Hey All,
Can anyone provide some guidance as to what the practical connection limits
to MySQL 5.1/5.5 are under linux?
We're running a ruby on rails application that establishes 50 to 100
Hiya
We have client that is using Ubuntu, therefore MySQL is 5.1, but where I
work, we still standardise on Debian Lenny (upgrading to Squeeze, is in
the pipeline), therefore, MySQL is 5.0.
What I would like to know is, can I just make a copy of the mysql
database files and copy them the
March, 2011 2:07:11 PM
Subject: Mysql 5.1 - 5.0
Hiya
We have client that is using Ubuntu, therefore MySQL is 5.1, but
where I
work, we still standardise on Debian Lenny (upgrading to Squeeze, is
in
the pipeline), therefore, MySQL is 5.0.
What I would like to know is, can I just make
Hi All
I am trying to setup replication between 2 mysql servers, however
when running the command below on the slave machine, I get the error as
shown below.
CHANGE MASTER TO MASTER_HOST='IP removed', MASTER_USER='repladmin',
MASTER_PASSWORD='password', master_log_file=‘mysql-bin.000620’,
Dear All,
I need to install MySQL 5.1.42 on ubuntu. MySQL site does not have installer
packages for ubuntu(.deb).
If I need to use tar.gz is there any document available which will help me do
this specific changes.
Any input will be great help. As I need to set it up urgently.
Thanks in
2010/8/23 Manasi Save manasi.s...@artificialmachines.com:
Dear All,
I need to install MySQL 5.1.42 on ubuntu. MySQL site does not have installer
packages for ubuntu(.deb).
If I need to use tar.gz is there any document available which will help me
do this specific changes.
Follow the
I'm looking to implement a new website, which will have on average around
100 approx users at any one time. Is there anything I need to be aware of
when setting up MySQL in terms of the server configuration ?
Regards
Neil
HI All
Maybe you can assist.
We are looking at upgrading a clients' MySQL 5.0 to version
5.1.
They are running the following version: mysql Ver 14.12
Distrib 5.0.72sp1, for unknown-linux-gnu (x86_64) using readline 5.1
Hi Machiel, all!
Machiel Richards wrote:
[[...]]
We are looking at upgrading a clients' MySQL 5.0 to version
5.1.
Good.
They are running the following version: mysql Ver 14.12
Distrib 5.0.72sp1, for unknown-linux-gnu (x86_64) using readline 5.1
Which
Hello,
Would appreciate if any you post the steps to upgrade MySQL 5.0 to
higher versions (5.1, 5.4)on Solaris 10 ,X_64 box.
Thanks Regards,
S Paul
I would like to note to the MySQL development team that there is no download
available for MySQL 5 Community Edition for a Mac Power PC and
OS X 10.5. There is a MySQL 4/PPC/OSX 10.4 download and there is a MySQL
5/Intel/OSX 10.5 download.
I tried the MySQL 5.1 /x86-64/OSX 10.5 download
Boosting Performance With MySQL 5.1 Partitioning
http://forge.mysql.com/wiki/Boosting_Performance_With_MySQL_5.1_Partitioning
This Thursday (June 4th, 14:00 UTC), Giuseppe Maxia will give a MySQL
University session on Boosting Performance With MySQL 5.1 Partitioning.
Giuseppe is leading
are recorded (slides and audio), so if you
can't attend the live session you can look at the recording anytime
after the session.
Here's the schedule for the upcoming weeks:
# June 4, 2009: Boosting Performance With MySQL 5.1 Partitioning
(Giuseppe Maxia)
# June 11, 2009: Building MySQL Releases on Unix
scheduled
* June 4, 2009: Boosting Performance With MySQL 5.1 Partitioning
(Giuseppe Maxia)
* June 11, 2009: Building MySQL Releases on Unix (Jörg Brühe)
* June 18, 2009: Architecture of MySQL Backup (Lars Thalmann)
* July 2 (tentative): Starring Sakila - a data warehouse mini-tutorial
(Roland Bouman
Until recently I have been using 4.0.25 and have just upgraded to 5.1
and just wondered if MySQL now enabled me to store queries in the
database rather than have to put them all on my pages. Basically, I
want to be able to write some select statements and save them in the
database.
Mat,
On Tue, Mar 17, 2009 at 2:04 PM, Matthew Stuart m...@btinternet.com wrote:
Until recently I have been using 4.0.25 and have just upgraded to 5.1 and
just wondered if MySQL now enabled me to store queries in the database
rather than have to put them all on my pages. Basically, I want to be
Until recently I have been using 4.0.25 and have just upgraded to 5.1
and just wondered if MySQL now enabled me to store queries in the
database rather than have to put them all on my pages. Basically, I
want to be able to write some select statements and save them in the
database.
Matthew,
wondered if MySQL now enabled me to store queries in the database
In three ways---stored procedures; views; and prepared statements built
from query strings that come from anywhere including your own tables.
PB
http://www.artfulsoftware.com
-
Matthew Stuart wrote:
Until
Hi,
Is there any way to rollback a transaction in MySQL 5.1 that contains
Create, Alter, Drop, table statements.
i.e. is there any way to turn off the feature:
Statements That Cause an Implicit Commit
or even remove some of the default statements that cause a commit.
I tried using
On Mon, Mar 16, 2009 at 10:25 AM, Hatem Nassrat hatem.nass...@gmail.com wrote:
Hi,
Is there any way to rollback a transaction in MySQL 5.1 that contains
Create, Alter, Drop, table statements.
No. Sorry.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Jake Maul wrote:
Didn't want this to go unanswered, although I don't have any great
info for you.
As long as you're running a 64-bit OS and a 64-bit version of MySQL,
there's no technical reason it would be limited to less than the
addressable space (that I know of). The main gain would
At 01:08 PM 1/20/2009, you wrote:
While specing out a new server, I was wondering if there is any limit to
how much memory can be allocated to mysql 5.1. If a server has 16GB of
ram, can mysql take advantage of that much ram (minus a reserved amount
for the OS obviously)? Is there any limit
wrote:
At 01:08 PM 1/20/2009, you wrote:
While specing out a new server, I was wondering if there is any limit to
how much memory can be allocated to mysql 5.1. If a server has 16GB of ram,
can mysql take advantage of that much ram (minus a reserved amount for the
OS obviously)? Is there any
mailto:mo...@fastmail.fmmo...@fastmail.fm wrote:
At 01:08 PM 1/20/2009, you wrote:
While specing out a new server, I was wondering if there is any limit to
how much memory can be allocated to mysql 5.1. If a server has 16GB of
ram, can mysql take advantage of that much ram (minus a reserved amount
much memory can be allocated to mysql 5.1. If a server has 16GB of ram, can
mysql take advantage of that much ram (minus a reserved amount for the OS
obviously)? Is there any limit such as those imposed by 32-bit processors?
Thanks!
http://www.retailretreat.com
--
MySQL General Mailing
memory can be allocated to mysql 5.1. If a server has 16GB of
ram, can mysql take advantage of that much ram (minus a reserved amount
for the OS obviously)? Is there any limit such as those imposed by
32-bit processors?
Thanks!
http://www.retailretreat.com
--
MySQL General Mailing List
While specing out a new server, I was wondering if there is any limit to how
much memory can be allocated to mysql 5.1. If a server has 16GB of ram, can
mysql take advantage of that much ram (minus a reserved amount for the OS
obviously)? Is there any limit such as those imposed by 32-bit
mos wrote:
I'm using MySQL 5.1.30 (WinXP) and user defined variables don't seem to
be working properly if the Select statement is sorted.
Here is a simple example:
CREATE TABLE `tmp` (
`Purch_Date` date DEFAULT NULL,
`Product` char(10) DEFAULT NULL
) ENGINE=MyISAM
On Mon, Jan 19, 2009 at 4:14 AM, b my...@logi.ca wrote:
mos wrote:
I'm using MySQL 5.1.30 (WinXP) and user defined variables don't seem to be
working properly if the Select statement is sorted.
Here is a simple example:
CREATE TABLE `tmp` (
`Purch_Date` date DEFAULT NULL,
At 03:14 AM 1/19/2009, b wrote:
mos wrote:
I'm using MySQL 5.1.30 (WinXP) and user defined variables don't seem to
be working properly if the Select statement is sorted.
Here is a simple example:
CREATE TABLE `tmp` (
`Purch_Date` date DEFAULT NULL,
`Product` char(10)
mos wrote:
At 03:14 AM 1/19/2009, b wrote:
mos wrote:
I'm using MySQL 5.1.30 (WinXP) and user defined variables don't seem
to be working properly if the Select statement is sorted.
Here is a simple example:
CREATE TABLE `tmp` (
`Purch_Date` date DEFAULT NULL,
`Product`
This means anytime a user defined variable like @num := @num + 1 and is
used in a query that is sorted, it is going to have to be changed to a
subquery. For example, if someone was using it to display detail line item
numbers on an invoice, it now has to be turned into a subselect. This breaks
I'm using MySQL 5.1.30 (WinXP) and user defined variables don't seem to be
working properly if the Select statement is sorted.
Here is a simple example:
CREATE TABLE `tmp` (
`Purch_Date` date DEFAULT NULL,
`Product` char(10) DEFAULT NULL
) ENGINE=MyISAM DEFAULT
items has approx 30 million rows in it and there are approx 5,000
rows for 'ABC'.
I copied these tables over from the MySQ 5.0 data directory to the MySQL
5.1 data directory.
My question is this. Has the table or index structure changed in 5.1? Do I
have to optimize all of the tables before
On Sun, Jan 11, 2009 at 2:24 PM, mos mo...@fastmail.fm wrote:
Yesterday I decided to take the plunge and upgrade from MySQL 5.01 to 5.1.30
because after all, it was Saturday and what else is there to do on a
Saturday?
I'm running it on XP Pro with 3gb ram and used the my.ini for very large
At 03:25 PM 1/11/2009, you wrote:
On Sun, Jan 11, 2009 at 2:24 PM, mos mo...@fastmail.fm wrote:
Yesterday I decided to take the plunge and upgrade from MySQL 5.01 to
5.1.30
because after all, it was Saturday and what else is there to do on a
Saturday?
I'm running it on XP Pro with 3gb ram
On Sun, Jan 11, 2009 at 9:31 PM, mos mo...@fastmail.fm wrote:
At 03:25 PM 1/11/2009, you wrote:
On Sun, Jan 11, 2009 at 2:24 PM, mos mo...@fastmail.fm wrote:
Yesterday I decided to take the plunge and upgrade from MySQL 5.01 to
5.1.30
because after all, it was Saturday and what else is
http://developers.slashdot.org/article.pl?sid=08%2F12%2F09%
2F0047225from=rss
Sun's Mickos Is OK With Monty's MySQL 5.1 Rant
Back on November 29, MySQL developer Michael Widenius trashed Sun's
decision to give MySQL 5.1 a 'generally available' designation in a
now-infamous blog post. Widenius
[EMAIL PROTECTED]
Subject: Re: Sun's Mickos Is OK With Monty's MySQL 5.1 Rant WAS: MySQL Server
5.1.30 has been released
To: mysql mysql@lists.mysql.com
Date: Tuesday, 9 December, 2008, 8:12 PM
http://developers.slashdot.org/article.pl?sid=08%2F12%2F09%
2F0047225from=rss
Sun's Mickos Is OK
Hi!
If you want to know what to expect from MySQL 5.1 GA and when to start
using it, please check my blog at:
http://monty-says.blogspot.com/
Regards,
Monty
Creator of MySQL
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Make sure your log_bin_trust_function_creator is on.
On Sun, Sep 28, 2008 at 3:04 AM, Jesse [EMAIL PROTECTED] wrote:
I'm trying to use existing functions from a restored database from 5.0xx to
5.1, and get an error about the mysql.proc table is missing or corrupt. The
mysql.proc table appears
I'm trying to get our new Windows Server 2008 running. I believe I heard
that I have to install 5.1 on there to get it running. I think I'm aout to
find out, because I'm giong to uninstall 5.1 and install 5.0.xxx At any
rate, here's what's going on:
I bring up the Query Browser GUI, and
I'm trying to use existing functions from a restored database from 5.0xx to
5.1, and get an error about the mysql.proc table is missing or corrupt. The
mysql.proc table appears to be there, and does not appear to be corrupt. I
did a grant select on mysql.proc to user, and that did not make any
Hi,
A little over a year since the project to write this book began, the
MySQL 5.1 Cluster Certification Study Guide is now at long last
available. Covering the Certified MySQL 5.1 Cluster Database
Administrator exam, this study guide is the one authority to look to
when you're preparing
Sid Lane wrote:
any update on the 5.1 general release date? is it still on target for
Q4 -
Q1? any narrower window?
Last I heard, Q2 next year.
Regards
--jm
On 8/30/06, Colin Charles [EMAIL PROTECTED] wrote:
Logan, David (SST - Adelaide) wrote:
Hi!
Does anybody have any idea when 5.1
any update on the 5.1 general release date? is it still on target for Q4 -
Q1? any narrower window?
On 8/30/06, Colin Charles [EMAIL PROTECTED] wrote:
Logan, David (SST - Adelaide) wrote:
Hi!
Does anybody have any idea when 5.1 may come to General Release? I am
particularly interested in
Logan, David (SST - Adelaide) wrote:
Hi!
Does anybody have any idea when 5.1 may come to General Release? I am
particularly interested in MySQL Cluster as I have several databases
(around 50) totalling 26Gb and would like to consider moving to this
version because of the Cluster Disk Data
Logan, David (SST - Adelaide) wrote:
Hi Folks,
Does anybody have any idea when 5.1 may come to General Release? I am
particularly interested in MySQL Cluster as I have several databases
(around 50) totalling 26Gb and would like to consider moving to this
version because of the Cluster Disk
Hi Folks,
Does anybody have any idea when 5.1 may come to General Release? I am
particularly interested in MySQL Cluster as I have several databases
(around 50) totalling 26Gb and would like to consider moving to this
version because of the Cluster Disk Data Storage and the fact the
current
The cluster engine has been available since the 4.0 tree, I believe. You can
begin using it immediately with 5.0 (which is GA).
David
Logan, David (SST - Adelaide) wrote:
Hi Folks,
Does anybody have any idea when 5.1 may come to General Release? I am
particularly interested in MySQL
The Chinese translation of the MySQL Reference Manual is complete. It
was done by one of our partners from Beijing, People's Republic of
China, and covers MySQL 5.1. Due to problems beyond our control it's not
available in CHM or PDF, but you can view it online, or download the
HTML version:
http
72 matches
Mail list logo