Currently our MySQL server runs around 20-30 queries per second. The
upper management decided they wanted to add about 4 times the customers
in the next two or three weeks. I'm worried that MySQL on this
particular box won't be able to handle the load of around 100-120
queries per second. Not t
Easy, =)
mysqldump -p | mysql -h
192.168.1.1 -p
That will dump the database and remotely insert in to the other server.
-Jason
On Wed, 2002-04-24 at 13:46, Andrew Chan wrote:
> Hello,
>
> I am trying to transfer tables/data from one server to another, say server A
> to B. mysqldmup helps
On Tue, 2002-04-23 at 14:35, Andrew Kuebler wrote:
> Hello Everyone.
>
> I'm still fairly a newbie to MySQL, but I could have sworn I read
> somewhere that MySQL supported relationships just like Access. I've
> searched the entire manual, and cannot find anything on the subject.
> Does MySQL supp
s worth a look.
If you use perl make sure you use mod_perl. I would suggest posting
this on an apache mailing list.
-Jason Yates
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.m
On Fri, 2002-04-12 at 11:47, Russell E Glaue wrote:
>
> If your database is read-only, you can use Linux Virtual Server to load
> balance traffic to MySQL servers.
> -RG
>
>
LVS as you said it is only good for read-only. Are there any solutions
for non read-only load balancing, using replicat
On Fri, 2002-04-12 at 10:56, Steve Buehler wrote:
> I am using PHP to run the following command:
> passthru("mysqldump -q -u$userName -p$password -h$hostName $databaseName");
>
> The problem is that it puts EVERYTHING on one line and, of course, and
> wraps it. I want to be able to dump the dum
Is there any sort of mysql load monitoring tools out there? If not how
can I get how many query's per/sec, users, etc, which I can log to a
flat file or db, and I could run rrdtool against it to get graphs?
-Jason
-
Before pos
001-10-10, the query won't
work because the table is left joined. The date value in the attendance
table will just return as NULL. Is there a way around this?
-Jason Yates
-
Before posting, please check:
http://www.my
> I am doing this using mySQlGui 1.7.5-2 on Win 2000
> Professional.
>From what I understand last_insert_id() can only be used
on the same connection as the insert. I'm guessing after every query
mysqlgui runs it disconnects, therefore killing last_insert_id().
pt, run a select
and loop through each id and delete the records in table1.
-Jason Yates
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
#x27;rpm -qa | grep -i mysql' that will list any mysql packages and put the
package name in the rpm -e command.
-Jason Yates
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://list
11 matches
Mail list logo
