I have created a table as follows but i was not able to use full text search on
a specific data.
create table racebike (id int auto_increment not null primary key, name
varchar(10), user text,fulltext(name,user));
The table is as follows,
++-+-+
| id | name
On 21/07/2010 16:33, Karthik Pr wrote:
I have created a table as follows but i was not able to use full text search on
a specific data.
create table racebike (id int auto_increment not null primary key, name
varchar(10), user text,fulltext(name,user));
[snip]
The query is
mysql select *
-Original Message-
From: MuraliKrishna [mailto:murali_kris...@arthaoptions.com]
Sent: Thursday, February 11, 2010 12:52 AM
To: mysql@lists.mysql.com
Subject: help me out for this scenario
I have a table like as follws
Emp_id, first_login , second_login
[JS] I think you are asking
8
From this I need a table like
Month, First_total(count(emp_id)), second_total(count(emp_id))
In first and second login the employee id will be consider only one time..
Please help me for this. thanks in advance
Whats the query if first loin and second login were from two different
tables.
..
if any body familiar with those.. please help me..
thnaks in advance
by
Muralikrishna
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
Here I have to update year column with reference to the row id
mysql update table1
- set year=case when id=1 then 2000
- when id=2 then 2001
- when id=3 then 2000
- when id=4 then 2001
- when id=5 then 2000
- when id=6 then 2001
- else 2003
- where
and 6;
Good luck!
Regards,
m
-Original Message-
From: MuraliKrishna [mailto:murali_kris...@arthaoptions.com]
Sent: Friday, February 05, 2010 12:04 PM
To: mysql@lists.mysql.com
Subject: help me out for this problem...
Here I have to update year column with reference to the row id
: Friday, February 05, 2010 12:04 PM
To: mysql@lists.mysql.com
Subject: help me out for this problem...
Here I have to update year column with reference to the row id
mysql update table1
- set year=case when id=1 then 2000
- when id=2 then 2001
- when id=3 then 2000
hi.. i like to know
really what is a cursor and a handler and those functionality and purpose...
i have tried much over net... but i didnt find proper material and examples
for those..
if any body familiar with those.. please help me..
thnaks in advance
by
Muralikrishna
I have come across a requirement where I need to store a very large amount of
data in a table.
In
one of our app.. we can have around 50 Million records each year.. Can
any one guide me in choosing a strategy than can handle this load.
Thanks
SN
Sudhir NimavatSenior software
sudhir543-nima...@yahoo.com wrote:
I have come across a requirement where I need to store a very large amount of data in a table.
In
one of our app.. we can have around 50 Million records each year.. Can
any one guide me in choosing a strategy than can handle this load.
50M records is not
, although I do not always like being taught
- Forwarded Message
From: sudhir543-nima...@yahoo.com sudhir543-nima...@yahoo.com
To: Jay Ess li...@netrogenic.com
Sent: Mon, 2 November, 2009 3:34:52 PM
Subject: Re: 50M records each year, help me choosing the stretegy
Its a very simple
: 50M records each year, help me choosing the stretegy
Its a very simple table that will store messages.
Each message would have subject, body,to_user_id,
from_user_id,is_deleted,date_sent and may be one or two more column
There would be frequent read operation and slow write operation
Sudhir, please remove the || from your name in your email: || Sudhir
Nimavat ||
We have about 1 BILLION rows of data here and we do a few tricks which may
or may not be of interest to you.
For starters, setup replication and write to a master and have at least 2
slaves. This makes backups MUCH
; mysql@lists.mysql.com
Cc: wi...@lists.mysql.com; mysql-h...@lists.mysql.com
Subject: RE: Please help me.
Velentin,
http://dev.mysql.com/doc/refman/5.1/en/innodb-foreign-key-constraints.html
Note the section for the droping of foreign keys used the contraint name,
not the key name. Try
like:
alter table documents_ex drop column Journal_ex_ID
or
alter table documents_ex drop foreign key Journal_ex_ID
or
alter table documents_ex drop key Journal_ex_ID
I receive the same error 150 and I don't know what to do.
Please help me.
Best regards.
--
MySQL General Mailing
the column after that.
From: Valentin Ionescu [colibry...@yahoo.com]
Sent: Wednesday, March 18, 2009 11:27 AM
To: mysql@lists.mysql.com
Cc: wi...@lists.mysql.com; mysql-h...@lists.mysql.com
Subject: Please help me.
Hi!
My name is Valentin and I am writing
Hi MySQL Users-
I have a query problem I have been working on for quite some time and I am
really at a loss to find a native function(s) to handle my task.
I have this table:
CREATE TABLE BookCategoryMetrics (
BookName VARCHAR(255),
CategoryId VARCHAR(128),
RatingSum DOUBLE,
Cost DOUBLE,
David,
My goal is to create a report, that lists the Top 100 most expensive
BookNames, for every CategoryId in this table.
I think you can map the example under Within-group quotas (Top N per
group) at http://www.artfulsoftware.com/infotree/queries.php to your
requirement.
PB
David
'./naxbmisq02-relay-bin.000157' not found
(Errcode: 2)
mysql
-Original Message-
From: David Giragosian [mailto:[EMAIL PROTECTED]
Sent: Sunday, August 10, 2008 12:54 PM
To: mysql@lists.mysql.com
Subject: Re: can some please help me -- REPLICATION
On 8/10/08, Jim Lyons [EMAIL PROTECTED] wrote
The background:
We are doing replication. The file-system containing the SLAVE's
relay-log got filled to capacity. Later on, I noticed replication has
not been working for the last month or more.
My Action:
I deleted the 2 oldest relay-log then attempted to restart SLAVE. Now,
the SLAVE will not
you should probably just resync your slave. If it hasn't run for over a
month then there's not a lot of point in trying to start it up. Even if you
did start the slave (which seems doubtful) you'd have over a month's worth
of commands to make up.
You can tell mysql to not keep relay logs that
On 8/10/08, Jim Lyons [EMAIL PROTECTED] wrote:
you should probably just resync your slave. If it hasn't run for over a
month then there's not a lot of point in trying to start it up. Even if
you
did start the slave (which seems doubtful) you'd have over a month's worth
of commands to make
Re: You can tell mysql to not keep relay logs that have already been
used.
What command does this
-Original Message-
From: David Giragosian [mailto:[EMAIL PROTECTED]
Sent: Sunday, August 10, 2008 12:54 PM
To: mysql@lists.mysql.com
Subject: Re: can some please help me -- REPLICATION
, August 10, 2008 12:54 PM
To: mysql@lists.mysql.com
Subject: Re: can some please help me -- REPLICATION
On 8/10/08, Jim Lyons [EMAIL PROTECTED] wrote:
you should probably just resync your slave. If it hasn't run for over
a
month then there's not a lot of point in trying to start it up. Even
To: Natalie Warshager
Cc: mysql@lists.mysql.com
Subject: Re: Can some one help me write it shorter?
Hi,
On Thu, Apr 3, 2008 at 3:25 AM, nataliew
[EMAIL PROTECTED] wrote:
I need querylike this that make a row of numbers (in one execute)
SELECT a from (
SELECT -1 a UNION ALL
Hi,
On Thu, Apr 3, 2008 at 3:25 AM, nataliew
[EMAIL PROTECTED] wrote:
I need querylike this that make a row of numbers (in one execute)
SELECT a from (
SELECT -1 a UNION ALL
SELECT -2 UNION ALL
SELECT -3 UNION ALL
SELECT -4 UNION ALL
SELECT -5 UNION ALL
SELECT -6 UNION ALL
You can use temporary table if you want short statement.
On Mon, Apr 7, 2008 at 9:24 AM, Baron Schwartz [EMAIL PROTECTED] wrote:
Hi,
On Thu, Apr 3, 2008 at 3:25 AM, nataliew
[EMAIL PROTECTED] wrote:
I need querylike this that make a row of numbers (in one execute)
SELECT a from (
:
http://www.nabble.com/Can-some-one-help-me-write-it-shorter--tp16467090p16467090.html
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I am an idiot. table_a and table_b have exactly the same structure.
How do I say this in SQL:
INSERT (all records from table_a) into table_b where table_a.customer
= '12'
Just trying to eventually duplicate the whole table, one customer's
set of records at a time. Thanks.
--
MySQL
Thanks to everyone who replied. So simple I couldn't see it. :-)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Wednesday 12 March 2008 00:14:46 Brian Dunning wrote:
I am an idiot. table_a and table_b have exactly the same structure.
How do I say this in SQL:
INSERT (all records from table_a) into table_b where table_a.customer
= '12'
Just trying to eventually duplicate the whole table, one
I am getting this message from mysql. We had our binlog directory full.
What is the resolution?
Error 2002 (HY000) Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
This message is intended only for the use of the Addressee and
sql:
select *
from table_one inner join table_two on table_two.column_one =
table_one.column_one
left join (SELECT * from table_three) table_four
on table_four.column_two = table_one.column_three and
SELECT *
FROM table_one t1
INNER JOIN table_two t2
ON t1.column_one = t2.column_one
LEFT JOIN table_three t3
ON t3.column_two = t1.column_three
AND t3.column_four = t1.column_five
WHERE column_six LIKE '%dsc%'
AND column_seven LIKE '%aaa%';
There is no need for a derived table.
Also, using LIKE
sql:
SELECT *
FROM table_one INNER JOIN table_one table_one1 ON table_one1.column_one =
table_one.column_two
INNER JOIN table_one table_one2 ON table_one2.column_one =
table_one.column_three
explain:
*** 1. row
No, because you have no WHERE condition.
wangxu wrote:
sql:
SELECT *
FROM table_one INNER JOIN table_one table_one1 ON table_one1.column_one =
table_one.column_two
INNER JOIN table_one table_one2 ON table_one2.column_one =
table_one.column_three
thank you
- Original Message -
From: Jay Pipes [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Tuesday, March 06, 2007 4:29 AM
Subject: Re: help me optimize this ALL
No, because you have no WHERE condition.
wangxu wrote:
sql:
SELECT
Dear friends,
Please help me to understand several LOCKing the same tables without
unlocking them between LOCKs. Imagine the following code:
LOCK TABLES t1 READ, t2 READ;
-- some hard select queries which need that other threads do not update tables
LOCK TABLES t1 WRITE, t2 WRITE
:[EMAIL PROTECTED]
Sent: Wednesday, January 10, 2007 2:29 PM
To: mysql@lists.mysql.com
Subject: Help me to understand multiple locking the same
tables (lock; lock; unlock)
Dear friends,
Please help me to understand several LOCKing the same
tables without
unlocking them between LOCKs
my operating system is linux redhat 9.0.
i am installing mysql 5.0.x binary distribution.
Which edition is the most fit in the following editions?
And would you like to tell me the difference among these editions?
Thanks very much!
[image: [ ]] mysql-standard-5.0.22-linux-i686-glibc23.tar.gz
On 6/2/06, yuan edit [EMAIL PROTECTED] wrote:
my operating system is linux redhat 9.0.
i am installing mysql 5.0.x binary distribution.
Which edition is the most fit in the following editions?
You notices most of those files are .asc and .md5 used to verify the
integrity of the archive after
Dear Mr. Heikki and Team,
Currently we hit by this bug
http://bugs.mysql.com/bug.php?id=15868
It got worse on MySQL5 rather than MySQL4, since i failed to downgrade
MySQL. Please give me idea to minimize the impact
My client is very dissapointed with this issue
Thank you very much
--
MySQL
Ady Wicaksono wrote:
Dear Mr. Heikki and Team,
Currently we hit by this bug
http://bugs.mysql.com/bug.php?id=15868
It got worse on MySQL5 rather than MySQL4, since i failed to downgrade
MySQL. Please give me idea to minimize the impact
My client is very dissapointed with this issue
Thank
-
From: Dan Trainor [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Wednesday, February 15, 2006 9:08 PM
Subject: Re: Client is starting to sue, Help me on this bug
http://bugs.mysql.com/bug.php?id=15868
Ady Wicaksono wrote:
Dear Mr. Heikki and Team,
Currently we hit
://www.innodb.com/order.php
- Original Message -
From: Dan Trainor [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Wednesday, February 15, 2006 9:08 PM
Subject: Re: Client is starting to sue, Help me on this bug
http://bugs.mysql.com/bug.php?id=15868
Ady Wicaksono wrote:
Dear
Hi Dan
I have an application that doing huge insert over web (HTTP) handled by
PHP, when i use MySQL 4. Multiple thread doing insert to table is not
really a problem. But NOT in MySQL 5.
You may test it self, imagine you have 1000 concurrent HTTP connection
that hit your PHP script. Each PHP
Hello.
The start point for you in such kind of problems should be researching
the output of the following statement:
SHOW VARIABLES LIKE '%char%';
Please, run it from different environments (PHP, MySQL Query Browser),
and send results to the list. Include the CREATE statement for you
Hellou!
I have MySQL(charset is utf-8) + PHP 5.0.5. Latvian symbols(auczsnsczikl) not
correctly viewed in MySQL Query Browser, but in 'phpmyadmin' its ok. When i use
php to viewed data with latvian symbols in IE, then latvian symbols(aui.)
is converted to ? symbols.
Please Help!
Ar
John thegimper wrote:
This is what i need:
Posted by gogman on Monday May 5 2003, @10:42am on the mysql website:
MySQL defaults to an 'OR'. Example: 'dog cat' = 'dog OR cat'. Most fulltext
search engines default to an 'AND'. These include: AltaVista, Fast Search,
Svensson [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: Please help me: Boolean fulltext searches, AND instead of
OR
Date: Wed, 23 Mar 2005 22:32:49 +0100
Hi!
On Mar 23, Jessica Svensson wrote:
Is there any way i can get results with AND instead of OR?
Trying to search for black
!!
From: Sergei Golubchik [EMAIL PROTECTED]
To: Jessica Svensson [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: Please help me: Boolean fulltext searches, AND instead
of
OR
Date: Wed, 23 Mar 2005 22:32:49 +0100
Hi!
On Mar 23, Jessica Svensson wrote:
Is there any way i can
hi
I have a requirement in generating a report in Nessus, Can you kindly
help me on this.I am using nessus in my office.I generated a report through
nessusWX in windows HTML format.In the report a column named
description having description,solution and warning indicated as ***
for each
.
Pls, help me in this.
Thanks and Regards,
Ashok.
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
[-- application/zip, encoding base64, 79 lines, name: err.zip
Dear Friends,
Iam trying to install MySQL 4.1.x in Windows 2003
Server, and on error occurs when installation try a
start de service. The service does not start and
installation don't finish.
I Try install and reinstall many times and all fail
My WIndows is a 2003 Server SP1
I Need a
Carlos J Souza wrote:
Dear Friends,
Iam trying to install MySQL 4.1.x in Windows 2003
Server, and on error occurs when installation try a
start de service. The service does not start and
installation don't finish.
I Try install and reinstall many times and all fail
My WIndows is a 2003
Carlos J Souza wrote:
The error as follows:
when installation is try to finish, the install try a start de new service MYSQL
4 and does not success
I try the install and reinstall many times and nothing.
Regards
On Wed, 29 Jun 2005 08:39:51 -0400, JamesDR wrote:
Carlos J Souza wrote:
Hi Carlos,
My suggestion for this problem is, just uninstall the
MySQL Server and manually delete all the corresponding
files, restart the system once (not a must, but it's a
advisable), then u install the MySQL, hope now it'll
definitely work.
This is happening because of mis-configuration b/w
Hello.
Very often similar error occurs when you didn't remove
service from previous MySQL installation. See:
http://dev.mysql.com/doc/mysql/en/windows-troubleshooting.html
Carlos J Souza [EMAIL PROTECTED] wrote:
Dear Friends,
=A0
Iam trying to install MySQL 4.1.x in Windows
comes from user input. So
it can be anything like +cat -dog +big nose -horse white black -red
so parsing the input is not what i want, i just want to change the default
word separator to AND instead of OR.
Now i´m running 4.1.10 and also tried with 4.0.24
Please help me, there must be a way to change
but thats not what i want
since the query comes from a searchbox and i dont want to write som code to
manipulate the indata so ite shows correctly i just want to change the
default word separator from OR to AND.
Maybe it´s ft_boolean_syntax that should be changed? If so to what... please
help me
comes from user
input. So it can be anything like +cat -dog +big nose -horse white
black -red
so parsing the input is not what i want, i just want to change the
default word separator to AND instead of OR.
Now i´m running 4.1.10 and also tried with 4.0.24
Please help me, there must be a way
Hi!
On Mar 23, Jessica Svensson wrote:
Is there any way i can get results with AND instead of OR?
Trying to search for black cat should only return records that contains
both black and cat.
I'm using the following code to get my result:
SELECT * FROM `searchtbl` WHERE MATCH (text)
show results with all words present.
This is what i did, set global ft_boolean_syntax = ' +-()~*:|'
I really appreciate your help!!
From: Sergei Golubchik [EMAIL PROTECTED]
To: Jessica Svensson [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Subject: Re: Please help me: Boolean fulltext searches
= ' +-()~*:|'
I really appreciate your help!!
From: Sergei Golubchik [EMAIL PROTECTED]
To: Jessica Svensson [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Subject: Re: Please help me: Boolean fulltext searches, AND instead of OR
Date: Wed, 23 Mar 2005 22:32:49 +0100
Hi!
On Mar 23, Jessica Svensson
Files\mysql\binmysql
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)=
please help me
=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=D6=C2
=C0=F1=A3=A1
=09=09=09=09
=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1 zhanghjun
[EMAIL PROTECTED]
=A1=A1=A1=A1
mysql
when click mysql.exe on $home\bin ,the report err is
D:\Program Files\mysql\binmysql
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)
please help me
zhanghjun
[EMAIL PROTECTED]
2005-02-02
--
MySQL General Mailing List
Thanks for your inputs Eric.
I tried this but it couldn't give me any insight abt
how can optimize this
for space saving of temp tables.
Maybe I am not expert enough to interpret this
output, so here it is -
- Manish
Seeing the explain log, it looks to me like you donot
have any index defined
Thanks for your inputs Eric.
I tried this but it couldn't give me any insight abt
how can optimize this
for space saving of temp tables.
Maybe I am not expert enough to interpret this
output, so here it is -
- Manish
Seeing the explain log, it looks to me like you donot
have any index defined
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Wu_Yang_SKZ, JPcommon wrote:
java.sql.SQLException: Communication failure during handshake. Is there a
server running on localhost:3306?
at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:275)
at
,
- Manish
- Original Message -
Sent: Saturday, December 04, 2004 10:26 AM
Subject: Re: Help me optimize this query
If you change the update to a select you can use explain to see it's
execution path just like you would with a normal select. The rows
returned are the rows that would
java.sql.SQLException: Communication failure during handshake. Is there a
server running on localhost:3306?
at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:275)
at org.gjt.mm.mysql.Connection.init(Connection.java:230)
at org.gjt.mm.mysql.Driver.connect(Driver.java:126)
If you change the update to a select you can use explain to see it's
execution path just like you would with a normal select. The rows
returned are the rows that would be matched by the update query.
Example:
explain select * from t1, t2 where t1.YYY=t2. and t2. like '%X%';
Optimize the
I am trying to execute this query and it is failing with Table is full error
(I know I can make temp tables big).
update t1, t2
set t1.XXX=1
where t1.YYY=t2. and t2. like '%X%';
My t1 has 10,00,000+ records and t2 has about 70,000 recorsds. I would like
to know how can I optimize this
Hi,
I need to make relationishp between 4 tables in my system.
I just don´t know how to make.
Somebody could help me, please?
The tables are: Order, Employee, ItensOrder and Unit.
My objective: to program a report of Order that appears in the screen the fields (
id_order, name_employee
The attachment describing your tables didn't come through. However,
here's roughly how your SELECT statement might look:
SELECT Order.id_order, Employee.name_employee,
ItemsOrder.date_order, Unit.name_unit, ItemsOrder.status_order
FROM Order, Employee, ItemsOrder, Unit
WHERE
I prefer to explicitly declare my INNER JOINs (not to imply them by using
commas to make a list of tables). That way I avoid accidentally creating
any Cartesian products of any tables by leaving out a WHERE condition.
Missing ON conditions are much easier to spot (IMHO).
Hi,
I am trying to install MySQL without any joy. I would appreciate if you
could help me please. Here I have listed the steps I took it to install.
1. I double click on INSTALL-BINARY in mysql.docs
2. Got the message as
Windows cannot open this fiel:
File: INSTALL-BINARY
To open
PM
Subject: Re: HELP ME WITH THIS
Hi,
The only way I can think of is to join the table to itself. It should look
something like this:
select unix_timestamp(concat(s.date,' ',s.time)) -
unix_timestamp(concat(e.date,' ',e.time))
from table s left join table e on
( s.CallingStationId
Hello can anyone help me with this,
i have a table, like the one below,
i need to find the time difference between the Start and Stop from a
particular CallingStationId to particular CalledStationId
Message-
From: Karma Dorji [mailto:[EMAIL PROTECTED]
Sent: Friday, September 03, 2004 5:06 AM
To: [EMAIL PROTECTED]
Subject: HELP ME WITH THIS
Hello can anyone help me with this,
i have a table, like the one below,
i need to find the time difference between the Start and Stop from
* Karma Dorji
i have a table, like the one below,
i need to find the time difference between the Start and Stop from a
particular CallingStationId to particular CalledStationId.
++--++---+
--
+---+
|
PROTECTED]
Subject: HELP ME WITH THIS
Hello can anyone help me with this,
i have a table, like the one below,
i need to find the time difference between the Start and Stop from a
particular CallingStationId to particular CalledStationId
Hi All,
Here's my table structure
Table 1: STM (Store Master)
STR_CODE
Desc
part_number
Table 2 : MRC(Master Received)
Ref_No
Rec_date
Table 3 : DRC (Detail Recived)
Ref_no
PO_No
STR_CODE
Hi all,
I have an audio tracks info table, let's call it Tracks;
every Track can have one or more ' Character' ( it is not a genre, it
is something like 'Italian' or 'International' or '80's' or 'evergreen'
)
so a track can be 'International' and 'Evergreen', or 'Italian' and
'70's')
I have
list wont change that
often? should be ok.
--
Dave
- Original Message -
From: Giulio [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Monday, July 12, 2004 1:50 PM
Subject: can you help me optimizing this query?
Hi all,
I have an audio tracks info table, let's call it Tracks
I've found a solution so I'm answering to myself, for who can be
interested and for asking if I've done something that could affect on
some way my DB performances.
I've added an index to both the columns that I use for the ON clause of
my left join query, and now it runs at the speed of
to:
|
| Subject: can you help me optimizing this query
:
|
| Fax to:
|
| Subject: Re: can you help me optimizing this query
Hi all.
My company has three Mysql DB servers.
one is master, the other are slaves.
master's version is 3.23.54-log.
two slaves's version is 4.0.17
and Os of all servers is linux 7.3
2 days ago, another slave's replication was currupted unexpactedly, but the other
slave was ok.
I
May be a full off the filesystem where the relay logbin file is ?
Marc.
-Message d'origine-
De?: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Envoye?: mercredi 9 juin 2004 09:46
A?: [EMAIL PROTECTED]
Objet?: Replication is currupted ...Please help me...
Hi all.
My company has three
Hi,
I am new to mysql and having some trouble with replication. Simple stuff like,
1. How to restart the stopped resplication,
2. How to check if the replication is working,
3. How to bring the slave into master status when master crashes,
4. How to restore master and re-enable
-Original Message-
From: Ravi T
To: [EMAIL PROTECTED]
Sent: 6/2/04 11:49 AM
Subject: Is there any good soul out there who can help me with mysql 4.0.17
replication.
Hi,
I am new to mysql and having some trouble with replication. Simple
stuff like,
1. How to restart the stopped
Any functions like filter ADO function in PHP? Thanks!
Hi,
I'm running a MySQL server on a duel P III 1G, with 2 GB RAM.
MySQL 4.0.18 compiled from source.
We have 2 webservers running apache, And this is the backend database server.
The server is really slow.
a select on a table with 138,247 rows takes about 1.6 - 2+ seconds, I have about 50%
CPU
Mohammed Sameer [EMAIL PROTECTED] wrote:
I'm running a MySQL server on a duel P III 1G, with 2 GB RAM.
MySQL 4.0.18 compiled from source.
We have 2 webservers running apache, And this is the backend database server.
The server is really slow.
a select on a table with 138,247 rows takes about
sorry Egor Egorov, Mutt sent the mail to your private inbox ;)
resending to the mailing list.
On Wed, May 19, 2004 at 02:02:29PM +0300, Egor Egorov wrote:
Mohammed Sameer [EMAIL PROTECTED] wrote:
I'm running a MySQL server on a duel P III 1G, with 2 GB RAM.
MySQL 4.0.18 compiled from source.
Something that small shouldn't really need optimizing. What is the size
of your data (mb?, gb?) and what does your query look like? If you are
doing a wild card search on a large text field without a full text
index, then those times may be the best you're going to get. Many times
it's about
On Wed, May 19, 2004 at 08:47:28AM -0400, Brent Baisley wrote:
Something that small shouldn't really need optimizing. What is the size
of your data (mb?, gb?) and what does your query look like? If you are
doing a wild card search on a large text field without a full text
index, then those
1 - 100 of 364 matches
Mail list logo