Table in database _messages is 194 Mb :(

Discuss the workings of JFusion

Table in database _messages is 194 Mb :(

Postby Cansay on Fri Aug 12, 2011 11:45 pm

Im preparing to migrate to 1.6/1.7 and doing tome testing with xampp.

Downloading my database without any compression = 243 mb .....

194 mb is the table messages containing almost 1 million rows...

Can I delete these simply via my database?
Im not sure how its even possible for joomla to keep that many messages ?
Maybe its not joomlas fault, but my Jfusion setup ?

I tried on joomla.org, but nobody cared to reply, could you have a look at your table in the database to check its size....
User avatar
Cansay
JFusion Advanced III
JFusion Advanced III
 
Posts: 248
Joined: Wed Jan 07, 2009 10:44 am

Re: Table in database _messages is 194 Mb :(

Postby fanno on Sat Aug 13, 2011 9:00 am

what table is it i what software
Fanno
_________________________________
Developer
Specialist on SMF, DokuWiki , Mantis, Eventum, Mediawiki, Universal plugin


Review us at!
http://extensions.joomla.org/extensions/3723/details
User avatar
fanno
Developer
Developer
 
Posts: 7668
Joined: Wed Jan 07, 2009 4:38 pm
Location: Denmark, Copenhagen

Re: Table in database _messages is 194 Mb :(

Postby Cansay on Mon Aug 15, 2011 3:26 pm

Amazing, I really cant be allowed to reply in this thread.
User avatar
Cansay
JFusion Advanced III
JFusion Advanced III
 
Posts: 248
Joined: Wed Jan 07, 2009 10:44 am

Re: Table in database _messages is 194 Mb :(

Postby fanno on Mon Aug 15, 2011 6:25 pm

=(, what are you trying to reply ?

there is a problem if you try to post # followed by __
Fanno
_________________________________
Developer
Specialist on SMF, DokuWiki , Mantis, Eventum, Mediawiki, Universal plugin


Review us at!
http://extensions.joomla.org/extensions/3723/details
User avatar
fanno
Developer
Developer
 
Posts: 7668
Joined: Wed Jan 07, 2009 4:38 pm
Location: Denmark, Copenhagen

Re: Table in database _messages is 194 Mb :(

Postby Cansay on Tue Aug 16, 2011 8:37 pm

n
User avatar
Cansay
JFusion Advanced III
JFusion Advanced III
 
Posts: 248
Joined: Wed Jan 07, 2009 10:44 am

Re: Table in database _messages is 194 Mb :(

Postby Cansay on Tue Aug 16, 2011 8:39 pm

This is what im trying to post, have tried al sorts of different ways but get a joomla http 500 every time.
Attachments
REPLY for jufision.txt
(964 Bytes) Downloaded 21 times
User avatar
Cansay
JFusion Advanced III
JFusion Advanced III
 
Posts: 248
Joined: Wed Jan 07, 2009 10:44 am

Re: Table in database _messages is 194 Mb :(

Postby Cansay on Tue Aug 16, 2011 8:39 pm

I dont know if it is copy past that is happening or what
User avatar
Cansay
JFusion Advanced III
JFusion Advanced III
 
Posts: 248
Joined: Wed Jan 07, 2009 10:44 am

Re: Table in database _messages is 194 Mb :(

Postby Cansay on Tue Aug 16, 2011 8:39 pm

COPY PAST ERROR TEST

This is what im trying to post, have tried al sorts of different ways but get a joomla http 500 every time.
User avatar
Cansay
JFusion Advanced III
JFusion Advanced III
 
Posts: 248
Joined: Wed Jan 07, 2009 10:44 am

Re: Table in database _messages is 194 Mb :(

Postby fanno on Tue Aug 16, 2011 9:09 pm

Comes if you post "jos _ messages" (no space) very odd..

I think its joomla that some how that wont allow it ...

as to the error (or what to call it..)

do this match up with the

Discution bot (if i remember right you are using it ...)

I do not see why this happens only to you.. my messages is empty ...

-Thanks
Fanno
_________________________________
Developer
Specialist on SMF, DokuWiki , Mantis, Eventum, Mediawiki, Universal plugin


Review us at!
http://extensions.joomla.org/extensions/3723/details
User avatar
fanno
Developer
Developer
 
Posts: 7668
Joined: Wed Jan 07, 2009 4:38 pm
Location: Denmark, Copenhagen


Return to Discussions

Who is online

Users browsing this forum: No registered users and 0 guests

cron