Is it dedicated to mysql only? what operating system does it run?
Sayed Hadi Rastgou Haghi wrote:
Dear All,
What is the best configuration for a server with 2 XEON dual core CPU and
4GB Ram and 200GB RAID 5 hard?
--
PO Box 26453 00504
Nairobi, Kenya.
TEL: +254722996532
[EMAIL PROTECTED]
--
M
Dear All,
What is the best configuration for a server with 2 XEON dual core CPU and
4GB Ram and 200GB RAID 5 hard?
--
Sincerely,
Hadi Rastgou
A Google Account is the key that unlocks the world of Google.
http://www.spreadfirefox.com/?q=affiliates&id=0&t=1";> Get
FireFox!
mos wrote:
At 08:41 PM 9/25/2006, you wrote:
Dilipkumar wrote:
Hi,
Its delete * from table will only do if you go for a truncate it will
recreate the table structure ?
It's better to use delete.
Can you explain why? I'd go for instant truncate rather than waiting
around for delete to f
At 08:41 PM 9/25/2006, you wrote:
Dilipkumar wrote:
Hi,
Its delete * from table will only do if you go for a truncate it will
recreate the table structure ?
It's better to use delete.
Can you explain why? I'd go for instant truncate rather than waiting
around for delete to finish.
The
Dilipkumar wrote:
Hi,
Its delete * from table will only do if you go for a truncate it will
recreate the table structure ?
It's better to use delete.
Can you explain why? I'd go for instant truncate rather than waiting
around for delete to finish.
--
MySQL General Mailing List
For lis
Is there a collation where 'œ' = 'oe' so that "cœur" is sorted between
"codirection" and "coffre"? I am currently using "latin1_swedish_ci" and
the 'œ' gets sorted to the end ("cœur" appears after "czar").
I am using "MySQL 5.0.22-Debian_0ubuntu6.06.2".
Thanks.
--
Brian P. Giroux
--
MySQL Ge
Thanks for the detailed feedback. I do not create the data so I can't
modify it. Your illustration of the table is correct. I'll try to
implement some of your feedback.
Thanks
On 9/25/06, Michael Stassen <[EMAIL PROTECTED]> wrote:
Jeff Drew wrote:
> I have a query with a subquery which does
True, but they are very slow in 4.1.14.
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 26 September, 2006 00:12 AM
To: Ravi Kumar.
Cc: mysql@lists.mysql.com
Subject: Re: Conditional copy of values
Ravi Kumar. wrote:
> Dear All,
>
> I have 2 tables Ta
Ravi Kumar. wrote:
Dear All,
I have 2 tables Table1 and Table2. In Table1 rowid is primary key and in
Table2 rowid is primary key as well as foreign key (referring to rowid in
Table1).
There are several other columns in Table1, but Table2 has only one col -
rowid.
I want to insert rowid i
David Godsey wrote:
> I am looking for a way to write a client program that will wake up when
> there is new data in the database, much like replication.
>
> So instead of my client pulling the database on some fixed interval, I
> would like the mysql daemon to push the data to my client when ther
Jeff Drew wrote:
> I have a query with a subquery which does not throw an error, but does not
> return either. I've been testing the query using mysql Query Browser and
> the poor dolphin jumps only once a minute or so ;) I use MYSQL's
> excellent error documentation heavily so if the query do
Have you dumped out your variables to make sure none of them is a
zero-length string? That would surely cause your problem.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Ed Curt
damn outlook!
fire up perl's CPAN interface:
perl -MCPAN -eshell
cpan> i /mysql/
...
Bundle Bundle::DBD::mysql (C/CA/CAPTTOFU/DBD-mysql-3.0007.tar.gz)
...
cpan> install Bundle::DBD::mysql
>>>-Original Message-
>>>From: Jørn Dahl-Stamnes [mailto:[EMAIL PROTECTED]
>>>Sent: M
someone correct me if I am wrong.
DBI is the generic database interface module for perl
DBD::mysql is the mysql specific module DBI relies upon to talk to mysql.
cpan> i /mysql/
>>>-Original Message-
>>>From: Jørn Dahl-Stamnes [mailto:[EMAIL PROTECTED]
>>>Sent: Monday, September 25,
I try to write a perl script that will update a mysql database, but when
running the script I get:
install_driver(mysql) failed: Can't locate DBD/mysql.pm
I have installed DBI 1.52, but that did not help. Now I have spend 1 hour
searching internet for this well hidden file mysql.pm, but withou
I'm trying to do a keyword search within a phrase saved in a table.
Here's the query:
SELECT * from closedtickets WHERE
keyphrase LIKE '%$keyword1%'
OR keyphrase LIKE '%$keyword2%'
OR keyphrase LIKE '%$keyword3%'
The problem I'm having is that the query is returning every record in th
It only works with engines that support transactions like innodb and
solid, i strongly sugget to read these links from the manual.
http://dev.mysql.com/doc/refman/5.0/en/ansi-diff-transactions.html
http://dev.mysql.com/doc/refman/5.0/en/innodb-transaction-model.html
Carlos
On 9/25/06, [EMAIL
Besides some recent change on the engine, i remember that the initial
size is 0 because the metadata remains on the main ibdata file(s), and
grows as needed, there is no specific range of extending.
Carlos
On 9/25/06, Takanobu Kawabe <[EMAIL PROTECTED]> wrote:
Hello.
In InnoDB tables , some "
I have a query with a subquery which does not throw an error, but does not
return either. I've been testing the query using mysql Query Browser and
the poor dolphin jumps only once a minute or so ;) I use MYSQL's excellent
error documentation heavily so if the query doesn't throw an error, I'm
I have found in life that I get stuck, email a list and then figure it out
myself often. It was rather dumb!
Anyhow, here is what I have.
SELECT b.zip, b.state,b.storename, b.address1, b.address2, b.city, b.state,
b.zip, b.id,
ROUND((3956 * (2 * ASIN(SQRT(
POWER(SIN(((a.lat-b.lat)*0.017453293)/2
On Mon, 2006-09-25 at 06:09 -0700, Steffan A. Cline wrote:
> Basically all 6 should come up in the big query because they are within the
> same zip and that any other locations within the same area. They all have
> the same latitude and longitude but only 1 shows up.
If they all have the same lat/
Ran into a strange problem. In this zip code I am searching in I know for
sure I have 6 locations within the 63385 zip.
Doing a simple select * from locations where zip = '63385' returns 6 rows.
Basically all 6 should come up in the big query because they are within the
same zip and that any othe
Hi,
You can simply use the following query:
ALTER IGNORE TABLE ADD UNIQUE INDEX(cli,type,status);
On 9/25/06, gerodim <[EMAIL PROTECTED]> wrote:
Hi there, I have this serious issue about a db i have to work with
Thing is there is a table called cpsorders
This table has a structure
Hi there, I have this serious issue about a db i have to work with
Thing is there is a table called cpsorders
This table has a structure like this...
id,cli,type,schema,startdate,enddate,1date,2date,status,initiator
27425-210201021-XOR-3--00-00 00:00:00-2005-03-09 00:00:00-2006-05-23
Thanks for all the help on this one. Its a MyISAM table.
I ended up creating a temp table and selecting the data in... took 2 mins. I
feel totally blonde for not thinking of that earlier!
Thanks for being there, everyone!
Helen
- Original Message -
From: praj
To: Helen M Hudso
There must be some thing went wrong with your settings in my.cnf
file.For an 3 million records 24 hrs is bad :(
> |myisam_sort_buffer_size value in my.cnf ?
Also you can apporx check the status by doing file size check on the
table in database dir and the temoprory table created in the data ba
>I want a (very smart) sql query that wil check the data and see how
>it's possible to get SUM=100
SQL doesn't do recursion; sprocs do it, but slowly; so the job probably
belongs in the business logic or client layer.
PB
-
Ahmad Al-Twaijiry wrote:
Thanks Douglas,
I know my question is
Thanks Douglas,
I know my question is very hard
if my data was 22, 41, 10, 40, 30, 20, 201 ,22 ,20, 100 , 60 ,70
I want a (very smart) sql query that wil check the data and see how
it's possible to get SUM=100
for example in the data above the **result** **can be** :
10,40,30,20 > 100
On Mon, 2006-09-25 at 15:27 +0530, Mugunthan SIFY wrote:
> If you have enough disk space, create a temporary table with the four new
> columns. Insert into this table selecting records from the original table.
> Finally rename the tables.
isn't this resource intensive?
Then again, since the OP did
If you have enough disk space, create a temporary table with the four new
columns. Insert into this table selecting records from the original table.
Finally rename the tables.
Hope this helps.
Regards,
S.Mugunthan
-Original Message-
From: Ehrwin Mina [mailto:[EMAIL PROTECTED]
Sent: Monda
At 12:53 PM 9/25/2006, Helen M Hudson wrote:
I have a table with about 3million rows and I'm having trouble
altering it to add 4 more columns. I'm using the MySQL
Administrator and I've left it more than 24hours and its still not
finished. I was going to try using a login to the console next,
Hello.
In InnoDB tables , some "table name.ibd" files are created when the
"innodb_file_per_table" parameter is specified.
I want to know How the MySQL server determines the initial size of "table
name .ibd" files and the extended size of them.
Please tell me about this .
With regards
--
M
32 matches
Mail list logo
