MDEV-36558 Performance schema fails to compile on AIX

[grooverdan]

trafficstars

try compile tests are flawed, particularly on AIX as they succeed with an "warning: implicit declaration of function".

Upon compulation of these detected feature there is a link error for the missing function.

AIX can use the HAVE_INTEGER_PTHREAD_SELF implementation

Interface per: https://www.ibm.com/docs/en/aix/7.3?topic=t-thread-self-kernel-service

• [x] The Jira issue number for this PR is: MDEV-36558

Description

Enable Performance Schema to compile on AIX.

Release Notes

Corrected compilation of performance schema on AIX

How can this PR be tested?

Compile under AIX:

With patch:

-- Performing Test HAVE_PTHREAD_THREADID_NP
-- Performing Test HAVE_PTHREAD_THREADID_NP - Failed
-- Looking for gettid
-- Looking for gettid - not found
-- Performing Test HAVE_SYS_GETTID
-- Performing Test HAVE_SYS_GETTID - Failed
-- Performing Test HAVE_GETTHRID
-- Performing Test HAVE_GETTHRID - Failed
-- Performing Test HAVE_PTHREAD_GETTHREADID_NP
-- Performing Test HAVE_PTHREAD_GETTHREADID_NP - Failed
-- Performing Test HAVE_INTEGER_PTHREAD_SELF
-- Performing Test HAVE_INTEGER_PTHREAD_SELF - Success

buildbot@mariadb:[/home/buildbot/build_10.6]make -j16 perfschema

[100%] Linking CXX static library libperfschema.a
[100%] Built target perfschema

If the changes are not amenable to automated testing, please explain why not and carefully describe how to test manually.

Basing the PR against the correct MariaDB version

• [ ] This is a new feature or a refactoring, and the PR is based against the main branch.
• [X] This is a bug fix, and the PR is based against the earliest maintained branch in which the bug can be reproduced.

PR quality check

• [X] I checked the CODING_STANDARDS.md file and my PR conforms to this where appropriate.
• [X] For any trivial modifications to the PR, I am ok with the reviewer making the changes themselves.