Jump to content

Alteil Analysis

Members
  • Posts

    4
  • Joined

  • Last visited

Alteil Analysis's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. Hi. My mediawiki site spends 1.44 seconds for a http 301. How to get rid of it? Specifying the type of index page by DirectoryIndex index.php reduce that part of time from 2 seconds to 1.44 seconds.
  2. Hi. Is it possible to make this work on heliohost? I tried to install memcached on a free account of openshift. After that, I installed the memcached extension of mediawiki (which checks if memcache is supported), and, it says no. :o/&--#62; Also, I wonder if the order of commands in LocalSettings.php can affect the speed of mediawiki? I have been checking the speed of my website with http://www.webpagetest.org The good thing is that sending SQL commands with Adminer (the newest version) let me install mediawiki with postgres. Edit: Wow. Initially Mediawiki took like 5 seconds to load a page in US. webpagetest.org showed Mediawiki 1.23 used like 2 seconds to load jquerry. Disabling it in resourceloader.php and instead loading jquerry from google get rid of that 2 seconds. I am so happy now!! This should be in the wiki : )
  3. Hi. I am sorry. I am not sure if I broke Postgres database. I tried to install mediawiki, with InnoDB. Failed for four times, and everytime I deleted the database before I started. It says it can not connect to localhost. I look for InnoDB and stevie in the official wiki. Later, when I search the forum I found that is bad because that would cause problems to stevie's InnoDB. After that, I read an article from digital ocean that says Postgres has ber data integrity than MySQL, but is also slower. I created a postgres database, and then reinstall mediawiki by reuploading and then setup. I also created two users for the database with cPannel and noted that it didn't ask anything about permission of the user. Installing mediawiki with the two users didn't work, probably because of permission problem. It didn't occur to me that I could directly use my root passwolrd to ask the mediawiki install to create lower permission accounts. Then, I downloaded adminer. The 3.x version say my root account needs to have connect permission. I downloaded and uploaded the 4.0 version, set the php file to 640 permission, and then log in with my root account. At the same time, I downloaded the PyGreSQL library for python to my laptop. The python library can connect with my root account to the database that I created in cPannel. Strangely, I don't see the postgres database that I created earlier with cPannel in adminer. I deleted the database and users with cPannel. After that I log into adminer with my root account and without specifying the table name. I see the information schema table, and then created alteilar_wiki table. I tried to create and then add alteilar_postgres user to the alteilar_wiki table, but, adminer says my root account can not grant permission. So, I deleted the user I made, and the alteilar_wiki table. When I log out and then log back in, I noticed that the information schema table disappeared and I see a bunch of table names with username_table format. I click on one of them, but admin says the table doesn't exist. I also noticed that one of the table is called admin. At that point, I log out. When I reload the php installer of mediawiki, it says MysqlUpdater.php has problem at line 249. as in http://code.metager.de/source/history/mediawiki/includes/installer/MysqlUpdater.php I deleted my heliohost account on stevie, and recreated one with the same subdomain, user name, but different password. I am sorry if I broke postgres of stevie.
  4. Hi. InnoDB is not recommended on stevie(http://www.helionet....s-and-problems/) Does this recommendation still stand? May be I should go for postgre for data integrity, dispite it is slower (https://www.digitalo...agement-system). I downloaded adminer (http://downloads.sou...miner-4.1.0.php) with 644 permission. The result is not good. In the end, I deleted and recreated my account.
×
×
  • Create New...