…aspects unique about India
RSS icon Email icon Home icon
    0
    Vote
  • BSNL Broadband Connectivity problem

    Posted on October 9th, 2011 ajadmin No comments

    BSNL Broadband connection keeps going down very often these days. I found out this was happening because the DNS servers were down or not reachable.

    Solution — For people who are well versed with computers, change the DNS for your network adapter (LAN and/or wireless) from “Automatically detect DNS” to “Use this DNS” and provide the IP address as “8.8.8.8″ which is the Google DNS.

    For people who are not computer savvy, do a google search “How to configure my DNS with a custom IP address” and follow the instructions and provide 8.8.8.8 as the DNS IP address

  • 1
    Vote
  • Network signal and GPRS/Edge issues after unlocking IPhone4 with Gevey

    Posted on May 27th, 2011 ajadmin 3 comments

    If you are seeing one or two of the following problems after unlocking your IPhone4, then read on. If you wish to know how to unlock IPhone4 with gevey, then go to the end of this page.

    Issue1: After unlocking, your network always shows a single Network signal bar
    Issue2: Your Edge/GPRS i.e. internet connectivity is not working

    Issue1: After unlocking, your network always shows a single Network signal bar

    You will be able to make calls and the call quality will be good but your network will always show a single signal bar. This happens when you have unlocked your iphone; mine was unlocked with Gevey Sim.

    The solution is to Install UnltrasnOw 1.2.3 and this will solve the problem. You can do this from Cydia. Follow the steps as shown below –

    1. Launch Cydia on your jailbroken iPhone
    2. Tap on the Manage tab followed by a tap on Sources section. Here you will see list of stock and custom Cydia sources
    3. Tap on the Edit button on the top-right followed by a tap on Add button on the top-left. Enter http://repo666.ultrasn0w.com as Cydia/APT URL and hit the Add Source button
    4. Now wait while Cydia updates its sources list. Once done, tap on the Search tab at the bottom and type Ultrasn0w in the search field
    5. Select Ultrasn0w from the search results and hit the Install button on the top-right
    6. Wait while Cydia installs Ultrasn0w 1.2.3 on your iDevice. After installation, tap on the Restart Springboard/Device button to respring/reboot your iPhone (if you reboot, you need to unlock again as per gevey standard instructions)

    See this original article on the steps with screenshots on how to install UltraSn0w

    Issue2: Your Edge/GPRS i.e. internet connectivity is not working

    Once issue1 is solved; if your next issue is not getting Edge or GPRS, then you need to update the APN settings. Do the following —

    1. Connect your iphone to WiFi and open Safari Browser
    2. Go to the website http://www.unlockit.co.nz
    3. On the home page, you will see a Continue button. Click it.
    4. On the next page, it will show some details like APN, username, password. Choose your network. India networks will start with “IN”. Mine was “IN - Airtel”. You should be able to find BSNL, Vodafone etc.
    5. Then click on “Create Profile”
    6. This will create a APN app and click on download or Install
    7. To verify if the APN got successfully installed, go to Settings>General>. You should see something called Profile. If you click that, in the next screen you should see “Verified” in green for APN Carrier Settings
    8. You should now be able to use internet/data based applications

    Also make sure that the following options are enabled in the Settings->General->Network page. Enable 3G, Cellular Data, Data Roaming - all of these should be enabled. Toggle the airplane mode to on & then back to off to reset the network connection. Edge/GPRS should start working now.

    How to unlock IPhone4 bought in the US (or elsewhere) in India?

    There is no software unlock for this as of this date. But you can do hardware based unlock. See following article for step-by-step process –

    http://thetechjournal.com/electronics/iphone/use-gevey-sim-to-unlock-iphone-4-ios-4-3-1-4-3-4-2-1-4-1-without-jailbreaking.xhtml

    Where to buy the Gevey SIM in Bangalore?
    You can buy the Gevey SIM in Bangalore in National Market, near Majestic. Go to shop no. 6. You will see two or three Muslim guys in the shop. They are pretty good. The Gevey SIM should not cost you more than 600 or 700 rupees. If they charge more, then bargain or ask around. Some of them quote 1300 rupees.

  • 2
    Vote
  • Lync Server 2010 Performance Tool

    Posted on March 17th, 2011 Asit No comments

    If you are looking to validate your performance of Lync Server 2010 deployment as per organization level requirement, then you have the good news. Microsoft announced the Releases of Lync Server 2010, Stress and Performance Tool in March 2011 along with Microsoft Lync Server 2010 Capacity Calculator. They have just changed the name of the tool in Lync and OCS R2 it’s known as “Capacity Planning Tool”.

    These tools are available in Microsoft download site along with documentation.

    Here are the links.

    Lync Server 2010, Stress and Performance Tool

    Microsoft Lync Server 2010 Capacity Calculator

  • 1
    Vote
  • Microsoft Released March 2011 Cumulative Update 8 for OCS R2 ( Version 6907.225 )

    Posted on March 17th, 2011 Asit No comments

    Microsoft has not forgotten it’s old product OCS 2007 R2, though Lync Server 2010 adoption is a hot cake. They have Released Cumulative Update 8 for OCS R2 ( Version 6907.225 ) in March 2011.

    Here are the links for this CU8. More details available under respective MS KB article sections.

    Microsoft Office Communications Server 2007 R2 Hotfix KB 968802

    Microsoft Office Communications Server 2007 R2 Group Chat Hotfix KB 2491973

    Microsoft Office Communicator 2007 R2 Hotfix KB 2501722

    Microsoft Office Communications Server 2007 R2 Attendant Hotfix KB 2502321

    Adoption Reporting Tool for Office Communications Server 2007 R2

    Unified Communications Managed API 2.0 Redist (64 Bit) Hotfix KB 2501720

    The following section covers the details regarding the above updates.

    OCS R2 Servers Updates ( CU8 )
    1 OCS2009-DBUpgrade.msi
    2 AcdUcApp.msp
    3 AdminTools.msp
    4 AppServer.msp
    5 AppSharemcu.msp
    6 AVMCU.msp
    7 CAA.msp
    8 CallControlServer.msp
    9 CAS.msp
    10 Cwamain.msp
    11 DataMCU.msp
    12 MediationServer.msp
    13 Monitoringserver.msp
    14 Ocscore.msp
    15 server.msp
    16 UcmaRedist.msp
    17 UcmaWorkflowRedist.msp
    18 WebComponents.msp

    OCS R2 Group Chat Server
    19 MgcAdmin.msp
    20 MgcServer.msp

    OCS R2 Group Chat Compliance Server
    21 MgcAdmin.msp
    22 MgcServer.msp

    Client Updates
    A Microsoft Office Communicator 2007 R2 Hotfix KB 2501722
    B MgcClient.msp

  • 0
    Vote
  • Technology & Vendor considerations for companies on Social Media

    Posted on March 3rd, 2010 ajadmin No comments

    In recent months, there has been an increasing media attention on social networking sites; and how this impacts business, compliance, security and so on. Some staggering statistics (which I reference later in this article) have been thrown in to demonstrate the crazy adoption rates of the social media.

    Social media, it appears, is here to stay and companies are now understanding that it’s not about blocking access now, but realizing that controlling and enabling access is the way forward.. It would sound naive to assume leadership teams in companies haven’t yet begun this process, some still block access, others are engaging with vendors that help manage and control the use of social media, and some are just giving it some more time. So in this post, I don’t focus too much on the statistics or impact of social media but look at the next steps for companies who understand the need to manage social media.

    There are several aspects for CIOs/Head of IT departments to consider while evaluating policies for social media as well as for evaluating solutions to manage social media usage in the network.

    Compliance Considerations

    FINRA in their recent webinar indicated that companies will not be given a compliance grace period because Social Media technology is new and evolving. FINRA has asked companies to not allow usage of Social Media if they cannot supervise it or the social media site does not support archival. Bottom line - Companies must retain, archive and retrieve to be compliant.

    If you are in a regulated industry, such as the financial services sector, you need to consider tools that either allow you to block access to unsanctioned social media and/or invest in a solution that allows you to monitor, archive and review content posted through social media.

    Read the full article here - http://blog.facetime.com/2010/02/social-media-impacts-business.html

  • 17
    Vote
  • OCS Front-End service stopped with service-specific error 3286842403 (0xC3E93C23), due to Windows update KB974571

    Posted on October 15th, 2009 Asit 45 comments

    [Short url for this article - http://doiop.com/ocsFE_issue]

    I am sure you must be facing this issue suddenly in your OCS production environment. This is quite interesting. I’m just sharing my experience. It’s also quite funny that Microsoft releases ‘Security updates’ and ends up bringing down a production server. One of the Windows security update KB974571 has broken OCS R2; that’s why OCS Front-End service Stopped.

    My OCS Server, LiveMeeting; Group Chat environment was working fine until Yesterday. But Today when i have tried to login to OCS, I was not able to login. Then i checked for my OCS Server; found that all of the OCS Services are in started state except OCS Front-End service.
    I tried to restart my OCS FE, but i ended with the following service specific error 3286842403 (0xC3E93C23).

    Log Name: System
    Source: Service Control Manager
    Date: 10/15/2009 11:22:54 AM
    Event ID: 7024
    Task Category: None
    Level: Error
    Keywords: Classic
    User: N/A
    Computer: FTI-360-VM1.ima64.com
    Description:
    The Office Communications Server Front-End service terminated with service-specific error 3286842403 (0xC3E93C23).
    Event Xml:

    7024
    0
    2
    0
    0
    0×80000000000000

    54887

    System
    FTI-360-VM1.ima64.com

    Office Communications Server Front-End
    3286842403 (0xC3E93C23)

    I was just clueless for a moment. I was not ready to accept that something has gone wrong with my OCS Server as nobody has access rights; also it was working fine till late night yesterday. I did not know how to proceed from there for a moment.

    I took a dip breath; then restarted my system. But still the same issue was there.
    Then i started thinking what might went wrong in last 8 hours. Suddenly i thought let me check for updates happened in my system last night.

    Then after half an hour I figure it out, that One of the Windows security update KB974571 has broken OCS R2; that’s why OCS Front-End service Stopped.

    I removed this Windows update & restarted my OCS Front End Service.
    Then it worked fine for me.

    It’s a bug in windows update….. They have managed bring down a critical product service with the release of a windows update.

    This could happen for LCS & OCS R1 deployments also.

    Please also note of another complexity that affects end users -

    Auto-upgrades are enabled on end user desktops as well. Security Update KB974571 will be applied on end user desktops. Hence users will not be able to login to OCS though the FE Server is up, after removing the offending update from the FE Server.

    But the users without this Security update will be able to login to OCS. To address this issue, end users too need to uninstall this update from their desktops. This is applicable for LCS as well.

  • 3
    Vote
  • Unable to upload files in OCS Group Chat

    Posted on July 28th, 2009 Asit 1 comment

    If you are a regular user of OCSR2 Group chat, you will find this ever interesting. Have you ever tried File transfer ( i.e. Upload / Download ) in OCS Chat room?. If you say yes, then you must be facing the issue with file transfer; I am sure you are unable to upload the file. You must be getting either one the following errors during File Upload in OCS Chat room.

    i) A file transfer error occured.Server was unable to process request.—> Object reference not set to an instance of an object.

    ii) A file transfer error occured.System.Web.Services.Protocols.SoapException: Server was unable to process request; System.NullReferenceException: Object reference not set to an instance of an object.
    at Microsoft.Rtc.Chat.MgcCommon.Logging.ParlanoLogger.get_IsInfoEnabled()
    at Microsoft.Rtc.Internal.Chat.Server.MGCWebService.Provider.ConfigureEverytime()
    at Microsoft.Rtc.Internal.Chat.Server.MGCWebService.MGCWebService..ctor()
    —End of inner exception stack trace—

    I would say it’s a MS bug & just ask me why? Here is the answer. I just want to share this, which may helpful for all.

    Case -1

    1.OCS Group Chat Web Service ( i.e. MGCWebService ) is responsible for File Upload & Download.
    2.Go to run & type “inetmgr” in OCS GC machine & you will find this website is running under Local Computer (i.e. AS-64b-VM1) –> Web Sites –> Default Web Site –> MGCWebService.
    3.Right Click on MGCWebService & then go to Properties –> Directory Security –> Authentication and Access Control –> Edit
    4.You will get the user name as “IUSR_MCName” (i.e. IUSR_AS-64B-VM1) & this is member of the Guests group of the local machine.

    Case -2

    1.When we configure OCS Group Chat Web Service we provide a share folder to specify the “Root directory used to store files that are uploaded to any instance of the Web service”.
    2.This shared folder name can be found once we open the GC Server Config Tool à File Repository tab.
    3.Now go to the properties of the File Repository folder (i.e. \\AS-64b-VM1\GCCWebService ) & check for NTFS permissions (Security Tab) of this File Repository folder.
    4.You will find that Guests group is not present in its Access Control List, but the MGCWebService account needs Full Permission (Read / Write) on this File Repository folder, inorder to file upload happens.
    5.Hence you need to choose one domain account that is having Full Permission for this folder. Additionally this account should be member of RTCComponentUniversalServices as the account needs to access the file repository as well as Message Queuing.
    6.You can say OCS GC Channel service account OR OCS Group Chat Admin service account are the right candidate for this are they are natively ready with all these permissions.

    Case -3

    1.Now you need to change the user name from “IUSR_MCName” (i.e. IUSR_AS-64B-VM1) to OCS GC Channel service account ( i.e. 64AS\GCManage ).
    2.Also change the password accordingly w.r.t this new account.
    3.Make sure that Enable Anonymous Access check box is selected under Authentication Methods dialog box.
    4.Now reboot the OCS Group Chat Server
    5.Try file upload after the server is up & ENJOY with File Transfer. Finally you are able to make it work.

  • 0
    Vote
  • New features in OCS 2007 R1

    Posted on June 23rd, 2009 ajadmin No comments

    There are new features added in OCS 2007 R1 apart from LCS 2005 and they are –
    • On-Premise Web Conferencing
    • Enhanced Presence
    • Federation Enhancements
    • Deployment and Administration Improvements
    • On-Premise Web Conferencing

    Office Communications Server 2007 introduces the capability for enterprise users both inside and outside the corporate firewall to create and join real-time Web conferences hosted on internal corporate servers. These “on-premise” conferences, or meetings, can be scheduled or unscheduled, and they can include IM, audio, video, slide presentations, and other forms of data collaboration.

    Multimedia Capabilities:
    OCS 2007 provides rich multimedia capabilities like group IM, audio and video, multiparty audio conferencing. For these it includes 4 servers—
    IM Conferencing Server
    Web Conferencing Server
    A/V Conferencing Server
    Telephony Conferencing Server

    OCS 2007 also includes multimedia conferencing with external users – For this it includes edge servers to be configured in the perimeter network.

    There are 4 main types of multimedia conferencing –
    ? Group IM
    ? Data Collaboration
    ? Audio/Video
    ? PSTN Connectivity

    Group IM
    This refers to IM conversation among 3 or more parties. We can send IM to a group and when replying back the IM will be delivered to that group.
    We can invite other person to IM when the conversation is happening between 2 members.

    Data Collaboration
    OCS 2007 Web Conferencing support a rich mix of data collaboration which includes—
    Power point Support, Application Sharing, Microsoft Office Document Imaging Support, Web Page, multimedia, snapshots etc.

    Audio/Video
    OCS 2007 support multi party audio/video support. Users can specify a/v when scheduling a conversation or to an existing IM conversation.

    PSTN Connectivity
    When a user places a call from an enterprise voice client
    1) Server normalizes the number to E.164 format and invokes routing rules based on the location profile and user policy and directs calls to Mediation Server.
    2) Mediation Server performs any necessary media transcoding and routes call to IP-PSTN gateway.
    3) Gateway, based on topology applies local dialing rules or PBX dialing rules and passes call to the PSTN or PBX.

    For Enterprise Voice, this uses 2 protocols –
    SIP (Session Initiation Protocol) for Signaling and
    RTP (Real Time Protocol) for Voice.

    Enhanced Presence
    This provides infrastructure to enable client application to publish extended presence information. This infrastructure includes Categories and Containers.
    Categories include presence information like status, location and calendar state.
    Containers are logical buckets into which clients publish instances of various categories of presence information.

    Federation Enhancement

    OCS 2007 had made some federation enhancements which include –
    Federated Conferencing – Users in federated domains are considered to be authenticated for the purpose of joining on-premise conference.
    Support for partners with multiple domain name – Enhanced federation now uses SANs (Subject Alternate Names) in certificate to support enterprise with multiple domain names.

    Deployment and Administration Improvements
    OCS 2007 has come up with new set of management tools which made administrative and deployment task simpler.

    Universal Group Support
    OCS 2007 supports the native mode universal groups in the Microsoft Windows Server 2003 and Windows 2000 Server operating systems. Members of universal groups can include other groups and accounts from any domain in the domain tree or forest and can be assigned permissions in any domain in the domain tree or forest. For example, it is no longer necessary to add one domain to another in order to enable an administrator to manage both. Eliminating the domain-add requirement also simplifies deployment.
    Enhanced in-band provisioning
    Office Communications Server 2007 administrators need to be able to customize clients in accordance with the requirements of their particular deployments.
    Office Communications Server 2007 uses in-band provisioning to convey the following categories of information to the client:
    • User Identity includes display name and e-mail address.
    • Server Configuration includes such information as Address Book Service download URLs, group expansion Web Service URLs, console installation URLs, and conference troubleshooting URLs.

    Integrated Address Book Server
    Address Book Server daily provides global user information to Communicator clients. In Live Communications Server 2005 with SP1, Address Book Server was optional and had to be installed separately from the server. But in OCS 2007 Address Book Server is required and which is installed as part of Standard and Enterprise Edition Setup.

    Call Detail Records
    Call Detail Records (CDRs) provide a way to collect both IM and meeting data, and generate reports on usage characteristics, which can be used to determine network bandwidth load, employee usage patters, and return on investment. CDRs capture user logons and logoffs, IM conversations, and conference starts and joins.

    Support for Globally Routable User Agent URI (GRUU)
    OCS 2007 has improved the routing capabilities by introducing support for GRUU technology.
    A GRUU uses the following syntax:
    sip:ted@contoso.com;opaque=epid:qIIWS2j5AVeD_HxnQdxmlwAA;gruu
    The “opaque” parameter makes this URI unique even though the prefix of the URI is still the user address (ted@contoso.com).
    In summary, a GRUU is a URI for a specific device whereas ted@contoso.com is a SIP URI that refers to Ted as a user. The Communicator client running on Ted’s laptop will have its own GRUU that allows other applications to route messages specifically to that device.

    Conference Protocols Used in OCS 2007
    • SIP(Session Initiation Protocol) – This is used for initiating, managing, and terminating sessions between one or more participants.
    • HTTP(HyperText Transfer Protocol) – This use in OCS for communication between the focus and conferencing server, downloading address book server updates to clients, and downloading meeting content to users.
    • CCCP(Centralized Conference Control Protocol) – A custom protocol for communicating conference creation and control commands from clients to OCS 2007.
    • PSOM(Persistent Shared Object Model) – A custom protocol for transporting web conferencing content.
    • SRTP(Secure Real-Time Transport Protocol) – This used for securely transporting audio and video content to various media devices.
    • RTCP(Real-Time Control Protocol) – This used in conjunction with SRTP to convey information about the signal quality of an audio-video conferencing session to various media devices.

    Questions and Answers (FAQ)

    1) When we are done with a IM Conference, where is the History stored ?
    After the IM Conversation, all the conversation details will be there in “Conversation History” Folder in Microsoft Outlook .

    2) When we are doing a Group IM , all the members in the group can receive the message, but can they reply to the same message.
    We can go with the Group IM feature, and when the members in the group will receive the message and when replying for the message it will received by all members in the group.
    3) We can transfer a file to a single person in the conversation but not to a group.
    4) We can have a audio between the 2 members and in a conversation.
    5) In OCS 2007 , Presence Information is—
    Status, Location, Calendar date, Display Names, Title, mobile phone, home phone, company, meeting location, meeting subject etc.
    6) PSTN Connectivity –
    In LCS 2005 Front-End Server will connect to CTI(Computer Telephony Interface) and then to PBX to PSTN-gateway and to phone.
    In OCS 2007, Mediation server has been introduced. From here it connects to IP-PSTN gateway and there to PSTN to Phone.
    Signaling for phone calls coming from the PSTN is converted to SIP by the Media(IP-PSTN) gateway

  • 0
    Vote
  • Useful resources, plugins, modules for Joomla, WordPress, websites

    Posted on April 21st, 2009 ajadmin No comments



    Golumolu’s recommendations for resources, plugins and other solutions to common tasks/issues that one may encounter while designing web content. Most of these are related to Joomla and WordPress

    Description of Task/Issue Solution / Web resource
    Move Joomla from the sub directory in the web server to the root. For e.g. http://domain/joomla to be moved to http://domain http://kb.siteground.com/article/How_to_move_Joomla_to_another_directory.html
    Want to track web site hits, hit counter, entry/exit pages, tracking search engine phrases

    http://www.statcounter.com

    http://www.google.com/analytics

    Online XML Sitemap generator to submit to Google http://www.xml-sitemaps.com/details-golumolu.in.html
    How to place ads on WordPress Blog Sidebar http://247-coach.com/create-add-ads-wordpress-blog-sidebar/
    How to embed an RSS feed into an article in Joomla http://www.howtojoomla.net/20090228104/how-tos/mambots/plugins/how-to-embed-an-rss-feed-into-an-article-in-joomla
    Create a favicon for your website

    http://www.html-kit.com/favicon/

    How to not count your own hits to website by your tracking tools like Google Analytics http://www.epikone.com/blog/2006/07/11/count-me-out/
    How to add Google Analytics to Joomla http://www.goodwebpractices.com/joomla/add-google-analytics-to-joomla.html
    EULA,License Analyzer http://www.spywareguide.com/analyze/analyzer.php
    yvComment - Commenting solution for Joomla! 1.5 http://yurivolkov.com/Joomla/yvComment/index_en.html#InstallyvComment
    How to take WordPress Backups http://codex.wordpress.org/WordPress_Backups
    Custom Home page design for WordPress

    http://robmalon.com/wordpress-custom-home-page-design-widgetized-front-page/

    http://www.wordpressmax.com/customize-wordpress/custom-page

    http://thedesigned.com/2008/05/08/make-a-custom-wordpress-front-page/

    How to enable Web page compression using GZip? http://www.gidnetwork.com/tools/gzip-test.php
    Web Page Analyzer - free website optimization tool, website speed test, performance report http://www.websiteoptimization.com/services/analyze/
    Website Speed Test Tool http://www.joomlaspan.com/webtools/website-speed-test-tool.php
    Manage Ads on WordPress Website, from John Kolbert http://www.johnkolbert.com/portfolio/wp-plugins/smart-ads/
    Colour Scheme Chooser Tool http://websitetips.com/colortools/sitepro/


  • 0
    Vote
  • Tips for speeding up your Joomla website

    Posted on March 31st, 2009 ajadmin No comments

    So your Joomla website, the front page, especially has slowed down. Dont worry. I am sure there are many who are in the same boat where the website response time has exceeded 10 seconds, which is the upper tolerable limit for website response times.

    1. Template Optimization

    One of the most common problems that is seen with Joomla - there exist literally thousands of templates made specifically for Joomla, and most of them look quite nice, but most have some severe performance issues. The problem is that some of the templates out there use upwards of 70 separate images to display the page. Each image generates a new request and has to be downloaded. The problem is compounded when the images are not as small, and when they are not optimized. The following site will help you determine what template optimizations need to be done. Make sure to run your site through it after ever major change to measure the performance of the website -
    http://www.websiteoptimization.com/services/analyze/index.html

    2. Enable Joomla Cache
    You can enable caching from your Joomla admin area > Site > Global Configuration > System.

    At the right side of the System page, under Cache Settings, next to Cache you should select Yes. Then click Save at the top right menu to enable caching for your Joomla

    3. Disable all unwanted statistics counters.
    Use GoogleAnalytics to track users. Avoid going in for 3rd party counters that are indicated as free but can slow done your site as they are basically small programs to collect more data from your website.

    4. Remove modules, components that are no longer used.
    Remove even if they are in “not published” state. If you look through the Joomla Extension directory, you’ll find a component to do everything you could want. The problem is that some of these components are REALLY inefficient and end up slowing your site down dramatically.

    5. Enable GZip compression for HTML

    The gZIP compression of your files improves the performance of your website and highly decreases its loading time. For complex websites it is highly recommended to enable it.

    For example, in Joomla you can turn on the gZIP compression from Global Configuration > Server > gZIP Page Compression set to ON.

    You can test whether the compression is working by using this useful tool - http://www.gidnetwork.com/tools/gzip-test.php

    6. Check the number of images, objects on your website.

    This is a useful website that provides insight into the number of images, objects on your site. Too many images, objects, bigger page sizes can slow down your site.
    http://www.joomlaspan.com/webtools/website-speed-test-tool.php

    7. Optimize MySQL tables from the backend.

    1. Login to your Joomla’s mySQL database via phpMyAdmin
    2. Display the tables and then scroll down to the session table.
    3. Check the check box next to the table (session table or any tables having overhead values) and select the Optimize option from the drop down select list.