Weird connection timed-out

2007-05-14 Thread JM
Hi, Im using MySQL-5.0.19-0 and for some reason when ever PHP connects to the DB the server won't respond immediately causing the conenct to time-out.. No firewall issues and no network related issues. The only thing that I noticed is that the server's average load is 60%.

Re: Weird connection timed-out

2007-05-14 Thread JM
after trying it again ang again.. maybe for the 5th time.. PHP will now be able to connect.. On Monday 14 May 2007 22:34, JM wrote: Hi, Im using MySQL-5.0.19-0 and for some reason when ever PHP connects to the DB the server won't respond immediately causing the conenct to time-out

unauthenticated user

2007-02-21 Thread JM
Hi, i got this results from show processlist | 11186 | unauthenticated user | 192.168.1.106:36198 | | Connect | NULL | login | | | 11187 | unauthenticated user | 192.168.1.106:36200 | | Connect | NULL | login | | | 11188 | unauthenticated

Load Balancer for mysql

2006-10-05 Thread JM
Hi, Is there a hardware/software loadbalancer for multiple mysql servers servicing read transactions? Mailing-List -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Implementing HA w/o clustering

2006-09-22 Thread JM
hi, how can i spread reads on a non-cluster config? what i have in mind is a master (with a passive box beside) and 2 replicated servers.. unfortunately i can only spread reads and not writes... thanks, DISCLAIMER: This Message may contain confidential information intended only for

Re: Implementing HA w/o clustering

2006-09-22 Thread JM
On Friday 22 September 2006 18:36, JM wrote: sorry.. what i have in mind is the writes.. master | |_ _ _ _ replicated 1 (read) | |_ _ _ _ replicated 2 (read) thanks, hi, how can i spread reads on a non-cluster config? what i have

Mysql HA

2006-09-15 Thread JM
Hi, Is it possible to implement an HA configuration in mysql without using Mysql Clustering? A howto is very much appreciated.. thanks, Mailing-List -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Friendster with MySQL

2005-12-05 Thread JM
Hi ALL, We are planning to create a social software similar to friendster and Im working on the requirements... I saw a site: http://philip.greenspun.com/teaching/6171/2003-fall/friendster and for some reasons its telling me not to use MySQL, the initial infrastructure is a

Please I need inputs on Lost connection to MySQL server during query

2005-09-01 Thread JM
Hi all, Ive read this link http://dev.mysql.com/doc/mysql/en/gone-away.html; hoping this has something to do with the error... Ive already checked based on the page the list of roots of error to produce gone-away.. w/c i hope leads to Lost connection to MySQL server during

A lot of instances of mysqld

2005-08-30 Thread JM
Hi ALL, Is this normal? 26527 ?SW 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/db.forum.com.pid.pid 26554 ?S 23:08 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql

Daily maintenance for mysql

2005-08-06 Thread JM
Hi, Im still new to mysql and Im the processes of reading the manual. Since I need a quick answer I need inputs on things to do to maintain the DB. Is there a similar pg_dump thing? or it doesn't need it? tia, -- MySQL General Mailing List For list archives:

Re: migration postgresql data to mysql

2005-08-03 Thread JM
is there other ways of doing this? tia, On Tuesday 02 August 2005 20:33, Gleb Paharenko wrote: Hello. Have a look here: http://solutions.mysql.com/technology/technology/?item=425 SQLPorter supports Postgres according to this page. JM [EMAIL PROTECTED] wrote: hi all

migration postgresql data to mysql

2005-08-02 Thread JM
hi all, is there a howto on this? or an application for this? tia, -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Importing date data from text files

2002-09-19 Thread Andrew Whittam - JM Data Services
other ideas? Many thanks Andrew JM Data Services 8 Stanton Road Wimbledon LONDON SW20 8RL t: 020-8286 8545 f: 020-8944 8621 m: 07801-866043 e: [EMAIL PROTECTED] - Before posting, please check