Mathieu Bruneau <[EMAIL PROTECTED]> wrote:
> > BTW, here's another oddity I noticed - here's typical output from
> > "iostat 60":
> >
> > | avg-cpu: %user %nice%sys %iowait %idle
> > |7.350.003.590.94 88.12
> > |
> > | Device:tps Blk_read/s Blk_w
Ofer Inbar a écrit :
> mos <[EMAIL PROTECTED]> wrote:
>>> Why are so many small tmp tables being created on disk, not memory?
>>> How can I tell MySQL to use memory for these?
>
>>I'd guess these temporary files are the result of Select statements
>> with an Order By clause that requires
I've got a server with a database that's about 10G. I need several
other copies of this database, with different names, on the same host
and same MySQL instance.
I could mysqldump the db and then restore it into the others...
mysql> create database one;
mysql> create database two;
...
mysqldum
Hello,
http://dev.mysql.com/downloads/mysql/5.0.html#winx64
Let me know if that helps.
-- Jimmy
James Eaton wrote:
Is there a 64 bit build of MySQL 5.0 available for Windows Server 2003
64 bit edition?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubs
Doh... found it.
Why are the 'without installer' versions significantly larger than those
with the installer? I would expect it to be the other way around?
- Original Message -
From: "James Eaton" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, July 17, 2007 3:24 PM
Subject: 64 bit build
Is there a 64 bit build of MySQL 5.0 available for Windows Server 2003 64
bit edition?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mos <[EMAIL PROTECTED]> wrote:
> >Why are so many small tmp tables being created on disk, not memory?
> >How can I tell MySQL to use memory for these?
>I'd guess these temporary files are the result of Select statements
> with an Order By clause that requires a FileSort. You can do a Show
At 12:29 PM 7/17/2007, you wrote:
MySQL 5.0.27 running on Redhat EL4.
In /etc/my.cnf I have:
tmp_table_size=64M
mysql> SHOW GLOBAL VARIABLES LIKE "%tmp%";
+---+--+
| Variable_name | Value|
+---+--+
| max_tmp_table
MySQL 5.0.27 running on Redhat EL4.
In /etc/my.cnf I have:
tmp_table_size=64M
mysql> SHOW GLOBAL VARIABLES LIKE "%tmp%";
+---+--+
| Variable_name | Value|
+---+--+
| max_tmp_tables| 32 |
| slave_lo
some more info on this:
putting "user AS friend" improves the query, but does not eliminate the problem.
also, here are the version numbers for each sql server:
mysql Ver 12.22 Distrib 4.0.22, for portbld-freebsd4.9 (i386)
mysql.exe Ver 14.12 Distrib 5.0.24, for Win32 (ia32)
the query even r
Hi Jen,
Jen mlists wrote:
Hello members,
When I do mysql replication,I didn't replicate the system's "mysql"
database.
but someone updated the mysql db in master,then I got the errors on slave.
How to resolve it?Do I need to always replicate mysql db?thanks.
ERROR: 1146 Table 'mysql.mobilea
Hi,
Thufir wrote:
SELECT product_name, customer.name, date_of_sale
FROM `sales` , product, customer
WHERE product.product_id = sales.product_id
and customer.customer_id = sales.customer_id LIMIT 0, 30
The above SQL command links three tables and display the required
result. The tables are linke
Mogens Melander wrote:
On Tue, July 17, 2007 04:29, Baron Schwartz wrote:
B. Keith Murphy wrote:
Hey all. I have a bit of a problem. We are upgrading from ver 4.1.x to
5.0.45. That's not the problem :). The problem is that MySQL recommends
dumping and importing your data when doing this upgrade
In article <[EMAIL PROTECTED]> [EMAIL PROTECTED]
(BaronSchwartz) wrote:
> B. Keith Murphy wrote:
>> The problem is that I am realizing that this dump/import is going
>> to take hours and in some cases days. I am looking for any way to
>> speed this up. Any suggestions?
> The fastest way I've
> hi
>
> i am experimenting with sql for getting lists of friends.
>
> select friend.*
> from user
>left join link on user.id=link.id and user.id = $MYID
>right join user friend on link.friend_id = friend.id
> where user.name is null;
>
> on my local windows machine running mysql 5
hi
i am experimenting with sql for getting lists of friends.
select friend.*
from user
left join link on user.id=link.id and user.id = $MYID
right join user friend on link.friend_id = friend.id
where user.name is null;
on my local windows machine running mysql 5 it works fine, howev
On Tue, July 17, 2007 04:29, Baron Schwartz wrote:
> B. Keith Murphy wrote:
>> Hey all. I have a bit of a problem. We are upgrading from ver 4.1.x to
>> 5.0.45. That's not the problem :). The problem is that MySQL recommends
>> dumping and importing your data when doing this upgrade to make sure
>
Check out this thread:
http://www.sitepoint.com/forums/showpost.php?p=3357628&postcount=2
2007/7/17, [EMAIL PROTECTED] <[EMAIL PROTECTED]>:
Hello,
we have a MySQL DBMS with a lot of databases. Most of them are using
MyISAM tables but three databases use InnoDB and MyISAM tables.
What is the b
Hello,
we have a MySQL DBMS with a lot of databases. Most of them are using MyISAM
tables but three databases use InnoDB and MyISAM tables.
What is the best method to get a consitent ONLINE backup of both table types?
Thanks,
Spiker
--
Pt! Schon vom neuen GMX MultiMessenger gehört?
Der kan
Hello members,
When I do mysql replication,I didn't replicate the system's "mysql" database.
but someone updated the mysql db in master,then I got the errors on slave.
How to resolve it?Do I need to always replicate mysql db?thanks.
ERROR: 1146 Table 'mysql.mobilearea' doesn't exist
070717 15:2
20 matches
Mail list logo