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
server 25', or telnet server 80')?
What are you using to connect to mysql? how long does 'telnet
server 3306' take (assuming you are on the default
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 server 25',
or telnet server 80')?
No
What are you using to connect to mysql?
Hi all,
Is it possible to create replication between debian and fedora box.
--
Krishna Chandra Prajapati
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 the
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 UUID()
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 record
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 you are
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 seconds.
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/mysql.strace
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
Hi All,
Can u please guide me to any good books or URL for mysql sql tunning..
regards
anandkl
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
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
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
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
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:
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
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
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
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 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
21 matches
Mail list logo