MySql is too big - Newscoop Support Discussions on Sourcefabric Forum

George Hadjichristofi

Hello my mysql is 500MB i OPTIMIZE at ripeir an is the same. what i make to make faster my web site?

Andrey Podshivalov

you can clear the Requests and Sessions tables

George Hadjichristofi · Post edited by George Hadjichristofi at 2012-03-28 10:36:47

what is Requests an session table?

if i remove i don't have problem with my database?

an the ArticleIndex is too big

Andrey Podshivalov

you won't have a problem if you clear the Requests and Sessions tables.

ArticleIndex is used for full text search

George Hadjichristofi

ok thanks :)

George Hadjichristofi · Post edited by George Hadjichristofi at 2012-03-29 03:31:54

sorry now is 200 Mb my database. what other i make to more smaller?

Holman Romero

Hi George,
What version of Newscoop are you running on ? How many articles do you currently have ?

George Hadjichristofi

Newscoop version 3.5.3

articles 8000

George Hadjichristofi · Post edited by George Hadjichristofi at 2012-03-29 11:52:12

hello i if i remove the data from ArticleIndex i have problem?

Petr Jasek

hi george, yep that would be a problem it's used for searching

Holman Romero

Reply to @George+Hadjichristofi:

If you are familiar with MySQL cli then you can query the information schema database and look for table sizes for your Newscoop database, something like this:

SELECT table_name AS "Table", table_rows AS "Rows Count", ROUND((data_length + index_length) / 1024, 2) AS "Size in Kb" FROM information_schema.TABLES WHERE information_schema.TABLES.table_schema = 'newscoop';

I am not a user of phpMyAdmin but I guess it can also give you this information.

You can save the output to some text file and attach it here so we can have a look.

All Best,

Howdy, Stranger!

Categories

Poll

Top Posters