RE: optimize DB - bad experience

2012-06-19 Thread Rick James
OPTIMIZE TABLE is almost never needed. I certainly don't blast away at all tables. > -Original Message- > From: Igor Shevtsov [mailto:nixofort...@gmail.com] > Sent: Tuesday, June 19, 2012 2:04 PM > To: mysql@lists.mysql.com > Subject: optimize DB - bad experience > > Hi Guys, > Just cur

optimize DB - bad experience

2012-06-19 Thread Igor Shevtsov
Hi Guys, Just curious if any of you had a bad experience running optimize table procedure. ERRORS, corrupted databases or tables caused by this. We have MySQL 5.1.46 server. I feel to run optimize of the full DB is quite safe Example: shell> mysqlcheck -o --skip-write-binlog database What's your

New releases of Percona Toolkit, Percona Monitoring Plugins

2012-06-19 Thread Baron Schwartz
Hi all, I'm happy to announce updates to two of Percona's suites of free (GPL) tools for MySQL. Percona Toolkit versions 2.0.5 and 2.1.2 are released. These are bug-fix releases in the 2.0 and 2.1 series, respectively. These releases fix many dozens of bugs, and we suggest that users upgrade to t

Re: Unresolved symbols with mysqlclient in DEBUG mode using VC++ 2010 Express

2012-06-19 Thread Lars Nilsson
On Tue, Jun 19, 2012 at 11:56 AM, Miguel Cardenas wrote: > RELEASE: > - Runtime: /MT (static threaded) > - Library: mysqlclient.lib (...\mysql\lib) > - Ignore library: LIBCMTD.lib (without this does not link the release) > - Debug: NO > > RELEASE: > - Runtime: /MTd (static threaded debug) > - Libr

Re: Unresolved symbols with mysqlclient in DEBUG mode using VC++ 2010 Express

2012-06-19 Thread Miguel Cardenas
Hello Lars After hours of testing different project configurations, finally I was able to compile with debug mode... still pending the test of debugging, but just created the DLL (it was a library that I'm developing) without errors... The configurations I used (VC++ 2010 Express) were: RELEASE:

Re: Unresolved symbols with mysqlclient in DEBUG mode using VC++ 2010 Express

2012-06-19 Thread Lars Nilsson
On Tue, Jun 19, 2012 at 10:47 AM, Martin Gainty wrote: > Miguel.. > > i do not have VC2010 but as my memory recalls the > C runtime library (MSVCRT*.dll) would be the first library on %PATH% .. and > all missing functions *should* be located inside the dll (e.g. > __CrtSetReportFile ) > > can you

RE: Unresolved symbols with mysqlclient in DEBUG mode using VC++ 2010 Express

2012-06-19 Thread Martin Gainty
Miguel.. i do not have VC2010 but as my memory recalls the C runtime library (MSVCRT*.dll) would be the first library on %PATH% .. and all missing functions *should* be located inside the dll (e.g. __CrtSetReportFile ) can you 1) locate MSVCRT*.dll on your %PATH% 2) dumpbin -exports MSVCRT*.dll

Re: Unresolved symbols with mysqlclient in DEBUG mode using VC++ 2010 Express

2012-06-19 Thread Lars Nilsson
On Tue, Jun 19, 2012 at 2:48 AM, Miguel Cardenas wrote: > Hello friends > 1>mysqlclient.lib(dbug.obj) : error LNK2019: unresolved external > symbol __CrtSetReportFile referenced in function _DbugExit > 1>mysqlclient.lib(my_init.obj) : error LNK2001: unresolved external > symbol __CrtSetReportFile