Hello,
I'd like to know if there is a command line tool I can run to collect
vital health information for a remote mysql server (just like
mysqltop) for 5.0 - I often see mysql swapping to disk and would like
to know what causes that.
Thanks
Hitesh
--
MySQL General Mailing List
For list archives
Thanks for you reply.
I read the official document and found the variable called
"thread_concurrency" could only affect on solaris.
On Sat, Apr 11, 2009 at 5:04 AM, mos wrote:
> At 06:00 AM 4/10/2009, you wrote:
>
>> Hi.
>> If the server has 16 cores, how to set parameters to make MySQL runs
I have problem at my replicated slaves. We have one master and 5 slaves. All of
its live in similar FreeBSD 7.0 systems. But by without understood for me
reasons 4 of 5 slaves are rebooted approximately one time at 30 minutes. There
are no signals and other reasons in logs. But one of slaves wi
Dear List,
Can someone recommend a web based tool for mass-editing tables in excel like
fashion?
Preferably view-based (can you even edit a view in mysql, as long as it's
'simple' (sorry, coming from Ora world)
We have an application which only allows to edit 'rows' one by one... yes, i
know the
I use http://www.dadabik.org/ since many years, I find it simply great.
I do not know if it is exactly what you need, but give it a try!
Claudio
Andrey Dmitriev wrote:
Dear List,
Can someone recommend a web based tool for mass-editing tables in excel like
fashion?
Preferably view-based (can yo
hello,
assume the following table:
CREATE TABLE t (
id INT UNSIGNED auto_increment PRIMARY KEY,
c1 INT UNSIGNED NOT NULL,
c2 INT UNSIGNED NOT NULL,
c3 INT UNSIGNED,
UNIQUE (c1, c2, c3)
) engine = InnoDB;
Our first issue is that the UNIQUE constraint on (c1,c2,c3) does not
work in the case tha
Innotop can satisfy you demand.
On Thu, Apr 16, 2009 at 4:36 PM, Hitesh Shah wrote:
> Hello,
> I'd like to know if there is a command line tool I can run to collect
> vital health information for a remote mysql server (just like
> mysqltop) for 5.0 - I often see mysql swapping to disk and would
Can you tell me which version of mysql you use in you test?
On Thu, Apr 16, 2009 at 12:43 AM, Pete Wilson wrote:
>
>
> Hi folks --
>
> New to MySQL. I'm developing C-language connector software and, while
> debugging, I often get the error message "MySQL server has gone away" if,
> say, I've sto
Yeah, please show us the source code of yours.
On Wed, Apr 15, 2009 at 4:10 PM, Venu Gopal wrote:
> Hi guys,
> I am using stored procedures and stored functions for the first time.
> And currently stuck at a this point where. I am unable to retrieve
> results returned by stored function using My
Use temporary table can be a good idea. But I think you performance would be
boost so much if you can do something else to replace the temporary table.
On Wed, Apr 15, 2009 at 2:03 PM, Manoj Singh wrote:
> Hi All,
>
> I have a query which returns the large number of ids which i am using in
> othe
Hi All,
Thanks for your valuable input.
I have decided to use temporary table approach. Since I am using it for the
first time and this has to be done in the production server. Do I need to
consider some facts before using this such as setting some parameters in
my.cnf etc or the MYSQL will handl
If you can not eliminate your temporary tables, you have to adjust the
following parameters in my.cnf
[mysqld]
max_heap_table_size=1G
tmp_table_size=1G
On Fri, Apr 17, 2009 at 12:57 PM, Manoj Singh wrote:
> Hi All,
>
> Thanks for your valuable input.
>
> I have decided to use temporary table appr
12 matches
Mail list logo
