MySQL Anyway To Log Queries Of Specific User
I know about the general log but want to just log queries of a specific user. Our database does 400 queries/s on a slow day, so I think it would be a pain to grep though a huge log like that. And, im not sure if it would cause any preformance issues.
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Limiting Ssh User To Specific Folder
I may have this wrong, but I think it's possible. I have a friend who wants to run a process on one of my servers, now I don't particularly 'care' about this server, it's just used for a couple of unimportant things so I'm okay with him running it, but I don't want the hassle of sorting out things if he decides to delete everything, so I'm hoping it's possible to limit his directory. For example, I have the folder "people" in the top most directory, inside that I have "arthur", I want to limit the ssh user "arthur" to the folder "arthur", I don't want him to be able to cd ../../ and delete stuff, is this possible?
View Replies!
View Related
Mysql Slow Queries
I added the following to my.cnf and restarted mysql log_slow_queries=/var/log/mysql/mysql_slow-queries.log I saw at leat 53 slow queries, however, there is no such file in that folder.
View Replies!
View Related
[MySQL] Too Many Connections: Locked Queries
This has happened twice now. I have my wait_timeout variable set to 60 seconds, but occasionally my database gets overloaded with "locked" queries. Here's an example of my processlist: Code: | 14773848 | db_name | localhost | db_name | Query | 35483 | statistics | SELECT COUNT... | | 14776290 | db_name | localhost | db_name | Query | 35144 | statistics | SELECT COUNT... | | 14778877 | db_name | localhost | db_name | Query | 34841 | statistics | SELECT COUNT... | | 14790744 | db_name | localhost | db_name | Query | 33056 | Locked | UPDATE... | | 14791275 | db_name | localhost | db_name | Query | 32977 | Locked | SELECT... | | 14791395 | db_name | localhost | db_name | Query | 32960 | Locked | SELECT... | | 14791556 | db_name | localhost | db_name | Query | 32929 | Locked | SELECT... | | 14791603 | db_name | localhost | db_name | Query | 32924 | Locked | SELECT... | | 14791757 | db_name | localhost | db_name | Query | 32900 | Locked | SELECT... | | 14792209 | db_name | localhost | db_name | Query | 32815 | Locked | SELECT... | | 14792355 | db_name | localhost | db_name | Query | 32786 | Locked | SELECT... | This continues on with locked queries all the way up to my limit of 450 connections, then the whole server goes down. Note the time spent processing these queries, 35483 seconds and counting! Surely the wait_timeout is supposed to prevent this from happening?! Also, this appears to start with queries in the State "statistics". Then the State for the following queries becomes "locked". Does anyone know what these mean? Can I get them to timeout normally? Queries which never timeout are guaranteed to bring your server down eventually, surely this is not the desired behaviour.
View Replies!
View Related
No Clue: Automatic MySQL Queries
I've been pondering something for a long time here, but never really knew the right question to ask, or how to word it... so I never even know what to search for. So I honestly have no idea what I'm asking or if this is even under the right topic. What I'm looking for is answers, links, tutorials, or just some words I can search for to help me do the following: I have a MySQL database filled with accounts. People have to pay to get these accounts. All the accounts are set to expire on different days. I need to send an e-mail out to accounts, for example, to let them know they're expiring, say, a month before this will occur. Right now the only way I know to do this is to have MySQL queries on a PHP page that, every time the page is loaded, runs through all the accounts, checks their expirations, and sends emails to those that need it. I know there has to be a way to have this happen automatically without having to load a PHP page every day, for example.
View Replies!
View Related
Upto 150 MySQL Queries A Second
I'm currently hosting all of my stuff with my own Wild West Reselling Account, i.e., InnoDomains.com. Problem is I'm running multiple Wordpress Installations and a few websites that have some pretty intense MySQL work going on in the background, and I use about 250GB per month in bandwidth. My Account gets the 503 downtime errors because according to Customer Service I cannot run more than 50 MySQL queries in one second. Well, that's not much of a challenge because a lengthy wordpress page runs about 90 queries and loads in 2-3 seconds. Time this by three including the other websites and a couple of shopping stores, and I'm easily doing more than 100-150 queries a second more than several times a day, thereby seeing that nasty, irritating error. My other option is to split up all the websites over basic $ 3.95 per month accounts. I don't want to switch to a dedicated server yet because I'm not really making a whole lot of money (about $ 30 per month). Another thing I could do is move my MySQL testing to a local machine, and that may actually reduce the load on the damn server. Are there any hosts out there that will allow me to do more than 100 MySQL queries per second? If so, are there any that are any good?
View Replies!
View Related
Optimizing These Particular MySQL Slow Queries In WordPress
What I did here was create /var/log/mysqld.slow.log for queries that are taking one second or longer. After around 36 hours, here is what I came up with. Since the file size of /var/log/mysqld.slow.log was 219KB, posting it in its entirety it not practical. Therefore, I used a program, the perl script known as mysql_slow_log_parser found on www.retards.org, to parse the mysqld.slow.log to make it easier to interpret and read. The result was that the original filesize of 219KB was converted to the smaller size of 14KB....
View Replies!
View Related
MySQL Replication Setup With 150 Queries/sec -> Major Lag
I have fairly a large web site that has a forum and a torrent tracker. Currently MySQL server is handling about 150 queries an avarage per second. Here is the server spec: Core2Duo 2.66Ghz 4Gb RAM 320GB SATA 7200RPM (Server provider does not have 1.5K RPM nor 1.0k RPM) 100Mbit Connection (servers on the same switch and the switch does not have 1Gbit port) MySQL Version: 5.0.51a I had Master-Master Replication setup with forum running on one and the tracker running on the other. Although this has been working for about few days, we started seeing lags in the replication process. After a week, there is a major lag and the changes made on one of the servers takes about 5 hours to appear on the another. So, this doesn't work. What would be the other ways of splitting MySQL queries concerning the same database? While I was researching, I read about MySQL Cluster with database storage engine being NDB. But, let's say that there is a power failure on both the nodes at the same time, then I would lose the whole database as the database is stored on the memory correct? I would not like to take that chance either, but if this is faster then replication method then maybe I will concider. I thought about editing the forum coding to make all queries that concerns the tracker to go in to, say server B (with forum's primary MySQL server being Server A), and make the tracker use server B as MySQL backend, but it seemed like a heavy work so that will be the last choice.
View Replies!
View Related
Recommend A UK LAMP Host - With Some Specific Mysql Privilege Requirements
I have a moderately successful site, which makes enough money to cover my current hosting costs of 7 per month. I know, millionaire row it ain't, but it's popular. But my database is getting big and my current host wont allow the user of EXECUTE and SUPER privileges which I need to run triggers and stored procedures to keep the page load times sensible. So, I need another UK host with: - 2Gb of space (the site serves up big PDF documents) - 70Gb of bandwidth (I said they were big) - mysql privs available as above Customer service with my current host, uk web solutions, is great (apart from refusal to countenance the privileges) so I need my new host to be as good. Budget? well, you can see what I'm paying now, and I have a psychological £10/month barrier which I don't want to cross.
View Replies!
View Related
VPS Incredibly Slow, Huge Numbers Of Slow MySQL Queries For Plesk/Watchdog
I've got 25 domains on a Virtuozzo/Plesk8.6/CentOS5 VPS. Each domain has one up-to-date install of WordPress, most have very little traffic (average 200mb per month), maybe 2 domains get 5-7gb traffic per month. I monitor port 80 connections and rarely see more than 10 at a time. That should in my opinion be no problem at all for a VPS with 768mb guaranteed ram and 2.4ghz cpu. I've got 30gb hard drive spare too. But.... about 8 or 10 times a day it grinds to a complete halt: server load at 500-1000%, sites timing out, plesk takes 3mins to load, often I can't even connect with SSH, and the plesk web server, apache INSERT INTO module_watchdog_sys_stat (time, type, value, service_id) VALUES(FROM_UNIXTIME(1226404705), 'MAINMEM_USAGE', 17472, 11); 80 seconds sounds like a huge amount of time for a MySQL insert to me! Does anyone know if this is likely to be the cause of my trouble? Some problem with Plesk and the database? Or could it be something else?
View Replies!
View Related
/var/log/mysql - Can I Delete It
Question: Is it safe to delete the files in /var/log/mysql ? Also, is there some way I can disable logging so that this folder does not get filled up again? Explanation: Last night I started running a Perl script to process the data contained in some files, and then do a series of INSERTs to put them in a MySQL database. When I checked on it this morning, I found that it was very close to being done, but had locked up. I had trouble doing anything at all, actually, until I realized that 100% of the disk space on my hard drive had now been used. I went to investigate, and I quickly realized that my /var/log/mysql folder was over 120GB! My intuition tells me that this folder is just used to store logs of what MySQL is doing. However, I have no need for these logs, and seeing as they are (unnecessarily) using over 120GB of my hard drive space, I would like to delete everything in that folder. But I'm still fairly new to Linux, and I'm not sure if this is safe. Can I just delete these files? And also, to prevent this from happening again, is there some way I can disable MySQL from creating such enormous log files?
View Replies!
View Related
Log All Mysql+php Errors
I'm running an IPB 2.2.1 Forum on a VDS, 512 RAM, DEBIAN SARGE, PHP4+Eaccelerator,MYSQL 4.1,Apache 1.3. I get the famous ipb mysql error : IPS Driver Error There appears to be an error with the database. You can try to refresh the page by clicking here I don't know what thsi error come from, i want to log all Mysql/Php errors. Ipb already log mysql errors in the /cache directory ..But there are no errors in ther, so i want to try server's logs.
View Replies!
View Related
MySQL Forgetting User Permissions
Does anyone know what could be the cause of this issue? I located a few others over at cpanel.net that have this problem, but no solution has been found. [url] I am running a VPS server with the following: WHM 10.8.0 cPanel 10.9.1-S14304 RedHat 9 i686 - WHM X v3.1.0 phpMyAdmin - 2.9.0.2 MySQL client version: 4.1.10 mysql version: 5.0.27-standard I have a database user that needs "Super Privileges" and so this was done. However, when Cpanel is updated the user permission is reset automatically from "ALL PRIVILEGES" to "USAGE". Here's a look at the database permissions from phpMyAdmin. Code: User Host Password Global privileges Grant hello localhost Yes ALL PRIVILEGES Yes hello_ % No ALL PRIVILEGES Yes hello_ localhost No ALL PRIVILEGES Yes The user "hello" loses its "ALL PRIVILEGES" and switches over to "USAGE" if an update is triggered. Updates to cpanel, creating/removing a database/user, and updating the account password will cause the switch.
View Replies!
View Related
Mysql/user Is Marked As Crashed
I am trying to start mysql but i am getting the following error MySQL manager or server PID file could not be found! [FAILED] Starting MySQL................................... [FAILED] I checked my hostname.err file in /var/lib/mysql and this is the error message it shows. 070130 17:59:41 mysqld started 070130 17:59:42 [ERROR] /usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should be repaired 070130 17:59:42 [ERROR] /usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should be repaired 070130 17:59:42 [ERROR] Fatal error: Can't open and lock privilege tables: Table './mysql/user' is marked as crashed and should be repaired 070130 17:59:42 mysqld ended how I would repair that to get mysql to start again?
View Replies!
View Related
What Are Common MySQL User Permissions
I want to use something like PHPBB forums and using one MySQL user and database. Just wondering, what are common user permissions I should set for the user? I want to try to minimize any permissions that can cause big risk to the server security. Here is a full list of permissions I can grant to the user (via Webmin): -Select table data -Insert table data -Update table data -Delete table data -Create tables -Drop tables -Grant privileges -Reference operations -Manage indexes -Alter tables -Create temp tables -Lock tables
View Replies!
View Related
MySQL Replication For User On Shared Server
I never did replication and do not know much about it so I figured I would ask here if anyone knows or has done it before like this. I have a user who wants me to enable replication on my server for his user. I dont like the sounds of it on a shared environment but if there is no risk to other users and its not a big resource hog I will do it. Anyway, from what I gather I have to: 1. execute: GRANT REPLICATION SLAVE ON user_main.* TO 'repl'@'ip-here' IDENTIFIED BY '4T6WjUZa'; [url] 2. Stop mysql server and Add in my.cnf: [mysqld] log-bin=mysql-bin server-id=1 slave-compressed=1 binlog-do-db=user_main start server[url] 3. execute: SHOW MASTER STATUS; we need values of colomns File and Position from output of above command[url] So my questions are: Is there any security risk? Is there significant extra resource usage? Is this even done on shared environments?
View Replies!
View Related
Mysql User Privilege Changed By Cpanel Or What
I am using Cpanel. One Cpanel account is backup. I use it to backup my database. Under mysql, I gave this account ( backup ) many priviledges. But when the backup script ran, error said that backup account can not 'lock table'. I gave "lock table' priviledge again and run the script, it is ok. But after a while, when the script ran autmatically on daily basis, it lost the 'lock table' priviledge again. I wonder if Cpanel is messing me up? What can I do about it? anyone knows?
View Replies!
View Related
MySQL: Access Denied For Root User
When I deleted a database, the user apparently was orphaned because when I tried to recreate it, it returned "user already exists". I've never encountered that problem although from Googling, I see others have and they delete the user to get around it. When I log into mysql using the da_admin@ account and attempt to remove the user with drop user <user_name>; I receive the following error message: ERROR 1227 (42000): Access denied; you need the CREATE USER privilege for this operation It seems I don't have rights even as the root user. How can I get remove the orphaned user?
View Replies!
View Related
Weird MySQL: User/pass Stops Working After A While
I am having a very strange problem with 2 different cPanel accounts on a server with 500-600 accounts. For some reason after a day or two the mysql username/password stops working. We have tried changing the MySQL user and the password with no success. The log does not indicate that the MySQL password was changed in any way. Only these 2 accounts are affected and this problem occurred at least half dozen times each. Again: these are two different accounts with 2 different MySQL users that after a while stop working (I am unable to determine if they stop working at the same time b/c they belong to different customers). When we reset the user (with the same pass) it works for a day or two. I have checked to connect not only from PHP but also from shell when it's down: it also doesn't work so this is a pure MySQL problem. Also on the server we have Fantastico.
View Replies!
View Related
Granting MySQL Command Line Permissions To A User
Is there any safe way to grant command line permissions to a user/specific account? One that only allows them access to databases on their account. The problem is that this user intermittently runs queries that cause their database to hang (including PHPMyAdmin, so they can't view the processlist through there), and I have to manually kill that process, because they can't. Server is 2.4.21 with MySQL 4.0.27, admin is cPanel WHM.
View Replies!
View Related
Apache Error Log: Log Files That Exist
I have moved my sites from old server with Apache 1.3 to new one with Apache 2.2.4. Since that time, the error log is full of these lines: Code: [Wed Jul 04 05:36:32 2007] [error] [client 212.47.9.194] File does not exist: /home/domain/public_html/russia [Wed Jul 04 05:36:39 2007] [error] [client 212.47.9.194] File does not exist: /home/domain/public_html/russia [Wed Jul 04 05:36:45 2007] [error] [client 213.192.18.2] File does not exist: /home/domain/public_html/italy [Wed Jul 04 05:36:57 2007] [error] [client 83.8.104.181] File does not exist: /home/domain/public_html/mexico The access logs show even more accesses, so sometimes the same page is ok, sometimes it is logged here. The strange thing is that these files (pages) exist! They are accessible through the browser without any problem. Do you have any idea where could be the problem? It would helped me lot, I am unable to find any real problem now, when error log is full of these. My OS is Ubuntu 6.06. I use mod_rewrite through .htaccess. I can provide list of apache modules, if it helps.
View Replies!
View Related
Log Php Errors To A Error Log
I have tried to configure my php.ini to output all the php error occurred in my production box to a php_error_log in /usr/local/apache2/php/logs/php_error_log for security sake However, cant seem to have any error logging to log file after running a syntax error script. Error already configured not to display on the screen the directory: /usr/local/apache2/php/logs is already exist but not the php_error_log the directory already chmod'ed 644 and owned by root. my apache log directory is also owned by root and the error logging is running just fine. Apache running as Nobody
View Replies!
View Related
Dnsstuff Queries
how can i run queries in dnstuff.com for examlpe we can run following query for DNS Lookup MX record Code: nslookup -q=MX www.webhostingtalk.com ISP Cached DNS Lookup =? E-mail Test = ? ISP Cached DNS Lookup =?
View Replies!
View Related
Redirect NS Queries
I have 2000 domains set to NS1.anydomain.com NS2 etc Is it possible, through some script or otherwise, to send the traffic to certain/chosen domains to a completely different set of nameservers.? Preferably without having too much server load? I already use a domain catchall, so no NS records are actually registered on the server.
View Replies!
View Related
Nameservers - Recursive Queries
I am checking DNS Report for a domain and in nameservers records I am getting following: Recursive Queries I could use the nameservers listed below to performe recursive queries. It may be that I am wrong but the chances of that are low. You should not have nameservers that allow recursive queries as this will allow almost anyone to use your nameservers and can cause problems. Problem record(s) are: xxx.xxx.xxx.xxx I am using Windows 2003 Standard and Microsoft DNS Server. Any ideas what is this all about and how to fix it?
View Replies!
View Related
DNS Queries From Our Server
We host our DNS with DNSmadeeasy.com. We noticed that the number of DNS requests is too high. So we decided to contact their support and ask them for log file, so we can determine what's going on. Reply we got from them is the following: We researched your queries and we found that many of them were coming from the SoftLayer resolving name servers. We phone their admins to report the abuse and they said that the queries were infact coming from your own server with them. We will not charge for any overage on the queries this month so you can research what on your server is causing these queries. But we will provide you with logs of about 5% of our your traffic. here is the example of the line from log file sent by them: May 10 17:15:48 t145 named[29945]: client 66.228.118.72#52529: query: host-196.218.57.145.tedata.net.mydomain.com IN AAAA -E May 10 17:15:48 t145 named[29945]: client 66.228.118.72#52529: query: afontenayssb-151-1-40-153.w83-114.abo.wanadoo.fr.mydomain.com IN AAAA -E I changed the real domain name to "mydomain.com" I checked the apache access log and found these hosts there in exact order as they are in log file sent by dnsmadeeasy. What is strange is that why is my server making back these requests ? Also these requests are bad because these are not valid domain names: e.g. should be "host-196.218.57.145.tedata.net" instead of "host-196.218.57.145.tedata.net.mydomain.com" Seems that it includes ".mydomain.com" to the end of every request. Is there a way to discover what is making those DNS queries?
View Replies!
View Related
Vbulletin... High Amount Of Queries
I got a dedicated server which hosted 45 sites, one of those sites contains a vbulletin forum application since january 2007 , but from two weeks i found that there is a high amount of Queries from the this database which leads the server load to be always in RED and exceeds 200 or 300! and the memory is totally consumed! i tried alot to solve this problem as : - reinstall the vb. - change the vb path to another ( considering it as attack) - installing BFD , APF , ( considering it as attack ) - upgrading to apache 2.2.6 , PHP 5.2.5 , MySQL 5.0.24 ( considering it as a bug) this is the sample of queries. Code: 46978hakawyc_SKJI8jjlocalhosthakawyc_froumvbSleep40 NULL46980hakawyc_SKJI8jjlocalhosthakawyc_froumvbSleep38 NULL46990hakawyc_SKJI8jjlocalhosthakawyc_froumvbSleep38 NULL47034hakawyc_SKJI8jjlocalhosthakawyc_froumvbSleep30 NULL47086hakawyc_SKJI8jjlocalhosthakawyc_froumvbSleep23 NULL47092hakawyc_SKJI8jjlocalhosthakawyc_froumvbSleep19 NULL47095hakawyc_SKJI8jjlocalhosthakawyc_froumvbSleep23 NULL47099hakawyc_SKJI8jjlocalhosthakawyc_froumvbSleep23 NULL47122hakawyc_SKJI8jjlocalhosthakawyc_froumvbSleep24 NULL47124hakawyc_SKJI8jjlocalhosthakawyc_froumvbSleep24 NULL47126hakawyc_SKJI8jjlocalhosthakawyc_froumvbSleep24 NULL47127hakawyc_SKJI8jjlocalhosthakawyc_froumvbSleep24 NULL47142hakawyc_SKJI8jjlocalhosthakawyc_froumvbQuery22Sending dataSELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache47143hakawyc_SKJI8jjlocalhosthakawyc_froumvbQuery0Writing to netSELECT moderator.*, user.username, IF(user.displaygroupid = 0, user.usergroupid, user.displaygroup47144hakawyc_SKJI8jjlocalhosthakawyc_froumvbQuery22LockedSELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache47145hakawyc_SKJI8jjlocalhosthakawyc_froumvbQuery22LockedSELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache47147hakawyc_SKJI8jjlocalhosthakawyc_froumvbQuery22Writing to netSELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache47151hakawyc_SKJI8jjlocalhosthakawyc_froumvbSleep16 NULL47159hakawyc_SKJI8jjlocalhosthakawyc_froumvbSleep17 NULL47166hakawyc_SKJI8jjlocalhosthakawyc_froumvbSleep15 NULL47177hakawyc_SKJI8jjlocalhosthakawyc_froumvbSleep0 NULL47180hakawyc_SKJI8jjlocalhosthakawyc_froumvbSleep16 NULL47211hakawyc_SKJI8jjlocalhosthakawyc_froumvbSleep10 NULL47251hakawyc_SKJI8jjlocalhosthakawyc_froumvbSleep0 NULL47283rootlocalhostNULLQuery0NULLSHOW PROCESSLIST Once i disabled the database the server load became normal again another example for Queries : Code: 117445 hakawyc_SKJI8jj localhost hakawyc_froumvb Sleep 49 NULL 117497 hakawyc_SKJI8jj localhost hakawyc_froumvb Sleep 42 NULL 117667 hakawyc_SKJI8jj localhost hakawyc_froumvb Query 24 NULL SELECT *ntttFROM datastorentttWHERE title IN ('','options','bitfields','attachmentcache','forumcache 117790 hakawyc_SKJI8jj localhost hakawyc_froumvb Sleep 7 NULL 117791 jarabhar_vb localhost jarabhar_vb Sleep 7 NULL 117793 hakawyc_SKJI8jj localhost hakawyc_froumvb Sleep 7 NULL 117795 hakawyc_SKJI8jj localhost hakawyc_froumvb Sleep 8 NULL 117798 hakawyc_SKJI8jj localhost hakawyc_froumvb Sleep 8 NULL 117799 hakawyc_SKJI8jj localhost hakawyc_froumvb Sleep 8 NULL 117802 unauthenticated user localhost NULL Connect NULL Reading from net NULL 117803 unauthenticated user localhost NULL Connect NULL Reading from net NULL 117804 unauthenticated user localhost NULL Connect NULL Reading from net NULL 117805 unauthenticated user localhost NULL Connect NULL Reading from net NULL 117806 unauthenticated user localhost NULL Connect NULL Reading from net NULL 117807 unauthenticated user localhost NULL Connect NULL Reading from net NULL 117808 hakawyc_SKJI8jj localhost hakawyc_froumvb Query 9 Sending data SELECT *ntttFROM datastorentttWHERE title IN ('','options','bitfields','attachmentcache','forumcache 117818 jarabhar_vb localhost jarabhar_vb Query 8 Sorting result SELECT post.postidntttFROM post AS postntttntttWHERE post.threadid = 52572nttttAND post.visible = 1n 117821 hakawyc_SKJI8jj localhost hakawyc_froumvb Query 8 Sending data SELECT *ntttFROM datastorentttWHERE title IN ('','options','bitfields','attachmentcache','forumcache 117829 jarabhar_vb localhost jarabhar_vb Query 8 Sending data SELECT *ntttFROM datastorentttWHERE title IN ('','options','bitfields','attachmentcache','forumcache 117832 hakawyc_SKJI8jj localhost hakawyc_froumvb Query 7 statistics SELECT post.*,ntttIF(visible = 2, 1, 0) AS isdeleted,ntttnnttteditlog.userid AS edit_userid, editlog 117833 jarabhar_vb localhost jarabhar_vb Query 7 statistics SELECT IF(visible = 2, 1, 0) AS isdeleted,ntttnntttNOT ISNULL(subscribethread.subscribethreadid) AS 117834 hakawyc_SKJI8jj localhost hakawyc_froumvb Query 7 statistics SELECT languageid,ntttphrasegroup_holiday AS phrasegroup_holiday,ntttphrasegroup_global AS phrasegro 117835 hakawyc_SKJI8jj localhost hakawyc_froumvb Query 7 Writing to net SELECT *ntttFROM datastorentttWHERE title IN ('','options','bitfields','attachmentcache','forumcache 117836 hakawyc_SKJI8jj localhost hakawyc_froumvb Query 7 Sending data SELECT *ntttFROM datastorentttWHERE title IN ('','options','bitfields','attachmentcache','forumcache 117840 hakawyc_SKJI8jj localhost hakawyc_froumvb Query 7 Sending data SELECT forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, reply 117841 hakawyc_SKJI8jj localhost hakawyc_froumvb Query 7 Sending data SELECT *ntttFROM datastorentttWHERE title IN ('','options','bitfields','attachmentcache','forumcache 117842 hakawyc_SKJI8jj localhost hakawyc_froumvb Query 7 Sending data SELECT *ntttFROM datastorentttWHERE title IN ('','options','bitfields','attachmentcache','forumcache 117843 hakawyc_SKJI8jj localhost hakawyc_froumvb Query 7 Sending data SELECT *ntttFROM datastorentttWHERE title IN ('','options','bitfields','attachmentcache','forumcache 117845 hakawyc_SKJI8jj localhost hakawyc_froumvb Sleep 2 NULL 117846 hakawyc_SKJI8jj localhost hakawyc_froumvb Killed 0 NULL NULL 117847 unauthenticated user localhost NULL Connect NULL Reading from net NULL 117848 hakawyc_SKJI8jj localhost NULL Connect NULL Writing to net NULL 117849 unauthenticated user connecting host NULL Connect NULL login NULL 117850 unauthenticated user connecting host NULL Connect NULL login NULL 117851 unauthenticated user connecting host NULL Connect NULL login NULL 117852 unauthenticated user connecting host NULL Connect NULL login NULL 117853 unauthenticated user connecting host NULL Connect NULL login NULL 117854 unauthenticated user connecting host NULL Connect NULL login NULL 117855 unauthenticated user connecting host NULL Connect NULL login NULL 117856 unauthenticated user connecting host NULL Connect NULL login NULL 117857 unauthenticated user connecting host NULL Connect NULL login NULL
View Replies!
View Related
Input Wanted: Optimizing SQL - For Millions Of Queries
I am running a SQL test server here that is piping HUGE amounts of data for a test project I am running. Approximately 30 queries a second - constantly. That's over 2.5M queries a day -- so we are talking big (I think?) I am currently running this test on a AMD Phenom 9300, 4GB RAM - SATA 500GB HDD and I am running MySQL 5.0.51a i386 on CentOS I have programmed a process control for our applications purpose - basically it controls the launching of our SQL intense applications, and stops launching when the Load is greater than 2.5 I have plans to optimize the number of queries (I will build in a cache to some of the applications - and run INSERT statements all together) however I am looking for SQL tweaks that will improve performance. Would running the 64bit version work better?
View Replies!
View Related
Wordpress Sql Queries Performance On A Shared Hosting Account
im running a few blogs on a shared hosting account (steadfast) and i noticed the 18 sql queries being generated by a fresh install of wordpress 2.7 are taking 0.246 seconds to execute. <!-- 18 queries. 0.246 seconds. --> considering this is a shared hosting server with over 800+ more domains on it, is the performance better or worse when compared to other shared hosting providers ? archim3des
View Replies!
View Related
Specific VPS
I'm trying to build a distributed cluster of virtual hosts spanning the U.S. My requirements for all of them are: 1. Very well connected - Tier 1 2. Able to run Gentoo Linux 3. OpenVZ/Virtuozzo/UML I've got the southern half of the country covered. Can anyone refer me to such a provider in the northeast, anywhere above Washington; and another in the north-central cornfield states?
View Replies!
View Related
CNAME To Specific Ports
I'd like to know how I can use DNS to do something like make a CNAME record that points the same address to different addresses based on the port used. mail.example.org on port 80 points to ghs.google.com mail.example.org on port 995 points to pop.gmail.com mail.example.org on port 587 poitns to smtp.gmail.com
View Replies!
View Related
Block A Specific ISP
Is there any way to block a particular ISP? Have a visitor that changes IP hourly, but the IP always resolves back to a hostname like dsl.yuns.sksk.uk . I have CSF installed. Any way to block all visitors from dsl.yuns.sksk.uk?
View Replies!
View Related
Specific Dedicated Server
I own a Limited company in the UK and we are looking for a Dedicated server to put our shoutcast services on. So far I have the following deal: Quad Core Q6600 (4x 2.4Ghz) 2GB RAM 2x 250GB SATAII HDDs in RAID Full Root Access 5TB Bandwidth per month 100Mbit network port (fully burstable) £99.99 + VAT Free setup 1 Month contract (30 Days Notice for Cancelation) I am looking for a better deal than this with a reliable and well known supplier. We are a expanding company offering not only shoutcast but web hosting, web design and broadband. The canditate host needs to be reliable and well known who can support us with no/little fees if we go over our alocated ammount. If the host lives up to expectations there are future company prospects and business. We are looking for a 1 month contract as we have with long term intentions in mind should all be well with the host.
View Replies!
View Related
Specific Config For A Blackberry
I have a customer that uses a blackberry and of course, he wants his email to be delivered in the BB, so is there any previous config or a specific port that needs to be opened, or anything else on the server?...please i have no idea about that x_X i have a WHM/Cpanel on a Centos 5.1 and i work with exim
View Replies!
View Related
Sub-domain Point To A Specific Ip
I have a few website's and a whm account. I also have a few things at home that I would like to access every now and then. I was wondering if it would be possible to setup a subdomain to point at my ip adress at home? like if I give the home.domain.com , all traffic would be directed to my home, but domain.com would remain the hosted website? If it is possible, how do I do it?
View Replies!
View Related
How To Delete Specific Files
In one folder, I have thousand of files, and I want to delete 100 specific files. Saying specific files, I mean all of them has a keyword. So, I can find out all of them by using grep "keyword" * but dont know how to delete all of them. Not deleting one by one.
View Replies!
View Related
ADULT Hosting - A Few Specific Questions
I had a few specific questions about ADULT hosting. I've been refining an idea I had for an adult website after getting some good feedback from this site, but I had a few specific questions I still need addressed. If you think this forum is the wrong place to be asking about this, do you happen to know of any other forums that specialize in discussing adult web hosting? My general plan is to set up a video-based adult site that charges people money (a monthly fee) to see the premium content. I have a general idea about my start-up investments, but not necessary how much each would cost, and I'm trying to put together a budget. If anyone could help me fill in some of these blanks I would really appreciate it!! I'll need a lawyer to set up site disclaimers, contracts, etc. - I assume this will be a few hundred dollars - does this sound correct? I need to build the site- this is where I'm not sure about costs. The general specifications are like any other adult website - users pay to register - so I would go with one of the established companies that deals with secure online credit card transactions - any ideas which ones are good? How much do they normally take? Users then can watch the videos, rate and give feedback. Since I don't really know any programming besides HTML, I'm assuming I need to hire someone to build the site and make sure it is secure. I'm also assuming this will be the most expensive part of the investment. Can someone give me some estimates about this? Are there general templates online that I can use that will save money? Is guru.com a trusted place to hire programmers? Is this something I could do myself without spending years learning a new programming language? How DO I make the site secure, and how can I keep people from stealing my premium content and posting it on other sites? I'm obviously trying to make this as cheap as possible without sacrificing all the quality - but unfortunately I have thousands to invest and not tens of thousands (i don't know if this will be a problem or not). Also - hosting. I was told that a popular adult video site will cost a fortune in bandwidth. If I'm charging a monthly membership fee I'm hoping that can offset the costs. Can someone recommend good, scalable adult video hosting - and give me a general idea about what kind of server I need, how much bandwidth etc. I figure since this is membership driven I can start small and then increase bandwidth depending on how many members join, so I'm always making a profit. Does that sound realistic? Finally, can adult pay sites still make money today? Not just a couple bucks here and there, but enough so I can eventually quit my day job? The wonderful feedback I got here before helped me to reshape my ideas, and now I'd like to begin the next steps. Thank you all very much again for ANY help you can give me - I sincerely appreciate all the generous, knowledgeable people that make this forum a pleasure to visit!
View Replies!
View Related
Forwarding Mail To A Specific Folder?
Is it possible to create an email forwarder that will forward to a specific folder? For instance, an email to "anemail@domain.com" will forward to a folder 'fold1' of "realemail@domain.com". Alternatively, is it possible to forward but with adding additional headers, such that I can then create a filter to place emails with that header in a specific mail folder?
View Replies!
View Related
Block GET Requests To Specific Files
I am getting a lot of GET requests from different IPs to 4 nonexistent PHP files on my server. Is there any way to block the requests to avoid the resources use of apache that these requests are generating? I have installed mod_security but Im not sure about how the block rule should be. The requests are going to images/log.php, images/log2.php, images/log3.php and images/logi.php of one of the sites hosted on the server, is there any way to block there requests for a specific domain or path?
View Replies!
View Related
|
TRACKER
