Hello,
Our mysql is using Innodb engines.
How can I get the read/write percent to each table?
for example, for the table_99, the read percent is 77%, write percent is 23%.
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql
Hello,
We are a company for gaming.
Our main db is mysql 5.1 installed on Linux.
Currently the hardware for mysql is 2*4 CPU, 16G memory, Raid 10 (four disks).
Now we have the plan to replace the disks with SSD for better performance.
Do you think is it right for the SSD solution for mysql?
Thank
At 06:12 AM 10/24/2010, you wrote:
Regardless of that, it would be nice to know what the parameters are that
cause this slowdown - some people may be stuck with the default version -
companies with a support contract come to mind.
You didn't say whether the slowdown occurs when
1) adding new ro
On 10/23/2010 12:44 PM, Claudio Nanni wrote:
Just a little note:
sometimes, if you are in command line session, you will not see the change
of the dynamic variable unless you logout and in again,
so in case you change the value of a dynamic variable but still the "show
variables" shows you the o
The idea of a foreign key is that is is, well, a *foreign key* :-) It's
meant to match up data that is in one table with data that is in another
table, and a constant obviously isn't data in your table. To be precise,
what you specify in your constraint are not even fields, but *indices* - and
a co
Regardless of that, it would be nice to know what the parameters are that
cause this slowdown - some people may be stuck with the default version -
companies with a support contract come to mind.
On Sat, Oct 23, 2010 at 10:46 AM, Krishna Chandra Prajapati <
prajapat...@gmail.com> wrote:
> Hi Will
Changes to global variables will indeed not affect the instantiated local
session variables. You can, however, also explicitly change those by using
"set local *variable*" - that should eliminate the need for most reconnects.
On Sat, Oct 23, 2010 at 7:19 PM, Sander de Bruijne wrote:
>
> > exit my
