taille maximum d'une base de donné et comment l'optimiser

[john2]

Lut, j'aimerait savoir la taille max d'une base de donnéé, j'ai lue que certain serveurs limitait leur taille

j'ai poser la question chez servage et la réponse

There is no limit as such on the size of your mysql database.

Per mysql database is allowed to generate:
100'000 updates
100'000 questions

il est marquer taille de la base de donne sans limite, une base de donné peut t-elle ocuper queque centaine de giga sans prob ? ( bon la c'est beaucoup mais c'est pour l'info ) normalement pas de limite niv mysql, ca serait plutot l"hébergeur ?

Mais en plus, si par exemple j'utilise un scrip qui permet d'afficher les article en relation, un peu comme sur ce forum, et qui utilise "full text" donc il analyse tout le texte pour donner les article en relation

j'ai du utiliser cette fonction


ALTER TABLE `jos_content` ADD FULLTEXT `ribfulltext` (`title`,`introtext` ,`fulltext`);


pour que le scrip recherche dans tout l'article


si il y a un milliard d'article sa peut poser problème ? enfin plutot qu'elle serait la limite d'article ?

j'ai lue que le performance dépendant aussi de la facon d'on le script éxécutait les requettes

par exemple pour une page j'ai ses requettes :

62 queries executed

Code: Tout sélectionner

1
SET sql_mode = 'MYSQL40'2
SELECT *
FROM jos_mambots
WHERE id = '61'3
DELETE FROM jos_session
WHERE (
( time < '1209334917' )
AND guest = 0
AND gid > 0
) OR (
( time < '1209334917' )
AND guest = 1
AND userid = 0
)4
SELECT *
FROM jos_session
WHERE session_id = 'f5d2fd3ecfd15fdeb784009e6b041250'5
UPDATE jos_session SET `time`='1209335817',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1' WHERE session_id='f5d2fd3ecfd15fdeb784009e6b041250'6
SELECT a.*, u.name AS author, u.usertype, cc.name AS category, s.name AS section, g.name AS groups,
s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access,
s.id AS sec_id, cc.id as cat_id
FROM jos_content AS a
LEFT JOIN jos_categories AS cc ON cc.id = a.catid
LEFT JOIN jos_sections AS s ON s.id = cc.section AND s.scope = 'content'
LEFT JOIN jos_users AS u ON u.id = a.created_by
LEFT JOIN jos_groups AS g ON a.access = g.id
WHERE a.id = 8983 AND ( a.state = 1 OR a.state = -1 )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2008-04-27 22:36' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-04-27 22:36' )
AND a.access <= 07
UPDATE jos_content
SET hits = ( hits + 1 )
WHERE id = '8983'8
SELECT *
FROM jos_mambots
WHERE id = '53'9
SELECT metakey,catid,sectionid FROM jos_content WHERE id='8983'10
SELECT introtext,`fulltext` FROM jos_content WHERE id=8983 LIMIT 111
SELECT id, title,title , MATCH  (`title`, `introtext`, `fulltext`)  AGAINST ('Sexualité. Alain Corbin ressuscite les langages du plaisir.Sexualité. Alain Corbin ressuscite les langages du plaisir.\nActualite : http://www.liberation.fr/culture/livre/309921.FR.php?rss=true&xtor=RSS-461.') as score , CONCAT('
',introtext) as text  FROM jos_content WHERE  state = 1  AND access <=0 AND id != 8983 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2008-04-27 22:36:57' )  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2008-04-27 22:36:57' )   AND (  MATCH  (`title`, `introtext`, `fulltext`)  AGAINST ('Sexualité. Alain Corbin ressuscite les langages du plaisir.Sexualité. Alain Corbin ressuscite les langages du plaisir.\nActualite : http://www.liberation.fr/culture/livre/309921.FR.php?rss=true&xtor=RSS-461.') > 1)  ORDER BY  score DESC,  RAND(NOW())  LIMIT 1212
SELECT COUNT( id )
FROM jos_menu
WHERE type = 'content_typed'
AND published = 113
SELECT id
FROM jos_menu
WHERE type = 'content_typed'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=8979'14
SELECT COUNT( id )
FROM jos_menu
WHERE type = 'content_item_link'
AND published = 115
SELECT id
FROM jos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=8979'16
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 8979
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id17
SELECT id
FROM jos_menu
WHERE type = 'content_typed'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=8891'18
SELECT id
FROM jos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=8891'19
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 8891
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id20
SELECT id
FROM jos_menu
WHERE type = 'content_typed'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=8975'21
SELECT id
FROM jos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=8975'22
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 8975
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id23
SELECT id
FROM jos_menu
WHERE type = 'content_typed'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=8976'24
SELECT id
FROM jos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=8976'25
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 8976
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id26
SELECT id
FROM jos_menu
WHERE type = 'content_typed'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=8899'27
SELECT id
FROM jos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=8899'28
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 8899
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id29
SELECT id
FROM jos_menu
WHERE type = 'content_typed'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=8967'30
SELECT id
FROM jos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=8967'31
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 8967
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id32
SELECT id
FROM jos_menu
WHERE type = 'content_typed'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=8956'33
SELECT id
FROM jos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=8956'34
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 8956
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id35
SELECT id
FROM jos_menu
WHERE type = 'content_typed'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=8906'36
SELECT id
FROM jos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=8906'37
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 8906
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id38
SELECT id
FROM jos_menu
WHERE type = 'content_typed'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=8914'39
SELECT id
FROM jos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=8914'40
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 8914
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id41
SELECT id
FROM jos_menu
WHERE type = 'content_typed'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=8926'42
SELECT id
FROM jos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=8926'43
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 8926
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id44
SELECT id
FROM jos_menu
WHERE type = 'content_typed'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=8980'45
SELECT id
FROM jos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=8980'46
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 8980
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id47
SELECT id
FROM jos_menu
WHERE type = 'content_typed'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=8910'48
SELECT id
FROM jos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=8910'49
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 8910
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id50
delete from jos_joomlacache where filename='french663352e149807371f6cd0bdc8d1b2a3e' and component='1'51
insert into jos_joomlacache set filename='french663352e149807371f6cd0bdc8d1b2a3e', size='3666', date='2008-04-27 10:36:52 PM', element='com_content', component='1'52
SELECT a.*
FROM jos_components AS a
WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' )
AND a.option = 'com_syndicate'53
update jos_joomlacache set head='






   
   ' where id='64532'54
SELECT p.id, p.title
FROM jos_polls AS p
INNER JOIN jos_poll_menu AS pm ON  pm.pollid = p.id
WHERE ( pm.menuid = 1007 OR pm.menuid = 0 )
AND p.published = 155
SELECT id
FROM jos_menu
WHERE type = 'components'
AND published = 1
AND link = 'index.php?option=com_poll'56
delete from jos_joomlacache where filename='french663352e149807371f6cd0bdc8d1b2a3e' and element='1'57
insert into jos_joomlacache set filename='french663352e149807371f6cd0bdc8d1b2a3e', size='77', date='2008-04-27 22:36:52', element='1'58
delete from jos_joomlacache where filename='french663352e149807371f6cd0bdc8d1b2a3e' and element='175'59
insert into jos_joomlacache set filename='french663352e149807371f6cd0bdc8d1b2a3e', size='845', date='2008-04-27 22:36:52', element='175'60
SELECT m.*
FROM jos_menu AS m
WHERE menutype = 'othermenu'
AND published = 1
AND access <= 0
ORDER BY parent, ordering61
delete from jos_joomlacache where filename='french663352e149807371f6cd0bdc8d1b2a3e' and element='30'62
insert into jos_joomlacache set filename='french663352e149807371f6cd0bdc8d1b2a3e', size='42', date='2008-04-27 22:36:52', element='30'

sa vient de joomla, je ne sais pas si c'est très optimiser

J'ai lut qu'il fallait " indexer la base", qui que quoi dont ou ?






avec cache activer ( 48 h de cache, doit je l'augmenter ? )

Code: Tout sélectionner

13 queries executed

1
SET sql_mode = 'MYSQL40'2
SELECT folder, element, published, params
FROM jos_mambots
WHERE published >= 1
AND access <= 0
AND folder = 'system'
ORDER BY ordering3
SELECT id
FROM jos_mambots
WHERE element = 'floodcontrol.systembot'
AND folder = 'system'4
SELECT *
FROM jos_mambots
WHERE id = '61'5
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND ( menuid = 0  OR menuid = 1007 )
ORDER BY menuid DESC
LIMIT 16
DELETE FROM jos_session
WHERE (
( time < '1209334949' )
AND guest = 0
AND gid > 0
) OR (
( time < '1209334949' )
AND guest = 1
AND userid = 0
)7
SELECT *
FROM jos_session
WHERE session_id = 'f5d2fd3ecfd15fdeb784009e6b041250'8
UPDATE jos_session SET `time`='1209335849',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1' WHERE session_id='f5d2fd3ecfd15fdeb784009e6b041250'9
SELECT *
FROM jos_menu
WHERE id = 100710
SELECT m.* FROM jos_menu AS m
WHERE menutype='topmenu' AND published='1' AND access <= '0'
ORDER BY parent,ordering11
select head from jos_joomlacache where component='1' and filename ='french663352e149807371f6cd0bdc8d1b2a3e'12
SELECT id, title, module, position, content, showtitle, params
FROM jos_modules AS m
INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id != 1
AND ( mm.menuid = 0 OR mm.menuid = 1007 )
ORDER BY ordering13
SELECT id
FROM jos_menu
WHERE link = 'index.php?option=com_search'
AND published = 1

si je veux héberger mon site sur mon ordi, est ce une bonne idéee ?

j'ai vu un site qui utilisait les article en relation, mais aussi les site en relation et en plus un nuage de tag a chaque fois, mais il doit y avoir un serveur dédier derrière


edit, en parlant d'index, j'ai aussi ce prob quand j'analise la base