DELETE DATA FROM TABLE

Hi Experts, I have a crm table where 12 millions records inserted/day. We are running report queries on this table and using partitioning features for faster results. we have to maintain 45 days data means 540million records. As per my calculation 540 records will use 1.8 TB of disk space. Total

Select through characters

Hello list I have a list of names with english and greek characters. How can select them separately? I mean, only greeks or only english. thank you, Nikos

Re: DELETE DATA FROM TABLE

Krishna Chandra Prajapati wrote: Hi Experts, I have a crm table where 12 millions records inserted/day. We are running report queries on this table and using partitioning features for faster results. we have to maintain 45 days data means 540million records. As per my calculation 540 records

RE: DELETE DATA FROM TABLE

Assuming you're using either myisam tables, or innodb with file-per-table option turned on, then dropping a whole partition at a time will allow you to reclaim disk space. If you're using innodb with a single tablespace currently, then unfortunately, you would have to export all your data,

Re: DELETE DATA FROM TABLE

Hi Gavin, I am using innodb with file-per-table. I agree with you dropping a partition will reclaim disk space. alter table table name drop partition partition name But, my concern is alter table table name drop partition partition name on very big table would might take a lot of time.

RE: Select through characters

Hi, If the efficiency is the key factor I would suggest to create a trigger on insert and update and mark the rows in a separate column instead of executing some fancy string checks during select. Regards, m. -Original Message- From: nikos [mailto:ni...@qbit.gr] Sent: 19 November 2009

Re: Select through characters [SOLVED]

I find a solution that works: SELECT writer_id, writer FROM writer WHERE writer REGEXP '^[A-Z]+' ORDER BY writer Thank you all Nikos misiaQ wrote: Hi, If the efficiency is the key factor I would suggest to create a trigger on insert and update and mark the rows in a separate column instead

Fwd: ODBC MySQL Password as plain text

Following my previous email. I've now configured my database connection using a ODBC DNSLESS SSL connection. However the problem still remains, the password is stored in the ASP file in plain text. Does anyone have any recommendations on how to overcome this issue ? Cheers Neil --

Re: Fwd: ODBC MySQL Password as plain text

Tompkins Neil wrote: Following my previous email. I've now configured my database connection using a ODBC DNSLESS SSL connection. However the problem still remains, the password is stored in the ASP file in plain text. Does anyone have any recommendations on how to overcome this issue ?

Re: Fwd: ODBC MySQL Password as plain text

Hi Jay, This was my thought. Maybe encrypt the pasword in the DNSless connection and have a key somewhere within a external file. However if someone found the key in this file they could still access it. Any other thoughts on how to overcome this ? Cheers Neil On Thu, Nov 19, 2009 at 12:40

RE: MySQL being hacked with commands through URL

I have tried that many times over and have found no way to get it to work, keep getting unexpected T_Variable and I cannot find out whats wrong with what you sent. -Original Message- From: Michael Dykman [mailto:mdyk...@gmail.com] Sent: Wednesday, November 18, 2009 3:49 PM To: James

RE: MySQL being hacked with commands through URL

Not sure exactly what you mean by 'setting date/time right'. Mind clarifying a little? -Original Message- From: Pintér Tibor [mailto:tib...@tibyke.hu] Sent: Thursday, November 19, 2009 9:10 AM To: James Coffman Subject: Re: MySQL being hacked with commands through URL James Coffman

RE: DELETE DATA FROM TABLE

Hi Krishna, Drop partition should be very quick - much faster than doing a DELETE on the same amount of data. Internally, it will be the same as doing a drop table for that partition. Regards, Gavin Towey From: Krishna Chandra Prajapati [mailto:prajapat...@gmail.com] Sent: Thursday, November

Foreign Keys Problem

Hi; I don't claim to be an expert in MySQL. The following code was largely supplied to me by someone who was. I don't really understand foreign keys. He wrote this off the top of his head, and it's throwing an error. Here's the python code: def catTree(): user, passwd, db, host = login()

mysqldump vs phpmyadmin dump

Hi everyone, Here is a rookie question. The problem what I found is that mysqldump and phpmyadmin generate different size of backup file against same database. I try to dump same database with the 2 different methods, the original database is 2.8mb, phpmyadmin export 1.5mb file, and mysqldump