MySQL: Count occurrences of distinct values in a column
What i want to do is : example db id name —– —— 1 Mark 2 Mike 3 Paul 4
Read moreAuthor: eduguru
SMS Marketing : Best and Cheapest SMS for business
eduguru 8 Comments ... Bulk SMS Services in Delhi, 00, 000 results (0.55 seconds) Why these ads? Send BulkSMS Online@7p - BhashSMS.com Adwww.bhashsms.com/SMS 095 43 927979 Easy & Quick Set Up, 2010 - TimesSMS.com is a leading provider of Bulk SMS services & Marketing SMS services in India. TimesSMS.com has been providing SMS based ... Bulk SMS - Bulk SMS Service - Bulk SMS Provider ... , 9670981038 Search Results Bulk Sms Mantra | Free Excel SMS software | Bulk SMS ... www.bulksmsmantra.com/ Bulk SMS is nothing but a tool or service through which you can market your product and servic, Addresses, API, API code Free Demo Call:09030120727 BulkSMS@7Paisa Per SMS - eddaonline.com Adfastsms.eddaonline.com/ Sender ID, Bangalore and other ... Bulk SMS Solutions - Nimbus IT Solutions www.nimbusitsolutions.com/bulk-sms-solutions-delhi.html Nimbus IT Solutions is a leader in bulk sms and short code service in India. We, Best Deals, bulk sms provider, bulk sms provider in delhi, bulk sms service, bulk sms service ... Price - Software - Transaction SMS Prices - Login Bulk SMS Solutions - Airtel www.airtel.in/aes/Global+Business/Global.../Bulk+SMS+Solutions Our Bulk SMS service is the ideal , Bulk SMS service provider ... www.bulksmsadvertising.in/ Bulk Sms Advertising Service Provider in delhi/NCR and everywhere in India by CB InfoTech.Mass sms advertising services are at affordable cost , Bulk SMS Softwares, Call 09837266488 See your ad here » Pul Prahlad Pur, call:09000937601 www.cheapsms.net/ Promotional sms with sender id Transactional sms, click here to turn off Google Instant. WebMapsImagesVideosNewsMoreSearch tools About 85, Delhi - From your phone (Location History) - Use precise location - Learn more Help Send feedback Privacy & Terms, DND Open, dynamic BulkSMS Service Provider www.bulksmsindia.mobi/ Transactional & Promotional SMS Call 9958891277 or 01203829704 Buy 2000 Sms Rs. 500/- online-bulksms.com/Call+9455146254 Promote Your Bu, employees or channel members. Bulk SMS services, excel, for e.g. customers, Free Trial. Call Us 1 Lakh SMS Rs.7000/- - redsms.in Adwww.redsms.in/ 100% Delivery & Speed Delivery, Gurgaon, High Speed Delivery. 1000+ clients. Free Demo! International SMS Service www.infobip.com/ Add SMS to your business, India | Justdial www.justdial.com/Delhi/Bulk-SMS-Services/ct-530963 Bulk SMS Services in Delhi Phone Numbers, Instant credits and fast delivery B2B Bulk SMS Service www.mvaayoo.com/Group_SMS_Solution Excel Sheet Upload, Latest Reviews & Ratings. Visit Justdial for Bulk SMS Services Delhi and more. Searches related to bulk sms service bulk sms free 160by2 way2sms google bulk sms service airtel bulk sms service bul, Low Price 100% Delivery, messaging as a service are designed for ease of ... Bulk SMS | Premium Bulk SMS Gateway | Bulk SMS ... www.smscountry.com/ Do Bulk SMS Campaign in India, Mumbai, New Delhi, Noida, Our feature : Competitive Price Best in Support Best delivered route Start with in minute API Customized service that suites to business Free consultation Contact us For more details : info@eduguru.in, Our SMS gateway provides SMS Excel Plugin, Ph:8052488884, PromotionalSMS Free10%SMS, reliable Bulk SMS services and can customise messaging for specific language groups. VISIT HERE to get to know ... Bulk SMS Advertising in India, Screen-reader users, SMS Marketing : Best and Cheapest SMS for business, SMS services for marketing www.tatadocomo.com/corporates/messaging-solutions.aspx Get the best SMS services for your business from Tata Docomo. Services like Bulk SMS, SMS Tools & APIs, system or application. Global reach. Sign up! Send 5 Bulk SMS in Rs.1 www.experttexting.com/ Free SMS API & Account Area Best SMS Gateway for SMS Marketing SMS @6 p, Voice Broadcasting, Web based SMS Services in India and ... Bulk SMS | Bulk SMS Services Free bulk sms software sw ... timessms.com/ May 12
Our feature : Competitive Price Best in Support Best delivered route Start with in minute API Customized service that suites to
Read moreGet a free domain
eduguru 1 Comment book your domain free, domain free, free domain at inet expert technology, Free domain registration, Get a free domain, Get a free domain with webhosting, how to get free domain
Get a free domain with every hosting of 999/- year Contact Us for more info: info@eduguru.in
Read morehttp://www.msftncsi.com/ncsi.txt
eduguru 0 Comments etc. If it determines successfully that there is network connectivity you’ll see on your network card status indications if there is IPv4 Connectivity and IPv6 Connectivity: In my case, http://www.msftncsi.com/ncsi.txt, I have only IPv4 Connectivity as my Internet Service Provider (ISP) does not support IPv6 yet. Below are a few details of the URLs that are used. As you might imagine there is an ipv6 and an ipv4 addr, router, What is www.msftncsi.com? If you are running a firewall one of the most common sites you’ll run across is www.mstfncsi.com. This is because the url www.msftncsi.com is generally used by Windows machin, Windows 7 and even Windows Vista I believe) will try to get a file from a web server to determine if there is network connectivity. There are two tests that a Microsoft Windows Client will perform to
What is www.msftncsi.com ? If you are running a firewall one of the most common sites you’ll run across is
Read moreJoining to different databases table
SELECT <…> FROM A.table1 t1 JOIN B.table2 t2 ON t2.column2 = t1.column1;
Read more
TOP command in Linux
eduguru 0 Comments "(getty)")."A, 0.07) the 3 values refer to the last minute, 0.12, 1:25) users sessions logged in (3 users) average load on the system (load average: 0.02, 4%id) Percentage of the CPU processes waiting for I/O operations(0.0%wa) Percentage of the CPU serving hardware interrupts (0.3% hi — Hardware IRQ Percentage of the CPU serving software interrupts (0., 5 and 15 minutes. This line is just like the output of uptime(1). The uptime display may be toggled by the interactive l command.processesThe total number of processes running at the time of the last , a negative value can be entered, and can provide an interactive interface for manipulating processes. It can sort the tasks by CPU usage, and greatly raise the load. This command is not available in secure mode.f or FAdd fields to display or remove fields from the display. See below for more information.o or OChange order of displayed f, and lose priority. If root is running top, and memory used for buffers. The display of memory information may be toggled by the m interactive command.SwapStatistics on swap space, and the signal to send to it. For a normal kill, and the status of secure and cumulative modes.kKill a process. You will be prompted for the PID of the task, and the three load averages for the system. The load averages are the average number of process ready to run during the last 1, and the value to nice it to. Entering a positve value will cause a process to be niced to negative values, and used swap space. This and Mem are just like the output of free(1).PIDThe process ID of each task.PPIDThe parent process ID each task.UIDThe user ID of the task's owner.USERThe user name of the tas, as with kill(1), available swap space, between updates. Fractional values are recognized down to microseconds. Entering 0 causes continuous updates. The default value is 5 seconds. Note that low values cause nearly unreadably fast displays, buffers cached. On this topic you can also read the following article Following Rows — Processes list top command last row And as last thing ordered by CPU usage (as default) there are the processes c, but rather abrupt, but swapped-out tasks will only have the name of the program in parentheses (for example, but you can change that with the d command-line option or the sinteractive command."uptime"This line displays the time the system has been up, causing a process to get a higher than normal priority. The default renice value is 10. This command is not available in secure mode.SThis toggles cumulative mode, D for uninterruptible sleep, expressed as a percentage of total CPU time per processor.%MEMThe task's share of the physical memory.COMMANDThe task's command name, five minutes and 15 minutes. 2° Row – task top command 2 row The second row gives the following information: Processes running in totals (73 total) Processes running (2 running) Processes sleeping (71, for a.out processes not.SHAREThe amount of shared memory used by the task is shown in this column.STATThe state of the task is shown here. The state is either S for sleeping, free, free memory, however, i.e., in kilobytes, in seconds, including total available memory, including total swap space, iowait and idle. (Niced tasks are only those whose nice value is positive.) Time spent in niced tasks will also be counted in system and user time, is 15, is shown here. For ELF processes used library pages are counted here, is shown here.TSIZEThe code size of the task. This gives strange values for kernel processes and is broken for ELF processes.DSIZEData + Stack size. This is broken for ELF processes.TRSText resident s, it will be easier to understand the reason of excessive load and/or the slowing of the system., it will be easier to understand the reason of excessive load and/or the slowing of the system. TOP Command Options -d Specifies the delay between screen updates. You can change this with the S interac, kill, memory usage and runtime. can be better configured than the standard top from the procps suite. Most features can either be selected by an interactive command or by specifying the feature in the perso, N for a process with positive nice value, niced tasks, normal mode will make them appear less demanding than they actually are. For others, or T for stopped or traced. These states are modified by trailing < for a process with negative nice value, or undead. The processes and states display may be toggled by the t interactive command."CPU states"Shows the percentage of CPU time in user mode, R for running, send signal 15. For a sure, send signal 9. The default signal, shared memory, SIGTERM. This command is not available in secure mode.iIgnore idle and zombie processes. This is a toggle switch.IToggle between Solaris (CPU percentage divided by total number of CPUs) and Irix (CPU , sleeping, so the total will be more than 100%. The processes and states display may be toggled by the t interactive command.MemStatistics on memory usage, stopped, such as compilers, such as shells and init, system mode, that CPU times will include a process's defunct children. For some programs, the equivalent of ps -S, then top will show as many processes as will fit on the screen; this is the default.qQuit.rRe-nice a process. You will be prompted for the PID of the task, this also includes the CPU time used by the process's children which have died. You can set cumulative mode with the S command line option or toggle it with the interactive command S. The header line , this behavior is correct. In any case, TOP command in Linux, top provides an ongoing look at processor activity in real time. It displays a listing of the most CPU-intensive tasks on the system, top runs with the highest possible priority. -S Specifies cumulative mode, top will not accept command line input. It runs until it produces the number of iterations requested with the n option or until killed. Output is plain text suitable for display on a dumb terminal. FI, try cumulative mode for an alternative view of CPU use.sChange the delay between updates. You will be prompted to enter the delay time, used memory, W for a swapped out process (this does not work correctly for kernel processes).WCHANdepending on the availability of either /boot/psdatabase or the kernel link map/boot/System.map this shows the addr, where each process is listed with the CPU time that it as well as its dead children has spent. This is like the -S flag to ps(1). See the discussion below of the S interactive command.-sTells top to r, which is based on window size measurement. If 0 is specified, which will be truncated if it is too long to be displayed on one line. Tasks in memory will have a full command line, which work by forking into many separate tasks, WP"these fields from the kmem top are not supported. INTERACTIVE COMMANDS Several single-key commands are recognized while top is running. Some are disabled if the soption has been given on the comman, Z for zombies
top provides an ongoing look at processor activity in real time. It displays a listing of the most CPU-intensive tasks on
Read moreHow to I disable echo cancellation module without removing the hardware?
eduguru 0 Comments disable echo cancellation without removing the hardware?, How do I disable echo cancellation module without removing the hardware?, How I disable echo cancellation module without removing the hardware?, How to I disable echo cancellation module without removing the hardware?
You’ll need to: Stop Asterisk Stop DAHDI Unload the driver for your card from the Linux kernel Load the driver
Read morefind the number of CPU cores on Linux
eduguru AMD Phenom II X6). Also, and hexa-core processors (e.g., and thus the total processor count seen by Linux is 16 (= 2 x 4 x 2)., find the number of CPU cores on Linux, How to find the number of CPU cores on Linux, including dual-core processors (e.g., Intel Core Duo), Intel Core i5), many server-grade physical machines are equipped with more than one CPU processor. To find the number of physical CPUs: $ cat /proc/cpuinfo | grep "^physical id" | sort | uniq | wc -l 2 To find the nu, Multi-core CPU processors are common nowadays, number of CPU cores on Linux, quad-core processors (e.g.
Multi-core CPU processors are common nowadays, including dual-core processors (e.g., Intel Core Duo), quad-core processors (e.g., Intel Core i5), and
Read more
MYSQL Partitioning : What is and HOW To ?
eduguru 3 Comments fname VARCHAR(30), hired DATE NOT NULL DEFAULT '1970-01-01', How to mysql partition, job_code INT, learn mysql, lname VARCHAR(30), MySQL, mysql partition, MYSQL Partitioning : What is and HOW To ?, PARTITION p1 VALUES LESS THAN (1996), PARTITION p2 VALUES LESS THAN (2001), PARTITION p3 VALUES LESS THAN MAXVALUE ); This allows to speed up e.g.: Dropping old data by simple: ALTER TABLE employees DROP PARTITION p0; Database can speed up a query like this: SELECT COUNT(*) F, separated DATE NOT NULL DEFAULT '9999-12-31', store_id INT ) PARTITION BY RANGE ( YEAR(separated) ) ( PARTITION p0 VALUES LESS THAN (1991), The idea behind partitioning isn't to use multiple servers but to use multiple tables instead of one table. You can divide a table into many tables so that you can have old data in one sub table and n, What is mysql partition, you define how the data is partitioned. Simple example from the MySQL Documentation: CREATE TABLE employees ( id INT NOT NULL
The idea behind partitioning isn’t to use multiple servers but to use multiple tables instead of one table. You can
Read more