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 matc
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: http://lists.mysql.com/mysq
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
fi
>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 t
Nuno Pereira wrote:
To do date change the first line from
printf(" number_format({$thearray[cost]}, 2)
to
printf(" ".number_format({$thearray[cost]}, 2)."
I think you mean:
print( "" . number_format( $thearray['cost'], 2 ) . "" );
As stated by a previous poster to this thread, you should
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 indexes
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 w
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 recen
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 th
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 h
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 serve
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, Septemb
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 o
> 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 AUTOCOMM
Bill Whitacre wrote:
I can get this to work just fine:
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 = mysql_query("SELECT org, COUNT(*), SUM(annual_cost) AS
cost FROM a05
> 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,
> wha
Bill Whitacre wrote:
printf(" {$thearray[org]}
{$thearray["COUNT(*)"]}
$ {$thearray[cost]} ");
If I replace
{$thearray[cost]}
with
number_format({$thearray[cost]}, 2)
Although this is a MySQL mailing list and your problem is not MySQL
related, but a PHP question I'
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
-Origi
I can get this to work just fine:
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 = mysql_query("SELECT org, COUNT(*), SUM(annual_cost) AS
cost FROM a05
GROUP BY org ORDER BY
> 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) ho
"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
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 h
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 you
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 Infi
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 t
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 mil
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 u
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 th
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:
http://dev.mysql.com/doc/
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 reco
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 f
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,
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
33 matches
Mail list logo
