Re: MySQL db size using show table status

using a command line tool should do this. Usually, .frm table definition files are negligible to the size of the actual database. Qus 2. Is there any other way to compute the db size (other than disk quota). du -s mysql_data_directory Regards, Josh -- Josh Chamas Director, Professional Services

Re: Locks acquired with get_lock() persisting, even after MySQL thread has exited

() reports that the lock is held by a particular thread ID. This does not seem like expected behavior. I would either file this as a bug at http://bugs.mysql.com/ with a nice reproducible test case, or file a ticket with MySQL Support at https://support.mysql.com/ Regards, Josh -- Josh Chamas

Re: MySQL Users

. Regards, Josh -- Josh Chamas Director, Professional Services MySQL Inc., www.mysql.com Get More with MySQL! www.mysql.com/consulting -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: innodb thread concurrency size [mysql performance tuning]

at these packages: http://www.mysql.com/consulting/packaged/performance.html http://www.mysql.com/consulting/packaged/rapidresponse.html Regards, Josh -- Josh Chamas Director, Professional Services MySQL Inc., www.mysql.com Get More with MySQL! www.mysql.com/consulting #use this line mfor mysql 4.1

Re: Too Many Queries Have Writing To Net Status [mysql performance tuning]

, and if you want expert help, I would recommend you engage with our professional services team with either of these packaged consulting solutions: http://www.mysql.com/consulting/packaged/performance.html http://www.mysql.com/consulting/packaged/rapidresponse.html Regards, Josh -- Josh Chamas Director

Re: 45 minutes to check table to complete

the extra memory the next step is tuning MySQL to take advantage of it depending on the storage engine you are using. Regards, Josh -- Josh Chamas Director, Professional Services MySQL Inc., www.mysql.com Get More with MySQL! www.mysql.com/consulting -- MySQL General Mailing List For list

Re: The Intel MySQL compiled Server

, then revert back to the normal binaries. Regards, Josh -- Josh Chamas Director, Professional Services MySQL Inc., www.mysql.com Get More with MySQL! www.mysql.com/consulting -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: Intelligent Converters product: MSSQL-to-MySQL

with it and it seemed fine. I would also stay tuned for our MySQL Migration Toolkit to support MSSQL migrations. You can find it here: http://www.mysql.com/products/tools/migration-toolkit/ Regards, Josh -- Josh Chamas Director, Professional Services MySQL Inc., www.mysql.com Get More with MySQL

Re: MySQLHotCopy Error

/not-enough-file-handles.html If this does not help, and you need further support, you could work this up with MySQL Support at: https://support.mysql.com Regards, Josh -- Josh Chamas Director, Professional Services MySQL Inc., www.mysql.com Get More with MySQL! www.mysql.com/consulting

Re: Behaviour of like expression

-- Josh Chamas Director, Professional Services MySQL Inc., www.mysql.com Get More with MySQL! www.mysql.com/consulting -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: URGENT --- OSX 10.4 ODBC driver error

. If you need urgent help, please contact MySQL Support at: https://support.mysql.com Regards, Josh -- Josh Chamas Director, Professional Services MySQL Inc., www.mysql.com Get More with MySQL! www.mysql.com/consulting -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: ORACLE and Mysql: Create tables, constraints, swquences, storage. ..?

-toolkit/ One of the ways I like to use it is to reverse engineer the Oracle schema, and then have the MySQL schema definition script created for further modification. Note we do not have support for sequences, and its typical to just use AUTO_INCREMENT columns for these. Regards, Josh -- Josh

Re: very slow inserts on InnoDB [InnoDB Performance Tuning]

help via our commercial offerings: http://www.mysql.com/network/ - OR - http://www.mysql.com/consulting/packaged/performance.html http://www.mysql.com/consulting/packaged/rapidresponse.html Regards, Josh -- Josh Chamas Director, Professional Services MySQL Inc., www.mysql.com Get More

Re: query on a very big table [MySQL partitioning of large tables]

partition your tables. If you continue to need help, then you might want to enlist our on-site consulting for your project needs: http://www.mysql.com/consulting/packaged/performance.html Regards, Josh -- Josh Chamas Director, Professional Services MySQL Inc., www.mysql.com Get More with MySQL

Re: Concurrency Question

this carefully under load to make sure that your code does not result in any dead locks. Regards, Josh Josh Chamas, Founder| NodeWorks - http://www.nodeworks.com Chamas Enterprises Inc. | NodeWorks Directory - http://dir.nodeworks.com

Re: Error 1005 when adding a Foreign Key

Josh Chamas, Founder| NodeWorks - http://www.nodeworks.com Chamas Enterprises Inc. | NodeWorks Directory - http://dir.nodeworks.com http://www.chamas.com | Apache::ASP - http://www.apache-asp.org -- MySQL General Mailing List For list

InnoDB tablespace fragmentation bug in MySQL 4.0.20

Josh Chamas, Founder| NodeWorks - http://www.nodeworks.com Chamas Enterprises Inc. | NodeWorks Directory - http://dir.nodeworks.com http://www.chamas.com | Apache::ASP - http://www.apache-asp.org mysql alter table clicks drop index idx_test; Query OK, 891450 rows affected (57.83 sec) Records

InnoDB, odd insert error shared row locking behavior

from show innodb status regarding one such deadlock. Regards, Josh Josh Chamas, Founder| NodeWorks - http://www.nodeworks.com Chamas Enterprises Inc. | NodeWorks Directory - http://dir.nodeworks.com http://www.chamas.com