List:General Discussion« Previous MessageNext Message »
From:Jerry Schwartz Date:July 6 2009 5:14pm
Subject:RE: How To Clean Old Table Data
View as plain text  

>-----Original Message-----
>From: OKAN ARI [mailto:okanari@stripped]
>Sent: Monday, July 06, 2009 11:39 AM
>To: Jerry Schwartz
>Subject: Re: How To Clean Old Table Data
>
>Thank you Jerry Schwartz and Blog Tieng Viet,
>
>To Viet: Mysql server is up alt lease 1 year, I have setup my.cnf and
>query_cache_size to a best value in this time, I think this setting is
>best
>as I can do.
>
>To [JS]: I understand that you say, memory limits can do this dramatic
>performance problem. In my.cnf there is no configuration about Max
>memory
>usage, this limit takes automatically or with any other setting or
>hardware.
>I am planning to increase the memory to 8GB of Ram, this will solve the
>problem if the reason is memory. I hope thet, I understant you
>correctly,
>for confirmation, what you thnik about memory increase plan for the
>first
>step of optimization.
>
[JS] As I said, I have no direct experience with tuning MySQL. All of the
databases I manage are quite small.

Adding memory is certainly the cheapest thing you can try.

Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com



>OKAN
>
>----- Original Message -----
>From: "Jerry Schwartz" <jschwartz@stripped>
>To: "'Carlos Williams'" <carloswill@stripped>; <mysql@stripped>
>Sent: Monday, July 06, 2009 6:20 PM
>Subject: RE: How To Clean Old Table Data
>
>
>>
>>
>>>-----Original Message-----
>>>From: Carlos Williams [mailto:carloswill@stripped]
>>>Sent: Monday, July 06, 2009 10:53 AM
>>>To: mysql@stripped
>>>Subject: How To Clean Old Table Data
>>>
>>>I have an application that crates a users email info in MySQL every
>time
>>>they login into the application. The only problem is once I remove
>their
>>>account from the application/Linux, their user data remains in the
>MySQL
>>>table and will eventually clutter the database. I don't know how I
>>>should or
>>>can set something up that when I remove someone from the Linux system,
>I
>>>can
>>>also remove their data from MySQL.
>>>
>>>mysql> select * from identities;
>>>+-------------+-----+----------+-----------------+--------------+-----
>--
>>>----------------+----------+-----+------------+----------------+------
>--
>>>-+
>>>| identity_id | del | standard | name            | organization |
>>>email                 | reply-to | bcc | signature  | html_signature |
>>>user_id |
>>>+-------------+-----+----------+-----------------+--------------+-----
>--
>>>----------------+----------+-----+------------+----------------+------
>--
>>>-+
>>>|           1 |   0 |        1 | Carlos Williams |              |
>>>carlos@stripped |          |     | --
>>>Carlos |              0 |       1 |
>>>|           2 |   0 |        1 | carlos                  |
>>>|
>>>carlos@stripped |          |     | NULL       |              0 |
>>>2 |
>>>|           3 |   0 |        1 | Carlos Williams |              |
>>>carlos@stripped    |          |     | Carlos      |              0
>>>|       3 |
>>>+-------------+-----+----------+-----------------+--------------+-----
>--
>>>----------------+----------+-----+------------+----------------+------
>--
>>>-+
>>>3 rows in set (0.00 sec)
>>>
>>>
>>>Above I have connected to the database and I can see 3 users that are
>no
>>>longer present on the server however their user data is still stored
>in
>>>MySQL. How can I delete the entire row of data in the table.
>> [JS] Ah, perhaps I misunderstood your question. The SQL command you
>want
>> is
>>
>> DELETE identities WHERE email = 'carlos@stripped';
>>
>> You'll have to do that for each email address, of course.
>>
>>
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
>http://lists.mysql.com/mysql?unsub=1
>>




Thread
How To Clean Old Table DataCarlos Williams6 Jul
  • RE: How To Clean Old Table DataJerry Schwartz6 Jul
RE: How To Clean Old Table DataJerry Schwartz6 Jul