Friday, January 3, 2025

Disable Update popup in Firefox...

TO STOP FIREFOX updating to latest versions and keep the old version (some like to keep a particular old version and not interested in newer versions) without messy popups - following works in most versions... Create a policies.json file and store that file into the ‘C:\Program Files\Mozilla Firefox\distribution’ folder. Create a ‘distribution’ folder in \Program Files\Mozilla Firefox\ folder if it is not there and place the following policies.json file into that folder Save policies.json file with the following { "policies": { "DisableAppUpdate": true } }

Excel 2007 too slow in advanced use...?

Office 2000 Excel (12.0.4518.1014) in Win 7 ultimate (Ver 6.1.1601 Service Pack 1) too slow in a file Check if there are any formulas like =Sum(IF($F:$F=val,$O:$O,0)) in cells! Excell stupidly goes through 1231313131 cells! Give a resonable range and you can see excel flies...

Tuesday, April 14, 2015

MySQL 5.6: Beware of Changing page_size

In MySQL 5.6 (mysqld  Ver 5.6.19 for Win64 on x86_64 (MySQL Community Server (GPL))), if for some reason there is a need to change the page size using
innodb_page_size
in the config file (my.ini or my.cnf) it is better to give attention to the following points:

Scenario:
  • Assume there are DBs already created and running with a different page size.
  • Changing the page size in my.ini and restarting usually works fine for InnoDB (well as far as I have checked, which is kind of minimal)
  • But assume that there happened to be a crash, like the computer shut down without bringing down the MySQL
  • On restart, MySQL will attempt a recovery since the entry numbers in the log file and .idb files may not match.

In this scenario, a changed page size causes a problem and MySQL 5.6 InnoDB is unable to recover (even when there is nothing to recover) the .idb's with the old page size. The server simply will not start and the user log file given under
log-output=FILE
general-log=0
general_log_file="xxx.log"

will have various options (just as restoring from backup, deleting the .idb, etc., etc.) and none of it works. Changing the page size back will have problems with the newly created DBs that has a different (new) page size.

In my case it was an experimental scenario with only dummy data and the schema was in the model, so I can delete all the new .idb's and recover. But situation would have been bad if the tables had been populated with data, as there was no indications that things might go wrong - which it doesn't till there is a crash...!

And if there is a need to know (Obsessive-Compulsive Disorder - OCD) why the page size was changed in the first place from default 16k to 4k - it was done in an attempt to align InnoDB's IO with the computer's OS/Disk characteristics for an optimal performance.

Monday, December 8, 2014

Win 7 USB Tethering and increasing Network number

When a laptop running Win 7 is connected to a net through an Android (my version is 4.6) phone using USB tethering using the normal software available within windows (no third party software), the network number keeps increasing each time the phone is tethered. It will also ask for the network group (like home, work, etc.) each time. None of the gimmicks suggested throughout the net seems to work. The actual problem may be that USB connects expects some unique serial number for the device connecting and during tethering somehow it is either over looked or is non existent and hence the win 7 OS thinks it is a new device and a new connection.

If not solving the problem, I just wanted to delete the old network configs and if possible to merge them into a single config (I suspected that in the long run it might create problems as I was already running on two digit number for the network number).

I found the best answer at http://answers.microsoft.com/en-us/windows/forum/windows_7-networking/how-do-i-delete-or-clear-redundant-network/07834191-708d-45f9-9ef2-e779dd930ce3

If you click on the ControlPanel->Network and Sharing Center->"View your active networks: The connect icon on the left (I still have the house icon)", you get a modal window with a editable network name showing the current name (like "Network 16"). But at the bottom you find a link "Merge or Delete Locations" clicking on which you get a new modal with all the network configs listed!!! You can now merge or delete the unwanted ones.

Note that it does not solve the problem of getting a new name each time you connect, but at least to prevent any further problems because of this behavior. If there is a way to stop this, that would rather be excellent...!

Thursday, October 30, 2014

Win 7 - Opening Excel Files in Seperate Windows: Other things to note

When the last excel instance that is closed had the 'Ignore other DDE application' checkbox set, then after closing it attempting to open any excel file from the browser will give a message saying that "There was a problem sending the command to the problem", even though the instance opens blank.

The immediate solution is in the blank instance use the 'open' command to open the new excel file (well not much of a problem as there is list of last opened excel files - clicking that will do). You may also notice that the 'Ignore other DDE applications' is still set in the opened instance.

So it throws light on point (2) of the last post. Excel remembers the setting of the last closed instance! Going by the kind of logic I usually follow in my code this should happen if there is no default setting - so where is it?

Wednesday, October 29, 2014

Win 7 - Opening Excel Files in new Window

What I posted earlier was not correct. Here is the new and correct one...

The age old Excel (Lotus123) has a problem with the new OS (es). An Excel file is being edited and there is a need to open another excel file for reference - bang! Excel opens this file also in the same window as the first one. I searched about in net, where they have too many good ways to solve this including tampering the registry entries.

As as old timer, I would like a simple solution. The point of actual fix seems to be to make Excel ignore other DDE applications (this does have a ton of other draw backs one of which is listed below).  This could be done through checking the Excel->options->Advanced-> Ignore other DDE applications check box in the already open excel file.

Now an attempt to open another excel file from the browser, either by directly double clicking it or by right click and using the 'open with' in the context menu, the new file will be opened in a new window. There are three points to note:
1) All the current running instance should have the 'Ignore other DDE applications' set. Otherwise the new open attempt will open the file in the same window where this option is not set along with whatever that is already open there.
2) The default behavior is for Excel to open with the 'Ignore other DDE applications' not set. This could only be changed through the registry and this is bound to cause a lot of problems if not done correctly
3) Hence after immediately opening the new file, the 'Ignore other DDE applications' for that instance too needs to be set. Otherwise another new file open attempt will open the next file in that last window along with whatever that is already opened there...

Another problem is that if the first file refers to the second one (such as aggregates of some range in the second file), then with two files open, and if the values in the second file are changed (and saved too), the first file's cell will not get automatically updated as Excel has no way of knowing that the value has changed in the other file (separate processes). This will not happen if they are opened under the same window (same process). There is a need to manually update the first file (like using 'update' in 'edit link').

If you are wondering what is great about it, ask those guys who have to work with many excel files that are linked and they need to see more than one file at the same time and add to it that they have multiple monitors! The pain of the files opening in the same window is really bad in those cases. I do not know why MS Excel cannot offer a simple dialog on opening a file asking whether to open it in a separate window (process), of course warning the user of the limitations and consequences.

Saturday, August 2, 2014

Eclipse Kepler - Excluding/Including Project in the 'Project Explorer' list

In Eclipse Kepler (service release 2) the project explorer usually shows all the projects in the workspace folder.

There are times when some projects are created that are currently not needed to be shown/listed in the project explorer but these may be required later and hence must remain intact in the file system - there must also be a way to re-list the project in the project workspace in future.

Note that
1. the concerned project exists in the same workspace
2. This is not about 'opening and closing' as the list still shows the projects (both closed and opened). What we want is to remove the project from the list shown.

One way is to use 'Remove' in the context menu (right click on the project that needs to be removed) and on the dialogue that opens select options to leave the project intact in the file system. This does the job of making the project disappear from the project explorer with the project itself remaining intact in the file system.

To re-include it in the workspace seemed like a problem as the use of 'import' would say that the project already exists in the workspace (remember the project removed is in the same workspace) and the on opening the workspace root directory in the import projects the projects are listed with check boxes but the lines are greyed (usually implying non-selectable, non-actionable) and the 'Finish' button is disabled. There is a warning message on the top of the dialogue that says 'some projects cannot be imported because they already exists in the workspace'.

But, what-ho! Click (left-click) the line under the projects on the removed project and it comes alive!!! Like it becomes actionable and un-greyed and the 'Finish' button is enabled. The same does not happen for projects that are already visible in the project explorer. Now select the check box on the un-greyed project of ours, un-check the 'copy project into workspace' and click 'Finish' to include the project in the project explorer list.

This looks not to be documented as per the searches made in local help, eclipse site and in Google (or maybe I am using the wrong key words)