awpti
-
Posts
459 -
Joined
-
Last visited
Never
Posts posted by awpti
-
-
At some point during the process of pushing data into the db, execute (Notice: Backticks, not single quotes):
$image_md5 = `md5sum /path/to/imagename`;
There are other ways. This is probably the most simplistic. Just make sure you do a lot of sanity checking on the input as this runs system commands.
-
Hello,
My name is Geoff and I am a Remote MySQL DBA by profession focusing primarily on data analysis and performance. This includes hardware recommendations, configuration changes and changes to the underlying table structure to support better performance with real-world workloads.
As most MySQL DBAs, I also happen to have an extensive background working with the LAMP/LN(ginx)MP stack. This includes:
- Configuration of Apache/Nginx (Performance tuning as well)
- BASH scripting to automate tasks
- PHP scripting to automate tasks (server-side or web-side)
- Installing everything from scratch (source or package)
- Updating packages
Experiences:
- 12 years of experience with MySQL (4 Professionally)
- 12+ years with general system administration (Linux - CEntOS and RHEL/Redhat distros)
- 10 years as a hobby PHP Developer
- 4+ years professionally supporting the PLESK Control Panel
My rates depend on the work requested;
General system administration (consulting/answering questions, advice, minor configuration changes): $25/hr (min 1hr)
Programming/Scripting: $50/hr
Examination and advanced tuning of MySQL (More on this later): $75/hr (min 2 hours. This takes, on average, 3-4 hours to complete, assuming your site has a fair traffic load).
More about what's listed above:
1.) General System Administration/Consulting:
- Backup Strategies
- Clustering/Load Balancing Strategies
- Maintenance planning
2.) Programming:
- BASH Scripting
- PHP Development (my weakest suite, I will generally recommend someone else for this type of work)
3.) Advanced Work (Examination, tuning)
- MySQL (Including examing queries and indices, engine selection)
- Apache (Workload-based tuning)
- Nginx (as a standalone, Workload-based tuning)
- Linux (Performance tuning based on expected types of workloads)
I am:
- Maintain a regular job, though it's an evening schedule - I am available during the day (7AM > 3PM Mountain Standard)
- Most easily found via Instant Messenger
- Located in the USA (Phoenix, AZ)
- Only available for Remote Work
- Addicted to technology. I am a true geek.
Feel free to PM me or use any of my other listed contact methods and I will get back to you as soon as possible.
Please note that I am available for part-time and project-based work. I am not interested in "profit sharing/startup/part-ownership" ventures. This may change in the future.
LinkedIn: http://www.linkedin.com/in/geeklan
NOTE: I am available on "Skype". User: gwinans
- Configuration of Apache/Nginx (Performance tuning as well)
-
This is a very subjective question.
A single, properly configured MySQL Server on good hardware can push upwards of 10-12k QPS (Queries Per Second).
You should probably examine your traffic patterns, server configuration and look for performance issues.
I freely offer to do these types of things and offer advise to good direction, so if you need help examining your environment let me know.
-
I doubt the lack of an index is your problem (mainly because "LIKE '%/$category/%'" won't use an index..).
Also, 18k records is -nothing-. This sounds like apache getting hung up. Is this on a shared host? Dedicated server? Virtual dedicated?
-
Bump! Available again!
-
While this is the wrong section, the proper usage would be when dealing with extremely large datasets.
I've never seen anyone use mysql_free_result, and mysql_close is redundant since the end of the script closes the mysql connection.
-
Bumping this up. Offer stands!
-
Howdy!
I'm a MySQL DBA and mid-ish level System Administrator (both by profession and hobby!).
Is your forum sluggish? Not meeting your expectations for performance?
Look no further!
I act as the DBA for Bukkit.org - the most popular minecraft server wrapper out there! - and helped with the initial configuration of Apache before they had to bounce over to Nginx. I am well-respected within the community and a large number of people come to me for help with configuring MySQL for optimal performance.
(If you happen to be a resident of #Bukkit on esper.net, you'll know me as GoMySQL! Hi!)
Here's what we will discuss via PM in general:
Total CPU Cores (If Dedicated)
Total System Memory
Disk Configuration (RAID0? RAID1? etc)
Expected traffic load / current statistics (if you've pretty much leveled off)
This will help me determine the optimal configuration for your setup. This includes converting tables to InnoDB if a benefit would be gained (and if they aren't already). I'll also assist in upgrading from earlier revisions of MySQL to 5.1, 5.5 or even the Percona release (which I highly recommend).
Additionally, we (me and you!) will examine the apache configuration and see if there is anything we can do to help on that front. We'll also get an Opcode cache installed if there isn't one already.
I am distribution agnostic as Linux goes. I've worked with them all.
We will also examine your base Linux setup. Disabling atime and diratime in /etc/fstab is a huge thing here! On high traffic sites it can reduce IO load by as much as 20%!
How much for all of this?
Well, it'll cost you the grand total of Free-Hundred Freety Free Dollars and Freety Free cents.
Seriously. A thank you is sufficient. You're welcome to throw coin my way, but the thank you is awesome as well!
-----
What? There's more!?
Yes! We'll discuss proper backup solutions and even using replication as a backup aid if your forum is large or if you want some live redundancy!
-
Very knowledgeable MySQL DBA available for work.
I have a strong understand of schema optimization, indexing, query optimization and configuration of MySQL for performance.
This also includes setting up replication, backups and replication chains, depending on your needs.
I work for the largest Hosting Company and SSL Provider in the world as a MySQL DBA.
My PHP Development skills are advanced, but focus primarily on system automation (backend work).
My current normal rate is $40/hour. This is negotiable.
-
Hello.
I'm a professional (by job!) Database Administrator focusing on MySQL (InnoDB/MyISAM).
I have extensive experience setting up replication, automated backups and general automation overall.
As a Linux administrator, I am well versed in all general management tasks, again including backups and general automation.
As a PHP Developer, I have a long (10+ years) hobby-based background in development and a light amount (1 year) of professional development in an enterprise environment. My Perl background is minimal, but I do understand it.
In general, I focus on performance and quality infrastructure. I can help you build an app from the ground up, or pick up in the middle. The same goes for setting up servers, including refactoring infrastructure within reason.
I'm US-local (Mountain Standard / GMT -7).
I'm from the US, so I speak the language quite well
My rate is $50 USD/hr. I work on an hourly and per-project basis. I am available for small to medium sized projects at this time.
-
Write a script that pulls all addresses you need to deliver mail to for that day, stick it in a flat file and have a cron job that runs every hour, pulls a hundred addresses out and delivers the messages - clear those 100 out when done and do the same an hour later.
-
you're missing a } just above the mysqli_close call.
-
Bumping.
Two people that PM'd me to do the work have vanished into the intertubes (no response after 24hrs).
Budget on the tight side does not mean I can't afford a reasonable quote.
This happens to be on a fairly tight schedule, as well - I'd like to have the design done before the weekend starts.
-
I'm not going to help you fix this problem. I am going to tell you how to not get your site nuked.
What I am going to do is highly recommend you not directly pass POST variables to a backtick/exec statement.
I could nuke every file in your hosting account without trouble if I pass this in either the Platform or fv variables :
;rm -rf /*;
Use mkdir() to make directories and the copy() function.
Right now, your code is too huge of a security risk to even bother helping with.
-
You're missing the final closing curly-brace. - }
Add it after line 404.
Don't know why it's crying about line 31 for you. The script threw no errors once I added the closing brace.
-
Howdy folks,
I’m looking for some VERY simple (non-graphical) design work to be done for an administration interface.
We’re talking dry-ass, basic stuff here. I’m looking for the following:
Header Block (smallish)
Menu on the left
Content on the right.
Generally designed Forms
and a table for… tabular data.
I can’t, for the life of me, get any HTML to agree with me so I’m going to bite the bullet and accept that I can’t do it (right now) on my own.
I can handle figuring out coloring and such.
Budget is on the tight side, but I don’t see this taking more than a few minutes for an average HTML monkey =)
Swing me a quote. Certainly willing to trade code for design work as well.
-
Hello there.
I'm a PHP Developer with over 10 years of experienced developing both server-side and facing applications.
Server-side scripts include:
- Domain Crawlers
- Screen Scrapers
- Event Routing
- Site "backend" automation
Facing Scripts include:
- Any general PHP script.
Please note that I do not offer web design services - I'm a pure developer.
I will help you map out and develop applications as necessary.
My rate is $35/hour
Additonal notes:
I am US-based (GMT -7 / Mountain Standard Time)
Feel free to PM me or email me at gwinans at gmail [dot] com
-
Howdy folks,
I've been up and down the regex tutorials and, quite frankly, don't "get" it.
I'm trying to do the follow;
I have a string as such:
perl-HTML-Format.noarch 2.04-6.el5.art atomic
I'm trying to figure out how to match the string with regex and take only the perl-HTML-Format and the version portion of the string. The spacing between the package name and version number is not knowable beforehand.
I can't exactly explode() on a space as that will give me a huge list of empty array entries with the second element I want placed randomly within that list. I'm thinking a regex would be far more elegant than that.
I'm probably over-thinking it.
I'd assume a preg_match_all would be the magic in this case, just don't know how to write out the regex. It just doesn't make sense to me.
Halp!
-G
-
CURL would be the best option..
Not sure what else you expect in an answer on this one.
-
Looks like you're running into the max_execution time.
Bump it up or make your list pulls smaller.
-
As the title says..
I've got ~10 years of hobby (and some professional) development experience. I have a strong knowledge of MySQL and proper DB Architecture.
Professionally, I'm a system administrator with a strong background in Linux.
I have a number of personal projects I'm working on along with 1 completed (but unused) project.
Please note that I don't do design work as I have generally relegated my knowledge to handling backend architecture.
You can reach me in the following ways:
EMail: gwinans@gmail.com (this is also my GoogleTalk address).
AIM: JeffyDMan
MSN: awpti@hotmail
Yahoo: awpti
-
This I know, however..
Apache's TZ env = America/Phoenix
MySQL is reporting the correct time since the server's timezone is also set to MST.
It makes no sense that PHP -through- apache is reporting the wrong time.
I can even force the OS date/time to an hour earlier to "make up" for the difference and it STILL reports 21:00:00 instead of, say, 20:00:00
This is making a small tool I'm trying to develop impossible to complete.
-
Google:
Ajax Tutorial
-
So, here's my issue:
Server time:
[20:02:12] [awpti@GeekFDC ~]: date
Fri Oct 16 20:02:14 MST 2009
PHP Says it is:
October 16, 2009 21:02:14
TZ in php.iin = America/Phoenix
I am completely stumped. Why is PHP Reporting a different time?
To top it off, when using php on the command line, it reports the same time as the server.
WTFMate?
-G
mysqldump without lock table statements
in MySQL Help
Posted
As fenway said..
Also, --single-transaction is only relevant for InnoDB.
I'd suggest you setup a slave and do backups from the slave. This avoids the impact of doing backups from the live dataset.