Your IP address is 35.175.191.46

AFRINIC Database Working Group

Draft – 24/08/2016

 

Purpose

The purpose of the AFRINIC Database Working Group (DBWG) is to provide a channel for discussion between AFRINIC staff, technical community members, and other stakeholders, regarding the implementation of AFRINIC's WHOIS service. Through this channel, the staff will:

  • Announce new developments or updates.
  • Engage the community in testing new developments.
  • Call for comments or suggestions regarding any technical aspect of the WHOIS.
  • Engage the community with regards to the database inconsistencies and how we can work together to have them resolved.
  • Call for presentations and researches around the WHOIS and database-related subjects.
  • Gather ideas of the community regarding improvements to the current DB-related services.
  • Help the community in terms of DB tools or objects migration.
  • Update and improve the current documentation and share the business rules.

 

Rules and guidelines

  • The database working group is dedicated for technical discussion of the WHOIS service and the underlying database.
  • Though comments and suggestions are welcome from the community, the final decision on implementation details will be reserved for the staff.
  • The database working group members are kindly asked to follow AFRINIC's code of conduct 
  • Comments or suggestions raised in the database working group will be handled by AFRINIC staff as time permits. Any bugs or operational issues should be reported through other channels. 

 

Chair

The database working group chairs are staff members appointed by the Head of IT&Engineering.

The current chairs are:

  • Michel ODOU
  • Simon SERUYINDA

 

Mailing list

The discussions are welcome on the dedicated mailing list :  This e-mail address is being protected from spambots. You need JavaScript enabled to view it . To subscribe, please follow the instructions at

https://lists.afrinic.net/mailman/listinfo/dbwg. 

Profile Information

Application afterLoad: 0.001 seconds, 0.71 MB
Application afterInitialise: 0.076 seconds, 2.70 MB
Application afterRoute: 0.131 seconds, 5.95 MB
Application afterDispatch: 0.183 seconds, 7.57 MB
Application afterRender: 0.451 seconds, 10.50 MB

Memory Usage

11050800

10 queries logged

  1. SELECT m.*, c.`option` AS component
      FROM www3menu AS m
      LEFT JOIN www3components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
  2. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value

      FROM www3jf_content AS jf_content

      WHERE jf_content.language_id=1
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(1,11,20,304,324,262,231,275,340,393,791,661,12,51,348,805,831,13,52,154,795,14,24,53,793,15,797,16,62,803,17,799,68,97,27,387,619,191,221,172,170,76,171,337,418,521,845,175,174,177,237,176,499,511,455,481,523,547,671,184,185,188,423,837,527,179,181,204,235,156,158,159,384,475,675,629,160,161,162,157,192,621,268,270,266,321,264,265,338,416,483,519,843,276,283,278,282,477,677,279,631,280,281,429,277,382,305,306,307,308,424,835,317,330,318,319,320,325,326,327,328,529,341,342,343,345,350,349,408,351,354,745,489,509,356,479,525,549,673,388,400,403,404,405,406,419,513,399,394,396,397,395,617,615,663,665,801,414,163,731,733,735,737,715,739,741,789,743,269,271,272,292,289,290,291,293,294,339,295,420,386,807,811,285,286,288,819,383,287,515,567,809,817,415,284,633,763,315,312,561,563,565,767,314,380,517,332,333,334,335,336,370,346,347,311,378,787,352,364,362,365,833,719,366,367,368,411,412,453,825,379,357,358,359,360,361,371,431,459,463,467,469,471,473,531,533,537,539,541,543,545,599,609,601,605,485,487,491,493,495,497,551,553,557,559,841,573,575,577,579,581,583,585,591,589,777,779,813,749,751,753,755,747,757,759,761,783,373,374,375,376,721,417,829,669,353,413,461,535,781,727,667,611,597,603,815,769,635,637,639,641,645,643,647,649,651,653,655,657,659,785,821,823,827,697,701,703,705,707,709,711)
       
      AND jf_content.reference_table='menu'
  3. SELECT *
      FROM www3rokcandy
      WHERE published=1
  4. SELECT template
      FROM www3templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 747)
      ORDER BY menuid DESC
      LIMIT 0, 1
  5. SELECT a.*, u.name AS author, u.usertype, cc.title AS category, s.title AS SECTION, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access  
      FROM www3content AS a
      LEFT JOIN www3categories AS cc
      ON cc.id = a.catid
      LEFT JOIN www3sections AS s
      ON s.id = cc.SECTION
      AND s.scope = "content"
      LEFT JOIN www3users AS u
      ON u.id = a.created_by
      LEFT JOIN www3groups AS g
      ON a.access = g.id
      WHERE a.id = 1865
      AND (  ( a.created_by = 0 )    OR  ( a.state = 1
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-10-02 08:20:03' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-10-02 08:20:03' )   )    OR  ( a.state = -1 )  )
  6. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value

      FROM www3jf_content AS jf_content

      WHERE jf_content.language_id=1
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(1865)
       
      AND jf_content.reference_table='content'
  7. UPDATE www3content
      SET hits = ( hits + 1 )
      WHERE id='1865'
  8. SELECT *
      FROM www3jcomments_settings

      WHERE lang = 'en-GB'
  9. SELECT id, title, module, POSITION, content, showtitle, control, params
      FROM www3modules AS m
      LEFT JOIN www3modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.published = 1
      AND m.access <= 0
      AND m.client_id = 0
      AND ( mm.menuid = 747 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  10. SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value

      FROM www3jf_content AS jf_content

      WHERE jf_content.language_id=1
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(79,330,35,326,331,306,347,345,329,292,335)
       
      AND jf_content.reference_table='modules'

Language Files Loaded

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None