Re: Trancate table from command line?

If you use *nix, you can use this form: *echo* "TRUNCATE TABLE you_table_name;" | *mysql* -A your_db_name -ulogin -ppassword And: *cat* your_file.sql | *mysql* -A your_db_name -ulogin -ppassword 2010/3/17 John Oliver > Is there a way to use mysqladmin (or mysql) to truncate a table as a > on

Mysql Performence config ?

Hi i use MySQL Server 5.1.42 on a IBM Xseries x3950 (32Go,4xDual Core,Mandriva 64 Bits, 250 GoRAID SAS). I search the best my.cnf configuration for performence, actually i use : [client] port= 3306 socket = /var/lib/mysql/mysql.sock [mysqld] port= 3306 socket

MySQL Community Server 5.1.45 has been released

Dear MySQL users, MySQL Community Server 5.1.45, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.45 is recommended for use on production systems. For an overview of what's new in MySQL 5.1, please see http://dev.mysql.com/doc/refman/5.1/en/mysq

Re: Need help with query optimization

Can you please show us the indexes on both the tables. regards anandkl On Tue, Mar 16, 2010 at 11:47 PM, Jesse wrote: > I have the following query: > > SELECT TAP.ID , M.UID, TAP.FirstName, TAP.MI, > TAP.LastName, TAP.State, > TAP.SchoolName, TAP.StateApproved, TAP.DiplomatAppro

Re: Trancate table from command line?

On Tue, Mar 16, 2010 at 02:12:42PM -0700, John Oliver wrote: > Is there a way to use mysqladmin (or mysql) to truncate a table as a > one-off command from the command line? > > I have an issue with importing data from one database into another, but > the second database might have columns that the

Trancate table from command line?

Is there a way to use mysqladmin (or mysql) to truncate a table as a one-off command from the command line? I have an issue with importing data from one database into another, but the second database might have columns that the first did not. On database 1, I use mysqldump to grab certain tables,

Re: dash was converted o a wierd character

On Tue, Mar 16, 2010 at 5:06 AM, Johan De Meersman wrote: > On *nix, look for a utility called convmv. > > I've got a hunch that your original file comes from a windows host, and the > filenames may have been copied from a word document or something similar. > Microsoft knows best, and thus tends

Need help with query optimization

I have the following query: SELECT TAP.ID, M.UID, TAP.FirstName, TAP.MI, TAP.LastName, TAP.State, TAP.SchoolName, TAP.StateApproved, TAP.DiplomatApproved, C.ChapterType, S.Region, S.District,Pts.TotPoints FROM TorchAwardParticipants TAP JOIN Members M On M.ID=TAP.CurrentMemberID JOIN Chapters

Re: mysql & RAID

What are your plans for OS as this can have an impact on hardware choice especially if you are considering Solaris or Open Solaris. Regards John On Tue, Mar 16, 2010 at 3:22 PM, Евгений Килимчук wrote: > > http://assets.en.oreilly.com/1/event/27/Linux%20Filesystem%20Performance%20for%20Databases

Re: mysql & RAID

http://assets.en.oreilly.com/1/event/27/Linux%20Filesystem%20Performance%20for%20Databases%20Presentation.pdf 2010/3/10 John G. Heim > Hi, > > I am working on configuring a new hardware database server. I'm a little > confused as to what to do about disk. We have several mysql databases but by >

Re: Innodb buffer pool usage

There will be an increase in IO and a noticeable decrease in performance if the buffer pool is too small. Give it all the memory which is not needed elsewhere. If you can set it a little larger than the size of all your innodb tablespaces that would be good. Oracle is a very different animal to My

RE: Innodb buffer pool usage

Hi Carlos (and all) I had a look at the script that we use an the following is the calculations that is used to calculate the innodb buffer usage. Machiel -Original Message- From: Carlos Proal [mailto:carlos.pr...@gmail.com] Sent: 16 March 2010 9:31 AM To: mysql@lists.mysql.co

Re: dash was converted o a wierd character

On *nix, look for a utility called convmv. I've got a hunch that your original file comes from a windows host, and the filenames may have been copied from a word document or something similar. Microsoft knows best, and thus tends to convert regular dashes into some weird, slightly elongated versio

RE: Innodb buffer pool usage

HI Carlos We run a script for the monitoring and the output received is as follows: InnoDB Buffer Pool __ Usage 3.00G of 3.00G %Used: 100.00 Read hit 100.00% Pages Free 0%Total: 0.00 Data

Re: Innodb buffer pool usage

Hi Machiel, What do you mean with "innodb buffer pool is at 100% full" ? There are several status variables associated with innodb buffer pool ie: Innodb_buffer_pool_pages_free is the number of unused data pages. Innodb_buffer_pool_pages_total is the total number of pages. Innodb_buffer_pool_