Sql Error - Shuts Down The Website In 5 Seconds
There is a program called as D4 and it sends a huge data to the sql database and it slows down the website in the first 2-3 seconds and then in a few seconds it shuts down
the website until s/he stops using the program. We made a huge research over
the internet, but we couldn't find any solutions for this. It can shut down
any website, that's having a sql based database. I hope you can help us with
this problem. Thank you for your attention and time.
if the site admins want to get the program, they can contact us. However, they should be aware that this is a dangerous program so it shoudn't be distrubuted.
View Complete Forum Thread with Replies
Related Forum Messages:
Seconds Between 2 Dates - Why Does Seconds Jump By 40 Seconds?
I have a table for my sessions and basically i wanna check seconds between NOW() and when it was created. I noticed that at every minute the seconds would jump by at least 40 seconds for every minute. So if i created a new sesson on my site and Log NOW() into created then i try doin SELECT (NOW() - created) AS created_sec I was monitoring it because my site would log me out all the time. So I noticed at every minute it seems that it always jump 40seconds or more for every minute. Here is table:...
View Replies !
Website Error
I have image hosting website. When I type in the the website name in the address bar of the browser, I get the following error: Couldn't connect to database server: Access denied for user: 'imgbiz@linhost120.prod.mesa1.secureserver.net' (Using password: YES) I am not very familiar with PHP or MySQL. Could someone let me know if it makes any sense or what I should be doing to correct this error? (it would help if someone might have had this error and resolved it, could help me out here) I have changed the username, because it was much more easier to remember. Does this cause any problems in the website being displayed? I have changed it going through phpMyAdmin/admin. Is there any other file that I need to change this information so that it works?
View Replies !
Converting A TIME Field Into Seconds : Error Message
CREATE TABLE `m010` (`date` date NOT NULL, `hour` time NOT NULL, `duration` time default NULL, `cs` int(11) default NULL, `id` bigint(20) NOT NULL auto_increment, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC the field 'duration' is in TIME format (thus 00:00:00) .. I want to convert it in seconds. I've read that I can do something like this: mysql> select duration, TIME_TO_SEC (m010.duration) AS 'ts' from m010 WHERE id = 736; Problem is, I get this error : ERROR 1305 (42000): FUNCTION m010.TIME_TO_SEC does not exist
View Replies !
Creating A Website Forum: Use Existing Website MySQL Db Or Create A Second Db?
I am getting ready to start coding my own forum.... to seemlessly integrate it into my existing website. My question is this; should I: a) create the new forum tables in my existing database (used for the website user accounts etc.), OR b) create the new forum tables in a separate new database (it would be on the same server with same u/n p/w) Which one is the better option? I've been banging my head over trying to decide which way to go...
View Replies !
Maximum Execution Time Of 300 Seconds Exceeded (was "MYSQL Error")
I have a huge database 400mb+ in size which i have exported into a .sql file. I tried to run this export script into a new database and it runs fine until three quarters into the scripts execution and the following error appears: ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<br / > <b>Fatal error</b>: Maximum execution time of 300 seconds exceeded in <b' at li ne 1 I believe this error may relate to "delayed_insert_timeout = 300". How do I increase this limit in mysql - maybe it may solve the problem but then again it may not . Any advice is most gratefully appreciated - As you can imagine if the script runs fine for 3/4 of it and then an error appears, stating the error is on line 1, it will take me days to go through the whole script (hundreds of thousands of rows) to find the error as I assume the error does not reside on line 1 as this line would have been executed. I am running the script on mysql 5, and via source /path/****.sql on linux.
View Replies !
MySQL Shuts Down ...
The mysql server seems to 'shut down' automatically. Im not sure if this shutting down occurs when root logs off the machiene or if its somthing else (perhaps a certian period of server inactivity?) Can anyone tell me what this could be caused by and how to fix it? Here's a further explination of what happens: Last evening I was logged in as root. I noticed that the database server had shut down. I knew this because Im in the process of seting up phpBB2 on the machiene and when I attempted to load the bulliten board's index.php page I got the following error: phpBB : Critical Error Could not connect to the database So I checked in the 'services' panel and in the mysql server section some text indicated that the server had halted. I ensured that the service was checked (so that it starts with the machiene) and then re-started it. Mysql started up fine, and I could sucessfully load phpbb's index.php page again. I loged out of the machiene. Now today, when I attempt to load index.php Im getting the same error msg. Whats going on here?
View Replies !
Mysql Shuts Down Overnight
I got apache 2.0 + MySql 3.23.52 + PHP 4.3.1 on a Redhat 8.0 server. Somehow MySQL automatically shuts down overnight, anyone has a reason for this? Might because of cron?
View Replies !
SQL Server Shuts Down On Logout OS-X 10.4.9
I have managed to get a MySQL Server Running on my G5 Power Mac, however the server only seems to be running when I am logged in. As soon as I log out the Server seems to shut down aswell, although I have set it to run at system startup (with the tickbox in the system pref.). Is there a way to have the server running in the background as long as the system is up, no matter which user is loged on (or no user just the login screen for that matter)?
View Replies !
Mysql Shuts Down During Rapid Execution Of Querys
I am using version 4.0.12-nt of MySQL and when I hit the enter key rapidly I can't connect to the database. The result is a message is returned to me from mysql that says I can't connect because the database is down. If I only hit the 'enter' key once (to execute the page that my queries are on(their are four queries on this particular web page)) my queries execute just fine. We have noticed that this only happens when we:
View Replies !
How Many Seconds Query Took?
I'm sure this is one of the easiest questions to answer, but how to you know how many seconds it took to query the database? I noticed it on the command-line client and on a lot of forums.
View Replies !
Changing Value After 30 Seconds?
Is there a way to change a value after 30 seconds of it being changed? So if I change it to 1 from an external script, I want to 30 seconds later to change to 0. Is this possible without a script (or a script in sql of some sort?)?
View Replies !
Adding Seconds In TimeStamp
I have a table that contains an "interval" column and a timestamp column. I want to set the default value for the timestamp column to be the current timestamp plus the interval column which is a value in seconds.
View Replies !
Add Seconds To Current Time
I am trying to create a statment to add a given time in second to the current time like this: update tags.triggers set next_interval=(addtime(curtime(),300)) where id=1; This statment adds 3 minutes to the current time. How can I add 300 seconds to the current time?
View Replies !
SELECT Takes 20 Seconds
I am having trouble speeding up a SELECT statement from a table with 1,764 records. I tried myisamchk --sort-index --sort-records=1 but this did not help (is a Primary key enough?). Things were fine at around 1200 records but went downhill after 1700. I am using MySQL 3.23.42 on HP/UX 11.11 and PHP 4.3.4. Any tips on how to speed things up?
View Replies !
Mysql Does Not Respond For Several Seconds.
I have created a new database-driven website. I've installed php 5.1.1 and mysql 5.0 I'm working with the Mysqli connector. Everything works fine. Except when a user starts tampering the website by continuously hitting the F5 button. On the intro-page of the website, a lot of queries are being fired against the database. When the user hits F5 quickly for, let's say, 50 times the database times out and I get the ugly error: "Warning: mysqli::mysqli() [function.mysqli]: (HY000/2003): Can't connect to MySQL server on 'localhost' (10048) in..." After the database 'hangs' and I am unable to connect to it for at least 30 seconds... Any idea why the tampering makes my database go down for a few secs ?
View Replies !
Is It Possible To Bypass 30 Seconds Time Out
hello im importing quite a large amount of .sql scripts into mysql and everytime i get this error Fatal error: Maximum execution time of 30 seconds exceeded in www.******* is it possible to alter this default timeout to a longer timeperiod and if so how is it done, im using MySQL v5.0.27, together with PHP v5 and phpmyadmin v2.9.03
View Replies !
Mysql Killing The Connection After X Seconds
I'm running mysql 4.0.20a on Windows XP Pro. I have a java web application that connects to the database for storing persistent java classes. I am running into a problem when I leave my application running overnight... I try to log in to my page in the morning and it gives me a JDBC Exception. If I restart the web server (not the mysql server) and then try to log in to my app runs fine. In trying to troubleshoot I've used the mysql control center to show the processes of the mysql server and it shows that my web app doesn't really disconnect after running a query, it just sleeps. Does mysql kill a connection if it has been sleeping for a long time? How do I change this? How do I find out how many seconds of sleeping before mysql kills the connection?
View Replies !
Difference Between Two Dates Including Seconds
1) I have mySQL 3.23 installed. I have a record with two date/times fields in YYYY-MM-DD HH:MM:SS format. How do I find the difference between those two date/times? (I would also like to know it with seconds left off.) 2) Let's say I have two records each with a date/time field in YYYY-MM-DD HH:MM:SS format. How do I find the difference in date/times when each field is in a different record?
View Replies !
3 Seconds To Run A Select That Returns Empty Set?
I have recently created a very simple table with 2 VARCHAR fields. I have then created a quick php script to loop through some inserts (inserted 600000 rows) and then deleted all the rows by doing "delete from Table where field1="abc" which should delete all rows. I then did a select * from Table and the query took 3 seconds! The return result set is empty! Later I found out that if I do a delete * from Table, without a where clause. And then after tat do a select * from Table, it will take 0.0 seconds. Why is this? How to fix?
View Replies !
Delete Inactive Sessions Every 60 Seconds?
I have a session table, where I stored user sessions in the database in a memory table. My question is, performance wise, would it be smarter to delete inactive sessions every 60 seconds via client http requests, or would it be wiser to select active sessions via a select that uses a where clause and searches a timestamp index column for active sessions, and then a cron job is scheduled to delete every 30 minutes. Which of these would be the better choice? On each page request I am going to have to select the number of sessions that exist and a second query that displays the active users. So if I go with my second choice, I will have to include a WHERE clause that scans the index on both those queries. But if I am issuing a delete every 60 seconds, then I won't have to do that, but then the delete is taking place every 60 seconds on a client request.
View Replies !
Avoid Duplicate Records In Within 30 Seconds
I'm working with php. I have a auction site, more or less. I want to create all-time rankings. The idea is to display where a seller ranks (all time) in the number of sales. So for example, I'd display John Doe All Time Sales Ranking: #138 I'm not exactly sure how to go about this. $query = "SELECT count(*) as counter, SellerName FROM sales GROUP BY Sellername ORDER BY counter DESC"; This query would give me the data to list all of the Sellers in desc order by the number of sales. In php, I could probably count until the Sellername was equal to $Sellername (already defined in their profile page), but I was hoping there would be a way to do this entirely in MySQL.
View Replies !
Using A DB In A Website
I want to create a website where users can select (from a dropdown box) and then view various PDF files. I also need the capability to upload and store these PDF's. What's the best way to accomplish this?
View Replies !
MySQL On A Website
I'd like to create a website with a MySQL database to store soccer players details like goals scroed for the season. I want to use it to update my fantasy soccer team through this season, does anyone know of a free host that provides MySQL? Or even better, does anyone have experience of this? I've created an ASP web interface to an Access database and read/written to it like that in the past so I assume it's the same for MySQL.
View Replies !
HOW DO I USE MYSQL WITH MY WEBSITE?
I have an existing website with Netfirms and it comes with "mysql" "php" etc. It is active and have been able to confirm that with tech support. I purchased two books regarding "php & mysql for dummies" and "biginning php5,Apache, mysql Web development" and still I donot have a clear understanding of how to write a script that will allow a website user to interact and or collect information and display information on the website page. I mean this is what it is all about right? Can someone please just give me an example that I can follow on how to actually creat a script to allow mysql to interact with a webpage. And while your add it. whats a good learning tool, book etc to have?
View Replies !
How Do I Set The Tables For My Website
I have usually done my websites with Access and all I had to do was transfer a MDB file, and put the path in the data connection and it was working. How do I do this with mySQL? Do I upload a file(s) and change the datapath or??? I am using ASP (not .NET) and the server is hosted elsewhere by a local company.
View Replies !
Website & Intranet - 1 DB Or 2?
I've been working on our company intranet for some time now and it's finally (more or less) been completed. The next phase is working on our internet website. The website will offer merged functionality (ie online quoting that is available to employees on the intranet, etc) and I was wondering the best way to tackle this project. My first thought is that the databases should be separate. That is, one for the intranet, one for the website. If at such time I need to gather data from both I can run a query and simply select the database to use. My question is: is there a reason that I should use two separate databases instead of just using separate tables - besides perhaps the fact it might be easier to manage? If anyone out there has done similar in the past, what did you find out/learn? As mentioned, some of the functionality will cross. For example, when a potential client enters information to be provided a quote, that information, based on certain characteristics (name, etc) will be made available to certain employees for the purposes of quoting and providing that quote to the applicant. I can see where I would need to be able to use information from both databases to run a query for this, so it might be easier if it's all in one table. However, there will be personal information so security is of concern also. Does using two separate dbs help in this regard? Either way, there are security measures in place to protect the integrity of the data but I'm curious if this "extra" layer is necessary. (This is a php/mysql integration btw which may have been obvious.)
View Replies !
Database Driven Website
We want to develop database driven website. because of enormous amount of data (300GB) customers's tech advisors are insisting on using SAN instead of any direct attached storage method. I want to know what issues need to be considered while using SAN in web solutions.? Which database server/ product is best suited for such kind of job ? Can anyone suggests good informative articles on this subject , available on web?
View Replies !
Double Quotes Appear As ? On Website
I have an Excel file (which is converted to csv by a tool and then uploaded to a MySQL database) and then php is used to display the data on the website. In the Excel file i have text fields which has data containing double quotes. They end up appearing at ? question mark on the website. Any idea how to dispaly the quotes Should i be carefull of any other invisible characters in Excel which can mess up the data.
View Replies !
Website Suddenly Freezes
mysql> show processlist; +------+--------------+-----------+--------------+---------+------+-------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+--------------+-----------+--------------+---------+------+-------+------------------+ | 1851 | root | localhost | admin_soccer | Query | 0 | NULL | show processlist | | 2538 | admin_soccer | localhost | admin_soccer | Sleep | 8 | | NULL | +------+--------------+-----------+--------------+---------+------+-------+------------------+ 2 rows in set (0.00 sec)
View Replies !
Website Freezes Due To Locks
I have used this command for database back up mysqldump -u USER -pPASSWORD --skip-extended-insert --lock tables DATABASE | gzip dump.sql or mysqldump -u USER -pPASSWORD --skip-extended-insert DATABASE | gzip dump.sql But even though i use lock tables or not , my website freezes for that period of time untill backup is finished. Is there anyway that users should be able to use website during backup
View Replies !
MySQL Driven Website
I would like to do is create a website that is driven by a MySQL database. The question is, does MySQL have to be installed on the web server by my isp or is there another option. I have read some posts about a MySQL DLL that can be placed on the server instead of a full install, but have not found enough relevent info.
View Replies !
Moving DB/website To Another Server
I exported my database so that I can move my website to another server PC. Upon importing into the new MySQL server I get this error messsage. I had a look at MySQL website but to no avail I still did not know what it means or how to solve it. Code:
View Replies !
User Interactive Website
I want to make an interactive website where people have to register to interact. (like fill out a form giving loging information and stuff). I want to do this using PHP/MySQL. Would anyone please show me how to do this, or give me a link to a website/tutorial that will?
View Replies !
Creating Website Search
I am attempting to create a search engine for my website. I have found a php script that should help me accomplish what I am trying to do, but I cannot get any search results to appear which means I have one or several or all of my parameters incorrect. Right now, I have the search included on a separate page, and while I have connected the script to the database so that it no longer says 'Could not connect to database' or 'Access denied,' I cannot get any search results to display. Code:
View Replies !
Connect To Mysql From A Different Website?
I have 2 websites that sometimes I want to transfer products from one website to the other. An easy way for me to do this would be site-a connect to site-b DB, select the data, and then reconnect to own site-a DB and save. I dont think security risks would be a big issue because the only thing I would be transfering would be products which dont have any sensitive info connected to them. but is there a way? if not I will just have to do it manually...Im just trying to be sufficient.
View Replies !
How To Use The Store Procedures For My Website?
As we all know that mysql is available with store procedures. But i dont know how to use the store procedures for my website. as i heard that we cannot use the store procedures for live site. we can only use store procedures for desktop application.
View Replies !
|
TRACKER
