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 Complete Forum Thread with Replies
Related Forum Messages:
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 !
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 !
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 !
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 !
Bypass Auto-increment
I have a table which uses an auto-incrementing id field. I now need to be able to edit other fields, but whenever I try to UPDATE a row with new data, a new row is created. I've tried updating the row with the old id number, but that doesn't work. How can I avoid the auto-increment
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 !
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 !
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 !
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 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 !
MySQL 4.0.18 On Dual AMD64 Opteron Causing Thread Zombie Even When Timeout Is Set To 60 Seconds
We have a problem with Dual AMD64 Opteron/MySQL 4.0.18/Mandrake 10 for a very high volume site. We are evaluating the performance on our new server AMD64 and it seems it's slow compared to Dual Xeon/MySQL 4.0.15/RedHat8 and Dual Xeon/MySQL 4.0.18/Mandrake 10. And it seems there are zombie threads. 570 threads in 1 hour and we didn't even use JDBC connection pooling at all. These threads are supposed to be gone within 60 seconds, since we set that option in mysqld. Note that we run many SELECT queries (can be up to 150 queries/seconds), but the system does not indicate any slow query: it's 0! Our configuration is Apache 2.0.48 + Tomcat 5.0.27 + MySQL 4.0.18 with MySQL connector/J 3.0.14 (latest stable). The Redhat 8 runs on Apache 2 + Tomcat 4.0 + MySQL 4.0.15. The old Redhat 8 on Xeon was fine. We have another machine running Mandrake 10 on Xeon and they were fine under the same load. I have set the wait_timeout to 60 seconds, and it appears to be fine within 10 minutes, all the threads that are in "sleep" mode disappeared after 60 seconds. After a few minutes though, it's back like it was before. Is this Mandrake problem? MySQL problem? I read in here than Mandrake win hands down on AMD64 compared to FreeBSD. Code:
View Replies !
PHP/MySQL Sorting By Date & Time (using Non Military Time)
This is probably a simple issue but I have searched online and can't find an answer. I am using PHP/MySQL and I guess the most intuitive would be to have three select boxes containing HOUR / MINUTE / AM,PM option. Then store the time into mysql using there functions so I can output the data sorting them all by date and time. All the examples I have seen are for military time only but I'm sure there has got to be a simple mysql function or php function that converts non military to military and a formatting function to display with the AM / PM. But I have not found it.
View Replies !
Compare Time Posted With Current Time Not Working
May I know how to get records with interval of 1 hour in database where the posting time is in this format '2008-05-15 00:10:40' I tried with this : $query="SELECT date,name FROM message WHERE (timediff(date,NOW())<=CRUDATE() CURTIME())"; But is not working. May I know what is the correct way of doing it?
View Replies !
Minutes + TIME = TIME Function
I need some way to convert minutes (e.g. 80 mins) to SQL TIME (e.g. 01:20:00) in order to add it to another TIME var. Is there any way to do this? I really dont want to convert my whole db. Basically, I want to do: e.g. 80 + 10:00:00 = 11:20:00.
View Replies !
How To Retrieve Mean Time Between Time Stamps
I have a table that stores failure information of external application. The time stamp of every failure event is stored. Now I'd like to make some system performance & reliability statistics calculations based on time stamps in certain recordset; mean time between failure MTBF, down time DT, etc. Example: 2007-09-27 12:23:52 2007-09-27 08:50:23 2007-09-26 23:31:34 2007-09-26 21:45:33 Here the times between are (hours:mins): 3:33, 9:18, 1:46 and MTBF=4:52 Any effective possibility to make this example within a single query - or a procedure is needed?
View Replies !
Time Format Military Time
I know the time format it HH:MM:SS in mysql but can I input military time? reason I can is that I want to later extract that information for calculations and military time is easier to work with.
View Replies !
Date-time Overlaps Another Time
had a time question in mysql... i have a start and end time for a meeting table and i am comparing whether a new meeting conflicts with another meeting in same room on the same date. i was wondering if i could check whether the 'date-time duration' in anyway overlaps another meetings date-time duration. visualized below... ............|____compareToThisMeeting__| .....|_________meetingNewOverlaps__________| i was doing something dumb before i realized i needed soemthing more complex (checking whether the start time of new meeting was 'BETWEEN' the start and end times of a meeting and whether the end time time is as well but i forgot the duration/middle value hehe). (using asp) and just returning booleans with a mySQL SELECT statement is what i am looking for like... //within a loop in asp for meetings on same date/room "SELECT '"+ year+"-"+month +"-"+day +" " + startHourString +":" + startMinuteString +":00''"+ " BETWEEN '"+ thisMeetingStart +"' AND '"+ thisMeetingEnd +"'"; (this doesnt cover the 'middle' overlap areas though)
View Replies !
Date Field, Time Field, Sort By Date And Time
I have a MySQL date field (e.g 13/12/2006) and a MySQL time field (e.g.13:00) in the same row. I'd like to join these two fields to make a date/time field (e.g. 13:00 13/12/2006) on the fly and to be able to sort the query results on the resulting field.
View Replies !
4.1.1 And 5.0.0 At The Same Time ?
mysql-4.1.1-alpha-win.zip mysql-5.0.0-alpha-win.zip Is it possible to install and run both MySQL versions under windows 2000? On one computer. I don't intend to run them at the same time, but investigate the new features. I'd like to install them in different directories and select the one that suits my needs.
View Replies !
SUM Time
I have managed to write the following query, which works well with the sum for the TOTAL values, but the values I get for Queue1, Queue2, Queue3, Queue4 all give me the wrong totals. Where am I actually going wrong? The values within the table has been set as TIME with a default of 00:00:00. the following is my query....
View Replies !
Add Time In One Row
i have a query: SELECT `date`, Last_Name, Time_Start, Time_End, subtime(time_end,time_start) as 'time due' FROM coding_adjustments order by `date` DESC, Last_Name ============= and i have to add 'time due' with the same date and last_name in time format.
View Replies !
Time In SQL
i have a table that has many categories... I want to reset one of the columns to zero at 12:00am every friday automatically. How do I do that? Second, i have a column thats auto_increment... lets say i set the first value to 10... if i add one more row... then the next row will be 11... how do i reset it to start with 0?
View Replies !
Time Out, ASP
I don't know if it's inefficient vbscripting, a slow server, a badly organised database or some other reason, but... Relatively simple scripts on our unix server keep timing out, and this is even after beefing up the time out to 120 seconds! The scripts don't seem to be doing much, although whenever one or more tables are referenced, the server takes ages and times out. My method of querying is: -check form data -create a connection -compose a sql string -execute it to make a record set -cycle thru the record set and copy data to arrays -close the record set (+ set to nothing) -close the connection (+ set to nothing) -do the html, with data from the arrays, etc. I used to open record sets separately, rather than on a connection, and also used to keep the record set open and cycle through it in the HTML rather than use arrays.
View Replies !
Time In My Sql
i want to retreive the time in GMT and store it in a DATETIME variable, for example the function now() retrieve the local time but i want to retrieve the time in GMT...
View Replies !
Now() + More Time?
How can I insert a timestamp into a database which is equal to the current time plus (for instance) and hour and 36 seconds? The code below is a complete shot in the dark: insert into TABLE values ('','now()+1hour 36seconds')
View Replies !
Time
in php my admin, i need to create a Time colum for a table but i only need the hh:mm part to be saved. so how do i ask the mysql to save only hh:mm with out seconds.
View Replies !
Two Queries At The Same Time?
I have 2 queries: The {..} are precalculated values. At the beginning no item can be matched by both where clauses. 1) update tabelle set L = L + {MOVE} set R = R + {MOVE} where L >= {LEFT} and R <= {RIGHT} 2) update tabelle set L = L - {DIFF} set R = R - {DIFF} where L >= {OTHERLEFT} and R <= {OTHERRIGHT} My problem: If I run update 1 first, the update 2 can match items from where clause 1 because the update changed the values from L and R so that they can be found at where clause 2. And if I run 2 first its the same in the other direction. So how can I do the 2 where clauses first, and when mysql knows my items I would like to update so no item gets updatet twice.
View Replies !
Update Time
I have a table with 4 different columns to record IP address of people visiting my site. If a new IP comes it is recorded and a time also written on the last column. when an exisiting IP comes again. The time becomes "0000-00-00". Here is the code after you already connect with the database and an IP is found on the database or not. Note: $Username_Found is a variable == 1 when an IP address is already found on the database. Default is not found == 0......
View Replies !
Time With Milliseconds
want hr:min:sec:millisecs. DATETIME is the correct type and what should go inside the parantheses. If i am doing a: CREATE TABLE startTable (TIMESTAMP DATETIME()
View Replies !
|
TRACKER
