| Welcome Visitor, Please Login or Register Now |
|
Friday, April 26, 2024 11:21 AM |
 |
Whizzz  |
| Registered Member |
Posts: 79  |
| Joined: 04-26-24 11:21 AM |
| Location: Canada |
|
|
 |
   |
|
| |
 |
|
| A call to anyone running A-S on Windows XP with Apache |
Edit Delete   Quote |
| First Post Posted on: 05-05-08 04:42 PM |
  |
|
|
Hi!
I'm trying to collect a little data from other users to help improve the high CPU usage when categories are created in, or updating the A-S script.
This is what happens when I create a large category list.
In Task Manager Processes;
Image Name - perl.exe
User Name - SYSTEM
CPU - 97%
Mem Usage - 30,444 K
It takes approximately 8 Minutes to update a category list consisting of about 289 cats, and I always get this server error at the end of the process. Even with this server error though, the number of categories above 150 still installs with no loss of data;
Server error!
The server encountered an internal error and was unable to complete your request.
Error message:
Premature end of script headers: CatAdmin.cgi
If you think this is a server error, please contact the webmaster.
Error 500
www.a1onlineauctions.com
10/28/2004 9:54:20 AM
Apache/2.0.49 (Win32) mod_perl/1.99_12 Perl/v5.8.3 DAV/2 mod_python/3.1.3 Python/2.3.3 mod_fastcgi/2.4.2 mod_jk/1.2.0 mod_ssl/2.0.49 OpenSSL/0.9.7d
Can you post your my.ini file? Maybe with a look at other my.ini's I can solve this mystery of high CPU usage when MySQL calls the perl.exe module when creating large indexes of cats.
Any input on this would be appreciated!
Thanks!
Whizzz 
I have experimented with my.ini in the windows folder using winmysqladmin.exe to edit the values. I went to the MySQL site and read up on improving server performance, the values I increased are highlighted in BOLD
# Example mysql config file.
# Copy this file to H:\my.cnf to set global options
#
# One can use all long options that the program supports.
# Run the program with --help to get a list of available options
# This will be passed to all mysql clients
[client]
#password=my_password
port=3306
#socket=MySQL
# Here is entries for some specific programs
# The following values assume you have at least 32M ram
# The MySQL server
[mysqld]
port=3306
#socket=MySQL
#(Unknown option skip-locking
set-variable = key_buffer=64M
set-variable = max_allowed_packet=1M
set-variable = table_cache=750M
set-variable = sort_buffer=4M
set-variable = net_buffer_length=8K
set-variable = myisam_sort_buffer_size=8M
server-id = 1
# Uncomment the following if you want to log updates
#log-bin
# Uncomment the following rows if you move the MySQL distribution to another
# location
#basedir = d:/mysql/
#datadir = d:/mysql/data/
basedir = h:\BigApache\mysql\
datadir = h:\BigApache\mysql\data\
# Uncomment the following if you are NOT using BDB tables
skip-bdb
# Uncomment the following if you are using BDB tables
#set-variable = bdb_cache_size=4M
#set-variable = bdb_max_lock=10000
# Uncomment the following if you are using Innobase tables
innodb_data_file_path = ibdata1:400M
innodb_data_home_dir = H:\ibdata
innodb_log_group_home_dir = H:\iblogs
innodb_log_arch_dir = H:\iblogs
set-variable = innodb_mirrored_log_groups=1
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=5M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
innodb_log_archive=0
set-variable = innodb_buffer_pool_size=64M
set-variable = innodb_additional_mem_pool_size=2M
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50
#Enter a name for the binary log. Otherwise a default name will be used.
log-bin=BigApache_MySql_Bin_Log
#Enter a name for the error log file. Otherwise a default name will be used.
log-error = BigApache_MySql_Error_log
#Enter a name for the slow query log. Otherwise a default name will be used.
log-slow-queries = BigApache_MySql_Slow_log
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[myisamchk]
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[mysqlhotcopy]
interactive-timeout
[WinMySQLAdmin]
Server=H:/BigApache/mysql/bin/mysqld-max-nt.exe |
|
|
|
|
|
|
| mewsoft |
| Administrator Team Member |
| Posts: 5381 |
| Joined: 04-26-24 11:21 AM |
| Location: knxoville, TN, USA |
 |
|
|
    |
|
| |
|
|
|
| Whizzz |
| Registered Member |
| Posts: 79 |
| Joined: 04-26-24 11:21 AM |
| Location: Canada |
|
|
|
| |
|
| |
|
|
|
|
| mewsoft |
| Administrator Team Member |
| Posts: 5381 |
| Joined: 04-26-24 11:21 AM |
| Location: knxoville, TN, USA |
|
|
|
| |
|
| |
|
|
|
|
| Whizzz |
| Registered Member |
| Posts: 79 |
| Joined: 04-26-24 11:21 AM |
| Location: Canada |
|
|
|
| |
|
| |
|
|
| Re: A call to anyone running A-S on Windows XP with Apache |
Edit Delete Quote |
| Reply #: 4 Posted on: 05-07-08 04:49 AM |
 |
|
|
In general thousands of items is nothing for a MySQL database or speed, even if it 10,000 cat by 500 bytes each totals to 5MB dataabse which is nothing for mysql server.
Ok, lets try this again, taking data out or calling a page from the internet is no problem for speed, it's putting data into MySQL. When I put large indexes (in access of 300 categories) in Configuration - Category Manager - Create New Categories, and press the Create Categories Button, the A-S calls the PERL.exe program. It's PERL.exe running at 99% not MySQL. Of course, when the create categories button is pressed " with 300 categories in a list " in Create New Categories, it calls the PERL module to do work. It is this work that takes time... My PERL.exe or Perl5.8.3.exe runs at 90 to 99% until the categories are completely created in MySQL, it takes about 8 Minutes for the task to complete when I create indexes larger than 300 categories in Create New Categories.
Try to load this list below in your, Create New Categories, and tell me how long it will take to completely load in MySQL.
Then get back to me with your results.
A Sample List;
A/C Assembly
A/C Condensor
A/C Condensor Fan
A/C Compressor
A/C Compressor Clutch Only
A/C Evaporator
A/C Hose
Air Bag
Air Bag Clockspring
Air Bag Ctrl Module
Air Bag Sensor
Air Box/Air Cleaner
Air Flow Meter
Air Pump
Air Ride Compressor
Alternator
Antenna
Anti-Lock Brake Computer
Anti-Lock Brake Pump
Audiovisual(A/V)
Auto. Trans. Cooler
Axle Assy Fr(4WD w. Housing)
Axle Assy Rear (w. Housing)
Axle Beam Front(2WD,incl I Beam Susp)
Axle Beam Rear (FWD)
Axle Housing Only
Axle Shaft
Back Glass
Backup Light
Bed, Pickup
Bed Floor (Pickup)
Bed Front Panel (Pickup)
Bed Liner
Bed Side, Pickup
Blower Motor (Heater)
Brake Rotor, Front
Brake Rotor/Drum, Rear
Bumper Assy (Front)
Bumper Assy (Rear)
Bumper Guard (Front)
Bumper Reinforcement (Front)
Bumper Reinforcement (Rear)
Bumper Shock
CD Player/Radio
Cab Clip, no cowl
Cab
Caliper
Camshaft Housing
Camshaft
Carburetor (See Also Throttlebody)
Carrier (See Also Differential)
Carrier Case
Center Pillar
Chassis Control Computer(not Engine)
Clock/Gauges/Instument Cluster
Clutch Master Cyl.
Coil/Igniter
Coil Spring
Column Switch
Computer Box Engine
Computer Box Not Engine
Condenser
Condensor/Radiator Cooling Fan
Control Arm, Front Lower
Control Arm,Front Upper
Control Arm, Rear Lower
Control Arm, Rear Upper
Conv Top Boot
Conv Top Lift
Conv Top Motor
Cooling Fan, Rad and Con
Core (Radiator) Support
Cowl
Cowl Vent Panel
Crank Pulley (Harmonic Balancer)
Crankshaft
Cruise Control Computer
Cruise Control Servo/Regulator
Cruise Speed Controler
Cylinder Head (Engine)
Dash Panel
Dash Wiring Harness/Misc Electric
Differential Assembly (See Also carrier)
Differential Case Only
Differential Flange Only
Distributor
Door Front(for parts see Front Door Parts)
Door Rear (for parts see Rear Door Parts)
Door Handle
Drive Shaft, Front
Drive Shaft, Rear
Electric Door Motor(not Window)
Electric Window Motor
Electrical Part Misc and Wiring
Engine
Engine Block
Engine Computer
Engine Cradle
Engine Cylinder Head
Engine Oil Pan
Exhaust Manifold
Fan Blade
Fan Clutch
Fender
Fender Extension/Moulding
Fender Inner Pannel
Flex Plate
Flywheel
Fog Lamp
Frame
Frame Sections
Front Axle Assembly(4WD w Housing)
Front Axle Beam (2WD, incl I Beam Susp)
Front Axle Shaft
Front Bumper Assembly
Front Bumper Guard
Front Bumper Reinforcemant
Front Door
Front Door Glass
Front Door Handle
Front Door Hinge
Front Door Mirror
Front Door Moulding
Front Door Regulator
Front Door Switch
Front Door Vent Glass
Front Door Vent Glass Regulator
Front Door Window Motor
Front Drive Shaft
Front End Assembly(Nose)
Front Valence
Fuel Distributor(&Misc. Injection)
Fuel Injector Pump
Fuel Pump
Fuel Tank
Generator
Glass, Back (Not in Door)
Glass, Front Door
Glass, Front Vent
Glass, Quarter Window
Glass, Rear Door
Glass, Rear Vent
Glass, Special(See Also Sunroof / TTop)
Glass, Windshield
Grille
Gauges/Clock/Instrument Cluster
Handle (Door)
Harmonic Balancer (Crank Pulley)
Hatch/Trunklid
Head(Cylinder)
Header Panel
Headlight Assembly
Headlight Door
Headlight Motor
Headlight Washer Motor Only
Headlight Wiper Motor Only
Heater Assy
Heater Core
Heater Motor
Heater/AC Control
Hood
Hood Hinge
Hub Cap/Wheel Cover
Hub
Hub, Lockout(4WD)
Ignition Module (See Also Ignitor/Coil)
Ignition switch
Ignitor/Coil
Instrument Cluster/Gauges(See also Speedo)
Intake Manifold
Intercooler
Interior Complete
Interior Panels/Misc
Knee Assembly (See Also Strut Assy)
Leaf Spring, Front
Leaf Spring, Rear
License Lamp
Lid/Gate
Lockout Hub, 4X4
Marker/Fog Light, Front
Marker/Side Light, Rear
Master Cylinder
Mirror, Door
Mirror, Rear View
Mouldings, Misc(Not Door Mouldings)
Nose (Front End Assembly)
Oil Cooler
Oil Pan, Engine
Oil Pan, Transmission
Overdrive Unit(See Also Transmission)
Park/Fog Lamp Front
Park Lamp Rear(Side)
Pickup Bed
Pickup Bed Floor
Pickup Bed Front Panel
Pickup Bed Side
Power Brake Booster
Power Steering Assy
Power Steering Pump
Power Window Switch
Quarter Panel
Quarter Panel Extension
Quarter Repair Panel
Quarter Window
Quarter Window Motor
Quarter Window Reg.
Radiator
Radiator Core Support
Radiator/Condensor Cooling Fan
Radio/CD
Rear Axle Assy ( RWD)
Rear Axle Beam (FWD)
Rear Body Panel
Rear Bumper
Rear Bumper Reinforcement/Misc
Rear Clip
Rear Door
Rear Door Glass
Rear Door Handle
Rear Door Hinge
Rear Door Molding
Rear Door Vent Glass
Rear Door Vent Glass regulator
Rear Door Window Motor
Rear Drive Shaft
Rear Finish Panel
Rear Gate/Lid
Rear Gate Wind Motor
Rear Stub Axle Only
Rear Suspension (see Also Control Arms)
Rear Suspension Trailing Arm
Rear Suspension Locating Arm
Rear Window Reg.
Rear Window Washer Motor
Ring and Pinion Only
Rocker Moulding
Roof
Roof Panel(See Also Sunroof)
Running Boards
Seat Belt
Seat Belt Motor
Seat, Front
Seat, Rear (2nd)
Seat, Back ( 3rd)
Seat Track, Front Only
Shock Absorber
Slave Cylinder
Special Glass
Speedometer(See also Instr. Cluster)
Spindle
Spoiler,Front
Spoiler,Rear
Stabilizer Bar Only
Starter
Steering Column
Steering Knuckle (See Also Knee & Strut)
Steering Rack/Box/Gear
Steering Wheel
Strut (See Also Knee Assy)
Sun Roof / T-Top
Sun Roof Motor
Supercharger/Turbocharger
Tail Light
Tailgate/Trunklid
Tailgate Hinge
Third Brake Light
Throttle Body/Throttle Valve Housing
Timing Cover
Tire
Transaxle Housing Only
Transfer Case
Transmission
Transmission Bellhousing Only
Transmission Computer
Trans OD Unit(See Also Transmission)
Transmission Pan
Transmission Torque Converter
Trunk Lid/Hatch
Trunk Lid/Hatch Hinge
TTop/Sunroof
Turbocharger/Supercharger
Vacuum Pump
Valence, Front
Valve Cover
Voltage Regulator
Water Pump
Wheel Cover/Hubcap
Wheel
Window Motor
Window Washer Motor, Rear
Windshield
Windshield Washer Motor(Front)
Windshield Washer Reservoir
Wiper Linkage
Wiper Motor, Front (Windshield)
Wiper Motor,Rear
Wiring Harness/Misc. Electric
Miscellaneous
Whizzz :shock: |
|
|
|
|
|
|
| mewsoft |
| Administrator Team Member |
| Posts: 5381 |
| Joined: 04-26-24 11:21 AM |
| Location: knxoville, TN, USA |
|
|
|
| |
|
| |
|
|
|
| mewsoft |
| Administrator Team Member |
| Posts: 5381 |
| Joined: 04-26-24 11:21 AM |
| Location: knxoville, TN, USA |
|
|
|
| |
|
| |
|
|
|
| Whizzz |
| Registered Member |
| Posts: 79 |
| Joined: 04-26-24 11:21 AM |
| Location: Canada |
|
|
|
| |
|
| |
|
|
| Re: A call to anyone running A-S on Windows XP with Apache |
Edit Delete Quote |
| Reply #: 7 Posted on: 05-07-08 06:06 AM |
|
|
|
Ok, now that you tested it and gave me the one second result, I am convinced, and I will try to find the problem in perl. If I am unsuccessful, I will change to a different OS and reinstall months of work...
Thanks!
Whizzz .gif) |
|
|
|
|
|
| mewsoft |
| Administrator Team Member |
| Posts: 5381 |
| Joined: 04-26-24 11:21 AM |
| Location: knxoville, TN, USA |
|
|
|
| |
|
| |
|
|
|
|
| |
Mewsoft and Mewsoft Logos are registered trademarks.
® Corporation. All Rights Reserved.
Copyright -
Privacy -
Terms of Use
| Page Load: 0.2927 Seconds |
|
