Description:
In the tab services, item databases, choice mySQL server
at localhost, right click, admin properties tab of window mySQl
server properties
Path to start command /usr/local/mysql/support-files/mysql.server
with argument start : don't work
Path to stop command
lists,
I have tried utilizing partitioning (mysql 5.1.35 advanced version)
from mysql docs, it has been said that insert delayed on partitioning table
isn't supported.
and when perform insert like this:
insert delayed into tbla values(...);
the error that mentioned by documents is coming.
but
Who can please tell me what is mean of The db storage is on fiber
channel.?
On Fri, Jun 26, 2009 at 1:05 AM, mos mo...@fastmail.fm wrote:
Mike,
I re-posted your Show Status to the group to see if anyone can offer a
way to speed up the indexing for you.
BTW, you are adding ALL of the
Login mysql client. Do the following commands.
tee ie.txt;
...
notee;
On Thu, Jun 25, 2009 at 10:29 PM, John Daisley
john.dais...@mypostoffice.co.uk wrote:
SELECT INTO OUTFILE does almost the same thing as spool in SQL*Plus
SELECT columnname from tablename into outfile
Could you tell me your detail statements?
On Wed, Jun 24, 2009 at 9:46 AM, sangprabv sangpr...@gmail.com wrote:
Hi,
I found every time I try to do multiple rows delete on replicated MySQL
is always failed. Is there any explanation regarding this issue and how
to solve it? TIA.
Willy
--
Hi.
I think you should create an index like this.
alter table user add index idx_tmp (key1,key2,key3,user_id)
2009/6/19 Darryle Steplight dstepli...@gmail.com
Select user_id from user where key1=value and
key2=value2 and key3=value2 GROUP BY user_id
is faster than
Select distinct
Hi.
I think innodb will split these into many small pieces and then merge them
to execute.
On Thu, Jun 18, 2009 at 1:52 PM, Krishna Chandra Prajapati
prajapat...@gmail.com wrote:
Hi guys,
On MIS (management information system) server we have 16GB of physical
memory. 10GB has been allocated
Hi.
Can you give me a flow of your master/slave?
On Wed, Jun 24, 2009 at 7:45 PM, 赵琦 tyzha...@gmail.com wrote:
hi all:
I have three mysql database,tow run as master and the other one runs as
slave.
Some tables in the database have an autoincreament field named as 'rowid'.
These
tables
Hi.
This is a good choice!
On Tue, Jun 23, 2009 at 5:53 PM, Janek Bogucki
janek.bogu...@studylink.comwrote:
Have you tried SQL Developer? It works great with Oracle and also
supports MySQL,
http://www.oracle.com/technology/products/database/sql_developer/files/what_is_sqldev.html
Hi.
If you know chinese, I advise that you should visit the website called
http://yueliangdao0608.cublog.cn
On Sat, Jun 20, 2009 at 10:44 AM, michel compu...@videotron.ca wrote:
I have MySQL set up and running, but I am under the impression that I am
unable to password protect it properly
Have a look at create table as select and the csv engine.
On Thu, Jun 25, 2009 at 4:18 PM, Lin Chun franks1...@gmail.com wrote:
Hi
In mysql , how can we stock the query result into a text file
the table is too large , i don't want to dump it , but select a part of it,
i wrote a script perl
DELETE FROM table WHERE key LIKE '%100%'
Also I tried to continously insert big numbers of new records (around 50
millions new records) and tried to delete 1 record on master, I checked
the slave not synchronized. Is it just a lag?
Willy
On Fri, 2009-06-26 at 16:14 +0800, Moon's Father wrote:
-Original Message-
From: Moon's Father [mailto:yueliangdao0...@gmail.com]
Sent: Friday, June 26, 2009 4:12 AM
To: mos
Cc: mysql@lists.mysql.com
Subject: Re: Indexing dynamics in MySQL Community Edition 5.1.34
Who can please tell me what is mean of The db storage is on fiber
channel.?
-Original Message-
From: Moon's Father [mailto:yueliangdao0...@gmail.com]
Sent: Friday, June 26, 2009 4:13 AM
To: john.dais...@butterflysystems.co.uk
Cc: Lin Chun; mysql@lists.mysql.com
Subject: Re: How can we stock the query result into a text file
Login mysql client. Do the following
Oops, my spell checker got the better of me: it should be Fibre Channel.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
-Original Message-
From: Jerry Schwartz
I have a website where my database is continuously growing. And I started being
worried about performance.
I have a couple of questions, and I would appreciate it very much if you can
elaborate on them.
- I have about 70 tables in the same database. some of them are becoming very
large (over
At 10:25 AM 6/26/2009, you wrote:
I have a website where my database is continuously growing. And I started
being worried about performance.
I have a couple of questions, and I would appreciate it very much if you
can elaborate on them.
- I have about 70 tables in the same database. some of
1 million records is not a lot at all if you have it indexed right.
I've worked with systems where tables grew by 30 million records per
month. Although we only kept about 300 million records at any one
time.
It's not really the size or record count you need to worry about, but
the activity. You
Hi All,
I want to create a table that defaults to current_date and current_time.
I have:
CREATE TABLE `personalevent`(
`pevent` mediumint(10) NOT NULL,
`eventid` mediumint(10) NOT NULL,
`userid` mediumint(10) NOT NULL,
`username` varchar(10) NOT NULL,
Hi Jason
The DEFAULT value can't be an expression.
2009/6/26 Jason Todd Slack-Moehrle mailingli...@mailnewsrss.com
Hi All,
I want to create a table that defaults to current_date and current_time.
I have:
CREATE TABLE `personalevent`(
`pevent` mediumint(10) NOT NULL,
-Original Message-
From: Jason Todd Slack-Moehrle [mailto:mailingli...@mailnewsrss.com]
Sent: Friday, June 26, 2009 1:10 PM
To: mysql@lists.mysql.com
Subject: Default Date and Time
Hi All,
I want to create a table that defaults to current_date and current_time.
[JS] Would a timestamp
After a few off-list e-mails with Tim, I issued
ALTER TABLE dbmail_messageblks ADD INDEX ( blocksize AND physmessage_id );
which took almost 11 hours to index. Once done, however, my select
statement went from a hair over 50 minutes to 15 seconds. (1.69 seconds
after the index was cached.)
Hi Walter,
Walter Heck - OlinData.com wrote:
Hey Tim, all
On Wed, Jun 24, 2009 at 10:03 AM, Little,
Timothytlit...@thomaspublishing.com wrote:
Why, you might ask, index on physmessage_id? Because then the db won't
have to do a fetch on items from the table since it's in the INDEX
itself,
Hello Nathan,
Nathan Huang wrote:
Hello
I want to fetch and calculate the data from remote database(for example
Japan) and insert them into my local database(for example usa), does
mysql have such function to do it, or do I have to write a script using
perl or other language to help
Thanks, I am looking answer internally how the thinks work.
Regards,
Krishna
On Fri, Jun 26, 2009 at 2:33 PM, Moon's Father yueliangdao0...@gmail.comwrote:
Hi.
I think innodb will split these into many small pieces and then merge them
to execute.
On Thu, Jun 18, 2009 at 1:52 PM, Krishna
25 matches
Mail list logo