On 21/09/2012 9:26 AM, Girish Talluru wrote:
Hi Guys,
I have requirement to change my production database tables which are using
myISAM and now bcoz of some changes we have to move to Innodb.
Can anyone suggest how the plan should be and risks involve?
Thanks,
Girish Talluru
Whatafford?
Fredrik Carlsson wrote:
It is a single PIII 500MHz, so i just changed thread_concurrency to 2
:), thanks
The slow query log don't show that many slow queries, but they did
show alot of queries that was'nt using any index, can these queries
cause some kind of occasional lock up?
Is there a fas
Bryan Heitman wrote:
I am experiencing extreme slowness performing a query in which 2 rows
are returned hanging in the "sending data" status.
Performing an index only query such as SELECT COUNT(*) is extremely
quick so I know the only extra step is retrieving the data from the MYD.
I am looking
w database every time. I just don't
want the MySQL server to slow down to a point where my
website becomes unresponsive while I'm loading a few
Gigs of data...
Any idea?
Thank you!
=
-
Benoit St-Jean
MySQL DBA
Yahoo! Messenger: bstjean
--
MySQL General Mailing Li
Dan Johnson wrote:
The site that I am working on is experiencing MySQL freeze ups any
time after the 'Queries per second average'; seen on the STATUS
output; is at 48-50 in value. When the site owner asked the hosting
service about this they told him that the MySQL cannot go above that
limit.
A Z wrote:
Thanks for your replies regarding to my previous
query.
We have encountered another problem:
MySQL 4.0.14, INNODB.
A table does have an Index on Field1, this field
(Field1) is also the Primary Key. Querying on this
field takes a long time, running along with Explain
command it displays
Rhino wrote:
Can anyone point me to documentation describing the concepts behind
MySQL's different join types?
I've got a lot of experience with DB2 but I want to do four things:
a) verify that 'natural join', 'left outer join', and 'right outer
join' mean the same in both MySQL and DB2.
b) de
Michael McTernan wrote:
Hi,
SELECT COUNT(*) for InnoDB tables is a know problem... The table
handler (for InnoDB) has to do a table scan to count all rows... This
particular case is optimized with MyISAM ...
Sure. But why is the tablescan ~100 times faster for the table without the
BLO
Michael McTernan wrote:
Hi there,
I'm making something similar to a file revision control system, and using
MySQL on Linux as the database to drive it. Almost all my tables are
InnoDB, and generally it is going very well, with the exception of one table
that is always very slow.
This table holds
Martijn Tonies wrote:
Hi,
==
I have an ID field in my database...it reads like this
ASS1
ASS23
ASS4
ASS10
ASS6
when i'm retrieving the data by taking ORDER BY clause it is sorting like
this
ASS1
ASS10
ASS23
ASS4
ASS6
means its only sorting by the 4 the character. i want the sorting to be done
lik
ad of having fixed format rows I
have dynamic ones. In a table with a few millions
rows, it can make a big difference!
tia
filter: mysql, sql, table, database
=====
-----
Benoit St-Jean
[EMAIL PROTECTED]
Yahoo! Messenger: b
Hi MySQL ,
I have made a test database for performance testing
and my InnoDb tablespace grew from 1Gig to 8 Gig...
After I dropped that test database, the tablespace
stayed to the same size. How can I "resize" it to its
original size?
=
-----
Benoit St-J
quot;
See section 4 of the InnoDb manual.
http://www.innodb.com/ibman.html
Hope this helps
=
-----
Benoit St-Jean
[EMAIL PROTECTED]
Yahoo! Messenger: bstjean
http://cactus
rary mentioned in the INSTALL-SOURCE document, as they seemed to be
necessary only for very high-availability servers (also, things in the upgraded glibc
didn't match EXACTLY the things in the doc file). I did upgrade linuxthreads as part
of the glibc upgrade (with the linuxthreads add-on correspon
Anyone has tried MySQL 3.23.5x (or even 4.x) on
Caldera OpenLinux eDesktop 2.4 ?
I am considering setting up a server on Linux but I
want to know if MySQL has any preoblem on Caldera's .
Thanks
filter: SQL, database, MySQL
=
-
Benoit St-Jean
[EMAIL PROTECTED]
=
-
Benoit St-Jean
[EMAIL PROTECTED]
Yahoo! Messenger: bstjean
http://cactus.swiki.net
-
__
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos & More
http://faith.yahoo
ng?
You just started the server. If you want to run it as
a service (I assume you have Windows NT or 2000), use
the --install option.
Now, you could open another command prompt window and
start mysql with, for example:
mysql --user=someguy --password=secret
Hope this helps.
=
--
connectionPoolManager.
I personally use the one from bitmechanic and I am so far happy with it
http://www.bitmechanic.com/projects/jdbcpool/
Regards,
Benoit
-Original Message-
From: aravind gorthy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 17, 2002 8:19 AM
To: [EMAIL PROTECTED]
Subject
I am using mysql 3.22.32 on solaris.
when i start safe_mysqld , two process start :
safe_mysqld and mysqld.
But when i try to access to the database with
an http request, or with mysql (the command line)
nothing append ...
there is nothing in var/server.err
do you have an idee or where to se
John,
are you sure that all indexes on all the tables merged are the same (same
fields, same order of indexes) ?
Benoit Grange
LibertySurf Telecom
10, rue Fructidor, 75834 Paris CEDEX 17
Tel: +33 (0) 1 41 66 77 88, Fax: +33 (0) 1 41 66 77 67
> -Original Message-
> From: John Ho
Thanks for help...
... and patience !
Benoit Milgram --
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EM
21 matches
Mail list logo