Is it possible to shutdown and restart mysql again, if its not in
production.
regards
anandkl
On 8/14/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
>
> Hi all,
>
> I am running mysql on debian. I didn't understand why there is a lots of
> mysql process running. There should be only on
Jerry Schwartz schrieb:
I strongly advise you to use an off-the-shelf solution. In fact, if you can
afford it you should go with a CRM vendor. They will have all kinds of
features, such as address duplication detection, that you will need.
you are of course perfectly right,
however I need it as
Hi all,
I am running mysql on debian. I didn't understand why there is a lots of
mysql process running. There should be only one mysql process running.
Please help me that what should i do. Although there is no problem with
mysql server.
debian:~# ps axu
USER PID %CPU %MEM VSZ RSS TTY
Just do a left join with the delete query.
DELETE feed_tag FROM feed_tag LEFT JOIN feed ON
feed_tag.feed_id=feed.id WHERE feed.id IS NULL
That should do it. You can change "DELETE feed_tag" to "SELECT" and
test it first.
--
Brent Baisley
On Aug 13, 2008, at 4:51 PM, Daevid Vincent wrote
Hi Daevid
If you are using a foreign key you can set the reference as "cascade"
and when a row is deleted from feed it will be deleted from feed_tag.
http://dev.mysql.com/doc/refman/5.0/en/innodb-foreign-key-constraints.html
If you don't like it you can delete it easy with a query like this
del
I want to remove all records from 'feed_tag' where the feed_id foreign key
doesn't have any corresponding records in feed.
For instance I may have a record in feed_tag that is like (23, 10, 4543,
'... (some date)').
Then lets say there is no record in feed that has a primary id key of 10.
I w
All!
To being with, sorry for crossposting, but I felt that there might be an
interest with both the General as well as the Win32 MySQL mailing lists.
This email is just a heads-up that I have now made my MySQL Script tool
available as Open Source. It has been going on and off for quite a
wh
On Wed, Aug 13, 2008 at 7:30 AM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
> Can u please guide me to any good books or URL for mysql sql tunning..
http://www.highperfmysql.com/
- Perrin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.
Absolutely... replication is designed to work across heterogenous
systems: I used to work at a place that ran replication from Mac OS/X
-on a G5G5 to BSD on x86 in production with no particular issues.
There were no extra magic steps.
Having said that, debian and fedora are flavours of the same
Hi Anada,
I recommend MySQL Database Design and Tuning by Robert Schineider. It
covers everything from benchmark testing to Innodb Performance
Enhancements. I'm 85% done with the book myself. It shows and explains
good command-line and MySql Admin tool examples. The techniques
discuss in this book
If you have both myisam and innodb.
You need to ensure sql's from myisam and sql's from innodb have sufficient
memory to run.
you can allocate 25% of you RAM to key_buffer used exclusively for myisam
and around 60% of your RAM to innodb_buffer_pool for supporting innodb .
Also there are other myi
Hello and Greetings mysql,
I have been running a WAMP server for some time on my Windows XP Pro
box. Over time I have gone through some issues about which WAMP to use
and last Year converted my Apache2Triad installation to WAMP5. All of
my database installations, out of preference, have been MYISA
Hi All,
Can u please guide me to any good books or URL for mysql sql tunning..
regards
anandkl
in infinite wisdom Ananda Kumar spoke thus On 08/13/2008 04:37 PM:
Hi Raj,
In which path the trace file would be created.
In your current path itself.
Or just do
strace -o /tmp/mysql.strace -T mysql -u root -h host -p
The "mysql -u root -h host -ppassword" is the command which you
Thank u very much.
regards
anandkl
On 8/13/08, Raj Shekhar <[EMAIL PROTECTED]> wrote:
>
> in infinite wisdom Ananda Kumar spoke thus On 08/13/2008 04:37 PM:
>
>> Hi Raj,
>> In which path the trace file would be created.
>>
>
> In your current path itself.
>
> Or just do
> strace -o /tmp/
Hi Raj,
In which path the trace file would be created.
regards
anandkl
On 8/13/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> In infinite wisdom "Krishna Chandra Prajapati" <[EMAIL PROTECTED]>
> spoke thus:
>
> > Hi all,
> >
> > Connecting to mysql server (Production) is taking 5 to 6 seco
In infinite wisdom "Krishna Chandra Prajapati" <[EMAIL PROTECTED]> spoke thus:
> Hi all,
>
> Connecting to mysql server (Production) is taking 5 to 6 seconds. Production
> has 16Gb ram. Previously it was using only 6GB ram. The details are as
> follows. DNS looks fine.
Is it that the database yo
> Why would the auto_increment not work for you? The only case where you
> would have a problem is if the last record was deleted before mysql
> shutdown. If you are really concerned about this unique scenario,
> insert a dummy record before shutdown to guard against it and delete
> the dummy reco
> >I try to generate a unique id for each row in a Mysql-InnoDB Table.
> >Because of many deletes I can't use an auto_increment column.
> >After a Mysql restart, the next value for an auto_increment-column is
> >max(auto_increment-column)+1, and I need a really unique id.
> >
> [JS] See if the
You should run into out of memory scenaria. OS is keeping to free some
memory that delay mysql connection.
On 8/13/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
> On Wed, Aug 13, 2008 at 1:30 PM, Doug Bridgens <[EMAIL PROTECTED]> wrote:
>
> > Do you have any other services running on th
Hi all,
Is it possible to create replication between debian and fedora box.
--
Krishna Chandra Prajapati
On Wed, Aug 13, 2008 at 1:30 PM, Doug Bridgens <[EMAIL PROTECTED]> wrote:
> Do you have any other services running on the server, such as mail or web?
> How long does it take to connect to those services ('telnet 25',
> or telnet 80')?
No
>
> What are you using to connect to mysql? how lo
Do you have any other services running on the server, such as mail or
web? How long does it take to connect to those services ('telnet
25', or telnet 80')?
What are you using to connect to mysql? how long does 'telnet
3306' take (assuming you are on the default port and have
firewa
23 matches
Mail list logo
