Hi guys I've been having some slow performance on queries that should
otherwise be pretty fast. I've checked my indexes etc. and cant see
what could cause it here is an example.
This one is taking long in the sending data step. although its running
on localhost so its not like its a network i
I'm having random query slowness that i can only reproduce once. My main
question is that the query runs faster the second time around but i dont
have query cache enabled here is some info from mysql profiler;
The time is spent mostly on the sending data step
first time around
63 rows in set (0.5
Since my previous post has been archived to may posts I will post again.
Would mysql server be able to handle about 2000 databases per server.
disregard space issues since thats not the case what im trying to see
are the capabitilities of the mysql server for a future project. In
average my db
OK I have one more scenario I need some help with. Say im using master
and slaves replication and i have N ammount of servers would mysql be
able to have say 10 databases with about 30 tables per db and a
total of say 100 megs of data per/db. would the server be able to manage
that. conside
itory.
MySQL supports master/slave setups which would replicate the data
across machines. One machine would be the "master" handling updates
which would propagate to the slaves.
On May 27, 2004, at 9:30 PM, tachu wrote:
WOuld the following scenario be possible
I currently have about 1.2
WOuld the following scenario be possible
I currently have about 1.2 Tb of data that i need to transform into
mysql and be able to server a very high amount of pages from a
discussion board. would i be able to place the mysql/data directory in a
main server with huge storage and then have several
