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
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
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
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
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
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
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
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
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 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
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
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
12 matches
Mail list logo
