hi all
what is the difference between
OPTIMIZE TABLE tablename;
and
ANALYZE TABLE tablename;
thank you
Cheers
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com
OPTIMIZE TABLE tablename;
analyze table ,stores the key distribution for a table ,reclaim the unused
space and to defragment the data file.
ANALYZE TABLE tablename;
This action only analyze table and stores the key distribution for a table.
2010-04-13
River wubx
Gtalk: wubin...@gmail.com
Are you quite sure there can never be more than 16 orders per ID ?
The form your table is in now is actually the preferred form. It's called an
associative table, and logic suggests that it sits between a table that
holds more info on the IDs, and a table that holds more info on the orders.
On
hi River
thanks for your mail.
could you please tel me the correct syntax for optimize table command. i
plan to put this in cronjob and execute every 8 hours in a day.
optimize table tab1; is that correct or anything need to add with his
statement.
my environment is solaria
Cheers
Faizal S
http://dev.mysql.com/doc/refman/5.0/en/optimize-table.html
The entire page is highly recommended due to the number of helpful
information.
Regards,
m
-Original Message-
From: F.A.I.Z.A.L [mailto:sac.fai...@gmail.com]
Sent: Tuesday, April 13, 2010 10:56 AM
To: River wubx
Cc: mysql;
I have no idea how you got here but there is no reason to do it that
way. This will work just fine and I do it every day in php.
However I don't use mysqli I still use ...
mysql_connect
mysql_select_db
mysql_real_escape_string
mysql_query
Don't forget to use the mysql_real_escape_string
__ Information from ESET Smart Security, version of virus signature
database 5025 (20100413) __
The message was checked by ESET Smart Security.
http://www.eset.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
__ Information from ESET Smart Security, version of virus
signature database 5025 (20100413) __
The message was checked by ESET Smart Security.
http://www.eset.com
__ Information from ESET Smart Security, version of virus signature
database 5025 (20100413
Hello,
I need to have a MySQL 3.x client to be compatible with a new MySQL 5.x
server, is it possible?
What do I need to change on my MySQL 5.x server to allow old clients to
work?
Also, what do I need to change to allow old PHP 4.x code to talk to a MySQL
5.x server?
Thanks,
POL.
Dear MySQL users,
MySQL Server 5.5.3-m3, a new version of the popular Open Source
Database Management System, has been released. We've also released
MySQL Server 5.5.4-m3 for Linux on x86_64 only at this time; it
contains a new version of InnoDB including several performance
enhancements in
Yes, If it is a password problem.
do a update with password=old_password('xxpasswdxx');
It will work.
If you are facing any other problems, paste it.
On Tue, Apr 13, 2010 at 10:37 PM, Pecas On Line pol.cota...@gmail.comwrote:
Hello,
I need to have a MySQL 3.x client to be compatible with a
Analyze table :
Analyze table analyzes and stores the key distribution for a table.
For more details check the below URL
http://dev.mysql.com/doc/refman/5.1/en/analyze-table.html
Optimize table :
OPTIMIZE TABLE is useful when we do more deleted operations on a table with
variable columns. It
Hello all,
My organization has a dedicated MySQL server. The system has
32Gb of memory, and is running CentOS 5.3. The default engine will be InnoDB.
Does anyone know how much space should be dedicated to swap?
Thanks!
Also, if you have read heavy workload, you might want to try using and
tuning your query cache.
Start off with something like 32M and incrementally tune it.
You can monitor some query cache related server variables.
Kyong
On Sat, Apr 10, 2010 at 4:28 PM, Rob Wultsch wult...@gmail.com wrote:
On
In the last episode (Apr 13), Joe Hammerman said:
My organization has a dedicated MySQL server. The system has 32Gb of
memory, and is running CentOS 5.3. The default engine will be InnoDB.
Does anyone know how much space should be dedicated to swap?
I say zero swap, or if for some reason you
Yeah. One of the telltale signs of something amiss is excessive swap activity.
You're not going to be happy with the performance when the swap space
is actually in use heavily.
Kyong
On Tue, Apr 13, 2010 at 8:15 PM, Dan Nelson dnel...@allantgroup.com wrote:
In the last episode (Apr 13), Joe
Hello,
I hope that this is the right list.
I have a database that has been running for years in latin1 but a
software update changed it in to utf8 that would be no big deal if we
know it right away so we could change the database.
The big problem is that the database has been running for 2
17 matches
Mail list logo