I have about 200k data entries in xml file. I wrote php script (using php-xml) to read xml file and insert into mysql. At first it went really quickly inserting, then after a while after inserting 100k entries, it slowed right down, just like it would not even doing anything. I have CentOs with 512M on VirtualBox running as server.
View 3 RepliesThe find command is taking too long on my machine to complete. When I use time command, I find that sys time and user time are too small as compared to real time. Is my find process not getting scheduled properly?
I interrupted the neverending find command and got the following statistics:
Real time : 5min
Sys time : 1.1 sec
User time : 3 sec
I was running
find / -name ls 2>/dev/null
Quote:
#!/bin/ksh
DBcounttry_finalnofunc()
{
[code]....
I've down loaded mysql database file and now I'm looking at adding it into a new dedicated server. Should I upload that sql file to the root folder I created for the domain and insert it with shh like that? If not where should I upload this mysql file to insert it to the new database. It's rather large so I have to use SHH Fir example if this is the code,
Code:
mysql -uUSERNAME -pPASSWORD DATABASENAME < MYDATABASE.sql
where is that actual location of MYDATABASE.sql
I am using ubuntu and mysql.I have a list of many .sql files, like 1.sql, 2.sql, 3.sql ... 100000.sqlI need to insert them into the database mysql mydb < *.sqlGives me: -bash: *.sql: ambiguous redirect
View 2 Replies View RelatedI switched to Fedora from Ubuntu about a month ago, and I've been very happy so far. But today I started the upgrade to Fedora 15, and something isn't right. I used the preupgrade method, and the package download took a respectable 30-40 minutes, then I was prompted to reboot my machine. I did so, about 4 hours ago. It took about 2 hours to get to the point where it says it's installing the packages, and 2 hours to get to where it is as I write this, at 116 completed packages out of 1634.
I'm pretty sure this isn't normal for ANY distribution. The machine itself is about 6 months old, so I'm pretty sure it's not a hardware issue. I'm considering interrupting the upgrade and doing a clean install, but I was wondering, is there anything I can do before resorting to the clean install option?
I just want to find out if anybody else is having a similar issue before I start trying to disable services one by one. When I boot in to F15, everything runs fine up to were it starts loading the CUPS module then it hangs for about 2 to 3 minutes, the next thing to load is Samba shares. So it could be either of these or it could have nothing to do with them. Just to add that I made 100% sure that all my samba shares mount fine and are online and have no shares mounting in my fstab file.
View 2 Replies View Relatedin ubuntu 10.04 After logging in t All I had was the wallpaper & my widgets for around a minute, and then the usual upper and lower panels appeared.. didnt had this problem in 9.10
View 4 Replies View Relatedwhile installation of debian 5 from small cd ... does configuring apt take a lot of time!!! installing debian for the first time.
View 1 Replies View RelatedI tried to update fedora 15 and it took too long , even the cleaing of packages took too long At the end of the update got the status cleaning up packages that took even longer than the whole update.
View 3 Replies View RelatedI have just made a clean install of Ubuntu 9.10 and after installing all updates, GDM is taking a long time (about one minute) to come up after a clean boot, resulting in a regular console prompt.
If I issue "sudo service gdm start" it does come up promptly.
What can I do? Where can I see startup logs to try and identify any problems?
I compressed a directory containing many image files. The directory amounted to 5.3gig. Compressed with TAR using .tgz the compression took a couple minutes at most and compressed down to 4.3 gig. Compressed using .bz2 the compression took about 90 minutes and compressed down to 4.2 gig. Hardly worth the extra time. Do these numbers look normal to you?
View 1 Replies View RelatedI don't know if it is just me but it seems like Ubuntu takes a long time to start up programs. For example, it takes me 10 seconds to start up "Ubuntu software center". My computer is a relatively fast one. It has 4 gb of ram and an intel core duo processor. I didn't install that many programs. Does anyone know what might be the source of the problem and how to fix it?
View 6 Replies View RelatedI purchased a special collection boxed Superman set for my 10 year old daughter in May for her birthday and recently some second hand Zumba DVD's. My daughter is quite hard on DVD's. So I have as asked her to wait whilst I have them copied.
I will be using the Zumba regularly and know they will suffer so want use copies and save the originals.
I have done some reading and I think I have everything installed correctly.
I tried K9copy, but it immediately closed. I then tried K3b and noticed I needed 99GB of space. (I wonder if that is why K9copy closed?) The only thing I have that big is my backup external drive.
So I connected it up. I only had about 44 GB of space on it. I ticked for half the tracks which needed less space. So now there was enough space. I then clicked on rip DVD. It has been doing it continuously for 2 nights and is up to 24%.
So at this rate it will take a week to copy half a DVD to my drive and then I have to burn it to a DVD. This can't be right, can it?
I am running OpenSuse 11.3
I am following this howto to install Apache, MySQL, and PHP5:
[URL]
I have just installed Apache and I am pointing my browser to:
http://192.168.0.100
but I am getting the error message that the server is taking too long to respond.
I am backing up data from a remote server onto a local ntfs partition. It seems that the rm -rf and cp -a commands are taking a long time to complete in what should be short, incremental backups.Has anyone had similar problems when backing up to an ntfs partitionHere is my rsnapshot.conf:
Code:
#################################################
# rsnapshot.conf - rsnapshot configuration file #
[code]....
I am using KVM and created four guest Operating systems on it.The server host is Ubuntu 10.04.I am using 4 websites in a reverse proxy environment.One of our website is running on CentOS VM.Right now there is no traffic on the website static HTML pages.I do not have any clue as why it was taking longer time to be accessed.
View 2 Replies View RelatedI'm running Ubuntu 9.10 on a VPS with linode.I run around 10 sites from this vps and whenever I try to do anything thats related at all to email (such as user registration, contact form submission) the process itself can take anywhere from one to five minutes. I realize that this is most likely due to a misconfiguration with how my email has been set up.
View 3 Replies View RelatedIt takes an exceptionally long time for basic graphic actions to occur like switching tabs in Firefox, redrawing windows that have been (un)maximized/minimized, and switching between windows. My video card is not a bad one, a GeForce 9500 GT and Windows handles it just fine. I'm using the current NVIDIA drivers 265.35. It seems like if I can't get some better response time I'll be using Windows much more.
View 3 Replies View RelatedI'm having a problem with my mail. When I send mail, it takes a long time for the send to complete.In the below, datestamp is just a simple script to put in a no-white-space date/time stamp.
Code:
$ datestamp ; mail woodnt; datestamp
02-05-10@193844
[code]....
Running first upgrade after installing 9.10.
Currently on item "Configuring linux-image-2.6.31-20-generic" and the progress bar/terminal readout has not changed for an hour or so I'd say.
Don't want to cause issues by killing it halfway through, especially as it presents an opportunity to learn something!
Making a low-pace instance of Conky on my server, running once a minute and without X-output. and then every minute it inserts a row in a MySQL table with some variables. Once it is in a MySQL database I can make a nice PHP-application showing some graphs and statistics or maybe even send a mail when the motherboard is catching fire or so
View 3 Replies View RelatedI know that Apache creates as many instances of a CGI program as required but I have no idea how those instances write to the same file in an orderly manner.For example, a CGI program called by Apache inserts additional data in a file, is that file made automatically unavailable to the other instances (children) of this CGI program while it is inserting the data? Or should the CGI program do that?
View 2 Replies View Relatedthe project I'm working on requires parsing a text file with fields separated by the | char and using perl to insert/update a mysql database. Some of the fields are simple numeric and others are text fields. In some of the text fields I run into a problem creating a proper insert statement for the perl api to mysql if I don't escape the single quote (') char with a backslash (). I can take each text file and do a manual subsitutiton, but I would prefer to use the script that prepares the text file to do it for me. I've tried sed (ex: sed s/'/\'/g ) and it runs cleanly, but does nothing to accomplish my goal. I suppose I could write a function to read the file character by character and write it out that way, but it seems a waste.
View 2 Replies View RelatedI have a httpd server with mysql and a php application running, but the process mysql eats lots of memory. Here is a printscreen: [URL].
View 5 Replies View RelatedWhen i open one of the web browsers i use and try to load a web site it's taking to long to respond and sometimes it doesnt load the website at all. I have tried with firefox,epiphany,opera with all the same results. I am sure that this is not a problem with my internet connection because i don't have these problems with windows.Also the network manager connection settings are correct
I also tried choosing the old kernel(2.6.32.24) to boot from but no success.The problem is the same as if i am using the 2.6.32.25 kernel. The strange thing is that i can download packages from synaptic with full speed. Last think.I have recently downloaded the recommended updates from the update manager but i don't remember what are the things that where updated.
I want to import data from MySQL to MSSQL. I've been searching in the web, and I can't find a good and straight answer. How can I do it?
View 2 Replies View RelatedI am not able to detect my USB hard drive in Linux rescue mode after passing "fdisk -l" as i want to take the data backup in my USB hard disk.
View 1 Replies View RelatedI reinstalled ubuntu linux and lost some mySQL database files that were located in the /var/lib/mysql/ folder. I need to recover them ASAP. How do i go about it. Is it possible to recover .frm, .myb files using scalpel. Is there an alternate software I could use?
View 1 Replies View RelatedWe have a test server in which we have not taken backup. Contents under /etc is entirely lost.
I need to execute scp to copy mysql data directory.
Also it is in remote location. Can I recover the data by scp by creating some /etc/passwd , /etc/shadow files ?