Re: Can Innodb reuse the deleted rows disk space?

Hi, Try using the optimize table tablename ,but this will keep the data accordingly,but really if it is a disk space constraint you can go with re-org process in which you will have to get a down time for mysql db.Process is something like . Dump all the Innodb tables drop the existing innodb

RE: Struggling with the logic

Thanks to all for the responses, as always problem now solved and I learnt a few things. Regards John Berman -Original Message- From: Chris Sansom [mailto:[EMAIL PROTECTED] Sent: 23 July 2006 16:02 To: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: Re: Struggling with the logic

Re: Searching through an alphabetical range

Hello Paul, You can try this: SELECT DISTINCT lastname FROM employee WHERE lastname BETWEEN 'm' AND 'z'; Thanks, ViSolve DB Team. - Original Message - From: "Paul Nowosielski" <[EMAIL PROTECTED]> To: Sent: Friday, July 21, 2006 10:33 PM Subject: Searching through an alphabetical r

Can Innodb reuse the deleted rows disk space?

Hi, all I know the Innodb use MVCC to achieve very high concurrency. Can Innodb reuse the deleted rows disk space? I have an database which have many update operation. If Innodb can't reuse the space of deleted rows, I worry about that MySQL will exhaust our disk space very quickly.

Segmentation fault error accrued when gcc -o test -L/usr/lib/mysql -lmysqlclient test.c

hi to all. thanks luiz and mike for response. my code is compiled when i use -lmysqlclient option and executable file is now exist but when i try to execute this file it prompts "Segmentation fault" .what's the meaning of it and what i have to do? ## gcc -o test -L/usr/lib/mysql -lmysqlcl

RE: Replication Problem

Aah, sorry, I didn't explain myself very well 8-( At the mysql prompt >RESET SLAVE; This tells the slave to reset itself back, and forget the current settings (eg. the log position etc., not the master or such details) to where the master started and begin replication from there. There is also a c

RE: Replication Problem

Hello David, Reset how? I did the CHANGE MASTER TO and set it as what was specified from the Show Master command after I tar'd the files. Thanks! Brett Hi Brett, Did you reset the master and/or slave? Looking at the logs, it appears as though the slave is trying to read from a different p

Re: Replication Problem

Hi, Check whether u have starting with the correct master position from slave. Thanks & Regards Dilipkumar - Original Message - From: "Brett Harvey" <[EMAIL PROTECTED]> To: Sent: Monday, July 24, 2006 9:36 AM Subject: Re: Replication Problem Hi, Thanks for the response. Yes - I h

RE: Replication Problem

Hi Brett, Did you reset the master and/or slave? Looking at the logs, it appears as though the slave is trying to read from a different position in the log than the master has reached. Regards --- ** _/ ** David Lo

Re: Replication Problem

Hi, Thanks for the response. Yes - I have that in my config also. replicate-do-db=FMS Thanks Brett Hi, Did u mention what all databases has to be replicated in ur cnf file as (replicate-do-db=database-name). Thanks & Regards Dilipkumar -- -

RE: Searching through an alphabetical range

Hi, Tim's point is that you have someone with a last name of 'zebra', they won't be included in your results. Quentin -Original Message- From: Paul Nowosielski [mailto:[EMAIL PROTECTED] Sent: Saturday, 22 July 2006 7:19 a.m. To: mysql@lists.mysql.com Cc: Tim Lucia Subject: Re: Searching

Re: mysql/syslog - 100,000s of log messages on restart

Hi, In ur cnf file mention the log file path as log=/mysql/logs/mysqllog/qry.log . log-slow-queries=/mysql/logs/mysqllog/slowqry.log and restart mysql. Thanks & Regards Dilipkumar - Original Message - From: "Adam Rosi-Kessel" <[EMAIL PROTECTED]> To: Sent: Sunday, July 23, 2006 1:58 A

Re: Replication Problem

Hi, Did u mention what all databases has to be replicated in ur cnf file as (replicate-do-db=database-name). Thanks & Regards Dilipkumar - Original Message - From: "Brett Harvey" <[EMAIL PROTECTED]> To: Sent: Monday, July 24, 2006 8:49 AM Subject: Replication Problem Well, I suc

Re: Is a "set current" TIMESTAMP operation atomic when updating/inserting multiple rows?

Hi, If u update this statment like what u have mentioned it will be updated for all the rows. update tablename set field name='2006-07-07 00:00:00'; Thanks & Regards Dilipkumar - Original Message - From: "Chris W" <[EMAIL PROTECTED]> To: "Dan Jakubiec" <[EMAIL PROTECTED]>; "MYSQL Gen

Replication Problem

Well, I successfully setup replication for one server/slave. Now I'm trying to do the same for another set. I've tried both the tar method and load data from master and can't seem to get either to work. Nothing replicates to the slave. I'm running Mysql 5.022. === My error

Re: Struggling with the logic

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > For what it's worth, the standard American date format of > mm/dd/ has always mystified me, as it's the least > logical possible way to do it. The SQL format - in > decreasing order of unit size - is of course the most > logical way because you

Re: Is a "set current" TIMESTAMP operation atomic when updating/inserting multiple rows?

Ah, thanks Chris. I should have looked there (I was studying the TIMESTAMP sections, not NOW()). The NOW() documentation also refers to the SYSDATE() function which does the opposite (i.e. sets the time when the record actually gets added). So I'll go ahead and use the 'my_timestamp=NOW()' form

Re: Is a "set current" TIMESTAMP operation atomic when updating/inserting multiple rows?

Dan Jakubiec wrote: Hi. I want to insert/update multiple rows into a table which has a timestamp field, and I want to set the timestamp field in each row to the current timestamp. However, it is important to me that all the rows I update actually end up with the same timestamp value. My conce

Is a "set current" TIMESTAMP operation atomic when updating/inserting multiple rows?

Hi. I want to insert/update multiple rows into a table which has a timestamp field, and I want to set the timestamp field in each row to the current timestamp. However, it is important to me that all the rows I update actually end up with the same timestamp value. My concern is: what happens if

gcc -o test -L/usr/lib/mysql -lmysqlclient test.c

hi to all. thanks luiz and mike for response. my code is compiled when i use -lmysqlclient option and executable file is now exist but when i try to execute this file it prompts "segmentation error" .what's the meaning of it and what i have to do? The code is as fillows: *

Re: Struggling with the logic

Hello John There are two approaches to this. 1) Best, save date into table as a number. Select date like WHERE date>=$date1 AND date<=$date2 2)Otherwise, if storing dates a strings: WHERE date=$date1 OR date=$date2 OR date=$date3 OR date=$date4 OR date=$date5. In general, if you want to

Re: Struggling with the logic

At 15:43 +0100 23/7/06, John Berman wrote: I have a table called: submissions and each record has an approvedate field which stores the date mm/dd/ Why? If you're storing the date in this format you can only be storing it as a string (char, varchar or text), so no wonder you're having tro

Struggling with the logic

Hi I'm struggling with some logic I have a table called: submissions and each record has an approvedate field which stores the date mm/dd/ I want to display all records for 7 days only from their approved date so I guess something like Select * from submissions were appro

Re: undefined reference to 'mysql_init'

Hi Ali Hi, I am begeener to MySQL. I have installed Suse10 and MySQL and mysql++ in my pc. i want to connect to MySQL through C. When I am compiling the program, I am getting the following error. *** compile your app wi

Re: undefined reference to 'mysql_init'

Try gcc -o test test.c -lmysqlclient On Sunday 23 July 2006 13:14, ali asghar torabi parizy wrote: > Hi, >I am begeener to MySQL. I have installed Suse10 and MySQL and mysql++ > in my pc. > > i want to connect to MySQL through C. When I am compiling the program, > I am getting the foll

undefined reference to 'mysql_init'

Hi, I am begeener to MySQL. I have installed Suse10 and MySQL and mysql++ in my pc. i want to connect to MySQL through C. When I am compiling the program, I am getting the following error. *** gcc -o test test.c