hi,
I need to have 2 DB in our development/production environment which require
both InnoDB and MyISAM engines. This is bacasue, DB1 contains spatial/geom data
which has to be on MyISAM engine and DB2 which needs transactional support has
to be InnoDB.
Now how to achieve this co-existance of
PRASHANT N wrote:
hi,
I need to have 2 DB in our development/production environment which
require both InnoDB and MyISAM engines. This is bacasue, DB1 contains
spatial/geom data which has to be on MyISAM engine and DB2 which
needs transactional support has to be InnoDB.
Now how to achieve this
hi,
thnaks for the speedy reply. I already have both the DBs in my server. is there
any way/method that the DB2 which needs transaction support can be converted
from myisam to innodb format without any hitch
regards
shann
___
Which
PRASHANT N wrote:
thnaks for the speedy reply. I already have both the DBs in my
server. is there any way/method that the DB2 which needs transaction
support can be converted from myisam to innodb format without any
hitch
http://dev.mysql.com/doc/mysql/en/alter-table.html
I would strongly
Hello.
Usually only benchmarks will show a real picture
for you. Create foreign keys, perform some tests. Then
temporary disable FKs using SET FOREIGN_KEY_CHECKS=0 and
repeat the performance measurement. Super Smack is a good
tool for such kind of analysis. See:
Hello.
Not enough information to make a conclusion. Please provide OS and MySQL
version. Include the problematic query and tables definitions which are
affected by the query.
Logg, Connie A. [EMAIL PROTECTED] wrote:
I am trying to reload/rebuild a table from the backup and I get this =
Hi all,
Willing to test an upgrading path from 4.0 to 4.1 database of MySQL.
Could someone provide a link or some slice of unload from a 4.0 with
encodings different from latin1 ?
Thanks in advance,
Francesco R.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
hi ,
I am using the Load Infile utility to load data from file to MySQL DB.
When trying to load different amounts of data, I observed a notable
difference in the time taken by that.
Test 1
Amount of data - 5.5 million rows. Time Taken - 6+hrs Approximately.
Test2
Amount of data - 0.45
Are there indexes on the table? Could be that.
--Original Message--
From: Sujay Koduri
To: mysql
Sent: Sep 13, 2005 5:24 AM
Subject: Major Difference in response times when using Load Infile utility
hi ,
I am using the Load Infile utility to load data from file to MySQL DB.
When trying
Yes, there are indexes on the table. Do you mean to say index is the
culprit.
sujay
-Original Message-
From: Peter J Milanese [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 13, 2005 4:58 PM
To: Sujay Koduri; mysql
Subject: Re: Major Difference in response times when using Load
Indexing can play a big role in the load time differential. When
loading .45 million rows, MySQL may be able to handle the sorting for
indexes in memory. With 5.5 million, it's more likely to have to go
to a temp file. You then could end up thrashing you disk, causing big
slow downs. If
Josh Chamas wrote:
Ryan Stille wrote:
Has anyone ever used this MSSQL-to-MySQL converter? It's pretty
reasonable at $40, and the demo output I got looked pretty good. But
I wanted to see if there is anything I should be weary about.
http://www.convert-in.com/mss2sql.htm
I have done a
Ryan Stille [EMAIL PROTECTED] wrote on 09/13/2005 08:42:05 AM:
Josh Chamas wrote:
Ryan Stille wrote:
Has anyone ever used this MSSQL-to-MySQL converter? It's pretty
reasonable at $40, and the demo output I got looked pretty good. But
I wanted to see if there is anything I should be
OK, you confused me. How can 16 be bigger than 16? For character-based
fields, the number in the parentheses shows the length of the field,
does it not? The first part, the text or char or varchar or ...,
tells the engine what kind of data a field will contain.
How can TEXT(16) hold more
I can get this to work just fine:
?php
$number = 23999.39;
print $;
print number_format($number, 2);
?
Comes out $23,999.39
I'd like use the number_format() thingie on an array returned from a
mysql_query.
My current program snippet looks like:
$res =
I believe the (16) is the size of offset pointer used to locate the text
data elsewhere on the disk. They are all (16 bits)...Sybase does this as
well and is an odd (ok it's stupid) notation. This is one of those
things you need to adjust by hand when convert from one db to another.
Ed
Bill Whitacre wrote:
printf(trtd {$thearray[org]} /td
td align=right {$thearray[COUNT(*)]} /td
td align=right $ {$thearray[cost]} /td/tr);
If I replace
{$thearray[cost]}
with
number_format({$thearray[cost]}, 2)
Although this is a MySQL mailing list and your problem is
I've 10 server in differents locations, I want to make a broadcast, I
would like to have always datas synchronized between this network, each
database have the same tables and same structure. Each insert or update
in database will be executed for each server within this broadcast,
what's
Bill Whitacre wrote:
I can get this to work just fine:
?php
$number = 23999.39;
print $;
print number_format($number, 2);
?
Comes out $23,999.39
I'd like use the number_format() thingie on an array returned from a
mysql_query.
My current program snippet looks like:
Test 1
Amount of data - 5.5 million rows. Time Taken - 6+hrs Approximately.
Test2
Amount of data - 0.45 million rows. Time Taken - 2 mins approximately.
Is this an InnoDB database by any chance? If it is, and it is a clean
import, then disable the FOREIGN_KEY_CHECKS.
SET AUTOCOMMIT =
quoting Alan Williamson [EMAIL PROTECTED] ..
This recipe is intended to minimize the impact on ongoing database
operations by inhibiting writes only during a relatively speedy
operation (creating a snapshot). The long dump operation can ...
This seems to be a rather long winded way of doing
Hi
I am INNODB tables only. (I have only one big table)
Autocommit I have already disabled.
And it doesn't have any foreign keys in it. Do I still need to set the
FOREIGN_KEY_CHECKS to '0'??
sujay
-Original Message-
From: Alan Williamson [mailto:[EMAIL PROTECTED]
Sent: Tuesday,
Hi,
I host a big french website including forum (phpbb), search engine (mnogo),
album (smartor), blogs... around 780Mo in MySQL
Everything work fine with my old configuration :
- One SQL/mail server bi-Xeon, 2.6Ghz, 3Go :
FC4, MySQL 4.0, Postfix-Mysql, Courier-imap Mysql
- One front
Is it possible to have cluster and replication? (ie clusters at each
location and replication to sync each location)
Alan Williamson wrote:
I've 10 server in differents locations, I want to make a broadcast, I
would like to have always datas synchronized between this network, each
database
Hi all,
I found that load infile should not take this much time(6 hrs) to load 5.5
million queries. Some people are saying it should not even take more than
10mins. So I think I am doing something wrong in my my.cnf file. I am Using
MySQL 4.1.13 version and 2.4.20 kernel on RH9. I am including
Hello.
SERIAL is an alias for BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE.
So you really specifying two keys (primary and unique). See:
http://dev.mysql.com/doc/mysql/en/news-4-1-0.html
http://bugs.mysql.com/bug.php?id=13140
Kemin Zhou [EMAIL PROTECTED] wrote:
I
This isn't a constraint, this is a limit, the goal is to have a
bi-directional replication but I've not found solutions to my problem
using mysql. I've a control access system with 9 minitowers which
controls people access via RFID, each minitower is provided with linux
and mysql synchronized
Hello.
Sometimes, after an upgrade it is necessary to rebuild indexes
in the tables (I'm not sure if it always produces an error if
you haven't done it). In general - usual recommendations for
optimizing queries work in your case. Use the slow query log
to find slow queries. Check if
Nuno Pereira wrote:
To do date change the first line from
printf(trtd number_format({$thearray[cost]}, 2) /td
to
printf(trtd .number_format({$thearray[cost]}, 2). /td
I think you mean:
print( trtd . number_format( $thearray['cost'], 2 ) . /td );
As stated by a previous poster to this
Description:
I get the following message error: 'Can't connect to local MySQL
server through socket '/tmp/mysql.sock' (61)' Everything has run
fine for along time. This is running on OS X server 10.3 and ever
since the ran the last software update mysql has not be available.
I have
Ed Collins wrote:
Description:
I get the following message error: 'Can't connect to local MySQL
server through socket '/tmp/mysql.sock' (61)'
This is the error the client gives when it cannot connect to the server,
usually because the server isn't running.
Everything has run
Hello,every one.
Is there a current criterion about database function to evaluating a
database?
_
免费下载 MSN Explorer: http://explorer.msn.com/lccn/
--
MySQL General Mailing List
For list archives:
hello
i hv one query as explained below :
Table FIRST contains
This is
What is this
how
whom
color
white
Table SECOND contains
WHOM
THIS IS
WHAT
WHITE AND BLACK
i want the result as
This is
what is this
what
whom
white
WHITE AND BLACK
i want a query which searches both table for exact
33 matches
Mail list logo