On Sun, Jan 9, 2011 at 1:54 PM, Yves Goergen
wrote:
> Why does it take ages for MySQL Workbench to startup?
I rarely use MySQL Workbench. But I remember that reducing the maximum
number of items in the undo history greatly improves speed, though maybe
not startup time.
--
MySQL General Mailing
Hello,
Why does it take ages for MySQL Workbench to startup? When I start it
(5.2.31 CE) on Windows (XP), the splash screen sits there around 15-30
seconds until the main window appears. There's moderate to high CPU
usage in this time and the hard disk is active. I believe this has been
much faste
in infinite wisdom Ananda Kumar spoke thus On 08/13/2008 04:37 PM:
Hi Raj,
In which path the trace file would be created.
In your current path itself.
Or just do
strace -o /tmp/mysql.strace -T mysql -u root -h host -p
The "mysql -u root -h host -ppassword" is the command which you
Thank u very much.
regards
anandkl
On 8/13/08, Raj Shekhar <[EMAIL PROTECTED]> wrote:
>
> in infinite wisdom Ananda Kumar spoke thus On 08/13/2008 04:37 PM:
>
>> Hi Raj,
>> In which path the trace file would be created.
>>
>
> In your current path itself.
>
> Or just do
> strace -o /tmp/
Hi Raj,
In which path the trace file would be created.
regards
anandkl
On 8/13/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> In infinite wisdom "Krishna Chandra Prajapati" <[EMAIL PROTECTED]>
> spoke thus:
>
> > Hi all,
> >
> > Connecting to mysql server (Production) is taking 5 to 6 seco
In infinite wisdom "Krishna Chandra Prajapati" <[EMAIL PROTECTED]> spoke thus:
> Hi all,
>
> Connecting to mysql server (Production) is taking 5 to 6 seconds. Production
> has 16Gb ram. Previously it was using only 6GB ram. The details are as
> follows. DNS looks fine.
Is it that the database yo
You should run into out of memory scenaria. OS is keeping to free some
memory that delay mysql connection.
On 8/13/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
> On Wed, Aug 13, 2008 at 1:30 PM, Doug Bridgens <[EMAIL PROTECTED]> wrote:
>
> > Do you have any other services running on th
On Wed, Aug 13, 2008 at 1:30 PM, Doug Bridgens <[EMAIL PROTECTED]> wrote:
> Do you have any other services running on the server, such as mail or web?
> How long does it take to connect to those services ('telnet 25',
> or telnet 80')?
No
>
> What are you using to connect to mysql? how lo
Do you have any other services running on the server, such as mail or
web? How long does it take to connect to those services ('telnet
25', or telnet 80')?
What are you using to connect to mysql? how long does 'telnet
3306' take (assuming you are on the default port and have
firewa
Hi all,
Connecting to mysql server (Production) is taking 5 to 6 seconds. Production
has 16Gb ram. Previously it was using only 6GB ram. The details are as
follows. DNS looks fine.
free -m
total used free sharedbuffers cached
Mem: 15899 15877
Chris Portka wrote:
I'm trying to create a table in MySQL with a few simple requirements,
but my table loads data very slowly. I need two columns, one of them a
10 digit string and another a very large integer. These pairs must be
unique. There must be an index on the 10 digit string for fas
I'm trying to create a table in MySQL with a few simple requirements,
but my table loads data very slowly. I need two columns, one of them a
10 digit string and another a very large integer. These pairs must be
unique. There must be an index on the 10 digit string for fast lookups.
Here's h
Ritesh Shetty wrote:
Hello,
My mysql server sometime just slows responding to database queriesIt
is as slow as less than 1 per sec.
But it speeds up by itself after some time , I have noticed that when it
speeds up there are lot more MYsql thread than just one thread when it
is slow.
So
taken in both the above scenarios ...
###
Slow MySQL top
##
top - 10:29:36 up 12 days, 23:20, 10 users, load average: 1.53, 1.47, 1.51
Tasks: 157 total, 2 running, 155 sleeping, 0 stopped, 0 zombie
Cpu(s): 14.5% us, 5.0% sy, 0.2% ni, 48.3% id, 31.9% wa, 0.2% hi
Shawn-
Works like a champ! Thanks so much. If your ever in the Silicon
Valley area drop me a line, and I will be happy to pick up lunch or
cocktails.
It's great that you are so active on this list and are helping so many
folks on here (myself included).
-Dale
On Fri, 25 Feb 2005 10:06:36 -050
(response NOT top-posted. see below...)
Dale Roddy <[EMAIL PROTECTED]> wrote on 02/24/2005 05:40:22 PM:
> I am new to MySql. I have a query with a subselect that is running
> very slow (28 seconds).
>
> SELECT *,MATCH(title, descr_part) AGAINST ("Project Manager" IN
> BOOLEAN MODE) AS score
> F
I am new to MySql. I have a query with a subselect that is running
very slow (28 seconds).
SELECT *,MATCH(title, descr_part) AGAINST ("Project Manager" IN
BOOLEAN MODE) AS score
FROM listings
WHERE MATCH(title, descr_part) AGAINST ("Project Manager" IN BOOLEAN MODE )
and zip in
(SELECT z
To: William Wang; [EMAIL PROTECTED]
Subject: Re: very slow mysql server, help please
On Thursday 06 Mar 2003 3:11 am, William Wang wrote:
> Question 1: Does sleeping processes slow down database server?
Nope, I have had many a discussion whats best to use, pcconect or
normall
connect but have
On Thursday 06 Mar 2003 3:11 am, William Wang wrote:
> Question 1: Does sleeping processes slow down database server?
Nope, I have had many a discussion whats best to use, pcconect or normall
connect but have yet to conclude what is better. We feel that pconnect works
best for us.
> Question 2:
sr=1-4/ref=sr_1_4/103-5030472-7439844?v=glance&s=books
Best of Luck,
Ken
- Original Message -
From: "William Wang" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 05, 2003 10:11 PM
Subject: very slow mysql server, help please
>
> Hi All:
>
Hi All:
I have three web server (DUAL 1.4 G MHZ, 1G RAM) connect to one mysql
database server (DUAL 2.2 G MHZ, 2 G RAM), SSL accelerator and a load
balancer. All those servers are FreeBSD. For some reason, mysql server can
be easily max out without many users. Also there are many processes in
slee
Hi All:
I have three web server (DUAL 1.4 G MHZ, 1G RAM) connect to one mysql
database server (DUAL 2.2 G MHZ, 2 G RAM), SSL accelerator and a load
balancer. All those servers are FreeBSD. For some reason, mysql server can
be easily max out without many users. Also there are many processes in sl
22 matches
Mail list logo
